Joins in SQL

Mar 25, 2024 Jessica Kirk | www.thedataschool.co.uk

Joins in SQL can be hard to get your head round initially. What I found different compared to other programming languages was having to effectively join all tables within one statement, instead of a tool like Tableau Prep where you can join things...

How to be a consultant not just an analyst

Mar 25, 2024 Jessica Kirk | www.thedataschool.co.uk

As part of our consulting training at the data school, we’re frequently reminded that we should think about telling a story with our data. But what does that mean? 

Forecasting in Tableau

Mar 25, 2024 Holly Jones | www.thedataschool.co.uk

Within Tableau, forecasting becomes not just a feature but a dynamic tool that empowers users to predict future outcomes based on historical data patterns. This can be used in a variety of different scenarios including sales trends, demand forecas...

First Last and Index Calculations on Tableau Desktop

Mar 25, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

There are three different functions that can be used on Tableau Desktop to determine the position of data: FIRST(), LAST() and INDEX().

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Dumbbell Charts in PowerBI

Mar 25, 2024 Jessica Kirk | www.thedataschool.co.uk

Dumbbell charts aren’t an embedded visual in PowerBI and they’re not as easy to create as they are in Tableau. Here are the different ways I’ve explored making them using imported visual tools.

Do students profit when colleges do

Mar 25, 2024 Salome Grasland | www.thedataschool.co.uk

This week at the Data School is Dashboard Week. An intensive 5 day stretch where every morning we are assigned a dataset and every afternoon we are expected to present a dashboard with our findings and how we got there. For our first day we have b...

Dashboard Week Day 1 Lego

Mar 25, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

Today was DS43’s first day of Dashboard week. We were tasked with using SQL on Snowflake to prepare our data before using PowerBi to analyse and visualise our findings. This was something I initially found quite daunting as I do not enjoy Power Bi...

Dashboard Week Day 1 Google Is Your Friend

Mar 25, 2024 Hewan Zewdu | www.thedataschool.co.uk

If in doubt and in a time crunch, remember you can still google!

Dashboard Week Day 1 - College Scorecard

Mar 25, 2024 Cecily Santiago | www.thedataschool.co.uk

Today is the first day of Dashboard Week for DSNY Cohort 7!

Dashboard Week Day 1

Mar 25, 2024 Jessica Kirk | www.thedataschool.co.uk

Today was DS43’s first dashboard week challenge, aimed at testing our SQL and PowerBI skills. 

DASHBOARD WEEK DAY 1

Mar 25, 2024 Tobias Colmer | www.thedataschool.co.uk

DASHBOARD WEEK 1

YoY Table Calcs

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

In order to show your previous sales as seen below, you will be required to used the function: Last ( )

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Tableau Current vs Previous Month Sales

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

In tableau, you can create LODs that will bring back your Current vs Previous month sales. 5 calculations for your month difference is needed.

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Tableau Current Year vs Pervious Year Sales

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

5 Calculations are needed to create your current vs pervious year difference in sales.

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

SQL - Using the SELECT function.

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

In SQL, the SELECT statement is used to retrieve data from a database. This is identified by inserting The asterisk (*) . When you use * in a SELECT statement, it instructs the database to retrieve data from all columns in the specified table, in ...

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Padding on a dashboard

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

Benefits to padding on a dashboard in Tableau means helping make the dashboard visually appealing by providing space between the content and the edge of the dashboard. It prevents the content from appearing cramped or cluttered, giving it a more p...

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Improving your Tableau Dashboard

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

Ever used the build in Tableau function called ‘ Workflow Optimiser’

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

How to Create a Pareto Charts

Mar 24, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

The Pareto Principle was developed by an Italian economist which states that 80% of effect comes from 20% of actions. A pareto chart applies this principle by combining bars and line graphs. During this blog I will be using sample superstore, and ...

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Cross Tabs and Pivoting on Alteryx

Mar 24, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

Cross-tab and transpose are the tools used to pivot tables on Alteryx Designer. Both tools can be found under the transform pane:

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Continuous Vs Discreate Dates

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

In Tableau, discrete and continuous date fields represent different ways of organising and visualising date fields:

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Alteryx previous month calculation

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

In Alteryx, in order to bring back your previous month’s date 4 date functions are required.

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

