Tableau Prep a Taster Menu

Oct 9, 2023 Hannah Bartholomew | www.thedataschool.co.uk

Never heard of Tableau Prep? No problem, this 5 minute read defines major tools in Tableau Prep that can transform your data, ready for analysis.

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

Power BI Creating a Bump Chart

Oct 9, 2023 Numa Begum | www.thedataschool.co.uk

A bump chart tracks the change of rank by position of different categories over time. This is effective in visualising trends of rank position in relation to each other.

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

LODs In DAX Power BI

Oct 9, 2023 Myles Stevenson | www.thedataschool.co.uk

When Highlighting the maximum and minimum of a line graph we will need to make a nested calculate function.

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

How to create a Dumbbell Chart in Power BI

Oct 9, 2023 Patrick Maguire | www.thedataschool.co.uk

I love Dumbbell charts. They are an extremely effective chart type. Making your first Dumbbell Chart in Power BI, however, takes a little bit of work.

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

How to Create a Customer Order frequency chart in Power BI

Oct 9, 2023 Patrick Maguire | www.thedataschool.co.uk

Getting acquainted with how to create different graphs across Tableau in Power BI has been challenging, but like anything, with time, it gets easier! Here is a quick tutorial on how to create a Customer Order Frequency Chart.

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

How can we create a nested LODs expression in Power BI

Oct 9, 2023 Abby Poon | www.thedataschool.co.uk

In Tableaus, if we calculate the average sum of sales at the Category level, We can use nested LOD to deal with that: (to make it easier to understand, I am going to break down the LODs by two steps)

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

Highlight table with LODs in PowerBI

Oct 9, 2023 Jules Claeys | www.thedataschool.co.uk

LODs can require different functions and some thinking about columns and measures. Here’s an example on how to use them to recreate a tableau viz.

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

DAX CALCULATE Example Building a Monthly Profit KPI in PowerBI

Oct 9, 2023 Maddalena Mariano | www.thedataschool.co.uk

We want to know the number of profitable days achieved each month of the year. The data in Sample Superstore is recorded at the transactional level.

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

A Quick Start Guide to Tableau Prep

Oct 9, 2023 Nick Cassara | playfairdata.com

In this tutorial, we’ll be covering the Tableau Prep tool and how we can use it to build out data…The post A Quick Start Guide to Tableau Prep appeared first on Playfair Data.

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

Customize Your Tableau Filters

Oct 9, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 I’ve always wanted the ability tocustomize Tableau filters a little more than what’s possible out of the box.For example, it would be nice to be able to change the style of the checkboxesor add some additional text or use a completely different U...

Design,How-To,Tableau

The Neuroscience of Visualising Data

Oct 8, 2023 Numa Begum | www.thedataschool.co.uk

Humans love patterns.

Tableau Server and Cloud Security 110 Overview

Oct 8, 2023 markwu2000@gmail.com | enterprisetableau.com

This serial is about the Tableau server and Tableau Cloud security. Tableau has a Platform Security white paper that covers Authentication, Authorization, Data Security and Network Security. It is a good documentation, however I find that it is ha...

Tableau,TableauEnterprise,CloudSecurity,DataSecurity,ServerSecurity

Tableau Server and Cloud Security 110

Oct 8, 2023 markwu2000@gmail.com | enterprisetableau.com

This serial is about the Tableau server and Tableau Cloud security. Tableau has a Platform Security white paper that covers Authentication, Authorization, Data Security and Network Security. It is a good documentation, however I find that it is ha...

Tableau,TableauEnterprise,CloudSecurity,DataSecurity,ServerSecurity

Leveraging Epochs for Dynamic Timeframes in Data Analysis and Reporting

Oct 6, 2023 Robin Kennedy | www.theinformationlab.co.uk

In various industries, tracking open cases, or items—such as support tickets, overdue invoices, or waiting lists for medical treatments—is a common practice for business analysis and reporting. Traditional reporting methods usually focus on presen...

Blog

Unveiling Success The Crucial Role of Client Research in Consulting

Oct 6, 2023 Harvey Joyce | www.thedataschool.co.uk

Here are the best top tips when researching new clients!

Sheet Happens Replacing Sheets in Tableau like a Pro

Oct 6, 2023 Sid Saythongphet | www.thedataschool.co.uk

Image this, you have created a stunning dashboard. All of the sheets are aligned, fixed to the most optimal width/height, and the background colors and borders are customized to your liking.

How to calculate Years Months and Days in Tableau

Oct 6, 2023 Rosario Gauna | rosariogaunag.wordpress.com

Have you ever wondered how to calculate age precisely in years, months, and days using Tableau? If you’re a data analyst, it’s highly likely that you’ve faced this challenge in previous projects or will encounter it in the near future. Calculating...

