Workout Wednesday Power BI Week 23 2021 Nobel Prize

2021 Week 23 | Power BI: Can You Build a Cumulative Line Chart?

5 Comments / Power BI, Workout Wednesday / By

Introduction Continuing with the Nobel Prize data that Meagan began exploring last week, this week extends to consider aspects of individual Nobel laureates. The main visual is a cumulative line chart, but you’ll also provide detail on laureates with a report page tooltip. While additional JSON expansion and transformation was required from the original dataset, …

2021 Week 23 | Power BI: Can You Build a Cumulative Line Chart? Read More

2021 Week 22 | Power BI: Create Your Own Timeline from JSON Data

1 Comment / Power BI, Workout Wednesday / By

Introduction Workout Wednesdays for Power BI is now in our sixth month! Thanks so much for joining us. For the month of June, we will have independent exercises that all use the same data source but focus on different aspects of the data and of Power BI. Our dataset for the month comes from Nobelprize.org. …

2021 Week 22 | Power BI: Create Your Own Timeline from JSON Data Read More

#WOW2021 week 22: Can You Structure the Unstructured?

Leave a Comment / Tableau, Workout Wednesday / By

Introduction Data analyst is supposedly the sexiest job of the 21st century.  Most people think that we spend our time building amazing models, visualizations, or insights all day.  What they don’t know is that you spend nearly most of your time cleaning data.  Some data is nice and refined (aka usable) and other data needs …

#WOW2021 week 22: Can You Structure the Unstructured? Read More

#WOW2021 week 21: How often is Sean listening to his favorite songs?

1 Comment / community, Tableau, Workout Wednesday / By

Introduction I’m really putting myself out there this week. But it’s for a good cause, so here we go! If you aren’t familiar, I love listen to music…who doesn’t though, right? Pretty sure I’m in the majority here. Anywho, being that my second hobby is data visualization, I really like visualizing about music. So anytime …

#WOW2021 week 21: How often is Sean listening to his favorite songs? Read More

2021 Week 21 | Power BI: Time Intelligence

1 Comment / Power BI, Workout Wednesday / By

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 DAX time intelligence functions, looking at the housing market in the US state of Connecticut. Time intelligence functions allow you to …

2021 Week 21 | Power BI: Time Intelligence Read More

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

1 Comment / Tableau, Workout Wednesday / By

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 19 | Tableau: Regional Sales Readout

Leave a Comment / Tableau, Workout Wednesday / By

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. …

2021 Week 19 | Tableau: Regional Sales Readout Read More

2021 Week 18: Can You Performance Tune This Workbook?

1 Comment / Tableau, Workout Wednesday / By

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

Scroll to Top