3 useful Alteryx workflow tips

Mar 24, 2024 Alexandra Skelly | www.thedataschool.co.uk

Aligning your workflow

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Bringing Tables Together Tableau Relationships

Mar 24, 2024 Felicia Styer | playfairdata.com

This is part two in a series on combining data tables together for analysis in Tableau. To review part one,…The post Bringing Tables Together: Tableau Relationships appeared first on Playfair Data.

DataPrep,Intermediate,TableauDesktop,TechnicalFeatures

Developing Predictive Models in Tableau Desktop

Mar 22, 2024 Holly Jones | www.thedataschool.co.uk

In today’s data-driven world, predictive modeling has become a crucial tool for businesses to forecast trends, make informed decisions, and gain a competitive edge. Tableau is renowned for its powerful data visualization capabilities, but also off...

WorkoutWednesday,WOW2024,ConnectLines,deselectmarks,DualAxis,DynamicZoneVisibility,HighlightAction,ParameterActions,ReferenceLines,SpecialValues,StackedBarCharts,Week12

Alumni Spotlight Louise Le

Mar 22, 2024 Mel Niere | www.thedataschool.co.uk

Learn more about Louise’s experience, from the time she applied to The Data School, to her career as a the Head of Data Enablement at Aldermore Bank. Louise was part of Cohort 11 of The Data School London, which took place from October 2018 to Feb...

WorkoutWednesday,WOW2024,ConnectLines,deselectmarks,DualAxis,DynamicZoneVisibility,HighlightAction,ParameterActions,ReferenceLines,SpecialValues,StackedBarCharts,Week12

Examining Data Distribution using Dynamic Histograms In Tableau

Mar 21, 2024 Holly Jones | www.thedataschool.co.uk

Histograms are indispensable tools in the data analyst’s arsenal, offering a visual representation of the distribution of a dataset’s values. In Tableau, creating histograms with bins is a straightforward yet powerful technique to gain insights in...

Data,AI,ML,SemanticLayers

Creating Small Multiples in Power BI

Mar 21, 2024 Holly Jones | www.thedataschool.co.uk

Small multiple charts are an excellent technique to convey complex information with clarity and efficiency. They allow us to compare multiple datasets side by side, offering insights into patterns, trends, and variations that might otherwise go un...

Data,AI,ML,SemanticLayers

PYD124 Data Council Austin 2024 Preview with Jack Hulbert Brooks Barth ...

Mar 21, 2024 InterWorks | interworks.com

  In this episode, Content Manager Garret Sauls sits down with Analytics Architect Jack Hulbert, Analytics Lead Brooks Barth and Solutions Architect Director, Americas Mat Hughes to discuss the upcoming Data Council Austin 2024, what they’re looki...

Data,Podcast,PYD

Introduction to Semantic Layers

Mar 21, 2024 Jack Hulbert | interworks.com

At InterWorks, most consultants would be able to tell you this story: “My client has asked me to help build a source of truth for all of their reporting and data analysis queries.” The ask is simple: analytics teams want a one-stop shop for their…...

Data,AI,ML,SemanticLayers

InterWorks Gives Back Fundacin Parque Metropolitano de la Libertad Train...

Mar 21, 2024 Alex Madrigal | interworks.com

It was the end of April 2023 when I got a phone call from Diego, a former and very dear colleague with great experience working with Tableau (and with data in general) from whom I personally have learned tons. He told me that he recently…The post ...

Data,Enablement,InterWorksGivesBack,Tableau,Training

Playing with Stacks

Mar 21, 2024 Donna Coles | donnacoles.home.blog

For this week’s challenge, Sean Miller introduced multiple ways to get insight from a stacked bar chart. I managed this using 5 sheets and 1 dashboard. Preparing the data As the requirement stated only 2024 was to be considered, I chose to add a d...

WorkoutWednesday,WOW2024,ConnectLines,deselectmarks,DualAxis,DynamicZoneVisibility,HighlightAction,ParameterActions,ReferenceLines,SpecialValues,StackedBarCharts,Week12

Last Dashboard Week Personal Project - Indonesia Volcanic Disaster Hist...

Mar 20, 2024 Nuki Susanti | www.thedataschool.co.uk

