2023 Tableau Fantasy Football Draft Kit

Aug 24, 2023 Will Jones | interworks.com

Football season is almost upon us. While we slog through the purgatory that is preseason matchups, some very real preparations are starting to get underway: drafting the perfect fantasy football lineup. Drafting your favorite players and hoping fo...

Data,datavisualization,fantasyfootball,football,Tableau

MakeoverMonday Week 34 - Go-To Drinks for Men and Women on Dates

Aug 23, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Join me for live analysis of Zoosk’s recent survey, covering 8,793 members’ dating drink preferences! In this livestream, I’ll break down the responses across 7 different drink types, comparing the preferences between men and women. Is there a gen...

barchart,barinbar,butterflychart,dashedlines,dimension,dotplot,dottedlines,howto,MakeoverMonday,measurenames,measurevalues,slopegraph,tableau

Ranking in Alteryx Using Record ID

Aug 23, 2023 Charles Yi | www.thedataschool.co.uk

Although there is no rank calculation or tool in Alteryx, you can still rank values using workarounds. In this post, I’ll show you how to do so using the Record ID and Join tools. The example I’ll be using to demonstrate Record ID and Join is base...

Advanced,Dashboards,TechnicalFeatures,TipsTricks

Ranking fields in Tableau Prep

Aug 23, 2023 Sakif Chowdhury | www.thedataschool.co.uk

It is quite easy to use the Rank() function in Tableau itself. However, it is a table calculation which may sometimes complicate things. It can be useful to have the data set ranked before it enters Tableau. Creating the ranks beforehand can help ...

Advanced,Dashboards,TechnicalFeatures,TipsTricks

How and Why to Create Tableau Data Extracts .hyper

Aug 23, 2023 Eric Parker | onenumber.biz

If you want to create the best user experience in Tableau, odds are you want to convert your data connections into extracts. Tableau Data Extracts (.hyper) provide the most efficient way to query data in Tableau. Extracts are local snapshots of yo...

Data

From Boring PowerPoint to Dynamic Tableau with Microsoft Web Viewer

Aug 22, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Tired of creating dashboards for static PowerPoint slides? I’m with you.In this video, I have a solution that will change how you present Tableau dashboards forever and engage your audience like never before.No more dull slides. No more monotonous...

embed,howto,microsoft,PowerPoint,presentation,tableau,tableauinPowerPoint

thInk Wisely Maximizing Your Data Ink Ratio

Aug 22, 2023 Sid Saythongphet | www.thedataschool.co.uk

Back when I was applying to the Data School, one of the feedback notes I remember was to be cognizant of my data ink ratio. At the time, I didn’t know what that meant, but I was advised to use it for the next phase of my application. And let me te...

Data,functions,Snowflake,sql

Writing an IF statement in Power BI

Aug 22, 2023 Myles Stevenson | www.thedataschool.co.uk

Writing an IF Statement in PowerBI is different than in other Platforms, this Blog post will walk you through how

Data,functions,Snowflake,sql

Switching chart type on Power BI

Aug 22, 2023 Jules Claeys | www.thedataschool.co.uk

As we wrap up our first day of Power BI, here is my favourite feature so far. While I will definitely need more time to become an experienced user, I really appreciate how easily you can go from one chart type to another.

Data,functions,Snowflake,sql

Power Query - Managing Workflows

Aug 22, 2023 Alexander Wood | www.thedataschool.co.uk

Managing Workflows - The steps work in a sequential order. You can edit steps by clicking on the cogs on the right. And you can see what a particular step has done by selecting it in the list. It is important to remember that the flow works in seq...

Data,functions,Snowflake,sql

Power BI - Merging two columns

Aug 22, 2023 Abby Poon | www.thedataschool.co.uk

Before loading a table, it’s necessary to transform it first to ensure its cleanliness. When merging two columns into one, there are several options to choose from. Once you’ve selected the two columns you want to merge, you can click ‘Transform. ...

Data,functions,Snowflake,sql

Mobile Layout View in Power BI

Aug 22, 2023 Jaroslav Tomcala | www.thedataschool.co.uk

Today was our first day with Power BI, and we learned a lot about Power Query and building Power BI pages (dashboards).

Data,functions,Snowflake,sql

How to make a bump chart

Aug 22, 2023 Jules Claeys | www.thedataschool.co.uk

One of the best ways to represent changes in rank over time is using a bump chart. It permits to visualize the changes in rank over time and easily compare the rank of different dimensions.

Data,functions,Snowflake,sql

How To RegEx in Alteryx

Aug 22, 2023 Matthias Albert | www.thedataschool.co.uk

How can you access the dynamic world of regular expressions from within Alteryx? Glad you ask. Check out this 3-minute-introduction and you will be one step closer to using RegEx like a pro to single out exactly what you need from even the messies...

Data,functions,Snowflake,sql

Date hierarchy and drill-downs in PowerBI

