Introduction The Power BI Workout Wednesday team has decided that May is made for DAX! Each challenge this month will require some DAX in the solution. For this week’s solution we are going to practice creating some tables in Power BI Desktop using DAX to help us answer some questions! Did you know that you can …
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
Introduction Recently I’ve been spending more time working with Map Layers, so this week is dedicated to reimagining maps using this feature. You’re tasked with recreating a Regional Readout Report where Sales teams can see the performance of various cities within their Region. They’ll be able to get more information by hovering over a city. …
Power BI Highlights with DAX
Introduction Learning complex techniques and beautiful design is super important to mastering visual analytics. But, nothing will stop a user from regularly and joyfully using a dashboard than a poor performing one. It doesn’t matter if it looks like Michaelangelo designed it or it has the cure for some crazy infectious disease – if it …
2021 Week 18: Can You Performance Tune This Workbook? Read More
Introduction The Power BI Workout Wednesday team has decided that May is made for DAX! Each challenge this month will require some DAX in the solution. We are going to start our month of DAX with a fun game called Cat or Croissant. You might be familiar with the many versions of “animal or food” …
2021 Week 18 | Power BI: DAX Trick – Cat or Croissant Read More
When I came across Nathan Yau’s post, over on his site – Flowing Data, I instantly knew this would make a great #WorkoutWednesday challenge.
Introduction It’s week 17 and we’re back to create what demographers refer to as an Age Pyramid, in which each bar represents the makeup of the US population as a whole in 5 year cohorts. The inspiration for this visual came from the Pew Research Center’s 2014 publication in which they visualized “America’s Morphing Age …
Introduction With Tableau 2021.1 being released last month, I thought it was time for a challenge. This week we focus in on the new feature of Quick LODs. Click to open in Tableau Public Requirements Dashboard Size: 800px by 700 px One Sheet Create a dual axis chart which shows the Sub-Category Average Sales by …
2021 Week 16 | Tableau : Can you use Quick LODs to recreate this view? Read More
Introduction Thanks to everyone who has ben participating in #WorkoutWednesday – Power BI edition! We have had an amazing 953 submissions for the Power BI challenges at the time of writing this post. If you haven’t been submitting your tracker upon completion, make sure to fill it out at this link. This week we are …
