Snowflake External Access Send Alerts to Slack

Jun 4, 2024 Chris Hastie | interworks.com

Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to com...

Data,Slack,Snowflake

Turning Up Volume My Journey to Loving Blog Writing

Jun 3, 2024 Aileen Pfleiderer | www.thedataschool.co.uk

This blog is about the book “working out loud” by John Stepper. My first impression is that this book is maybe not for me. So far, I’ve always found book titles like “Quiet people sell differently” by Andreas Hoffmann more appealing to me. But sin...

ChartTypes,Engineering,Fundamentals,TableauDesktop

Tableau Measure Names And Measure Values - How To Use Them

Jun 3, 2024 Bruno Gasparotto Ponne | www.thedataschool.co.uk

What are measure names and measure values?

ChartTypes,Engineering,Fundamentals,TableauDesktop

How to Make a Heat Map in Tableau

Jun 3, 2024 Dan Bunker | playfairdata.com

A Tableau heat map is a chart type that allows users to quickly identify patterns in marks by using the…The post How to Make a Heat Map in Tableau appeared first on Playfair Data.

ChartTypes,Engineering,Fundamentals,TableauDesktop

Custom Dynamic Legends in Tableau

May 31, 2024 Lindsay Betzendahl | vizzendata.com

Data visualization tools provide many out-of-the-box elements that make our jobs as designers and developers easy. Tools like Tableau haveContinue reading

DataVisualization,Design,Tableau,Tutorial,Color,Legends

Is looking like Matt Damon the key to Hollywood success Dashboard Week ...

May 31, 2024 Jeffrey Brian Thompson | www.thedataschool.co.uk

This blog will walk through my final Dashboard Week project, where I made the following dashboard, which can be found on Tableau Public here:

Dashboard Week Final Day -Financial Success of Poorly Rated Films

May 31, 2024 Justinas Aleksiejus | www.thedataschool.co.uk

Today, I was analyzing the financial success of poorly rated films using Tableau. The initial data was prepared, but I needed additional information on film budgets, opening week box office figures, and lifetime box office earnings. I chose top 20...

DS44 Go To The Movies Dashboard Week Finale

May 31, 2024 Alex McManus | www.thedataschool.co.uk

To end the final day of dashboard week, and consequently training, we were tasked with creating a dashboard from the Data + Movies challenge set by Tableau.

Can you make a page navigator

May 31, 2024 Donna Coles | donnacoles.home.blog

Yoshi set this week’s challenge to build a page navigator, but there was so much more in it too, so this could be a bit lengthy 🙂 Note, I’m blogging based on the full ‘advanced’ challenge, to include an ‘apply all’ button as well. I built the foll...

WorkoutWednesday,WOW2024,deselectmarks,filteractions,Filters,INDEX,PageNavigation,ParameterActions,SIZE,TableCalculations,week22,Window_Max

DS44 Dashboard Week Day 34

May 30, 2024 Ruth Amarteifio | www.thedataschool.co.uk

Lets go to the Movies

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Coloring the Ends of a Bar Chart in Tableau

May 29, 2024 Lindsay Betzendahl | vizzendata.com

The Theories We Learn As much as I’m a huge fan of color, I’m also an advocate for reducing itContinue reading

DataVisualization,Design,Tableau,Tutorial,Barchart,Color,Gantt,Gestalt

SQL Data Preparation and Power BI Dashboard Week Day 2

May 29, 2024 Jeffrey Brian Thompson | www.thedataschool.co.uk

Today we were tasked to connect to and prepare data via SQL, and then produce a Power BI report around a topic of our choosing.

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Project Fire Rescue

May 29, 2024 Leonardo Ceballos | www.thedataschool.co.uk

In this project, I helped the London Fire Brigade create a dashboard to analyse their data. My main task was to provide insights into their Call Centre performance.

Data,ETL,Matillion,python,Snowflake

Lego Dashboard in PowerBI Dashboard Week Day 2

May 29, 2024 Anne Porcia Affi-Asamani | www.thedataschool.co.uk

On the second day of dashboard week DS44 were given a Lego themed dataset and tasked with creating a report in PowerBI. It involved preparing and retrieving tables from snowflake using SQL and focusing on a specific topic to narrow our scope for t...

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

LEGO Dashboard - Dashboard Week Day 2

May 29, 2024 Alex Bernaciak | www.thedataschool.co.uk

