Z-Score, how to build it?

Feb 9, 2023 Anita Longa | www.thedataschool.co.uk

After today’s session of Statistics 101 we were tasked to write a blog about one of the topics we spoked about, in my case: Z-Score.

Data,Coding,Dataiku,kaggle

Z Score - An overview with examples

Feb 9, 2023 Sherina Mahtani | www.thedataschool.co.uk

What is Z score?

Data,Coding,Dataiku,kaggle

What is Z-score and how do we use it?

Feb 9, 2023 Stanley Chan | www.thedataschool.co.uk

To understand what Z-score does, we need to first understand some basic statistic knowledge - normal distribution and standard score.

Data,Coding,Dataiku,kaggle

Sample and Population Variance

Feb 9, 2023 Jack Arnaud | www.thedataschool.co.uk

When looking at a distribution in a dataset, variance is a key feature. It shows the ‘spread’ of a distribution, with higher variance representing an increased likelihood of values that are further from the mean. In the case of the normal distribu...

Data,Coding,Dataiku,kaggle

How to make a Dynamic Control Chart using Standard Deviations

Feb 9, 2023 Kate Joyce | www.thedataschool.co.uk

In this blog I am going to explain two ways to create a Control Chart in Tableau using London Airbnb Data to show Standard Deviation. This chart will focus on Average Price of Airbnb’s over time.

Data,Coding,Dataiku,kaggle

How to Create a Dynamic Control Chart

Feb 9, 2023 Curtis Paterson | www.thedataschool.co.uk

Control charts are great for showing a statistical analysis of change over time. They contain a plot over time, a mean average line, a lower limit line, and an upper limit line with the limit lines commonly representing a number of standard deviat...

Data,Coding,Dataiku,kaggle

InterWorks Recognized as Dataiku APAC Partner of the Year for 2022

Feb 9, 2023 Garrett Sauls | interworks.com

There were many reasons to celebrate 2022, and we’re excited to add one more to the list: InterWorks was officially named the Dataiku APAC Partner of the Year for 2022! This award represents a lot of hard work and collaboration between InterWorks ...

News,ANZ,Australia,awards,Dataiku,PartneroftheYear

Crash Kaggle Challenge Digit Recognizer with Dataiku Auto-Coding

Feb 9, 2023 Han Zheng | interworks.com

Are you not yet confident enough to announce that you are a data scientist because you haven’t programmed a model yourself with a neural network? Neural networks (NN) are an advanced technology in data science, widely applied in the field of compu...

Data,Coding,Dataiku,kaggle

Can you create a normalised jitter plot?

Feb 9, 2023 Donna Coles | donnacoles.home.blog

Continuing the theme of alternative chart types, Kyle decided to challenge us to recreate this jitter plot inspired by an example from The Big Book of Dashboards. I’ve built jitter plots in the past for #WorkoutWednesday challenges (the hidden RAN...

Introduction to Modern Data Architecture

Feb 8, 2023 Andreea Scintei | www.thedataschool.co.uk

First day of training with the Data School! 🙌 Here is a snippet of what we learned about modern data architecture.

Design

Combine Multiple Filters into a Single Swappable Filter in Tableau

Feb 8, 2023 Eric Parker | onenumber.biz

How often do you build a Tableau dashboard and feel like it has too many filters? This happens to me all the time! You don’t know what to do with them, right? Make two rows of filters? Ugh. Make a massive column? That’s a lot of screen real estate...

Design

Things You Absolutely Do Not Need to Worry About for your First Day at t...

Feb 7, 2023 Trea McElhone | www.thedataschool.co.uk

The first day of anything is almost always a little nerve-wracking, whether it’s your first day of school, your first day in a new country, or like me, your first day at the Data School.

Data,Azure,KeyVault,python,Snowflake,SnowPark

The 7 types of Data Story

Feb 7, 2023 Habeeb Gayle | www.thedataschool.co.uk

When analyzing and presenting data it is useful to present it in the form of a story to help the audience follow along with a narrative and present different angles.

Data,Coding,Dataiku,kaggle

The 7 Data Stories

Feb 7, 2023 Edward Hayter | www.thedataschool.co.uk

I wanted to begin my blogging career by recording the 7 approaches to telling stories featured in an article written by Martha Kang. I think it is important to start with something fundamental that is going to underpin the technical decisions of v...

Data,Azure,KeyVault,python,Snowflake,SnowPark

Taking the Alteryx Designer Advanced Certification Exam

Feb 7, 2023 Bianca Ng | www.thedataschool.co.uk

Part of my goals while on bench was to prepare for and take the Alteryx Designer Advanced Certification exam. My intention was to take the exam this week - only to get an idea of what topics I needed to study up on, then take it “for real” next we...

Data,Azure,KeyVault,python,Snowflake,SnowPark

Should You Trust Any Data Sources?

Feb 7, 2023 Karina Chan | www.thedataschool.co.uk

There are different ways to increase the credibility of a data source. In this blog, I will discuss two of the ways to do so.

Data,Azure,KeyVault,python,Snowflake,SnowPark

Data Visualization: why so many definitions?

