Macro in Alteryx Part 1

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

An Alteryx Macro is a combination of many tools of a workflow built into a single tool that can be inserted into another workflow. The user can save the macro and re-use it without re-create the workflow. Macro helps to solve the problem faster if...

Elf Economics

Dec 22, 2023 Donna Coles | donnacoles.home.blog

For the penultimate challenge of 2023, Erica set this fun Christmas themed challenge to visualise the toy production in Santa’s workshop. It was a collaboration with the #PreppinData crew, where you were encouraged to complete their challenge to p...

WorkoutWednesday,WOW2023,BarChart,DualAxis,LineChart,Mostrecentlabel,RUNNING_SUM,TableCalcs,Week51,WINDOW_MAX

Pros and Cons of PowerBI

Dec 21, 2023 Holly Jones | www.thedataschool.co.uk

Today was our first day learning PowerBI and Power Query. In the second half of the day, we were tasked with replicating two designs, the first designing an overview of the Top 50 Films on Netflix and the second replicating executive sales from th...

Calculations in Power BI and Tableau Part 2

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

In the first blog of Calculations in Power BI and Tableau, I introduced the definition of the DAX and some common DAX functions in Power BI. If you haven’t read it yet, you can click here. Continue to that blog, in this second blog, I am going to ...

Year in Review Top 10 Playfair Tutorials of 2023

Dec 21, 2023 Dan Bunker | playfairdata.com

It’s hard to believe that another year has gone by and 2024 is just around the corner. While we are…The post Year in Review, Top 10 Playfair+ Tutorials of 2023 appeared first on Playfair Data.

Announcements

Sunburst Chart Part II- Multilayer Sunburst

Dec 20, 2023 Jun Hou Kok | www.thedataschool.co.uk

In a previous blog, I’ve demonstrated how to make a simple 2 layer sunburst chart using ‘dummy’ pills. Sunburst charts functions as a pie chart but provide a deeper layer of detail breaking. This is especially useful when it is used to visualize h...

TableauParameters,TableauCalculations

SQL... Some Questionable Lingo

Dec 20, 2023 Hannah Bartholomew | www.thedataschool.co.uk

An intro to the basics of SQL.

TableauParameters,TableauCalculations

Punk API Drinking on the job

Dec 20, 2023 Dan Wade | www.thedataschool.co.uk

A tutorial on how to use the Punk API and clean data in Alteryx ready for analysis.

TableauParameters,TableauCalculations

APIs in Alteryx Designer - An Introduction

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

What is an API?

product-management,data-engineering,data,analytics,product-leadership

3 important aspect in crafting a good dashboard

Dec 20, 2023 Jun Hou Kok | www.thedataschool.co.uk

Tableau dashboards serve many functions in different environments and settings. A dashboard made for the finance department of a company, comparing yearly metrics can look and feel very different when thinking about a dashboard designed to deliver...

TableauParameters,TableauCalculations

Swap Between Measures with Different Number Formats in Tableau

Dec 20, 2023 Ollie Linley | onenumber.biz

Normally, when using a parameter to swap between measures, you’re limited to using a single number format in a text table. But what happens when using the same number format makes no sense?

TableauParameters,TableauCalculations

From Data to Design The Process of Building a Dashboard

Dec 19, 2023 Serena Purslow | www.thedataschool.co.uk

Ever wondered what goes into the process of building a Tableau dashboard? From creating fake data, to designing an eye-catching viz - I’m going to take you through all the steps I took to build a Sales Pipeline Dashboard.

product-management,data-engineering,data,analytics,product-leadership

Calculations in Power BI and Tableau Part 1

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

During the training time with DSNY 5, I had an opportunity to work on a client project using Power BI. The team and I didn’t know much about the Power BI tool at that time. Thanks to Lyon Abido, and Kinley Ly - The Data School consultants in cohor...

product-management,data-engineering,data,analytics,product-leadership

Understanding the multiple layers of data management enabling products

Dec 19, 2023 Elliott Stam | towardsdatascience.com

What product leaders need to know to get unblocked by dataContinue reading on Towards Data Science »

product-management,data-engineering,data,analytics,product-leadership

Understanding the Multiple Layers of Data Management Enabling Products

Dec 19, 2023 Elliott Stam | medium.com

What product leaders need to know to get unblocked by dataContinue reading on TDS Archive »

product-management,data-engineering,data,analytics,product-leadership

Start Here What does one row of data represent

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

Last week, our coach Val told us that the most important part of working with a new dataset is understanding what one row of data represents. Experience reinforced this lesson for me while working on my project this week.

data-science,trading,tableau,cryptocurrency,machine-learning

Wireframing a Tableau Dashboard