Today we were tasked with preparing a dashboard based on the LEGO data placed on a SQL server. The first challenge focused on identifying all the relevant tables and understanding how to relate them to pull up all the necessary data.

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Internes Projekt Fire Rescue

May 29, 2024 Rui Pedro Fernandes Ramos | www.thedataschool.co.uk

Daten: In diesem Projekt wurden Feuerwehr Datensätze genutzt, welche in England gesammelt wurden. Der Datensatz beinhaltet Informationen zu verschiedenen Indikatoren wie:

Data,ETL,Matillion,python,Snowflake

Inclusive Dashboards Small changes Big impact.

May 29, 2024 Justinas Aleksiejus | www.thedataschool.co.uk

As a data consultant, I often build dashboards to present complex data in a clear and understandable way. Today, I had the opportunity to create a dashboard with a focus on accessibility, a task that has reshaped my approach to data visualization.

Data,ETL,Matillion,python,Snowflake

Dashboard Week Day 2 - Using Snowflake SQL and PowerBI to Analyse Lego D...

May 29, 2024 Alex McManus | www.thedataschool.co.uk

Today marked the second day of Dashboard Week for DS44. Our task was to use SQL on Snowflake to prepare data, followed by analysis and visualisation using Power BI.

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Dashboard Week Day 2 - SQL Power BI

May 29, 2024 Justinas Aleksiejus | www.thedataschool.co.uk

Today we were tasked with using SQL on Snowflake to prepare our data before using Power BI to analyze the data.

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Dashboard Week - Day 2 - Lego

May 29, 2024 Alvaro Gonzalez | www.thedataschool.co.uk

For Day 2 of Dashboard Week, DS44 was assigned a task that required combining planning, SQL & Power BI skills to create a LEGO themed report. We had to scope and plan a dashboard based on a Snowflake schema, we then had to query the data we re...

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Dashboard Week - Day 1 - Accessibility

May 29, 2024 Alvaro Gonzalez | www.thedataschool.co.uk

Intro

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Dashboard Day 2 Lego Data

May 29, 2024 Jessica Robbin | www.thedataschool.co.uk

For Day 2 of Dashboard Week, we were given a dataset on an inventory of LEGO pieces. The data was stored on Snowflake, and we needed to use SQL to prepare the data before building a dashboard in Power BI.

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

DS44 Dashboard Week Day 2

May 29, 2024 Ruth Amarteifio | www.thedataschool.co.uk

It’s day 2 of dashboard week for DS44.

Data,ETL,Matillion,python,Snowflake

DS44 Dashboard Week Day 1 Accessibility

May 29, 2024 Alex McManus | www.thedataschool.co.uk

As part of DS44’s dashboard week, we delved into the crucial topic of Accessibility. The task involved presenting a dashboard based on our learnings, specifically focusing on making it accessible to users who navigate exclusively with a keyboard. ...

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Accessible Dashboards in Tableau Dashboard Week Day 1

May 29, 2024 Anne Porcia Affi-Asamani | www.thedataschool.co.uk

This week is dashboard week for DS44 and for day 1 we were tasked with creating a dashboard that is accessible for a specific user. My brief required me to recreate a dashboard that a user with dyscalculia would be able to use. Along with this I a...

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Accessibility Navigating a Dashboard Using Keyboard Only on the Server

May 29, 2024 Jessica Robbin | www.thedataschool.co.uk

On the 1st day of Dashboard week we were learning about how to make dashboards accessible for different people. To achieve full accessibility, a website should be designed to function seamlessly for individuals who use only a keyboard for navigati...

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Accessibility Font Choice - Dashboard Week Day 1

May 29, 2024 Alex Bernaciak | www.thedataschool.co.uk

Accessibility is an umbrella term which changes can change its meaning depending on the people it involves. Accommodating for different conditions when building vizzes is therefore a difficult task unless you know exactly what conditions you’re tr...

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

An Introduction to the Power BI Power Query Editor

May 29, 2024 Juan Carlos Guzman | playfairdata.com

With the Power BI Power Query Editor, the data engineering world is at your fingertips. You can shape data to…The post An Introduction to the Power BI Power Query Editor appeared first on Playfair Data.

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

The Jungle of Tools

May 28, 2024 Aileen Pfleiderer | www.thedataschool.co.uk

or which tools you get to know as a data analyst

Data,ETL,Matillion,python,Snowflake

Internal Project London Fire Brigade

May 28, 2024 Sayd Abdul Tawab Hussainy | www.thedataschool.co.uk

The Client

Data,ETL,Matillion,python,Snowflake

