Dashboard Week - Day 2 - Accessibility

Sep 24, 2024 Becky Wright | www.thedataschool.co.uk

Challenge

Alteryx,DataPrep,Fundamentals,TipsTricks

Choosing Between Map and Filled Map in Power BI

Sep 24, 2024 Takhmina Pirmahmadova | www.thedataschool.co.uk

In Power BI, both Map and Filled Map visuals are used to represent geographical data, however, they have certain key differences.

Alteryx,DataPrep,Fundamentals,TipsTricks

Simple Comparison of OLTP vs OLAP Systems

Sep 24, 2024 Jason Hoehn | interworks.com

Now more than ever, businesses are focused on investing time and capital into their data platform. There is so much work that goes into processing data to generate insights, yet in my experience, there seems to be some confusion surrounding this c...

Data,OLAP,OLTP

Setting Up Scheduled Data Extraction Using Python

Sep 23, 2024 Curtis Paterson | www.thedataschool.co.uk

This blog outlines the process and key steps taken to set up a scheduled data extraction using Python and GitHub actions. I’ve done this for a personal project where I fetch data using the Reddit API, perform a sentiment analysis on the top posts ...

Plans for my Personal Project

Sep 23, 2024 Kealan Daly | www.thedataschool.co.uk

This week I’ve started to compile the ideas I have for my personal project into a coherent plan, and I decided to focus on my favourite video game franchise of the past few years, the Legend of Zelda. Picking Tears of the Kingdom for reference, I ...

Personal Project Planning

Sep 23, 2024 Joe O'Connor | www.thedataschool.co.uk

A plan for a personal project during my time at the data school

Lesson learned check the data

Sep 23, 2024 Tim Jeffries | www.thedataschool.co.uk

First day of Dashboard Week today, starting bright and early being given a LOT of SQL data about football, 37 tables with one having data about tournaments (43), one about matches (1300), one about player lineups (16,500, one record per player) an...

Decoding U.S. Elections Understanding Swing States with Tableau and Fixe...

Sep 23, 2024 Thomas Duong | www.thedataschool.co.uk

As the U.S. elections approach, it’s clear that their outcome will have a significant impact not only on the country but also on the rest of the world. With that in mind, let’s take a closer look at seven key states that will likely decide the ele...

Dashboard week Day 1 - Football

Sep 23, 2024 Alfie King | www.thedataschool.co.uk

When the day started we were given data on the UEFA Women’s Euros from 2022. This data included many different tables. This caused me to immediately start thinking about all the possibilities of dashboards and analysis. I started off by thinking a...

Dashboard week Day 1

Sep 23, 2024 Thiago Santos | www.thedataschool.co.uk

Play with your strengths:

Dashboard Week Day 1

Sep 23, 2024 Becky Wright | www.thedataschool.co.uk

Today we had the task to perform some football analytics. We had access to json data parsed out in Snowflake, 36 tables in total, however we were advised to narrow our focus.

DS45 Dashboard Week Day 1 - StatsBomb Open Data

Sep 23, 2024 Jenny Martin | www.thedataschool.co.uk

It’s time for the beginning of dashboard week! DS45 won’t know what topic they’ll be covering each day or which data skills they’ll need to embrace. Luckily they’ve had 4 months of training to draw from! Some general rules that will apply each day...

Translating Values to Many Languages in Tableau Desktop

Sep 22, 2024 Le Luu | www.thedataschool.co.uk

As a Tableau user, I usually set the default language for Tableau Desktop as English. However, in some cases, if a user works for a global company, many users worldwide can use the dashboard. The language could be a barrier for the user to interac...

Can you create multi-select parameters

Sep 20, 2024 Donna Coles | donnacoles.home.blog

For this week’s #WOW2024 challenge, Kyle simulated a real-world challenge he’s faced at work where he wanted the ability to select multiple parameters as he was sourcing data from multiple data sources, so using traditional filters didn’t work. Co...

WorkoutWednesday,WOW2024,DelimitedStrings,deselectmarks,multipledatasource,ParameterActions,Week38

5 lessons learned while building a map-centric dashboard in Tableau

Sep 20, 2024 | www.anyalitica.dev

It’s been a long time since I built a Tableau dashboard! My day-to-day work is now fully focused on data engineering, and I wanted to find a personal project to keep my Tableau skills sharp.Shortly after moving to the Netherlands 2 years ago, I su...

tableau,art

From printHello World to Hello Data School

