Tableau Prep: Plan your Prep!

Apr 11, 2023 Shreya Arya | www.thedataschool.co.uk

Last week, DS39 were introduced to Tableau Prep for the first time.

ChartTypes,Dashboards,Storytelling,Tips&Tricks,UserExperience

Makeover Monday using the DougScore

Apr 11, 2023 Reshika Chilakapati | www.thedataschool.co.uk

Today’s Makeover Monday task involves using a dataset which is based on Doug Demuro rating different cars in various categories such as; acceleration, value, comfort, etc. He collates all these factors into what he calls the Doug Score! Looking at...

Series--Tips

Documenting Alteryx Workflows: A Comparison

Apr 11, 2023 Edward Hayter | www.thedataschool.co.uk

In my previous blog documenting my approach to Alteryx Challenge 313 I reflected on the benefits of documenting workflows in order to handover work and better explain what the different parts of the workflow achieve. I have since remade the flow a...

ChartTypes,Dashboards,Storytelling,Tips&Tricks,UserExperience

DSNY3 Week8: API

Apr 10, 2023 Zhengyi Qiu | www.thedataschool.co.uk

What is API?

ChartTypes,Dashboards,Storytelling,Tips&Tricks,UserExperience

23 Simple Tips to Polish Your Dashboards

Apr 10, 2023 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Sloppy dashboards drive me crazy. The truth is, you can clean them up with some relatively simple steps. I call these steps “adding polish”.  When I talk about polish, I am talking about those extra steps you take to ensure your dashb...

Series--Tips

Schlafanalyse von Apple Watch Nutzern - Dashboardweek Tag 4

Apr 8, 2023 Jan Kaiser | www.thedataschool.co.uk

Am letzten Tag der Dashboard-Woche erhielten wir einen Datensatz von Apple Watch Usern und ihrer Schlafqualität - ein spannendes Thema. Dieses Mal wollte ich versuchen ein Dashboard im typischen Apple-look zu erstellen. Im Mittelpunkt des Dashboar...

Image Roles: Tableau Desktop 2022.4 New Feature

Apr 7, 2023 Ryan Alexander | interworks.com

Launched in Desktop 2022.4, “Image Roles” allow you to add an additional semantic field to give end users another way to view their data. This allows you to include images at speed and scale by utilising a URL link within your data to feed straigh...

Data,imageroles,images,Tableau

How short are baseball games in 2023?

Apr 7, 2023 Donna Coles | donnacoles.home.blog

It’s time for Community Month at #WOW2023 Towers, and this week, Spencer Baucke teamed up with Luke to provide this baseball related challenge. Sourcing the data Instructions were provided to get the data from this site , select ‘Share & Expor...

Understanding Data Inputs & Outputs

Apr 6, 2023 Zak Saucede | www.thedataschool.co.uk

Thursday brings our first Project as we work together in pairs to present on different stages of using Tableau Prep. Paired with my colleague Reshika, we look into Data Inputs and Outputs.

The Ins and Outs of Inputs and Outputs in Tableau Prep

Apr 6, 2023 Reshika Chilakapati | www.thedataschool.co.uk

Tableau Prep is a tool used to clean and reshape any data that is considered messy. This allows the data to then be ready for visual analysis through Tableau Desktop to communicate said data. Cleaning is beneficial as it is time efficient and remo...

The Clean Step

Apr 6, 2023 Tom Gould | www.thedataschool.co.uk

As we have reached the last day of the week it was time for our first Friday (Thursday) Project! This weeks task was to prepare a 10 minute presentation on a Tableau prep tool in pairs, and my colleague and I were tasked with explaining the Clean ...

Preppin' Data Challenges!

Apr 6, 2023 Tom Gould | www.thedataschool.co.uk

Today it was time to dive into the world of Tableau Prep. During a morning session with Carl he outlined the data preparation process from start to finish as follows:

Pivoting data - its all about the record

Apr 6, 2023 Muhammad Choudhury | www.thedataschool.co.uk

Pivoting data is the process of reshaping unorganised data into something that can be easily analysed. A messy dataset may have multiple counts of the same record with different measure. Ideally, we want each record to be unique and display measur...

#How to Pivot in Tableau Prep

Apr 6, 2023 Amelia Holland | www.thedataschool.co.uk

A very basic definition of pivoting data is taking rows and making them into their own columns (and vice-versa).

First Presentation Day

Apr 6, 2023 George Ledger | www.thedataschool.co.uk

This morning we were left to ourselves with a project to present at 1pm. We were put into pairs with a specific goal in mind, teach Tableau Prep to a version of ourselves one week earlier.

Cleaning with Tableau Prep

Apr 6, 2023 Lorenz Nacilla | www.thedataschool.co.uk

First project presentation and me and my cohort colleague were tasked with presenting on the cleaning phase in tableau prep.

