Introduction A few weeks ago I saw this Twitter poll (and the ensuing discussion) about Team Tiled vs Team Floating and I noted that I am neither. Rather, I am Team Container. Using Containers in dashboards makes positioning and sizing everything in your dashboard a piece of cake, once you have mastered how they work. …
#WOW2023 | Week 12 | Can you build a dashboard using containers? Read More
Introduction Welcome back to Workout Wednesday! This week we’re taking a note out of Meagan’s book and looking at existing reports to ensure they’re accessible to our end-users. Creating accessible Power BI reports isn’t just a nice-to-have feature, but a crucial aspect for ensuring all users can access and understand your data. Don’t let accessibility …
2023 Week 12 | Power BI: Are your reports accessible? Read More
Determining trend for use in smart narratives with DAX LINEST and Power BI
Introduction This week we align ourselves with the DuBois challenge, which aims at celebrating the work of W.E.B. Du Bois. You can learn more about him, his visualisations, the data behind them and the challenge here: https://github.com/ajstarks/dubois-data-portraits Some of his charts are quite “out there” so I chose one that could be recreated in CRMA. …
Introduction This week’s challenge is focused on interactivity, and was born out of a client requirement to compare store locations via selections from a map. I’ve naturally adapted it to use our favourite Superstore dataset. The core requirement is to be able to make a selection on the map and see how sales compare to …
One of the less often used features of Tableau is device designer. While it may not be needed all the time, when the need does arise its good to have the practice under your belt
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 …
