2023 Week 11 | Power BI: Determining trend with LINEST
Determining trend for use in smart narratives with DAX LINEST and Power BI
Workout Wednesday
#WOW2023 | Week 11 | Can You Compare State Sales?
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 …
#WOW2023 week 10: Let’s practice Device Designer
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
2023 Week 10 | Repeater Widget
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, …
2023 Week 09 | Mobile KPI Scorecard
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 …
#WOW2023 | Week 9 | A tricky filter
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! …
2023 Week 08 | Power BI: Create an interactive resume
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
2023 Week 8: Can you build a comet chart as an alternative to a side-by-side bar chart?
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
2023 Week 08 | Hidden Pages Extended
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 …
2023 Week 07 | Power BI: Non-linear Regression
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 …