Aggregating Data in Power Query

Jan 2, 2024 Andrew Tobin | www.thedataschool.co.uk

Aggregation is an important part of data preparation, and this is achieved in different ways depending on the data prep software used. While in Tableau Prep this is achieved by adding an ‘Aggregate’ step to the flow, Power Query makes use of the ‘...

A Reflection on my Tableau Training Day

Jan 2, 2024 Beza Taye | www.thedataschool.co.uk

Teaching has always been a passion of mine, so when DS42 was informed about a training day on Power BI and Tableau for clients and the general public, I was pretty excited. While I’m used to 1-2-1 tutoring with teenagers, teaching a group of grown...

Blue and Green Dimensions and Measures

Jan 1, 2024 Faith Rotich | www.thedataschool.co.uk

That dimensions are blue and measures are green in Tableau is a common misconception. I thought so too when I first started using Tableau. Now, as I revisit fundamental concepts in preparation for the certification exam, I thought to write a blog ...

Filters,Salesforce,Tips,embedding,Tableau

Filter a Tableau Dashboard using Salesforce

Dec 31, 2023 Marc Reid | datavis.blog

In this follow-up blog post on Embedding Tableau views within Salesforce, I walk through two options for passing filters from the Salesforce UI to Tableau to improve the user experience and ensure your embedded dashboards are showing relevant info...

Filters,Salesforce,Tips,embedding,Tableau

Project Management Insights Trust Documentation and Communication

Dec 30, 2023 Franziska Schwade | www.thedataschool.co.uk

This blog post lists a few things that I noticed were important about my project manager role. I reflected on teamwork, scheduling, documenting, and general communication. Hopefully, this is also useful to other people trying to take on the projec...

The Order of Operations

Dec 29, 2023 Finn Kappus | www.thedataschool.co.uk

The Order of Operation also referred to as query pipeline, is a fundamental concept in Tableau. It dictates the order in which Tableau processes data. This includes the order in which, filters, calculated fields, and other Tableau features are exe...

Strings and Calculated fields

Dec 29, 2023 Saampave Sanmuhanathan | www.thedataschool.co.uk

A string is a sequence of characters such as letters and words. A calculated field allows us to create new data fields with the data we already have. When performing calculations using strings, tableau has a range of functions we can use. Some com...

Spatial Analytics in Alteryx Part 1

Dec 29, 2023 Le Luu | www.thedataschool.co.uk

One feature from Alteryx that impressed me is Spatial Analytics. From Spatial Analytics in Alteryx, I can do most analytics in spatial including finding the boundary, finding the distance between points, and calculating the area,… In this blog, I ...

SQL and Snowflake 5 LODs ranks and CTEs

Dec 29, 2023 Harvey Joyce | www.thedataschool.co.uk

In this blog, I take on Preppin’ Data Challenge 2023 Week 5 in Snowflake using SQL!

SQL and Snowflake 4 Reshaping Data with unions pivots and date functions

Dec 29, 2023 Harvey Joyce | www.thedataschool.co.uk

In this blog, I take on Preppin’ Data Challenge 2023 Week 4 in Snowflake using SQL!

SQL and Snowflake 3 pivots LODs subqueries vs CTEs

Dec 29, 2023 Harvey Joyce | www.thedataschool.co.uk

In this blog, I take on Preppin’ Data Challenge 2023 Week 3 in Snowflake using SQL!

SQL and Snowflake 2 joins concatenation and cleaning

Dec 29, 2023 Harvey Joyce | www.thedataschool.co.uk

In this blog, I take on Preppin’ Data Challenge 2023 Week 2 in Snowflake using SQL!

SQL and Snowflake 1 Reshaping Data using aggregates splits aliasing and ...

Dec 29, 2023 Harvey Joyce | www.thedataschool.co.uk

In this blog, I take on Preppin’ Data Challenge 2023 Week 1 in Snowflake using SQL!

Produktivitt im Home-Office

Dec 29, 2023 Finn Kappus | www.thedataschool.co.uk

Elon Musk und andere Traditionalisten befürworten nach wie vor die persönliche Arbeit und fordern eine ständige physische Anwesenheit im Büro in dem Glauben, dass dies zu einem stärkeren Zusammenhalt des Teams beiträgt und die allgemeine Produktiv...

Personal Project I

Dec 29, 2023 Finn Kappus | www.thedataschool.co.uk

Winning my NBA Fantasy League with Tableau

Granularity Aggregation in Tableau Desktop