Cleaning Up With Prep

Apr 6, 2023 Zak Saucede | www.thedataschool.co.uk

On Day 3 we began to navigate our way around Tableau Prep. Tableau Prep is software used to input, clean, pivot and output your data in preparation for your analysis in Tableau Desktop. Its functionality allows you to create a workflow of multiple...

Applying Iterative Macros: Alteryx Challenge 313 Base Converter

Apr 6, 2023 Edward Hayter | www.thedataschool.co.uk

Building out the logic for Binary

TableauParameters,TableauGeneralKnowledge

How to Create Engaging Soundwave Charts in Tableau

Apr 6, 2023 Dan Bunker | playfairdata.com

A soundwave chart, which gets its name for its resemblance to a soundwave (shocking, I know), is excellent for measuring…The post How to Create Engaging Soundwave Charts in Tableau appeared first on Playfair Data.

ChartTypes,Dashboards,Storytelling,Tips&Tricks,UserExperience

The Basic Building Blocks of Data Preppin' ft. Tableau Prep

Apr 5, 2023 Lorenz Nacilla | www.thedataschool.co.uk

Third day here at the Data School, and we have now taken our firsts steps towards the technical training. The journey to data preppin’ starts now.

TableauParameters,TableauGeneralKnowledge

Prepping Your Data - A beginners guide

Apr 5, 2023 Amelia Holland | www.thedataschool.co.uk

Today we looked at how to effectively prepare data. We started by looking at how data is structured - with fields as our columns and records being our individual lines of data.

TableauParameters,TableauGeneralKnowledge

Planning and Prepping

Apr 5, 2023 Reshika Chilakapati | www.thedataschool.co.uk

Today was the first time I ever opened Tableau Prep ever, it was intimidating at first but Carl’s amazing tangents helped me wrap my head around the new concepts!

TableauParameters,TableauGeneralKnowledge

PREP. YOUR. DATA.

Apr 5, 2023 George Ledger | www.thedataschool.co.uk

Day 3 - First Day of Data Preparation

TableauParameters,TableauGeneralKnowledge

How to make a See-Saw chart

Apr 5, 2023 Linda Duong | www.thedataschool.co.uk

Recently I’ve been browsing through Pinterest and saw a see-saw chart that caught my attention since I’ve never seen anything like this before on Tableau. So I decided to make it for one of the Makeover Mondays. Here’s how I created it.

TableauParameters,TableauGeneralKnowledge

Totally Customizable Top-Bottom Filter in Tableau

Apr 5, 2023 Eric Parker | onenumber.biz

Users love filtering and sorting options in Tableau dashboards, right?

TableauParameters,TableauGeneralKnowledge

When not to use Chat GPT to create Mock Datasets?

Apr 4, 2023 Adrien Sourdille | www.thedataschool.co.uk

Introduction: Creating a mock dataset can be super helpful for a bunch of reasons. Whether you want to imitate real-world data you don’t have access to or you want to protect sensitive or confidential information while still being able to work wit...

Data,Azure,json,python,Snowflake,SnowPark

The agile approach - Training day 2

Apr 4, 2023 Muhammad Choudhury | www.thedataschool.co.uk

Before beginning any data project, it is important to understand the approach we take to forming a visulisation from the raw data. We spent day 2 exploring what software are out there and how they communicate with each other to form a data story.

Data,Azure,json,python,Snowflake,SnowPark

The 1-hour Makeover Monday Challenge

Apr 4, 2023 Shreya Arya | www.thedataschool.co.uk

At the Data School, we’re working on completing Makeover Monday challenges within the space of just one hour! If you’d like to find out more about why we’re practicing this skill, read on…

Data,Azure,json,python,Snowflake,SnowPark

Quick Reflection of Day Two at The Data School

Apr 4, 2023 Lorenz Nacilla | www.thedataschool.co.uk

Second day at the Data School and the day started with a session into looking into what modern analytics pipeline looks like.

Data,Azure,json,python,Snowflake,SnowPark

Modern Analytics Architecture

Apr 4, 2023 Tom Gould | www.thedataschool.co.uk

After a day of opening up new laptops and installing software it was time to delve into the world of data on Day 2. The morning consisted of session focusing on Modern Analytics Architecture, which entails the backbone of how businesses set up the...

Data,Azure,json,python,Snowflake,SnowPark

How to in Alteryx: create reports

Apr 4, 2023 Elena Raluca Mazareanu | www.thedataschool.co.uk

Alteryx is a data analytics and visualization platform that allows businesses to blend, analyze, and visualize data from various sources. It is designed to help users easily prepare, blend, and analyze data using a drag-and-drop interface, without...

Data,Azure,json,python,Snowflake,SnowPark

How to Add a 'Transparent' Colour into Tableau and Use Cases

