How to shape business metrics and stories into Dashboards

Introduction


Image by Author

In this series we look at all sorts of SQL features, by doing examples from real world scenarios.

· Intro
·
Source data & DIY setup
·
Quiz
·
Concepts explained
1. Exponential Row Generator : Cross Join
2. Unique data value generation
·
Solution

Intro

Source data & DIY setup


Photo by Isaac Smith on Unsplash
· Getting Tableau Public and a data set
Getting Tableau Public
Getting the source data set
·
Getting the source data set
·
Step 1 — Connecting the data
·
Step 2 — Editing the data
·
Step 3 — Visualizing the data
·
In a nutshell..

Getting Tableau Public and a data set


Image by Author

In this series we look at all sorts of SQL features, by doing examples from real world scenarios.

· Intro
·
Data
·
Quiz
·
Concepts explained
·
Solution

1. Intro

2. Data


Image by Author
· Intro..
·
Source data & DIY setup..
·
Quiz..
·
Concepts explained..
·
Solution..

Intro..

  • finding the Top N, or Bottom N values
  • handling duplicate rows, or values
  • assigning unique rows identifiers
  • calculating more advanced derived values
  • .. so much more


Image from Unsplush by Balázs Kétyi

How human perception drives Dashboard designers

Design can cause weakness


Image from Patrick Tomasso edited by Author
· Quick reminder about LOD expressions
·
Testing "Quick LOD"
·
Testing Outcomes
·
In a nutshell…

Quick reminder about LOD expressions


Photo by @alexmotoc on Unsplash

Tips and Tricks

An effective approach to analyse and understand complex SQL

· What can make SQL tricky
· Breaking SQL complexity
1. Improve…


Revolutionary SSA


Photo by Honey Yanibel Minaya Cruz on Unsplash

This divulgation series aims to explain different topics about Data subjects, in a simple but effective way.

Introduction

Maw Ferrari

Data freelance. Data literacy evangelist. Math & music hobbyist.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store