English,Age,Days,LaborOld,Months,Years

Cmo calcular Aos Meses y Das en Tableau

Oct 6, 2023 Rosario Gauna | rosariogaunag.wordpress.com

¿Te has preguntado alguna vez cómo calcular la edad de forma precisa en años, meses y días utilizando Tableau? Si eres un analista de datos, es muy probable que hayas enfrentado este desafío en proyectos previos o que te lo encuentres en un futuro...

Espaol,Aos,Antigedad,Das,Edad,Meses

What did it take to get into DS42

Oct 5, 2023 Robbin Vernooij | www.thedataschool.co.uk

DS42 has just started their journey at the Data School. A perfect time to look at what it took for them to get in!

Espaol,Aos,Antigedad,Das,Edad,Meses

Planning with user stories XZY Framework

Oct 5, 2023 Dan Wade | www.thedataschool.co.uk

Day 2 at The Data School focused on user stories in data analysis, using the XYZ framework.

Espaol,Aos,Antigedad,Das,Edad,Meses

Getting out of Locale Hell in Power BI

Oct 5, 2023 Matthias Albert | www.thedataschool.co.uk

The topic of this post might be a none-issue for most Power BI users. Consider yourself lucky if this is the case. But depending on your system locale and the date and decimals format in your data, you might find yourself spending a frustrating am...

Espaol,Aos,Antigedad,Das,Edad,Meses

Data Basics Missing Data

Oct 5, 2023 Aurora Malinauskaite | www.thedataschool.co.uk

Is it truly missing or was it not there to begin with?

Espaol,Aos,Antigedad,Das,Edad,Meses

Dashboard Design Best Practices Eliminate Noise from the Dashboard

Oct 5, 2023 Tobias Fitschen | www.thedataschool.co.uk

Hello everyone! Welcome to part five of the dashboard design series, which is already the last part. So far we discussed the advantages of applying whitespace, proper text use, chart choice and color choice in your dashboards. Moving on, this blog...

Espaol,Aos,Antigedad,Das,Edad,Meses

Tableau Hacks The Forklift

Oct 5, 2023 Robin Schouten | interworks.com

In the past, Tableau used to have a maximum number of 16 dimensions on the row shelf. Whilst it is generally not recommended to create tables that exceed that number anyway (there are other tools for that), Tableau has upped the limit to 50 and…Th...

Data,Tableau,TableauHacks,TableauTips

InterWorks Blog Roundup September 2023

Oct 5, 2023 Mark Cordeiro | interworks.com

Ah, September. The breaking of the summer heat, state fairs, the winds of change beginning to usher in a new season and children returning to school. Idyllic, for sure, but we haven’t been taking too much time to stop and smell the roses. We kicke...

Data,Roundup,Snowflake,Tableau

Lets Analyse New Product Sales

Oct 5, 2023 Donna Coles | donnacoles.home.blog

For the challenge this week, Sean wanted us to identify the sales of ‘new’ products compared to previous years. This challenge was born out of a requirement he had at work, where he discovered the definition of a ‘new product’ was different to wha...

WorkoutWednesday,WOW2023,CustomNumberFormat,FIXEDLOD,LOOKUP,PercentofTotal,StackedBarCharts,TableCalculations,Week40

Customizing Shapes with Opacity in Tableau

Oct 4, 2023 Lindsay Betzendahl | vizzendata.com

Better Tables A number of years ago (2020), Tableau Iron Viz finalist, Ludovic Tavernier, created a dashboard that showcased twoContinue reading

DataVisualization,Tableau,Tutorial,Design,Ludovic,Shapes,Tables

Wireless and Wired Connections in Alteryx

Oct 4, 2023 Jessica Kwan | www.thedataschool.co.uk

Before working on my recent project, I didn’t know that wireless connections in Alteryx were a thing. I ran around telling people and from the reactions I got, I realized that wireless connections are like pie charts in that you either love them o...

Espaol,Aos,Antigedad,Das,Edad,Meses

Right Round rounded edge UI design in Tableau

Oct 4, 2023 Caitlin Walsh | www.thedataschool.co.uk

A short summary of a few options for including rounded edges in Tableau, and why this design feature might have become so popular.

Espaol,Aos,Antigedad,Das,Edad,Meses

Dividing the Data

Oct 4, 2023 Thomas Smith | www.thedataschool.co.uk

Though it may initially seem more straightforward to store an extensive array of information for each of the records in a table within a single file, there are many reasons why you should NOT to do this.

Espaol,Aos,Antigedad,Das,Edad,Meses

Introducing Gap Charts in Tableau

Oct 4, 2023 Ryan Sleeper | playfairdata.com

In Practical Tableau, we introduced the concept of a pace chart, an alternative bullet graph that normalizes progress to goal…The post Introducing “Gap” Charts in Tableau appeared first on Playfair Data.