Sep 19, 2024 Davy Ly | www.thedataschool.co.uk

Hi reader and welcome to my first blog post!

TableauPrep,Data

CSV Files Default Properties

Sep 18, 2024 Maria Maske | www.thedataschool.co.uk

Kennt ihr das auch? Ihr wollt gerade mit der Bearbeitung eines Datensatzes starten und schon habt ihr das erste (technische) Problem?

TableauPrep,Data

How to Union Tables in Tableau Prep

Sep 18, 2024 Eric Parker | onenumber.biz

When you union tables in Tableau, you append two tables of data vertically. That means if you have two tables that are 1,000 rows each, the result of the union will be a single table that is 2,000 rows. Shared columns will align automatically, and...

TableauPrep,Data

Data Connectivity Joins Unions and Relationships Explained

Sep 17, 2024 Niklas Kubus | www.thedataschool.co.uk

Introduction: Why Connecting Data Matters

IT,Podcast,PodcastYourData

Native Snowflake Connector for Google Analytics

Sep 17, 2024 Steve Taylor | interworks.com

At InterWorks, we regularly build data pipelines for customers that include tools for migrating and transforming data such as Fivetran or Matillion. Tools such as these have connectors for many common sources of data to save us the hassle of build...

Data,Snowflake

IT Sales Simplified Recap and Lessons Learned

Sep 17, 2024 InterWorks | interworks.com

In this episode, InterWorks Content Manager Garrett Sauls sits down with IT Intern Genna Callahan to review what she learned over the course of her IT Internship, and how she feels about continuing her internship through through the fall.The post ...

IT,Podcast,PodcastYourData

Whats behind Gregorian and ISO-8601 formats

Sep 16, 2024 Niklas Kubus | www.thedataschool.co.uk

I’m sure all Data Schoolers, that are not from the United States at least, have faced the same issue as me in Tableau regarding the week days at least once. I remember, I was trying to build a bar chart for a seasonal analysis. I wanted to see the...

IT,Podcast,PodcastYourData

Formula 1 Telemetry Analysis in Python and Tableau

Sep 16, 2024 Dan Wade | www.thedataschool.co.uk

In [28]:

IT,Podcast,PodcastYourData

InterWorks at CDAO Melbourne 2024

Sep 16, 2024 Giovanna Brisotti | interworks.com

InterWorks recently attended CDAO Melbourne 2024, a three day event that took place on September 2-4, 2024. Featuring keynote speakers, panel discussions and interactive workshops, the conference addressed topics like data governance, culture and ...

News,Conferences,Events

New Viz The Seven Data TV

Sep 16, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

I love the Amazon Prime series The Boys. I mean, it’s gruesome and crude, but it’s fun. I just finished the fourth season (and now waiting for season 5 to be released in 2026 - argh) and I asked myself a question about the show. Well, ...

Tableau

Paris Olympics 2024 What medals did each country win each day

Sep 14, 2024 Donna Coles | donnacoles.home.blog

For this week’s #WOW2024 challenge, I asked the community to rebuild this unit chart depicting the medals won each day by country. I built this out while the Olympics was on, curating the data myself, so there is a chance it may not match ‘officia...

WorkoutWednesday,WOW2024,CustomShapes,DualAxis,INDEX,Reverseaxis,SIZE,TableCalcs,UnitChart,Week37

Optimizing the SQL Performance - Part 1

Sep 13, 2024 Le Luu | www.thedataschool.co.uk

In the previous blog, I compared the difference in the order of writing SQL queries and the order of execution in SQL (link). Acknowledge the execution order in SQL is significant and helpful because the user will know how the SQL queries execute ...

Data,analytics,data,videogames

How I Played the Long Game with InterWorks

Sep 13, 2024 Hilary Hunt | interworks.com

I’m writing this post after all of eight days on the InterWorks payroll, but I’m not exaggerating when I say that walking into the office already feels like a homecoming. I learned about InterWorks a few years ago when I got involved at my local…T...

Culture,onboarding,recruiting

Maximizing Data Insights with Bullet Graphs A Compact Visualization Tool

Sep 12, 2024 Takhmina Pirmahmadova | www.thedataschool.co.uk

Given the variety of chart options available, it’s important to choose one that conveys the message most effectively. For performance-based questions in organizations, a Bullet Graph is an excellent choice for tracking progress against multiple me...

Data,RankDense,Tableau

Alteryx 11 Steps to Create an Iterative Macro for Pagination

