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
Introduction This week we are collaborating with Preppin’ Data to get a close look at the schedule for the 2020 Olympic Games! We’re also collaborating with the Tableau team and we invite you to take a look at both challenges! With the opening ceremony 2 days away, we thought we’d visualize the schedule in our own time zone. We encourage you …
2021 Week 29 | Power BI: Let’s Watch the Olympics! Read More
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
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! Starting off the month, you’ll use Power Query to perform preliminary cleanup and filtering of data exported …
2021 Week 27 | Power BI: Data Transformation with Power Query Read More
Introduction This is our last week using the Nobel Prize data. We are again looking at the age of the laureate when they were awarded the prize. This time we will examine it using a histogram. Histograms measure the distribution of data within defined ranges. So we are calculating age and creating bins of equal …
2021 Week 26 | Power BI: Make a Histogram with Equal Size Bins Read More
Introduction This week we are building on Meagan and David’s challenges using the Nobel Prize data. We’re also continuing on our customization journey and will have a bit of fun using unicode values. Unicode is a standard numeric value that represents a character, which can easily be transformed into a character in Power BI using a bit …
Introduction This week we are continuing with the Nobel laureates data and taking a look at gender diversity of Nobel laureates. We’ll do this by using an isotype visualization. Isotype visuals use an icon that is related to the subject matter being depicted and often use multiples to represent quantitative data. You can learn more about …
2021 Week 24 | Power BI: Create an Isotype Visualization Read More
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
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
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 …