Dec 15, 2023 Leigh Davis | www.thedataschool.co.uk

I will be showing you how to wireframe a Tableau dashboard. This will assist you in creating a well organized dashboard. So let’s jump right into it and get started.

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

What is the Ideal Workout Split A Passion Project

Dec 15, 2023 Tyler Ha | www.thedataschool.co.uk

I was watching a Youtube video the other day titled, “Comparing Training Splits for Muscle Growth (20 STUDIES).” As the title suggests, this video referenced the results of 20 different studies that examined how different workout splits performed ...

Espaol,Filters,ParameterActions,UI,UserExperience,UX

Shape charts and highlight actions What if the charts have different lev...

Dec 15, 2023 Maddalena Mariano | www.thedataschool.co.uk

This week I have been working on a dashboard for the Data School.The project included a really interesting application of highlight actions, which

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

Power BI vs Tableau My Experience

Dec 15, 2023 Michael Imbriale | www.thedataschool.co.uk

For a week, I decided to leave the world of Tableau and venture into the world of Power BI. I had never used the platform before, but I had heard of it. Power BI is a one-stop shop for data cleaning and data visualization. It is a Microsoft-based ...

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

My Data School Application Experience Part 1

Dec 15, 2023 Leigh Davis | www.thedataschool.co.uk

The application process of The Data School at The Information Lab proved to be quite unique. It was an opportunity within itself constituting exploratory learning, logic exercises and artistic expression. I am so happy that I stuck with the challe...

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

Learning how to Transpose

Dec 15, 2023 Stanley Chen | www.thedataschool.co.uk

Introduction

Espaol,Filters,ParameterActions,UI,UserExperience,UX

Learning how to Cross Tab

Dec 15, 2023 Stanley Chen | www.thedataschool.co.uk

Introduction

Espaol,Filters,ParameterActions,UI,UserExperience,UX

Labeling Stacked Bar Charts in Tableau

Dec 15, 2023 Tyler Ha | www.thedataschool.co.uk

One of Tableau’s best features is its contextual awareness. It is a very smart program that generally knows what you are trying to do based on what you have done already. Unfortunately however, this feature can sometimes lead to automatic assumpti...

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

How to Synchronize Axis Across Two Charts

Dec 15, 2023 Stanley Chen | www.thedataschool.co.uk

Introduction

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

How to Make a Waterfall Chart

Dec 15, 2023 Michael Imbriale | www.thedataschool.co.uk

A waterfall chart is a great way to illustrate parts of a whole over time or across categories. In the example above, the waterfall chart displays the profit for each category and demonstrates how each category contributes to the total profit for ...

Espaol,Filters,ParameterActions,UI,UserExperience,UX

How to Make a Donut Chart

Dec 15, 2023 Stanley Chen | www.thedataschool.co.uk

Introduction

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

Datepart vs Datetrunc

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

In Tableau,  2023-12-15PART and 2023-12-15TRUNC are two functions used to manipulate and analyze date data, but they serve different purposes:

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

Parte 5. Mens de Seleccin Jerrquicos UXUI

Dec 15, 2023 Rosario Gauna | rosariogaunag.wordpress.com

¡Te doy la bienvenida a la quinta y última entrega de nuestra serie de blogs, enfocada en compartir prácticas destinadas a la creación de menús diseñados para la selección de elementos dentro de una jerarquía, con el propósito fundamental de perfe...

Espaol,Filters,ParameterActions,UI,UserDesign,user-experience,UX

Part 5. Hierarchical Selection Menus UXUI

Dec 15, 2023 Rosario Gauna | rosariogaunag.wordpress.com

I welcome you to the fifth and final installment of our blog series, focused on sharing practices aimed at creating menus designed for the selection of elements within a hierarchy, with the fundamental purpose of perfecting the user experience in ...

English,Filters,DrillDown,DrillUp,Filters,ParameterActions,UI,UserExperience,user-experience,UX

InterWorks Wrapped 2023

Dec 15, 2023 Danny Steinmetz | interworks.com

It’s the most wonderful time of the year again. That’s right: Spotify Wrapped is finally here. The magical time where friends surprise you with the weird new genre or artist they’ve been into, or when you start doing math to determine if it’s even...

Data,culture,InterWorksWrapped,Spotify,SpotifyWrapped

Can you build this simple KPI card

Dec 15, 2023 Donna Coles | donnacoles.home.blog

For this week’s challenge, Luke asked us to recreate this KPI card on a single sheet. We needed to display data for the last 2 years up to the latest complete month. If this was being built for a business situation, we’d make use of the TODAY() fu...

WorkoutWednesday,WOW2023,DualAxis,FIRST,FIXEDLOD,KPIcard,ReferenceLines,sparkline,TableCalcs,Week50