Apr 4, 2023 Kaitlin MacDonnell | www.thedataschool.co.uk

Since learning how to add ‘transparent’ into the colour legend in tableau, I have ended up using it quite a bit in a variety of different ways, so I thought I’d take you through how to import one into Tableau, and some possible use cases.

Data,Azure,json,python,Snowflake,SnowPark

Dungeons & Dragons (D&D) Spell Book API Project

Apr 4, 2023 Elaine Yuan | www.thedataschool.co.uk

Last week, I formally learned how to retrieve data through an API. This training was much needed, especially after my experience completing the Dashboard Week: Rick and Morty API challenge. It was fun to practice Regex in a realistic scenario and ...

Data,Azure,json,python,Snowflake,SnowPark

Doughnuts and Data

Apr 4, 2023 Zak Saucede | www.thedataschool.co.uk

As we come to the end of Day 2 of DS39, its a quick chance to reflect on the very beginning of a new journey. The first two days have been relaxed as we settle in to our new environment at Watling Street, and get to know one another on the cohort,...

Data,Azure,json,python,Snowflake,SnowPark

Day 2 at the Data School

Apr 4, 2023 George Ledger | www.thedataschool.co.uk

Since yesterday was mainly tech setup and being introduced to other team members, today was our first day of training.

Data,Azure,json,python,Snowflake,SnowPark

Data Analytics Pipeline explained using Tesco

Apr 4, 2023 Reshika Chilakapati | www.thedataschool.co.uk

Our second day in training in DS 39 was spent learning about different business approaches in extracting, storing, preparing and reporting data. The six stages that we looked at were; raw data, ingestion, central storage, prepared data, trusted da...

Data,Azure,json,python,Snowflake,SnowPark

Analytics Architecture & Data Pipeline

Apr 4, 2023 Amelia Holland | www.thedataschool.co.uk

Second day of official training with DS39!

Data,Azure,json,python,Snowflake,SnowPark

Trigger Snowpark Functions When Files Are Uploaded to Azure Storage

Apr 4, 2023 Chris Hastie | interworks.com

In previous articles in this series, we have demonstrated how to set up Azure Functions to leverage Snowpark for Python. This allows us to interact with Snowflake from an Azure Function, unlocking a wide range of opportunities for scripting activi...

Data,Azure,json,python,Snowflake,SnowPark

Smoking is killing your sleep

Apr 3, 2023 Lucas Carvalhal Sirieiro | www.thedataschool.co.uk

Last day of training, the last day of Dashboard week.

vscode,data-engineering,vscode-extension,chatgpt,github

How to in Mockaroo: create related datasets with a foreign key

Apr 3, 2023 Elena Raluca Mazareanu | www.thedataschool.co.uk

In this article, I will show you how to create two datasets that are related by a foreign key column using Mockaroo.

vscode,data-engineering,vscode-extension,chatgpt,github

How to Filter and Highlight with Slicers in Microsoft Power BI

Apr 3, 2023 Morgan A Rennie | www.thedataschool.co.uk

The general purpose of a “slicer” in PowerBI is to filter out information. However, with a little bit of DAX, we can use a single slider to not only filter our information but highlight it too! This blog will provide a brief how-to guide on buildi...

vscode,data-engineering,vscode-extension,chatgpt,github

Dashboard Week - Day 5 - Sleep Cycles

Apr 3, 2023 Morgan A Rennie | www.thedataschool.co.uk

Dashboard week is a 5-day challenge, each day confronted with a new data set, either given straight out or directed to where to build or capture it from, before investigating and presenting the data in a series of visualizations

vscode,data-engineering,vscode-extension,chatgpt,github

Your New Favorite Extensions for VSCode: CodeGPT and Github Actions

Apr 3, 2023 Anjan Banerjee | medium.com

I’m happy to report that my picks for the most underrated VSCode extensions still get regular use — if you haven’t checked them out yet, now’s a good time to put it on your to-do list. They’ll make you a happier and more productive data engineer. ...

vscode,data-engineering,vscode-extension,chatgpt,github

InterWorks Blog Roundup — March 2023

Apr 3, 2023 Mark Cordeiro | interworks.com

Clocking in at 28 blog entries this month, March was easily one of the most jam-packed months we’ve had on the InterWorks blog. I feel like I’ve written that exact same intro several times since I took over compiling these monthly roundups, but th...

Data,AWS,Curator,Snowflake,Tableau,UCDD

Custom Date Drill Down Trend Chart (Guest Post from Kasia Gasiewska-Holc)

Apr 3, 2023 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 This is a guest blog post is from our regular contributor, Kasia Gasiewska-Holc. Based in Poland, Kasia works remotely as a Senior BI Analyst at Ecovadis, a data analytics company based in Berlin. She is also a Tableau Public Ambassad...

How-To,Tableau