Advanced,ChartTypes,Storytelling,TipsTricks

Totals for Tableau Text Tables Tips and Tricks

Oct 4, 2023 Eric Parker | onenumber.biz

Text tables can be overwhelming because they contain a lot of information without using many pre-attentive attributes to draw the users’ attention toward areas of interest. One of the best ways to add value to a text table in Tableau is to add tot...

TableauTextTables,TableauTotals

More thoughts on visualizing uncertainty in survey data

Oct 4, 2023 Steve Wexler | www.datarevelations.com

I recently participated in a LinkedIn Live discussion about how to visualize uncertainty in survey data with Bob Walker, Anna Foard, and Jon Cohen. I find myself contemplating whether we have a type of moral obligation to try to make sure our audi...

BusinessVisualizations,VisualizingSurveyData,Confidence,errors,uncertainty

Master Dynamic Zone Visibility in Tableau Yearly to Monthly Calendar Dri...

Oct 3, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Welcome to this comprehensive tutorial on creating a Yearly to Monthly Calendar Drill Down using Dynamic Zone Visibility in Tableau.📌 What You Will LearnIn this video, you’ll discover how to use Tableau’s Dynamic Zone Visibility feature to effortl...

boolean,calendar,calendardrilldown,datavisualization,drilldown,drilldown,dynamiczonevisibility,howto,interactivity,month,parameter,parameteraction,tableau,tip,tutorial,year

User stories - a way to kill your darlings

Oct 3, 2023 Faith Rotich | www.thedataschool.co.uk

Embracing the constraints of a user story can be a powerful way to let go of elements that, while dear to us, may not truly serve the greater narrative.

Espaol,Aos,Antigedad,Das,Edad,Meses

User Story and Viz Sketches

Oct 3, 2023 Robbin Vernooij | www.thedataschool.co.uk

Creating user stories and sketches allow you to feedback your understanding of the clients needs and will help guide you through the data and visualisation work whilst potentially saving yourself heaps of time before getting stuck into it.

Data,Fail-safe,Snowflake,tables,TimeTravel

User Stories and Sketches

Oct 3, 2023 Yoan Caboste | www.thedataschool.co.uk

How do you deal with a client who doesn’t quite know what they want or need? The 5 Whys method may help you out!

Espaol,Aos,Antigedad,Das,Edad,Meses

User Stories - A way to kill your darlings

Oct 3, 2023 Faith Rotich | www.thedataschool.co.uk

Embracing the constraints of a user story can be a powerful way to let go of elements that, while dear to us, may not truly serve the greater narrative.

Data,Fail-safe,Snowflake,tables,TimeTravel

The Power of Asking Questions

Oct 3, 2023 Lisa Hitch | www.thedataschool.co.uk

I always loved the Information Lab’s company philosophy “Asking questions encouraged”. In preparation for this blog post, I went on a journey to interview as many colleagues as possible about their take on the power of asking questions.

Data,Fail-safe,Snowflake,tables,TimeTravel

The Inclusive Nature of Stupid Questions

Oct 3, 2023 Harvey Joyce | www.thedataschool.co.uk

Yes, your cluelessness is actually an asset!

Espaol,Aos,Antigedad,Das,Edad,Meses

How to put Yourself in the Users Shoes

Oct 3, 2023 Hannah Bartholomew | www.thedataschool.co.uk

A 2 minute guide on how to consider the user BEFORE creating your visualization.

Espaol,Aos,Antigedad,Das,Edad,Meses

How to Research Your Client Before Meeting Them

Oct 3, 2023 Beza Taye | www.thedataschool.co.uk

Research your client using these questions provided for a prepared first-meet with them.

Espaol,Aos,Antigedad,Das,Edad,Meses

A simple introduction to fact and dimension tables

Oct 3, 2023 Aurora Malinauskaite | www.thedataschool.co.uk

During day 2 of the data school, we covered some key concepts including fact and dimension tables. This blog provides a simple introduction.

Espaol,Aos,Antigedad,Das,Edad,Meses

Which Snowflake Table Type Should You Use

Oct 3, 2023 Guilherme Rampani | interworks.com

As Snowflake has developed over the years, we have seen the introduction of more and more table types, and it isn’t always immediately clear what the differences are and when they should be used. Today, I hope to shed some light on this by outlini...

Data,Fail-safe,Snowflake,tables,TimeTravel

Exploring Football Transfer Window Spending with Tableau in 2023

Oct 3, 2023 Matthew Whiteley | interworks.com

Last year, I took a look at the Summer 2022 transfer window for the top five leagues in Europe. The main takeaway was that Premier League clubs are pulling away from the rest of Europe when it comes to their spending power. But has this…The post E...

Data,datavisualization,football,soccer