Dec 29, 2023 Faith Rotich | www.thedataschool.co.uk

A few weeks ago, when leading a teaching session for TIL Training Day, one of the participants asked why, when creating a Profit Ratio calculation on Tableau Desktop, we use the syntax SUM(Profit)/SUM(Sales) as opposed to simply Profit/Sales. This...

Formatiere einen Alias fr die Option Alle Felder in der Tableau QuickInfo

Dec 29, 2023 Franziska Schwade | www.thedataschool.co.uk

Ihr kennt das sicherlich: euer Dashboard ist fertig, alle QuickInfos wurden mit viel Aufwand formatiert, und das Ergebnis lässt sich sehen. Ihr filtert euer Dashboard und alle Werte passen sich in den QuickInfos an, genau so wie ihr es sehen wolltet.

Erstellen von benutzerdefinierten kategoriale Farbpaletten in Tableau

Dec 29, 2023 Volha Fiadotava | www.thedataschool.co.uk

In diesem Artikel werde ich Sie durch die Schritte führen, um Ihnen bei der Erstellung einer benutzerdefinierten Farbpalette zu helfen. Dies könnte erforderlich sein, wenn Sie eine Palette für eine bestimmte Marke erstellen möchten.

Using datetimeoffset from SQL Server in Tableau

Dec 28, 2023 George Ledger | www.thedataschool.co.uk

A form of SQL Server is a very common way of retrieving your data to use in Tableau. In SQL it is normal to store dates (with specific times) in the ‘datetimeoffset’ datatype however, Tableau does not support this.

Reducing Time to Insight

Dec 28, 2023 Salome Grasland | www.thedataschool.co.uk

In the realm of data analysis a well-crafted dashboard transforms data into actionable insights. It serves as the map that allows users to navigate seamlessly through mountains of information. The essence of a good dashboard lies in its ability to...

Project Managers Guide to Documenting a Data Consulting Project

Dec 28, 2023 Franziska Schwade | www.thedataschool.co.uk

Last week, I led my first project as a project manager. I was genuinely excited about the documentation part. I’ve always enjoyed documenting things; I’m a big memory keeper in my personal life. I keep notes, lists, and have been maintaining journ...

Power BI How to add a Dynamic Title with DAX

Dec 28, 2023 Aurora Malinauskaite | www.thedataschool.co.uk

Add a dynamic title to your Power BI dashboard when using drill throughs or slicers.

Power BI How to Drill Through

Dec 28, 2023 Aurora Malinauskaite | www.thedataschool.co.uk

A short tutorial on how to drill through from one page to another in Power BI using a common categorical field.

Interesting Findings From My Application Viz

Dec 28, 2023 Alan Grunberg | www.thedataschool.co.uk

For my application to the Data School, I created a Tableau viz using publicly available data from Citi Bike. Working on this project led me to some interesting findings which I’d like to share.

How to color differentiate cities in a user-defined region on a map from...

Dec 28, 2023 Alex Briody | www.thedataschool.co.uk

You can define various regions of a country so that the map can be filtered to specific areas defined to include a number of states in the Midwest United States, for example.

General Steps to Create a New Dashboard in Tableau

Dec 28, 2023 Cecily Santiago | www.thedataschool.co.uk

You’ve already created your vizzes and sketched the general layout of your dashboard. You click the icon to create a new dashboard in Tableau. Now what?

Dynamic Zone Visibility in Tableau

Dec 28, 2023 Volha Fiadotava | www.thedataschool.co.uk

In diesem Artikel werde ich erklären, wie man in Tableau eine Dynamic Zone Visibility erstellt.

Creating Heatmaps in Tableau

Dec 28, 2023 Salome Grasland | www.thedataschool.co.uk

If you are coming from the world of Python you may be familiar with the concept of a correlation heatmap. These heatmaps allow us to visually interpret how different variables correlate with one another. This tool can show us interesting trend in ...

Change the Axis Range and Axis Title Dynamically old and new Tableau ver...

Dec 28, 2023 Le Luu | www.thedataschool.co.uk

In some cases, I would like to build a visualization to see how the metric changes in time series. However, there are many metrics in the dataset, but I don’t want to build each visualization for one metric. In this case, I need to find a way to c...

User Stories

Dec 27, 2023 Saampave Sanmuhanathan | www.thedataschool.co.uk

When running a successful client project, we must know what the user story is. User stories help us understand who the client is and what we are trying to achieve. They are structured in the following way:

