Introduction Have you ever wondered what’s in that fancy coffee drink you ordered? Me too! Let’s take a look using an infographic in Power BI. In this week’s Workout Wednesday we will be creating an infographic using the PureViz custom visual. I had loads of fun creating this and cannot wait to see what you …
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
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 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 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
Power BI Highlights with DAX
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
Power BI Conditional Formatting using Background Color, Font Color, and Icons
Power BI Conditional Formatting using Background Color, Font Color, and Icons
Introduction Thanks for joining us for Week 10 of Workout Wednesday – Power BI Edition. This week our challenge is to use the Violin Plot custom visual. There are no dependencies on prior weeks for this workout, so feel free to jump right in. Custom visuals are additional visuals created by Microsoft and Microsoft partners …
2021 Week 10 | Power BI: Violin Plot Custom Visual Read More
