Day 14 - vs, part 02
Dawid Rasa?a
Business Analysis | Data Analysis | Problem Solving | Data Storytelling | Business Strategy
Door number 14 brings you another round of information on the keyword vs. You've known since yesterday that it's incredibly powerful, but what if I told you it was just an introduction? Open the next door of the #ThoughtSpotAdventCalendar and see for yourself what ThoughtSpot has prepared for you.
Yesterday we focused on the fact that we were comparing the same measure for different possibilities from the same attribute. Quantity on Friday vs Saturday, etc. What if we wanted to compare two completely different attributes? For example, quantity in December vs classic pizza sales? One is from the OrderDate attribute and second from the PizzaCategory attribute. Nothing could be simpler. You do it exactly the same way as before.
Think of how many opportunities this gives you. You count what you want, even seemingly incongruous things. You can expand this comparison as much as you like. Add, for example, quantity on Mondays. It is the same OrderDate attribute but treated differently, as a day of the week. And let's narrow down our question to only m and s size pizzas.
Absolutely amazing. Let's play along and add the hourly dimension here and see what the distribution looks like in each case - in December, for classic pizza and on Mondays, but always for m and s size pizzas.
领英推荐
In theory it looks good. But note that each curve is aligned to a different axis and each has a different scale. This is something I owe you since yesterday. Below you can see how align the vertical axes.
And that is what #SpeedOfThought is all about. It only took three minutes and you already know that classic pizza sells better around midday and lunchtime and the schedule of the hour in December and on Mondays is something similar.
Tomorrow, something that is sure to make you swoon. Something you can hardly imagine, but which you will be able to do. Will you find out what door number 15 will be hiding?