Color Data Points Dynamically in Tableau

Dec 27, 2023 Le Luu | www.thedataschool.co.uk

Interactive dashboard was one of my favorite topics when I was in training at The Data School. It helps the audience or the stakeholder get insight faster based on the color, filter, and actions, … I usually apply Gestalt Principles in building vi...

APIs with Alteryx

Dec 27, 2023 Beza Taye | www.thedataschool.co.uk

What is and API and How do they work?

Object in Tableau Layout Container Wont Contract

Dec 27, 2023 Eric Parker | onenumber.biz

Do you have an object in your Tableau dashboard that should be expanding and contracting but isn’t?

LayoutContainers,TableauDashboards

Using Parameters to Sort

Dec 26, 2023 Salome Grasland | www.thedataschool.co.uk

Sometimes your data visualization will demand sorting by a custom value. Using the Superstore Data in Tableau we will review how you can create a custom sort on your chart.

Announcements

Tableau LOD - Order of Operations Part 2

Dec 26, 2023 Nuki Susanti | www.thedataschool.co.uk

In the last post (part 1, unfortunately in German), I mentioned 3 types of LODs in Tableau. I believe, it is already very clear on the cases where INCLUDE, EXCLUDE and FIXED are applied. However, I noticed one thing on the LOD calculation that rai...

Announcements

Tableau LOD - FIXED Teil 3

Dec 26, 2023 Nuki Susanti | www.thedataschool.co.uk

Dieser Post ist immer noch eine Fortsetzung des letzten Posts (Teil 2). Basierend auf diesem Fall ist es sehr verlockend, den FIXED LOD-Ausdruck zu verwenden, nur zum Ausprobieren und Vergleichen.

Announcements

So what

Dec 26, 2023 Salome Grasland | www.thedataschool.co.uk

The “So what” question is integral to the effectiveness of data visualization. It creates meaningful insights, provides context, supports decision-making, and enhances the overall impact the information that is communicated. When creating visualiz...

Announcements

Reflektierendes Logbuch - Internes Kundenprojekt Chin Beard Suds Co.

Dec 26, 2023 Mihai Mazareanu | www.thedataschool.co.uk

In der sechsten Woche unseres Trainings hatten wir das erste von insgesamt 8 Kundenprojekten. Das erste war ein internes Projekt mit Daten vom internen TIL-Server, und ich wurde ausgewählt, um das Projekt zu leiten. Ich möchte gerne meine Gedanken...

Announcements

Organizing and Simplifying Data in Tableau

Dec 26, 2023 Alex Briody | www.thedataschool.co.uk

Create Hierarchies

Announcements

Macro in Alteryx Part 2

Dec 26, 2023 Le Luu | www.thedataschool.co.uk

In the first part of Macro in Alteryx, I introduced the overview of macro, the type of macro, and a demo for standard macro and batch macro. Continue to the first part, I am going to write about the Iterative Macro in Alteryx. In this blog, I will...

Announcements

Compost Garden Data

Dec 26, 2023 Alan Grunberg | www.thedataschool.co.uk

This past year, I started volunteering at a compost garden in my neighborhood. Every Sunday neighbors come and drop their food scraps off at the garden. We compost the scraps into soil which we use for growing vegetables, herbs, and other plants.

Announcements

Chaos to Clarity Unpacking Information in a Blink

Dec 26, 2023 Salome Grasland | www.thedataschool.co.uk

The beauty of data visualization is that you can take a mountain of information and package it into an easily digestible visual. A spreadsheet that was previously a jumble of numbers can transform itself into a beautiful bar chart that clearly dem...

Announcements

Tableau LOD - Warum brauchen wir Teil 1

Dec 25, 2023 Nuki Susanti | www.thedataschool.co.uk

Die Datengranularität ist der Detailgrad der Daten. Sie beschreibt, wie detailliert unsere Daten sind, z. B. pro Tag, pro Stunde oder Minute bei Time-Series Analyse. Die Granularität geht Hand in Hand mit der Aggregation. Durch die Aggregation geh...

Tableau When Should I Use Connections and Joins

Dec 24, 2023 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

Initial Phase: Getting to Know the Data (Structure)

Card-Styled Dashboard Template and Dark Mode

Dec 24, 2023 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

I’d like to post another one of my latest Tableau Dashboard here; one of few that I find interesting, design-wise. It might not be the easiest-to-understand dashboard. It might be just a bunch of repetitive, similar looking bar charts thrown into ...