Aug 22, 2023 Maddalena Mariano | www.thedataschool.co.uk

In Tableau we can use dates as dimensions, measures, discrete and continuous variables, which all react differently to

Data,functions,Snowflake,sql

Alteryx How to Create Chained Apps

Aug 22, 2023 Tabitha Diaz | www.thedataschool.co.uk

If you’ve had experience working in Alteryx you know that you can create both macros and Apps using Interface Tools. Recently, I was working on a workflow where I wanted to create an App based on a given year and specific top Ns. When I began the ...

Data,functions,Snowflake,sql

A Clean Way to Merge Columns in PowerQuery

Aug 22, 2023 Numa Begum | www.thedataschool.co.uk

Today was my first time trying out PowerQuery and PowerBI. I web-scrapped data from Rotten Tomatoes listing of their Top 100 Netflix Movies, as you can imagine taking data straight from a webpage means a lot of cleaning!

Data,functions,Snowflake,sql

Statistical Tableau Using MAD to Detect Outliers in Non-Normalized Data

Aug 22, 2023 Ethan Lang | playfairdata.com

I recently wrote a tutorial on 3 ways to visualize outliers in Tableau. This tutorial assumes a normal distribution of…The post Statistical Tableau: Using MAD to Detect Outliers in Non-Normalized Data appeared first on Playfair Data.

Advanced,Dashboards,TechnicalFeatures,TipsTricks

SQL Delight in Snowflake EXCLUDE RENAME REPLACE ILIKE GROUP BY ALL

Aug 22, 2023 Guilherme Rampani | interworks.com

Snowflake is like that friend who’s always got something new up their sleeve! Snowflake is all about staying up-to-date and cool, regularly spicing up its lineup of awesome features to keep up with the changing times in the world of data. So, in t...

Data,functions,Snowflake,sql

Two Techniques to Transform Tableau Tooltips

Aug 21, 2023 Lex Devlin | www.thedataschool.co.uk

Formatting tooltips in Tableau can be troublesome and tedious. By default, Tableau will include in the tooltip all relevant measures and dimensions in the view, but often in rather boring and occasionally distracting ways. What if you want somethi...

Data,functions,Snowflake,sql

Tableau Prep Mini Tip Series Where to insert a new step in an existing f...

Aug 21, 2023 Lisa Hitch | www.thedataschool.co.uk

Two different ways to insert Tableau Prep flow steps: one that creates a new branch, the other does not.

openai,data-science,open-source,large-language-models,chatgpt

Streaks in Tableau

Aug 21, 2023 Terrence Miller | www.thedataschool.co.uk

Calculating streaks in Tableau is something I have had some trouble with.

openai,data-science,open-source,large-language-models,chatgpt

Projecting a line in Tableau

Aug 21, 2023 Sakif Chowdhury | www.thedataschool.co.uk

Last week, for our client project we had monthly target data. However, we needed to compare values at a daily or weekly level. This meant that we had to take this monthly target value and show how that translates into a daily targets throughout th...

openai,data-science,open-source,large-language-models,chatgpt

Iterative Macros in Alteryx A Simple Example

Aug 21, 2023 Lex Devlin | www.thedataschool.co.uk

In this blog, I’ll walk through what an iterative macro is and provide a simple example for how you might use one. I’ll assume you’re already familiar with the general concept of a macro.

openai,data-science,open-source,large-language-models,chatgpt

How to be more organized

Aug 21, 2023 Ana-Casiana Tarita | www.thedataschool.co.uk

As an unorganized person myself,  I’ve always been into the work smarter-not harder mindset but couldn’t get myself to follow it until recently when I discovered a few ways of getting more organized with my work.

openai,data-science,open-source,large-language-models,chatgpt

From Chaos to Zen Mastering the Art of Organized Work

Aug 21, 2023 Ana-Casiana Tarita | www.thedataschool.co.uk

As an unorganized person myself,  I’ve always been into the work smarter-not harder mindset but couldn’t get myself to follow it until recently when I discovered a few ways of getting more organized with my work.

Data,functions,Snowflake,sql

Detours in Alteryx

Aug 21, 2023 Terrence Miller | www.thedataschool.co.uk

The Detour tool is really useful in Alteryx when you have something you would like to have under one condition and something else to happen with other conditions.

openai,data-science,open-source,large-language-models,chatgpt

Creating a Fixed Axis Comet Chart

Aug 21, 2023 Afnan Foyez | www.thedataschool.co.uk

What is a comet chart?

openai,data-science,open-source,large-language-models,chatgpt

A No-Nonsense Approach to Large Language Models for the Enterprise pt. 3

Aug 21, 2023 Szilvia Hodvogner | medium.com

Final Results and EvaluationBusinesses are rushing to adapt language models to better serve their unique use cases, but due to the rapid evolution of the technology and the many variables in enterprise implementations, there’s a shortage of actual...

