Introduction A percentile is a number denoting the position of a data point within a numeric dataset by indicating the percentage of the data points with an equal or lesser (assuming it’s inclusive) value. Percentiles can be used to understand test scores, stock values, health indicators, and other values. This week, we will use them to look …
2024 Week 49 | Power BI: Visualize Ranges with Percentiles Read More
Introduction A bump chart shows changes in rank over time. This week, inspired by a visual from Statista Charts, we are making a bump chart of the countries with the highest GDP in 3 selected years. The example below uses a ribbon chart core visual to create the bump chart, but you are welcome to use …
Introduction Welcome back to Workout Wednesday! I’m nearing the end of my 4th year contributing to this incredible initiative, and quite honestly, I am running out of ideas! This week I went to the Fabric Data Stories Gallery to look at reports that have inspired me, and I was reminded of this incredible report that Jason Thomas …
2024 Week 44 | Power BI: Community Appreciation – SQLJason Read More
Introduction This week’s challenge is to test your data storytelling skills and enhance a line chart of service desk survey responses to focus attention on important aspects. No solution file provided this week. Requirements Obtain the data Model Data Create a chart showing survey response trends Dataset This week’s dataset is downloadable from Github https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Help%20Desk.xlsx …
Introduction Welcome back to Workout Wednesday! This week’s challenge is purely dataviz – there is no data transformation involved. A huge thanks to our friend and colleague Zoe Douglas for providing us with a beautiful and fun report to recreate. Find the data and instructions to complete the challenge below, and as always, have fun! Requirements …
2024 Week 28 | Power BI: Create custom navigation with Zoe Douglas Read More
Introduction Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with a built-in theme and customize it, or create your own theme. In addition to the primary data colors, we can also define sentiment colors and divergent …
2024 Week 26 | Power BI: Reference Theme Sentiment Colors in DAX Read More
Introduction Welcome back to Workout Wednesday! This week’s challenge is purely dataviz – there is no data transformation involved. You have the pleasure of either recreating or making over the stunning sample report provided by the Power BI core visuals team. This report is beautiful to look at and was built to demonstrate some of the …
2024 Week 24 | Power BI: Get creative with the Power BI Core Visuals team Read More
Introduction Welcome back to Workout Wednesday! This week’s challenge is for participants new to Power BI and/or new to data visualization. We’re building a report containing 2 charts, a table, and a slicer. My challenge to you is to design the report in a way that a) makes sense to business users and b) is …
2024 Week 20 | Power BI: Build your first report with Dynamics 365 Business Central Data Read More
Introduction Welcome back to Workout Wednesday! This week we’re celebrating Earth Day (April 22) with a design challenge. You can do whatever your designer heart desires with this challenge. I’ve provided a sample, but this is just to get your creative juices flowing. Whatever you do, ensure that your design is accessible and that you’re …
2024 Week 17 | Power BI: Design an Earth Day Infographic Read More
Introduction Since I watched the solar eclipse from Texas this week, we have a solar theme. We are visualizing the sunrise time each day in 2024 to date. I’m keeping it simple with the line chart core visual, but you can use whatever visual you would like. Requirements 1. Retrieve the data from Data.World. 2. …
2024 Week 15 | Power BI: Visualize sunrise times with a line chart Read More