Sep 12, 2024 Kate Crawford | www.thedataschool.co.uk

There are four Macro types in Alteryx. This post introduces the Iterative Macro, which loops through a flow based on a condition.

Data,analytics,data,videogames

Lateral Thinking in Games and Data

Sep 12, 2024 Ben Bausili | interworks.com

Or, What Nintendo’s Game Boy has to do with Analytics  Back before the success of the Nintendo Switch or the motion-controller craze of the Nintendo Wii, there was a device that encapsulated a central driving philosophy of Nintendo and was key to ...

Data,analytics,data,videogames

What is CICD How can Azure DevOps Help

Sep 11, 2024 Edward Hayter | www.thedataschool.co.uk

What is CI/CD?

Data,RankDense,Tableau

The Highlights Are On But Nobodys Home

Sep 11, 2024 Vivian Ng | www.thedataschool.co.uk

Today, I’ll be talking about how to highlight all your marks in a visualization (also known as removing unwanted highlighting or disabling Tableau’s default highlighting). Before I describe the process, let me explain what I mean by Tableau’s defa...

Data,RankDense,Tableau

Alteryx 11-ish Steps to Create an Iterative Macro for Pagination

Sep 11, 2024 Kate Crawford | www.thedataschool.co.uk

1) Build a Standard Workflow.

Data,RankDense,Tableau

Mutation Testing An Unknown Known Solution in Software Development

Sep 11, 2024 Matthew Orr | interworks.com

We All Suck at Something I want to let you in on a journey I’ve been on lately, just in case it can be as profound for you as it has been for me. Picture this: You’ve been in auto racing for decades. You were…The post Mutation Testing: An Unknown ...

Data,MutationTesting

Hardening Snowflake Security with Network Rules and Policies

Sep 11, 2024 Chris Hastie | interworks.com

An important step towards ensuring the security of your Snowflake account(s) is the appropriate use of network rules and policies to prevent unauthorised access. These policies are leveraged to ensure that access is only allowed through restricted...

Data,Snowflake

A Use Case for Rank Dense in Tableau

Sep 10, 2024 Robby White | interworks.com

Oftentimes, I find myself in training or enablement sessions, showing the full list of possible functions available to use in Tableau. It’s quite a list of possibilities that starts with ABS (for the absolute value of an integer) and runs through ...

Data,RankDense,Tableau

The Softer Side of Data Visualization Training Course

Sep 9, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

Ken and I are known for our technical abilities within Tableau. I mean, out of 400 blog posts on our website, I’d say that 390 of them are directly related to Tableau. But we’ve been building charts and dashboards for a long, long time...

DataViz,Training

Power BI vs. Tableau

Sep 8, 2024 Marcus Oberdiek | www.thedataschool.co.uk

Ease of use and data visualization

WorkoutWednesday,WOW2024,DualAxis,Gantt,Line,Path,Scaffold,Stepped,Waterfall,Week36

Can you build a Measure Names Waterfall

Sep 8, 2024 Donna Coles | donnacoles.home.blog

I’ve been on my holibobs, so haven’t blogged a solution for a few weeks. It’s been a bit of a struggled to get my head re-engaged to be honest, as I’m sure you can all relate to. Anyway this week’s challenge was set by Sean, to produce a waterfall...

WorkoutWednesday,WOW2024,DualAxis,Gantt,Line,Path,Scaffold,Stepped,Waterfall,Week36

3 Ways to Apply Python Script in Tableau Desktop

Sep 6, 2024 Le Luu | www.thedataschool.co.uk

Tableau users usually apply built-in functions to calculate, filter, and retrieve data. However, in some complicated problems, the built-in function in Tableau may not be useful in solving the problem. We can consider using the Python script throu...

What did it take to get into DS46

Sep 5, 2024 Robbin Vernooij | www.thedataschool.co.uk

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

Git GitHub and GitHub Desktop for Beginners

Sep 5, 2024 Zoe Reed | www.thedataschool.co.uk

This blog aims to clarify the differences between Git, GitHub and GitHub Desktop, including how they can be used together to manage code both on your local machine and on GitHub.

Context Filters and why do we need them

Sep 5, 2024 Rory Moxom | www.thedataschool.co.uk

When covering an introduction to Tableau Desktop there was one feature that jumped out that would really have helped if I knew about it before my Data School Application!

Unit Testing In Data Engineering dbts latest update

Sep 4, 2024 Edward Hayter | www.thedataschool.co.uk

What is Unit Testing