Internal Project Chin Beard Suds Co

May 28, 2024 Rui Pedro Fernandes Ramos | www.thedataschool.co.uk

Date: 07.05.24 - 10.05.24

Data,ETL,Matillion,python,Snowflake

How to Make a Dashboard Accessible for Screen Readers Dashboard Week Da...

May 28, 2024 Jeffrey Brian Thompson | www.thedataschool.co.uk

Screen readers such as window’s in-build narrator (which can be turned on and off via windows key + ctrl + enter) sometimes struggle to navigate a Tableau dashboard.

Data,ETL,Matillion,python,Snowflake

How to Build a Bar Chart with Gantt-Like Lines in Power BI

May 28, 2024 Salome Grasland | www.thedataschool.co.uk

Data,ETL,Matillion,python,Snowflake

Snowflake External Access Trigger Matillion ETL Jobs

May 28, 2024 Chris Hastie | interworks.com

Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to com...

Data,ETL,Matillion,python,Snowflake

How I Design an Actuals vs Target Chart

May 28, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

      In almost every single dashboard I’ve created for clients, I’ve created some form of an actuals versus targets chart.  That target might be an actual target or some variation like a previous year’s value, as an example. Regardles...

Tableau

Top 7 Lessons From Our Internal Projects

May 27, 2024 Bruno Gasparotto Ponne | www.thedataschool.co.uk

As we approach our first client project, I would like to gather 7 of the most valuable feedback we have received during our two internal projects. This feedback is both about technical aspects (how to use the tools) as well as about how we communi...

Espaol,NLP,Token,Tokenization

Tokenization in Tableau Prep Unlocks unlimited text handling

May 27, 2024 Rosario Gauna | rosariogaunag.wordpress.com

Tokenization is a crucial step in natural language processing, where a text is divided into basic units called «tokens». This process allows algorithms to understand the structure and context of the text, facilitating further analysis. In Tableau ...

English,NLP,Token,Tokenization

Tokenizacin en Tableau Prep Desbloquea el manejo de texto ilimitado

May 27, 2024 Rosario Gauna | rosariogaunag.wordpress.com

La tokenización es un paso crucial en el procesamiento del lenguaje natural, donde se divide un texto en unidades básicas llamadas «tokens». Este proceso permite a los algoritmos comprender la estructura y el contexto del texto, facilitando su aná...

Espaol,NLP,Token,Tokenization

How to Create a Barcode Chart in Tableau

May 26, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Like dot strip plots, barcode charts are good for displaying all the data in a table, they work best when highlighting individual values.

barcode,barcodechart,detail,dimension,distribution,howto,measure,tableau

How to Become a Better Learner

May 26, 2024 Yan Peng | www.thedataschool.co.uk

One motivating factor for me to apply for the Data School was its focus on candidates with the potential to become good data analysts. They don’t need prior experience as analysts but should have successfully learned something challenging in the p...

How to Create a Dot Strip Plot in Tableau

May 25, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Dot strip plots help visualize the frequency and distribution of small, discrete data sets. Dots placed in order on a strip are a space-efficient method of laying out ranks across multiple categories.

comparison,discrete,distribution,dotplot,dotstripplot,frequency,howto,order,referenceline,stripplot,tableau

How to Calculate Year over Year Change in Tableau

May 25, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

With Level of Detail Expressions, calculating year over year change is simple with the 7 steps.

difference,calculatedfield,change,howto,levelofdetail,LODcalc,percentchange,tableau,yearoveryear

Noisy Environment

May 25, 2024 Aileen Pfleiderer | www.thedataschool.co.uk

This blog is about the book “The Signal and the Noise” by Nate Silver published in the year 2012.

Can you rebuild this Tube Map

May 24, 2024 Donna Coles | donnacoles.home.blog

Lorna called on the help of a data schooler, Olivier Newman to set this week’s challenge, which will be part one of a 2-part challenge. For those of you who are regular readers of my blog, you’ll know that working with maps and spatial data isn’t ...

WorkoutWednesday,WOW2024,MAKEPOINT,MapLayers,Parameters,Path,Sets,Spatial,Week21

How to Sort Stacked Bars With a Selection in Tableau

May 22, 2024 Eric Parker | onenumber.biz

Stacked bar charts are a brilliant visual for displaying how individual segments contribute to the overall value of a category, and how a category ranks in relation to other categories. Like all data visualizations however, it has some weaknesses.

TableauSets,TableauHow-Tos