table calculations

2021 Week 26 – Tableau: Profitability with Dual Axis Charts

Introduction This week we are going to do two things:  look at alternative for the most common scatterplot I see in Tableau. use a very uncommon unsynchronized dual axis chart. First, the chart I always run into is this scatterplot of total sales and total profit by order. While we can see which orders were …

2021 Week 26 – Tableau: Profitability with Dual Axis Charts Read More

2021 Week 20 | Tableau: Can you compare Same Day to a Selected Date?

Introduction I came across an interesting challenge. When comparing data, Tableau automatically compares to the same date on the prior month/year etc. But what if you want to compare to the same DAY. For example, Tuesday 18th May 2021, would compare to Tuesday 19th May 2020 for the previous year, and Tuesday 20th April for …

2021 Week 20 | Tableau: Can you compare Same Day to a Selected Date? Read More

2021 Week 3 | Tableau : Can you build a Control Chart

Introduction Is it too late now to start the post with Happy New Year?  Well it’s my first Workout of the year so Happy New Year everyone, it’s really great to be back for my third year! After completing the first two workouts from this year (because I suck at Table Calculations), I wanted to …

2021 Week 3 | Tableau : Can you build a Control Chart Read More

2021 Week 2 | Tableau : Can you build a Customer Lifetime Value Matrix?

Introduction This year we’ve made a commitment to start with the basics and build, so this challenge is designed to do just that. This week, you’ll be constructing a Customer Lifetime Value Matrix (CLTV).  This viz is frequently used in marketing and retail industries to understand the value of each customer.  Specifically, the interesting insights …

2021 Week 2 | Tableau : Can you build a Customer Lifetime Value Matrix? Read More

2020 Week 46: Can you build a Premier League table?

Introduction I was scrolling thru my Twitter timeline and noticed a comment by fellow Zen Master Simon Beaumont to #MakeoverMonday co-lead Charlie Hutcheson regarding tables, specifically the kind to track teams and the results of matches in the English Premier League (which are a group of the highest level teams that play football/soccer in England). …

2020 Week 46: Can you build a Premier League table? Read More

2020 Week 42: Can you build a Strava Workout Calendar?

Introduction When Lorna asked me to be a Community contributor for Workout Wednesday, honestly, I was hesitant since I don’t participate every week. I typically only take on the challenges that I think are most beneficial to me as a teacher. I want to share work that I know the Data Schoolers are likely to …

2020 Week 42: Can you build a Strava Workout Calendar? Read More

2020 Week 27: What is the distribution of total orders by customer?

Introduction After many weeks of practical challenges. I’ve decided to switch it up this week. If I’m being honest I’ve been saving this challenge since August of last year (it’s still not the oldest challenge I am saving). This weeks challenge is to make a symmetrical dot plot. Not only is the dot plot symmetrical …

2020 Week 27: What is the distribution of total orders by customer? Read More

2020 Week 24: Can you compare a 3-day vs. 14-day moving average and describe the latest trend?

Introduction I’ve got an exciting challenge for you this week!  It involves collaboration with a peer of mine in the data community (Jami Delagrange, who you may recognize as an upcoming Community Month contributor) and also a challenge that involves working with COVID-19 data. This built-for-mobile dashboard was born out of seeking to understand the …

2020 Week 24: Can you compare a 3-day vs. 14-day moving average and describe the latest trend? Read More

2020 Week 18: Which products were most profitable?

Introduction Sometimes you want to make fun charts, but life gives you tables. This challenge is another real-life challenge I’ve encountered through Dr. Alicia Bembenek: show a table, but only highlight a subset of the products. An innocent challenge that is actually more difficult than it first appears. –LS. Be sure to check out the …

2020 Week 18: Which products were most profitable? Read More

Scroll to Top