Feb 7, 2023 Adrien Sourdille | www.thedataschool.co.uk

As you embark on the Data School journey and create your first data visualization, you will undoubtedly ask yourself the following question: What is a data visualization, and why am I making it in the first place?

Data,Azure,KeyVault,python,Snowflake,SnowPark

Blog Post: A (very) brief History of Data Visualization

Feb 7, 2023 Tanbir Jalil | www.thedataschool.co.uk

With the very first day of proper training in DS38b commencing, the objectives of the lessons weren’t too difficult or complex just yet. As a group, we explored the very basics of data visualization in terms of what it can be defined as, why it ca...

Data,Azure,KeyVault,python,Snowflake,SnowPark

Analytics Pipeline - How a Viz is born

Feb 7, 2023 Zoe Reed | www.thedataschool.co.uk

It’s day 2 at The Data School and we’ve followed the creation of a viz - from its origin in raw data all the way through to a published visualization.

Data,Azure,KeyVault,python,Snowflake,SnowPark

Using Azure Key Vault to Authenticate Snowflake with Python

Feb 7, 2023 Chris Hastie | interworks.com

This article is builds on the following two previous articles: Intro to Azure Functions and Snowpark: Populating Snowflake Control Tables Using Azure App Settings to Authenticate Snowflake with Python The above articles do a great job at building ...

Data,Azure,KeyVault,python,Snowflake,SnowPark

Prepping Consumer Duty Data with Alteryx

Feb 6, 2023 Nick Jastrzebski | www.theinformationlab.co.uk

The FCA’s Consumer Duty standards are aimed at ensuring consumers of financial products are treated fairly. The principle is broken down into four main areas: Tracking KPIs associated with each of these is important to ensure regulations are being...

Blog

Fivetran’s Custom Connector in AWS Lambda

Feb 6, 2023 Jason Hoehn | interworks.com

Fivetran‘s custom connector enables customers to create an ingestion process for data sources that are not currently offered by Fivetran’s service. This is accomplished by creating a function in Amazon Web Services (AWS), Microsoft Azure or Google...

Data,AWS,Azure,connector,Fivetran,GCP,Lambda,python

Using Web-Based Images in Tableau

Feb 6, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

When building a Tableau workbook, it’s not uncommon to want to embed some web-based images into the workbook itself. Tableau has added some new features recently which make this a lot easier, but there are still some limitations. Somet...

How-To,Tableau

BENCH BLOG 2 - Concepts That Gave Me Headaches, But I Finally Understood...

Feb 5, 2023 Mohammed Uddin | www.thedataschool.co.uk

LOD’s or level of detail in Tableau always gave me nightmares. To be completely honest, anything with calculated fields fills me with dread. Although, I feel that’s due to negative assumptions from fear; like bad news creating hysteria about somet...

Español,#FunnelChart,#LODCalculations,#WOW2023

Gráfico de Embudo: Won, Lost o Outstanding

Feb 5, 2023 Rosario Gauna | rosariogaunag.wordpress.com

Para la semana 5 de #WOW2023, Donna Coles nos preparó un desafío que trata sobre la construcción de un gráfico de embudo. Un gráfico de embudo ayuda a visualizar un proceso que tiene etapas secuenciales y conectadas en las que los valores suelen d...

Español,#FunnelChart,#LODCalculations,#WOW2023

Funnel Chart: Won, Lost or Outstanding

Feb 5, 2023 Rosario Gauna | rosariogaunag.wordpress.com

For week 5 of #WOW2023, Donna Coles prepared a challenge for us that deals with building a funnel chart. A funnel chart helps visualize a process that has sequential, connected stages in which values typically decrease. That is, it shows a process...

English,#FunnelChar,#LODCalculations,#WOW2023

My experience as Project Manager

Feb 3, 2023 Sherina Mahtani | www.thedataschool.co.uk

In this blog, I will be diving into my experience and challenges as a Project Manager (PM) and providing any feedback or insights I may have for anyone who is PM in the future!

How to in Tableau Prep: create and use a parameter

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

What is a parameter? In Tableau, a parameter is a user-created value, that allows a great deal of versatility in terms of what you can produce utilizing the parameters because they can be used independently of the data source you are using.

#Throwback Thursday - Week 13 at The Data School

Feb 2, 2023 Serena Purslow | www.thedataschool.co.uk

A super packed week, and a break from client projects! Join me for my weekly reflection on life at the Data School!

Uncategorized,PublicSector,Tableau,WebinarReplay

Go Track Yourself

Feb 2, 2023 Bianca Ng | www.thedataschool.co.uk

During 17 weeks of training in the Data School, progress can be measured by the Alteryx tools you’ve learned to use, or the Tableau charts you now know how to build; however it’s not something we explicitly measure.

Uncategorized,PublicSector,Tableau,WebinarReplay

Webinar Replay: Analytics for the Public Sector with Tableau and InterWo...

Feb 2, 2023 Rowan Bradnum | interworks.com

A video replay for this webinar is available at the bottom of the blog For this webinar, we provide a number of demos of work that we’ve done for Public Sector clients that showcases the power of Tableau. Watching the webinar below is highly recom...