This post came little late after our last dashboard week because I didn’t have finished dataset at that time. This post is to finish off what I started. You can find the finished dashboard here.

How To Calculate Business Days in Tableau

Mar 20, 2024 Nuki Susanti | www.thedataschool.co.uk

Tableau has native function to calculate difference between two dates and also to add days (week, months, etc.) to a date. However, by using this function, we calculate all the days including weekends. In the real world, we know that business days...

Order of Operations Tableau Version

Mar 19, 2024 Calvin Gao | www.thedataschool.co.uk

As you start to incorporate more advanced filters and interactivity in your dashboards, you might notice Tableau is not working the way you expect it to.

Data,DataManagement,dataproducts

Dynamic Top N Filter

Mar 19, 2024 Calvin Gao | www.thedataschool.co.uk

When you want to provide a bar chart with a limited number of bars, the Top N filter is an option. The Top N filter allows a user to select the number of bars they would like to see on a bar chart and sorted by a predefined field.

Data,DataManagement,dataproducts

Data Products Why Use Them and Why It Can Be Difficult to Get Started

Mar 19, 2024 Mike Oldroyd | interworks.com

Packaging data in the form of data products greatly increases the value and flexibility of your data assets. New business functionality can be delivered up to 90% faster and overall TCO of your data assets can be reduced by 30% (ref 1). Limiting d...

Data,DataManagement,dataproducts

Workout Wednesday 2024 W11 IM TRAUMATIZED

Mar 18, 2024 Tyler Ha | www.thedataschool.co.uk

I would like to start this blog by thanking my dear colleague Erica Hughes for creating this absolute behemoth of a Workout Wednesday challenge. Here is the challenge link: https://workout-wednesday.com/2024w11tab/ Additionally, here is my complet...

Optimizing Performance of Tableau Dashboards

Mar 18, 2024 Holly Jones | www.thedataschool.co.uk

Time is one of a the key components in decision making in a data driven world and slow dashboards can often be the bane of a data consultants life. It is therefore vitally important that dashboards are as fast and efficient as possible.

Creating a Year-on-Year chart using the Last Function in Tableau

Mar 18, 2024 Holly Jones | www.thedataschool.co.uk

The LAST() function in Tableau is a useful table calculation function that allows you to access the value of a specific field from the last row within a partition defined by partitioning fields in your visualization. This function is particularly ...

Tiny Tableau Tips - Round 5

Mar 18, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

   As a reminder, our Tiny Tableau Tips blog posts are comprised of tips shared by others on social media that we are just providing a more permanent home for.  For more information on how #tinytableautips came to be, check out Round 1...

SeriesTips,Tableau

A short guide to the GitHub Foundation Exam

Mar 18, 2024 | www.anyalitica.dev

I have been using GitHub for my personal and work projects for a few years now, but there were some features that I wasn’t familiar with. When GitHub released their new range of certifications, I thought it would be a good way to validate my skill...

github

Streamlining Dashboards Minimizing Chartjunk with Icon Design

Mar 17, 2024 Rafael Simancas | playfairdata.com

Whether you use icons within or around your data visualizations, it’s crucial to be mindful of the value they add…The post Streamlining Dashboards: Minimizing Chartjunk with Icon Design appeared first on Playfair Data.

Design,Figma,Fundamentals,UserExperience

Data School Blog Roundup - March 1 to March 14 2024

Mar 15, 2024 Mel Niere | www.thedataschool.co.uk

It’s been a little while since our last blog roundup and there’s so much to cover! Check out what our Data School consultants have written about!

WorkoutWednesday,WOW2024,CustomSort,Dates,Fillinginblankswith0s,FIXEDLODs,INDEX,LOOKUP,ShowMissingValues,SmallMultiple,TableCalcs,Trellis,Week11

TOP 10 TIPS for Performance in a Workbook

Mar 14, 2024 Tobias Colmer | www.thedataschool.co.uk

Workbook running slowly? Applying filters and they’re taking HOURS to actually apply? Dive in deeper reader and see how you can speed up your dashboard.

Optimising Workbooks

Mar 14, 2024 Jessica Kirk | www.thedataschool.co.uk

Monitoring workbook performance is an important part of creating dashboards. Larger data sources, busy servers and lots of worksheet actions can all contribute to slowing down the dashboard rendering and loading process.