>>Yeah, yeah. >>Hello and welcome back. You're just in time for our third session spot. I Q amplify your insights with AI in this session will explore how AI gets you to the why of your data capturing changes and trends in the moment they happen. >>You'll >>start to understand how you can transform your data culture by making it easier for analysts to enable business users to consume insights in real time. >>You >>might think this all sounds too good to be true. Well, since seeing is believing, we're joined by thought spots. Vika Scrotum, senior product manager. Anak Shaped Mirror, principal product manager to walk you through all of this on MAWR. Over to you actually, >>Thank you. Wanna Hello, everyone. Welcome to the session. I am Action Hera, together with my colleague because today we will talk to you about how spot I Q uses a. I to generate meaningful insights for the users Before we dwell into that. Let's see why this is becoming so important. Your business and your data is growing and moving faster than ever. Data is considered the new oil Howard. Only those will benefit who can extract value of it. The data used in most of your organization's is just the tip of the iceberg beneath the tip of the iceberg. What you don't see or what you don't know to ask. That makes the difference in this data driven world. Let's learn how one can extract maximum value of the data to make smarter business decisions. We believe that analytics should require less input while producing more output with higher quality in a traditional approach. To be honest, users generally depend on somebody else to create data models, complex data queries to get answers to their pre anticipated questions. But solution like hot spot business users already have a Google like experience where they can just go and get answers to their questions. Now, if you look at other consumer applications, there are multiple of recommendation engines which are out there, which keep recommending. Which article should I read next? Which product should I buy? Which movie should I watch in a way, helping me optimized? Where should I focus my time on in a Similarly in analytics, as your data is growing, solutions must help users uncovered insights to questions which they may not ask, we believe, and a I automated insights will help users unleash the full potential off their data Across the spectrum, we see a potential in a smart, AI driven solution toe autonomously. Monitor your data and feed in relevant insights when you need them, much like a self driving car navigates our users safely to their desired destination. With this, yeah, I'm happy to introduce you to spot like you are a driven insights engine at scale, which will help you get full potential off your data like you automatically discovers, personalize and drive insights hidden in your data. So whenever you search to create answers, spot that you continues to ask a lot more questions on your behalf as it keeps drilling and related date dimensions and measures employed insights which may be of interest to you. Now you as a user can continue to ask your questions or can dig deeper into the inside, provided by spotted you Spartak. You also provides a comprehensive set of insights, which helps user get answers to their advance business questions. In a few clicks, so spotted it. You can help you detect any outlier, for example, spot that you can not only tell you which seller has the highest returns than others, but also which product that sellers selling has higher returns than other products. Or, like you can quickly detect any trends in your data and help us answer questions like how my account sign ups are trending after my targeted campaign is over. I can quickly use for, like, toe get unanswered how my open pipeline is related to my bookings amount and what's the like there. What it means is that how much time a lead will take to convert into a deal I can use partake. You, too, create multiple clusters off my all my customer base and then get answers to questions that which customer segment is buying which particular brand and what are the attributes last and the most used feature Key drivers of change spotted you helps you get answer to a question. What factors lead to the change in sales off a store in 2020 as compared to 2019? We can do all this and simple fix. That's barbecue. What is so unique about Spartak? You how it works hand in hand with our search experience, the more you search, the smarter. The spot that you get as it keeps learning from your usage behavior on generates relevant insights for you for your users. Spartak. You ensures that users can trust every insights. A generator. It broadly does this and broadly, two ways. It keeps their insights relevant by learning the underlying data model on. By incorporating the users feedback that is, users can provide feedback to the spot I Q similar to any social media back from, they can like watching sites they find useful on dislike. What insights Do not find it useful based on users. Feedback Spot like you can downgrade any insight if the users have not find it useful. In addition to that, users can dig deep into any Spartak you insight on all calculations behind it are available for a user to look and understand. The transparency in these calculations not only increases the analytical trust among the users, but also help them learn how they can use the search bar to do much more. I'm super excited to announce Partake you is now available on embrace so our automated A insights engine can run queries life and in database on these datasets so you do not need to bring your data to thoughts about as you connect your data sources. Touch Part performs full indexing value to the data you have selected, not just the headers in the material and as you run sport in Q, it optimizes and run efficient queries on your data warehouse on. I am super pleased to introduce you. This new spot like you monitor the spot that you monitor will enable all your users to keep track of their key metrics. Spartak, you monitor will not only provide them regular updates off their key metrics, but we also analyze all the underlying data on related dimensions to help them explain. What is leading to the change of a particular metric monitor will also be available on your mobile app so that you can keep track of your metrics whenever and wherever you go, because will talk for further detail about this during the demo. So now let's see Spartak in action. But before we go there, let's meet any. Amy is an analyst at a global retail about form. Amy is preparing for her quarterly sales review meeting with the management, so Amy has to report how the sales has meat performing how, what, what factors lead to the change in the sales? And if there are any other impressing insights, which everyone should off tell to the management? So but this Let's see how immigrant use part like you to prepare for the meeting. So Amy goes to that spot, chooses the sales data set for her company. But before we see how many users what I Q to prepare for the meeting. I just wanted to highlight that all this data which we're going to talk about is residing in Snowflake. >>So >>Touch Part is going to do a life query on the snowflake database on even spot. A Q analysis will run on the Snowflake databases, so we'll go back and see how you can use it. So Amy is preparing for the sales meeting for 2019. We just ended. So images right Sales 2019 on here. She has the graph of the Continent tickets, >>so >>what she does is immediately pence it >>for >>the report. She's creating Andi now. This graph is available >>there now. >>Any Monnet observed >>that >>the Q four sales is significantly higher than Q >>three, so >>you she wants to deep dive into this. So she just select these two data points and does the right click and runs particularities. So now, as we talked earlier, Spartak, you recommends which columns Spartak Things Will best explains this change >>on. >>Not only that, you can look that Spartacus automatically understood that Amy is trying toe identify what led to this change. So the change analysis we selected So now with this, >>Amy >>has a bit more business context when he realizes that she doesn't want to add these columns. So she's been using because she thinks this is too granular for the management right now. >>If >>she wants, she can add even more columns. All columns are available for her, and she can reduce columns. So now she runs 42 analysis. So while this product Unisys is running, what the system will do with the background, this part I Q will drill across all the dimensions, which any is selected and try to explain the difference, which is approximately $10 million in sales. So let's see if Amy's report is ready. Yeah, so with this, what's product you has done is protect you has drilled across all dimensions. Amy has selected and presented how the different values in these dimensions have changed. So it's product. You will not only tell you which values in these dimensions have changed the most, but also does an attribution that how much of this change has led to the overall change scenes. So here in the first inside sport accuse telling that 10 products have the largest change out of the 3 45 values and the account for 39% increase. Overall, there has been look by the prototype category. It's saying that five product types of the largest change out of the 15 values, and they account for 98.6% of total increase. And they're not saying the sailors increased their also demonstrating that in some categories the sales has actually decreased to ensure the sales has decreased. Amy finds this inside should be super useful so immediately pins this on the same pain, but she was preparing for and she's getting ready with that. Amy also wants to dig deeper into this inside. My name goes here. She sees that spot. I Q has not only calculated the change across these product types, but has also calculated person did change. So Amy immediately sorts this by wasn't did change. And then she notices that even though Sweater as a category as a prototype, was not appearing in the change analysis but has the most significant change in terms of percentage in comparison to Q two vs Q four. So she also wants to do this so she can just quickly change the title. And she can pin this insight as well under spin board for the management to look at with this done. Now, Amy, just want to go back to this sales and see if she can find anything else interesting. So now Amy has already figured out the possible causes. What led to the increase in sales? So now, for the whole of 2019, as this is also your closing, Amy looks, uh, the monthly figures for 2019, and she gets this craft now. If Amy has to understand, if there is an interesting insight, she can dig into different dimensions and figure out on her own or immigrant, just click on this product analysis. That's product immediately suggest all the dimensions and measures immigrant analyze sales by Andi many. We will run this What will happen is this barbecue system will try to identify outliers. The different trend analysis Onda cross correlation across different measures. So Amy again realizes that this is a bit too much for her. So she reduces some of these insights, which she thinks are not required for the management right now from the business context and the business meeting. And then she just immediately runs this analysis. So now, with this, Amy is hoping to get some interesting insights from Spartak, which immigrant present to her management meeting. Let's see what sport gets for her. So now the Alice is run within 10 seconds, so spot taken started analyzing. So these are the six anomaly sport like you found across different products, where their total sales are higher than the rest. He also founded Spot. I just found eight insights off different product types which has tired total sales and look across these enemy sees that oh jackets have against the highest sales across all the categories in December as well. Amy wants toe been this to the PIN board on M. It moves further now. Amy's is that it has also shown Total Country purchased their product a me thinks this is not a useful insights. Amy can get this feedback. The system and system asked, Why are you saying you don't find this useful so the system can remember? So you can also say that anomalies are obvious right now and give this feedback and the system will remember. In addition, Amy finds that the system has automatically correlated the total sales in total contrary purchase. Amy Pence this as well to the pin board. Andi. She loves this inside where she she is that not only the total sales have increased, but total quantity purchases have increased a lot more on their training, opposed as well. So she also opens this now anything. She is ready for her meeting with the management. So she just goes and shares the PIN board, which she just created with the management. And you know what happens immediately? The jacket sales category Manager Mr Tom replies back to Amy and says in the request, Any d really like this? So now we will see how Spartak you can help any educators as request doesn't mean really need to create these kind of reports every month to cater toe Tom's request. So with this, I will handle it because to take us walk us through How spot that you can cater this request. Hi, >>everyone. So analysts like Amy are always flooded with such requests from the business users and with Spot and you monitor. Amy can set up everyone who needs updates on a on a metric in just a few simple steps and enable them to drag these metrics whenever and wherever they want. And north of the metrics, they also get the corresponding change analysis on the device off their choice with hot Spot. What I give money being available on both Web and the mobile labs. So let's get started with the demo will be set up a meet and go to the search tab and creator times we start for the metrics you want to monitor, right? And please know if the charges already created is already created. All is available is, um, usually a section in a PIN board. Also dancer. Then there's no need to create a new child. She can simply then uh, right click on the chart and select moisture from the menu, which then shows, which then shows the breakdown off the metric he's going to monitor, including the measure. What it's been grouped by on what it is filtered on. Okay, and also as this is a weekly metric, all the subscribers are going to get a weekly notification for this metric had been a monthly metric. Then the notifications would have been delivered on a monthly cadence. Next she can click on, continue and go to the configure dimensions called on Page. Here A is recommending what all dimensions could best being the change in this metric, she can go ahead with default recommendation, or she can change the columns as she seems very she can click, she conflict, continue and go to the next page, which is the subscriber stage. It is added by default to the subscriber, but she can search everyone who needs update on this metric and add them on this metric by clicking confirmed, she'll see a toast message on the bottom of the page, taking on which will take a me to this page, which is a metric detail page On the top of this page, we can see the movement of the metric and how it is changing over time, 92 you can see that the Mets jacket, since number has increased by 2.5% in the week off 23rd of December has compared toa the week off 16th of December and just below e a has invaded the man is generated in sites which are readily available for consumption. Okay to discharge. Right here says that pain products have the largest change out of all the 28 values and contributes to the 88% of the total increase in the same. And this one right here is that Midwest is the larger Midwest has the largest change and accounts for 55.66% off the total increase. Now, all this goodness is also available on the mobile lab. Right? So let me just show you how business users are going to get notified on the based. On this metric, all the business users who are subscribed to this metric are going to get a regular email as well as push notifications on the mobile lab. And when the click on this, they line on a metric detail page which has all the starts, which I just showed you on the on the bed version, okay. And one cyclic on back burden. They land on this page, which is a monitor tab, and it summarizes all the metrics Which opportunity monitoring and gives them a whole gave you to stay all I want to stay on top of their businesses. Okay. Eso that folks was monitor. Now I'll search back to slaves and cover. Summarize the key takeaways. From what? That she and I just don't know. So it's part of you wanted, uh, Summit Spartak you. It automatically discovers insights and helps you unless the full potential of your data and that's what I do is comprehensive set off analysis. You can answer your advanced business question in just a few simple steps and the end speed of your time. Bring state. And with a new support for embrace, you can run sport like you on your data in your data warehouse and with spotted you monitor, you can monitor all the business metrics and not just died. We can also understand that teaching teaching drivers on those metrics on the platform of your choice. So with that, I'll hand over toe, you know. >>Thank you so much. Both of you That was fantastic. Um, I just love spot like, because it makes me look like much more of a rock star with data than I really am. So thank you guys for that fantastic presentation. Um, so we've got a couple of minutes for a couple of questions for you. The first one is for action. Um, once spot I Q generates a number of insights. Can you run spot I Q again on one of those insights? >>Yeah, As a philosophy off Spiric, you sport like you never takes the user to the dead end Spartak. You also transparently shares the calculation. So user can not only the keeper that on edit Understand how this product you inside has been calculated, but user can also run us for like you analysts is honest for data analysis as well. Which music? And continue to do not on the first level. Second level in the third level as well. >>That's cool. Thank you. Actually on then The next one is for because for spot ik monitor is it possible to edit the dimensions used for explaining the factors to change that was detected? >>Yes. It's an owner of the metric you can change the dimensions whenever you want and save them for everyone else. >>Okay, well, I think that's about all we've got time for in this session. So all that remains is for me to say a huge thank you to Because an Akshay Andi, we've got the last session of this track coming up in a few minutes. So grab a snack. Come right back and listen to an amazing customer story with Snowflake on Western Union, they're up next.