Advanced

Week 05 2022 Challenge

2022 Week 05 | Power BI: Can you make a Nested Chart with Charticulator?

4 Comments / Power BI, Workout Wednesday / By

Introduction This week we are familiarising ourselves with Charticulator and Nested Charts. This graph was inspired by Gus Wezerek and Sara Chodosh’s chart for NYT Opinion. Requirements Download the data and remove all columns excepting the Date field, New Cases Smoothed Field and Location (save as csv) Create a second csv with only Location = …

2022 Week 05 | Power BI: Can you make a Nested Chart with Charticulator? Read More »

A power bi report that calculates contrast ratio between two colors

2021 Week 46 | Power BI: Create a Color Contrast Calculator

Power BI, Workout Wednesday / By

Introduction This week we are continuing our design theme by making a report about report design. Color is a very important element in report design. Color contrast is not only important for accessibility, it’s also an element of visual hierarchy. You can also use color contrast as a way to make elements on your report …

2021 Week 46 | Power BI: Create a Color Contrast Calculator Read More »

Workout Wednesday Power BI Week 34 2021

2021 Week 34 | Power BI: Building a Network Diagram

Power BI, Workout Wednesday / By

Introduction This week’s Workout Wednesday we will be creating a network diagram in Power BI.  Network diagrams are useful to explore relational datasets and are often used to visualize such things as project interdependencies, and social networks.  For this challenge we will be visualizing the interconnections of actors/characters of the Love Actually movie by number …

2021 Week 34 | Power BI: Building a Network Diagram Read More »

Wow 2021 PBI Week 30 Power BI report

2021 Week 30 | Power BI: Remove Punctuation and Count Words With Power Query

Power BI, Workout Wednesday / By

Introduction To celebrate our fourth week of Power Query month, we are going to use Power Query to analyze text data. Inspired by Chris Webb’s blog post, we are going to analyze word usage in Mary Wollstonecraft Shelley’s Frankenstein; Or, The Modern Prometheus. The Power Query techniques used in this week’s challenge are a bit …

2021 Week 30 | Power BI: Remove Punctuation and Count Words With Power Query Read More »

2021 Week 28 | Power BI: Web Scraping with Power Query

9 Comments / Power BI, Workout Wednesday / By

Introduction July is “Power Query Month”, where the theme is focused less on visualization and more on data preparation. Every Power BI challenge requires Power Query to get and transform data, but now we’re going deeper in July! If you haven’t checked out Dave’s challenge from last week, make sure to check it out here.   This …

2021 Week 28 | Power BI: Web Scraping with Power Query 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 »