Day 14 - vs, part 02

Day 14 - vs, part 02

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?

要查看或添加评论,请登录

Dawid Rasa?a的更多文章

  • Day 24 - liveboards

    Day 24 - liveboards

    Day 24: The grand finale of the #ThoughtSpotAdventCalendar. You are probably busy so it will be #SpeedOfThought and fun.

    1 条评论
  • Day 23 - KPI chart

    Day 23 - KPI chart

    Just today's door and tomorrow's. The #ThoughtSpotAdventCalendar flew by very quickly.

  • Day 22 - sankey diagram

    Day 22 - sankey diagram

    Door number 22 continues the theme of visualisation. Today you will find a sankey chart in the…

    1 条评论
  • Day 21 - waterfall chart

    Day 21 - waterfall chart

    As I promised yesterday from today just pure fun. We've finished the block I called advanced and we're going to play…

  • Day 20 - speed of thought

    Day 20 - speed of thought

    Today will be different from the previous days. No new commands or keywords.

  • Day 19 - subquery

    Day 19 - subquery

    We're slowly heading towards the end and starting the final week of the #ThoughtSpotAdventCalendar. We continue with…

  • Day 18 - own formulas

    Day 18 - own formulas

    I know that the word formula hidden in today's #ThoughtSpotAdventCalendar trees sounds scary and unfriendly. But I…

  • Day 17 - growth, part 02

    Day 17 - growth, part 02

    You already know how to use the growth function and we even made a cool visualisation of what growth looks like from…

  • Day 16 - growth

    Day 16 - growth

    We're coming to the end of the year so questions about year-over-year growth, month-over-month growth, etc. are…

  • Day 15 - answers flexibility

    Day 15 - answers flexibility

    In the previous days you learnt the basics of data analysis with #SpeedOfThought and also went to a slightly higher…

    1 条评论

社区洞察

其他会员也浏览了