Introduction Welcome back to Workout Wednesday! This week we’re building some basic visuals and use dynamic titles to visualize gas prices in the Rocky Mountain Region of the US (where I live!) over the past 3 years from the U.S. Energy Information Administration. Be sure you’re using the June 2023 version of Power BI desktop or later …
2023 Week 34 | Power BI: Use core visuals with dynamic titles Read More
Introduction This week we are exploring user experience and design for CRM Analytics dashboards. Design foundations are the key visual elements to create a consistent interface. This includes guidance on color, type scale and fundamental navigation patterns. Using the Design Style Guide template app gives you a starting point for consistent and best practice design …
2023 Week 34 | User Experience, Design & Templates Read More
Introduction This is week 28 of 2023 and week 2 of #RE-VIZ-IT and I’m bringing back my VERY FIRST #WOW challenge from WAY BACK in the summer of 2018! I chose this challenge because “back in my day” this use case required additional sheets, a “custom” chart and a lot of sheet swapping. If you …
Introduction Hello and welcome to WoW week 28! This weeks topic takes it back to a fundamental lesson in CRM Analytics. I often get questions about data accuracy from users when they are comparing rows of data to the row count of a grouped chart or table. Have you ever experienced a case of “missing …
Introduction Welcome back to Workout Wednesday! This week we’re exploring the new card visual that was released in preview this month. Key metrics are frequently displayed in reports, and in the past it took a combination of cards, images, and other visuals. Thanks to the new card visual, we now have more flexibility, options for …
2023 Week 26 | Power BI: Display metrics with the new card visual Read More
Introduction This week we are exploring the Component widget. Essentially it is a container with pages that allows you to quickly create and reuse dynamic areas of a dashboard! Components solve 2 main use cases: Reusability & maintainability (the components you create in this challenge will be used again in a future challenge!) Easily (through …
Introduction Welcome back to Workout Wednesday! This week’s inspiration comes from the incredibly cool 1 dataset 100 visualizations project, presented by the Data Viz Project. The basic premise of the 1 dataset 100 visualizations project is that the team created 100 visualizations using a single, simple dataset. In today’s exercise, we challenge you to re-create as many of …
Introduction This week, we’re building on Shannon’s theme from Week 17 2022 by creating a custom Power BI theme–with a twist! Instead of manually selecting colors, this week you’ll use OpenAI’s free version of ChatGPT (or your Large Language Model (LLM) of choice) to create a theme. You’re in control of your prompts, and …
2023 Week 21 | Power BI: Create a Theme – With a Twist! Read More
Introduction For this Workout Wednesday, we are putting a Power BI spin on a Tableau viz created by Luke Stanke and Spencer Bauke for their Workout Wednesday 2023 Week 14. While we could probably match nearly exactly to the original Tableau viz by using Deneb in Power BI, I wanted to see what I could …
2023 Week 20 | Power BI: Remake of Tableau Length of Baseball Games Read More
Introduction Welcome back to Workout Wednesday! We’re taking inspiration once again from our friends at Makeover Monday. This one is fun – the Makeover Monday team was inspired by a bar chart featured in a blog post and they decided to recreate it in Tableau! You can read Andy’s full post on his blog if you want more info. Today …
2023 Week 19 | Power BI: Formatted bar chart and bookmark navigator Read More
