Month: May 2018

Week 22: Which city contributes the most sales to each state?

He’s back again! Andy Kriebel shares with a problem that you can only use table calculations to solve Requirements Use only table calculations The bar length is the total sales of each state City must be included in the view. Display only one mark per state. Label each bar by the city with the highest …

Week 22: Which city contributes the most sales to each state? Read More

Week 21: Profit and Sales Cat Emoji Map

This week’s Workout Wednesday is an emoji map. The original idea comes from a Dark Sky emoji map of the weather. This worksheet has several major elements you’ll have to work through: Data modeling Percentiles Hex bins of geospatial data Working with emojis Customized “legend” Requirements Dashboard size: 600 x 600, 2 sheets (floating and …

Week 21: Profit and Sales Cat Emoji Map Read More

Week 18: Customer Retention By Cohort and Quarter

If you’ve ever worked with web Google Analytics then you’ve probably seen the cohort analysis chart. To me its the coolest information provided. This week were back with an intermediate and jedi options. Both look basically the same but the jedi forces your thinking to a higher level!   Intermediate Build a cohort analysis heat …

Week 18: Customer Retention By Cohort and Quarter Read More

Scroll to Top