Introduction This week we are exploring transforming tabular data with repeater widgets to display our top accounts and sales people based on total revenue. Use repeater widgets to show select fields from a query in a scrollable list in your dashboard. Create a customized layout of text, numbers, charts, and images in a repeater widget, …
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 »
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 »
Introduction Not everyone wants to consume analytics through their desktop these days. We live in a busy world where people are often on the go, so we’re focussing on a mobile dashboard this week. The goal is to create a simple view that can be quickly glanced at to see our KPIs vs. last year’s …
Introduction This week’s challenge was inspired by a question from a client. In truth, I was not able to solve the problem for them upfront. This challenge would not exist were it not for an article in the Tableau Community that explains how to achieve the desired outcome – thanks to whoever wrote this up! …
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 »
Introduction The theme for February 2023 has been alternatives. This week I present an alternative (and trust me, there are many other alternatives) to my least favorite chart: the side-by-side bar chart. The reason this chart is so difficult for me is because it takes up a lot of space and when I am doing …
2023 Week 8: Can you build a comet chart as an alternative to a side-by-side bar chart? Read More »
Introduction Welcome to WoW week 8! Last week we looked at hidden/unused pages in within your dashboards. The exercise last week was to get familiar with how to create and navigate between hidden pages. This week we will attempt different variations of uses cases of this functionality. Requirements Edit the dashboard from week 07 or …
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 …
Introduction Welcome to WoW Week 7! Have you ever needed to show different or conditional information on a dashboard… that is not actually a part of the page being viewed?? Or maybe you want to make changes to a dashboard but not yet ready to render them to a user?? Need to optimize dashboard efficiency …