Uncategorized,PublicSector,Tableau,WebinarReplay

Can you build a funnel chart?

Feb 2, 2023 Donna Coles | donnacoles.home.blog

For my first #WOW2023 challenge, as an ‘official’ part of the #WOW crew, I challenged everyone to build this funnel chart. Inspiration came from a colleague who posed me the challenge of building something similar, ensuring the bars were a single ...

BENCH BLOG 1 - Visual Analytics

Feb 1, 2023 Mohammed Uddin | www.thedataschool.co.uk

When thinking about visual analytics; the number one thing I keep in mind is understanding. At a glance, I want my audience to quickly grasp what my work is saying. Yes further questions will be asked, but there’s less confusion in the air. So how...

TableauGeneralKnowledge

How to Build Donut Charts in Tableau

Feb 1, 2023 Ollie Linley | onenumber.biz

Donut Charts are a very visually-appealing chart type, used to show part-to-whole relationships. They’re simple and effective, and are a great tool to add to your dashboarding arsenal. While they’re not a built-in chart type in Tableau (unlike a b...

TableauGeneralKnowledge

InterWorks Blog Roundup — January 2023

Feb 1, 2023 Mark Cordeiro | interworks.com

New year, new me! Tired of hearing that one yet? It’s the time of year to start (and potentially abandon) your New Year’s Resolutions. If you’re kinda over the whole trend, I recommend this video from CGP Grey that replaces a single resolution wit...

Data,Dashboarding,Snowflake,Tableau,ThoughtSpot

Hazards on the Road to Self-Service Analytics

Feb 1, 2023 John McKenzie | interworks.com

The term “Self-Service Analytics” gets thrown around a lot these days and for good reason. It’s what a driven-driven organization strives for, and at InterWorks, it’s the goal we help our clients achieve. I don’t know if there is a specific defini...

Data,CoreChallenges,Self-service,Self-ServiceAnalytics

Create a Calendar with Variable Layout Options in Tableau (Part 1)

Jan 31, 2023 Lindsay Betzendahl | vizzendata.com

About a year ago I got the idea to create a data-driven calendar of my family’s events; things like birthdays,Continue reading

DataVisualization,Tableau,Tutorial,Calendar,TableauHow-To,VOTD

How to Calculate Day over Day Change Excluding Weekends

Jan 31, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

In a previous tip, I showed you how to calculate day over day change and build 3 KPI cards.However, this does not cover the case when you need to ignore weekends. In this #Tableau tip, I show you how to calculate daily change excluding the weekend...

perc_difference,boolean,calculatedfield,change,color,comparison,dailychange,datepart,dates,dayoverday,integer,levelofdetail,LOD,percentchange,tableau,tip,variance,weekends

Why must we BUFFER() in this world

Jan 31, 2023 Bianca Ng | www.thedataschool.co.uk

DSNY2 did our spatial lessons just about two months ago, and that’s when we made points and lines. We also learned a third function, BUFFER(), that takes in a point, distance, and unit. It draws a circle around that point, using distance as the ra...

Data,AppSettings,authentication,Azure,python,Snowflake

What are the FIRST(), INDEX() and LAST() table calculations in Tableau?

Jan 31, 2023 Almeera Hasham | www.thedataschool.co.uk

This post is a quick guide to the FIRST, INDEX and LAST functions in Tableau. These functions are advanced table calculations that you can use for many different things!

Data,AppSettings,authentication,Azure,python,Snowflake

The Survivor Data! (Day 5)

Jan 31, 2023 Kinley Ly | www.thedataschool.co.uk

On Day 5 of Dashboard week, we play with data from the Survivor TV Show. Fun Fact, this dataset was actually the same dataset that DSNY 3 was given for their final interview. Having already been given clean data is really a nice change from the ot...

Data,AppSettings,authentication,Azure,python,Snowflake

Quick Table Calculations Part 5 - Rank

Jan 31, 2023 Serena Purslow | www.thedataschool.co.uk

This is the fifth blog in my series on Tableau Table Calculations. This time we will be going through creating a Rank calculation!

Data,AppSettings,authentication,Azure,python,Snowflake

Point annotations

Jan 31, 2023 Eugenia Losada Gamst | www.thedataschool.co.uk

As always tableau surprised me today with another basic feature i did not know existed. This time its: Annotations! Today we will be focusing on point annotations but I will be writing a separate blog on Area annotations as they have a variety of ...

Data,AppSettings,authentication,Azure,python,Snowflake

Now you see it... (Dynamic Zone Visibility)

Jan 31, 2023 Bianca Ng | www.thedataschool.co.uk

I’ve used Dynamic Zone Visibility for small bits of client projects, but on Day 5 of Dashboard Week (my blog post on that), I made my Survivor “navigation” using only dynamic zone visibility. Typically, we would have multiple dashboards and use Ta...

Data,AppSettings,authentication,Azure,python,Snowflake

Is your parameter running?

Jan 31, 2023 Bianca Ng | www.thedataschool.co.uk

Then you’d better go catch it!

Data,AppSettings,authentication,Azure,python,Snowflake