openai,data-science,open-source,large-language-models,chatgpt

Why You Need an Analytics Platform and Why Excel is Not Enough

Aug 21, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

Inthe past few years, I’ve written almost solely about Tableau, but this post isa little different. I’m going to step back and speak to a different audience ata much higher level and try to give you some reasons why you need to invest ina solid an...

How-To

Using Rank and Table Calculations in Tableau

Aug 20, 2023 Le Luu | www.thedataschool.co.uk

In the project of week 2, DSNY 5 was assigned to build a dashboard with World Indicators dataset in Tableau. I would like to compare the Internet usage of each region and each country. Therefore, I chose to build a drill down bar chart for that ca...

Lets Talk About Scatter Plots - Introduction

Aug 20, 2023 Jaroslav Tomcala | www.thedataschool.co.uk

What is a Scatter Plot?

How to compare value differences between different year in Tableau

Aug 20, 2023 Abby Poon | www.thedataschool.co.uk

In data visualization, Tableau offers powerful tools to uncover insights from your data. One common scenario is comparing  differences between different years. In this guide, we’ll walk you through the steps to achieve this using Tableau.

Forecasting in Tableau

Aug 20, 2023 Nitesh Shrestha | www.thedataschool.co.uk

In Tableau, we can forecast values in a time series using simple drag-and-drop function. Tableau uses an exponential smoothing prediction model where it identifies consistent patterns within measurements that can be extended into upcoming time per...

Diary of a Data School Newbie

Aug 20, 2023 Numa Begum | www.thedataschool.co.uk

After reading endless blogs from previous data schoolers, exploring Tableau and getting through to the interview. It was a huge accomplishment to be 1 of 8 to get the call from Carl (Head Coach, UK) to say I would be joining DS41! I had a month be...

Connected Scatter Plots - How to Show Time Series

Aug 20, 2023 Jaroslav Tomcala | www.thedataschool.co.uk

After I wrote my blog post about Scatter Plots, I thought it would be great to take one more step further and write about how to visualize changes over time using them.

Alteryx Designer Core Certification - 5th Week at DSDE

Aug 20, 2023 Ali Fawwaz | www.thedataschool.co.uk

The fifth week at the data school was a great week which is full of energy and confidence for all members of  DSDE 5 cohort.

Linear Trend Line in Tableau

Aug 19, 2023 Nitesh Shrestha | www.thedataschool.co.uk

Trend lines within Tableau serve as statistical tools designed to approximate trends or correlations among variables and to represent how one variable changes with another. Tableau gives us five types of these trend lines: Linear, Logarithmic, Exp...

Alteryx Week What is Alteryx - 4th Week at DSDE

Aug 19, 2023 Ali Fawwaz | www.thedataschool.co.uk

It is already the fourth week and in this week I was introduced to Alteryx. From my personal perspective, I felt more comfortable working with Alteryx compared to Tableau Prep that I worked with in the first week.

Why Planning Matters

Aug 18, 2023 Alexander Wood | www.thedataschool.co.uk

I really enjoyed the application process for the data school. It was great to have the freedom to decide what topic I wanted to do and then go ahead and learn how to use a tool that was completely new to me.

causality,dowhy,data-science,root-cause-analysis

The Gamification of Data Preparation

Aug 18, 2023 Numa Begum | www.thedataschool.co.uk

Have you ever felt stuck trying to prepare your data? Here is some motivation to improve your data prep skills by treating it like a game! I have been using Tableau Prep using the challenges on https://www.preppindata.com/, remember each time you ...

causality,dowhy,data-science,root-cause-analysis

Rules for presenting data in tableau

Aug 18, 2023 Myles Stevenson | www.thedataschool.co.uk

When working with a tableau desktop the most important thing I learnt was the importance 0f containers, everything should go into containers and this helps to position all of the aspects in your dashboard

causality,dowhy,data-science,root-cause-analysis

How to Create SQL Joins in Alteryx

Aug 18, 2023 Tabitha Diaz | www.thedataschool.co.uk

When I was first introduced to Alteryx I couldn’t wrap my head around why the outputs were so different than the ones you can create in SQL. The great news is you can create those same SQL outputs in Alteryx without any need to code. Before contin...

Data,consulting,PersonalDevelopment,Presenting

Gestalt Principles

Aug 18, 2023 Le Luu | www.thedataschool.co.uk

In the second training week, I learned about the data visualization about what users should do and should not do in visualization. There are many rules and principles, but I like the Gestalt Principles and useful to apply them into the visualizati...

Data,consulting,PersonalDevelopment,Presenting

Avoid the Pitfalls of Causality Analysis

Aug 18, 2023 Lajkó Gábor | medium.com

Business intelligence has been concerned with “why” questions since the field’s inception, and there’s a wealth of methods that companies employ to find answers. These, however, all have inherent limitations that make them fundamentally ill-suited...

causality,dowhy,data-science,root-cause-analysis