Parte 4. Mens de Seleccin Jerrquicos UXUI

Dec 14, 2023 Rosario Gauna | rosariogaunag.wordpress.com

¡Bienvenidos a la cuarta entrega de nuestra serie de blogs dedicada a compartir ejercicios especializados en la creación de menús diseñados para la selección de elementos dentro de una jerarquía, con el objetivo principal de mejorar la experiencia...

Espaol,Filters,ParameterActions,UI,UserExperience,UX

Parte 3. Mens de Seleccin Jerrquicos UXUI

Dec 14, 2023 Rosario Gauna | rosariogaunag.wordpress.com

Bienvenidos al tercer blog de una serie dedicada a compartir cinco ejercicios centrados en la creación de menús diseñados para la selección de elementos dentro de una jerarquía. Nuestra meta es que estos menús no solo cumplan la función de selecci...

Espaol,Filters,Hierarchy,UI,UX

Part 4. Hierarchical Selection Menus UXUI

Dec 14, 2023 Rosario Gauna | rosariogaunag.wordpress.com

Welcome to the fourth installment of our blog series dedicated to sharing specialized exercises in creating menus designed for the selection of elements within a hierarchy, with the main objective of improving the user experience! On this occasion...

English,Filters,Filters,ParameterActions,Tableau,UI,UserExperience,user-experience,UX

Part 3. Hierarchical Selection Menus UXUI

Dec 14, 2023 Rosario Gauna | rosariogaunag.wordpress.com

Welcome to the third blog in a series dedicated to sharing five exercises focused on creating menus designed for the selection of elements within a hierarchy. Our goal is that these menus not only fulfill the selection function, but also act as fi...

English,Filters,Filters,Hierarchy,UI,user-experience,UX

Why Were Excited about Tableau Pulse

Dec 14, 2023 Keith Dykstra | interworks.com

Tableau released a beta version of Pulse to the public this week, and we think there are some pretty cool things about it. If you’re not familiar with Pulse, we wrote an introductory article after Tableau showcased it at TC23. Tableau has been har...

Data,AI,data,Tableau,TableauPulse

5 Things To Consider When Using Tableau Pulse

Dec 14, 2023 Keith Dykstra | interworks.com

As we mentioned in our last article, we’re excited about what the future holds with Pulse. Tableau let us have early access to the beta version before releasing it to the public, so we wanted to share a few things we learned while we were…The post...

Data,AI,Tableau,TableauPulse

3 Tips To Prepare Your Organization for Tableau Pulse

Dec 14, 2023 Keith Dykstra | interworks.com

Tableau Pulse is really going to shake up the traditional Tableau experience by offering some exciting new capabilities. If you’re already a Tableau Cloud customer, you can start testing these new capabilities using the beta version, and we’ve put...

Data,data,dataupkeep,Tableau,TableauPulse

TABLEAU SERVER AND CLOUD SECURITY 1010 Trade Secrets

Dec 14, 2023 markwu2000@gmail.com | enterprisetableau.com

My previous post TABLEAU SERVER AND CLOUD SECURITY (9/10): PII and DETECT AND DELETE PII DATA ON TABLEAU SERVER talk about PII detection and deletion scripts. Why and how. There is another type of concerns related to compartmented secret informati...

TableauEnterprise

Synthetic Data Magic Unleashing AI in Your Data Analysis Adventure

Dec 13, 2023 Myles Stevenson | www.thedataschool.co.uk

Explore AI in mock data creation with ChatGPT! Learn data schema crafting, Python integration, and overcome synthetic data challenges. Ideal for data pros!

English,Filters,Filters,Hierarchy,UI,user-experience,UX

SQL Basic Queries

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

In this blog post I will walk through basic SQL queries using the database  described in my previous post.

English,Filters,Filters,Hierarchy,UI,user-experience,UX

ROUNDing in Alteryx - A Short Guide

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

You may have noticed that the ROUND function works a little differently in Alteryx compared to Tableau Desktop. In Tableau, the syntax is: ROUND(number, [decimals]). You only need to specify the number of decimals you’d like, e.g.:

English,Filters,Filters,Hierarchy,UI,user-experience,UX

Quick Concept Pills in Tableau

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

In Tableau, the fields from your data source are stored as “pills” that you drag on different shelves to construct your data visualization.

English,Filters,Filters,Hierarchy,UI,user-experience,UX

Quick Concept Parameters in Tableau

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

Parameters in Tableau all the end user to dynamically control a viz or dashboard. Here’s a quick overview of how to set them up and some use cases:

English,Filters,Filters,Hierarchy,UI,user-experience,UX