Power BI

Doge with a word cloud of US misspellings

2023 Week 14 | Power BI: Word Cloud and Modulo

Power BI, Workout Wednesday / By

Introduction This week’s challenge is inspired by recent Twitter activities. We are creating a word cloud containing common misspellings in the US. Requirements Power Query Obtain the dataset from https://www.dailymail.co.uk/femail/article-11357183/Google-search-data-reveals-commonly-misspelled-words-spell-correctly.html OR https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Misspellings Transform and load data HINT : Add Index column, create modulo column, unpivot data Power BI Desktop Obtain Word Cloud custom visual from …

2023 Week 14 | Power BI: Word Cloud and Modulo Read More

2023 Week 13 | Power BI: Create a connected scatterplot with image markers

Power BI / By

Introduction This week we are getting a bit artistic and taking inspiration from a visual that was recently published by Robin Rohwer on Twitter. She created a connected scatterplot that uses a flower emoji to represent each point. I thought her visual was wonderful, so I set out to create something like it in Power …

2023 Week 13 | Power BI: Create a connected scatterplot with image markers Read More

Image of Power BI report.

2023 Week 12 | Power BI: Are your reports accessible?

1 Comment / Power BI, Workout Wednesday / By

Introduction Welcome back to Workout Wednesday! This week we’re taking a note out of Meagan’s book and looking at existing reports to ensure they’re accessible to our end-users.  Creating accessible Power BI reports isn’t just a nice-to-have feature, but a crucial aspect for ensuring all users can access and understand your data. Don’t let accessibility …

2023 Week 12 | Power BI: Are your reports accessible? Read More

2023 Week 10 | Power BI: Mapping Cities with Michelin Star Restaurants

3 Comments / Power BI / By

Introduction Note from the Editor: This week we have our first bilingual WoW for Power BI! Below you will find both the Spanish and English instructions for the exercise. Please note that the solution video is in Spanish, but auto-generated captions are available in English. If you enjoyed this, please let us know in the …

2023 Week 10 | Power BI: Mapping Cities with Michelin Star Restaurants Read More

2023 Week 09 | Power BI: Create a table with custom and built-in microcharts

1 Comment / Power BI / By

Introduction This week we are making a table with microcharts (sparklines). Power BI does offer built-in sparklines, but sometimes we want formatting options not available with the defaults. Our challenge this week uses both the built-in sparklines and custom SVG images in a table. Requirements Create a custom column with the following logic: If the …

2023 Week 09 | Power BI: Create a table with custom and built-in microcharts Read More

2023 Week 08 | Power BI: Create an interactive resume

2 Comments / Power BI, Workout Wednesday / By

Introduction Welcome back to Workout Wednesday! This week we will use Power BI to build an interactive resume. This challenge is for a few different audiences. 1) Job seekers – feel free to use this template, plug in your information, make design tweaks, and post this to your portfolio! 2) Data vizzers – use the starter …

2023 Week 08 | Power BI: Create an interactive resume Read More

2023 Week 07 | Power BI: Non-linear Regression

2 Comments / Power BI, Workout Wednesday / By

Introduction This week for Workout Wednesday we will be trying our hand at non-linear regression with the Deneb custom visual. With Vega and Vega-Lite we can create a non-linear line of best fit over our data points and utilise the statistical API to return a correlation coefficient. Requirements Power Query Obtain the dataset from the …

2023 Week 07 | Power BI: Non-linear Regression Read More

2023 Week 05 | Power BI: Visualize the Oscars with an Isotype/Pictogram Chart

7 Comments / Power BI / By

Introduction Hello and welcome back to Workout Wednesday! If you’re joining us for the first time, be sure to check out our complete list of challenges. This week we’re looking at data from the American Academy Awards, also known as the Oscars. The Oscars are awards for artistic and technical merit for the American film industry …

2023 Week 05 | Power BI: Visualize the Oscars with an Isotype/Pictogram Chart Read More

Scroll to Top