Breaking down the Cube

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

or “Rolling the Dice with Power BI: My Dive into an Expert Challenge”

What did it take to get into DS45

Jun 26, 2024 Jenny Martin | www.thedataschool.co.uk

DS45 are in the 4th week of their journey at the Data School. A perfect time to look at what it took for them to get in!

How to Create a 9-Box Matrix in Tableau

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

In this video, I show you how to build a 9-box matrix. These are commonly used in talent management and HR to map a company’s workforce along two dimensions, potential and performance. Each of these two dimensions is split up into three categories...

9-box,employee,grid,heatmap,howto,HR,humanresources,matrix,performance,scatterplot,tableau,tip

Scraping multiple webpages - in Power Query

Jun 25, 2024 Tim Jeffries | www.thedataschool.co.uk

One of the most enjoyable days so far today, as the planned Power Query WOW webpage scraping wasn’t working as expected, so another had to be found quickly, and TL;DR no-one was entirely sure exactly how to get all the pages in properly. It was a ...

Data,python,Snowflake

Data Models

Jun 25, 2024 Alfie King | www.thedataschool.co.uk

Creating a data model is like a lot of projects in data. It is significantly easier if you plan first.

Data,python,Snowflake

Containers

Jun 25, 2024 Alfie King | www.thedataschool.co.uk

When starting my application for the data school we had to create a visualisation, and when it came to actually creating the dashboard I struggled throughout the application. This is because I was using floating panes instead of containers.

Data,python,Snowflake

Avoiding Common Pitfalls in Chart Design

Jun 25, 2024 Alyssa Huff | playfairdata.com

Choosing and designing charts is a deceptively challenging aspect of data visualization. It can seem obvious when someone else made…The post Avoiding Common Pitfalls in Chart Design appeared first on Playfair Data.

ChartTypes,Design,Figma,Intermediate

Python and Snowflake FAQ

Jun 25, 2024 Chaitanya Joshi | interworks.com

Python is a first class language in the Snowflake eco system, and there are multiple ways to use Python with Snowflake: Snowflake Connector for Python: Listed in Snowflake drivers, this is a standard connector to Snowflake written using Python. It...

Data,python,Snowflake

Maturing Analytics Why Dashboards Fail

Jun 25, 2024 Ben Bausili | interworks.com

In Part 1, we looked at our Job to be Done and why it wasn’t building Dashboards. The key takeaway is to focus on user value and solve their pain points. Now, let’s turn to why what building dashboards doesn’t deliver the user value we…The post Ma...

Data,analytics,dashboards

Maturing Analytics The Job To Be Done

Jun 25, 2024 Ben Bausili | interworks.com

The data and analytics industry is changing. Buried beneath the marketing hype and buzzwords, there’s something real happening, and the data industry is going through a giant shift. I’ve heard it described as both “overhyped and underestimated.” O...

Data,analytics,dashboards

Explaining with Data Normalization and Percentile calculations in Tablea...

Jun 24, 2024 Robbin Vernooij | www.thedataschool.co.uk

In this blog, part of the Explaining with series, I will go over two different methods of data normalization; Z-Scores and Rank Percentile calculations. Showcasing examples using Sports Data and how-to guides in Tableau and Power BI

IT,Podcast,PodcastYourData,sales

IT Sales Simplified Tech Talk with Tim Adams

Jun 24, 2024 InterWorks | interworks.com

In this episode, IT Sales Simplified host Genna Callahan sits down with IT Support Manager Tim Adams to talk about real world IT experience and Tim’s path to IT.The post IT Sales Simplified: Tech Talk with Tim Adams appeared first on InterWorks.

IT,Podcast,PodcastYourData,sales

Boost Your Tableau Workbooks With Large and Complex Data Sources

Jun 24, 2024 Robin Schouten | interworks.com

Speed is of the essence in lots of things, and Tableau dashboards are no different. Developers and end users alike want dashboards loaded in a blink of an eye. Luckily, there are many resources online that will help you optimise your dashboards, s...

Data,data,sql,Tableau

Kirk Munroe New in Tableau 2024.2 Shared Dimensions

Jun 24, 2024 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Kevin and Iare pleased to welcome back Kirk Munroe for another guest post. Kirk lives inHalifax, Nova Scotia, Canada and is a business analytics and performancemanagement expert. He is currently one of the owners and principal consultantsat Paint...

How-To,SeriesDataModeling,Tableau

How to Set Up a Date Field in a Year-Over-Year Dual Axis Chart

Jun 22, 2024 Yan Peng | www.thedataschool.co.uk

In this post, I will show you how to create a year-over-year dual axis chart in Tableau, with the x-axis displaying the month-year date format of the current year. The following chat visualizes the sums of sales from the current and the previous y...

Alteryx,DataPrep,Fundamentals,TableauPrep,TipsTricks

Why Its Important to Understand the Granularity of Data

Jun 22, 2024 Ariana Cukier | playfairdata.com

When kicking off a project involving data, one of the first questions will be, “Do we have the right data…The post Why It’s Important to Understand the Granularity of Data appeared first on Playfair Data.

Alteryx,DataPrep,Fundamentals,TableauPrep,TipsTricks

Building an Investment Portfolio Optimisation Tool with Python and Table...

Jun 22, 2024 | www.prosvetova.com

Some time ago I wanted to create a dynamic tool in Tableau, that enables end users to iterate through different combinations of variables (companies to invest, investment value, etc.), and immediatelly see how their choices impact the output of po...

tableau,datadev,python

The Current State of Semantic Layers

Jun 21, 2024 Jack Hulbert | interworks.com

In my last blog post, where I introduced the concept of a universal semantic layer, we outlined the benefits that organizations with multiple business domains can recognize. These organizations use data and data consumption tools, and can adopt a ...

Uncategorized,AI,Cube,dbt,ML,SemanticLayers,TableauPulse

InterWorks Blog Roundup May 2024

Jun 21, 2024 Mark Cordeiro | interworks.com

I want you to know, my first draft of this blog post was almost entirely made up of me slipping “May” into casual sentences or trying to come up with puns surrounding the month’s name. I’ve spared you from reading all that, don’t worry. It…The pos...

Data,BlogRoundup,IT,Snowflake,Tableau

Can you combine part-to-whole and comparison

Jun 21, 2024 Donna Coles | donnacoles.home.blog

Sean’s #WOW2024 challenge this week was to visualise the comparisons between different entities within a limited space, by using a Viz In Tooltip (VIT) to provide additional information on hover. Building the Treemap Add Sales to Size, Category to...

WorkoutWednesday,WOW2024,HideMarks,ParameterActions,ParttoWhole,Rank,Treemap,VIT,VizinTooltip,Week25

How to Simultaneously Highlight Deselect with a Parameter Action in Tab...

Jun 20, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this video, we’ll dive into an advanced technique to enhance your Tableau visualizations: simultaneously highlighting and deselecting marks using parameter actions. This is a great skill for making your dashboards more interactive and user-frie...

action,deselect,filteraction,highlight,howto,label,parameter,parameteraction,tableau,tip

Building Data Models

Jun 20, 2024 Becky Wright | www.thedataschool.co.uk

It’s week 3! From Monday to Wednesday, we worked through calculations and functions, Intro to Power BI and Data Models & Data Source Connections. 

Data,python,Snowflake

So which do you prefer

Jun 19, 2024 Tim Jeffries | www.thedataschool.co.uk

This past week we’ve moved on from just using Tableau and Tableau Prep, and started using Alteryx and Power BI as well for our Calculations & Functions and Data Models sessions. Naturally, then, I’ve been asking around a bit to see if people h...

Data,python,Snowflake

Reflective Log from Week 2 Friday Project

Jun 19, 2024 Alfie King | www.thedataschool.co.uk

When I first started this project it was quite daunting. But, by the end of the project I realise that this project was not as hard as I first thought, and now that I am done with it I feel like I spent a lot of time doing non-essential items. Suc...

TableauPrep

Tableau Prep Join Types Explained All 7

Jun 19, 2024 Eric Parker | onenumber.biz

One of the primary ways we combine multiple tables of data in Tableau Prep is with joins! Joins allow us to merge multiple tables of data horizontally on a common key.

TableauPrep

Snowflake Security and Cost Management Health Checks

Jun 19, 2024 Chris Hastie | interworks.com

As many are already aware, there has recently been a lot of noise about security on the Snowflake platform. On June 2nd, 2024, Snowflake issued this statement regarding a targeted threat campaign against some Snowflake customer accounts. This appe...

Data,healthcheck,security,Snowflake

Getting Ready For The Tableau Certified Data Analyst

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

As part of our training at The Data School we must pass the Tableau Data Analyst certification. In order to increase my chances of passing, I am getting ready and trying to review as much content as I can.

TableauPrep

What Is ThoughtSpots SpotIQ

Jun 18, 2024 Kirsty Wall | interworks.com

Do you think there might be insights hidden in your data that are waiting to be uncovered, but you’ve just not found them yet? Yes? Well, ThoughtSpot can help uncover those insights using their SpotIQ feature. Sometimes when looking at data, wheth...

Data,SpotIQ,ThoughtSpot

Snowflake External Access Trigger Tableau Datasource Refreshes

Jun 18, 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,Snowflake,Tableau

How to Improve Security with Snowflakes Trust Center

Jun 18, 2024 Chris Hastie | interworks.com

As many are already aware, recently there has been a lot of noise about security on the Snowflake platform. On June 2, 2024 Snowflake issued this statement regarding a targeted threat campaign against some Snowflake customer accounts. This appeare...

Data,data,security,Snowflake

De-Mystifying the Data Catalog Find and Use Your Data

Jun 18, 2024 Jim Horbury | interworks.com

At InterWorks, we put an enormous amount of effort into translating complex technical concepts to make them easily understandable — and actionable — for the organisations we work with. It’s extraordinarily difficult to decide about a tool or vendo...

Data,data,DataCatalog

Tableau Parameter

Jun 17, 2024 Rui Pedro Fernandes Ramos | www.thedataschool.co.uk

Advanced,Design,Figma,UserExperience

Male wie ein Data Analyst

Jun 17, 2024 Rui Pedro Fernandes Ramos | www.thedataschool.co.uk

Datenvisualisierung spielt eine entscheidende Rolle in der Datenanalyse. Sie hilft, komplexe Datenmengen verständlich und interpretierbar zu machen. Verschiedene Arten von Visualisierungen eignen sich für unterschiedliche Arten von Daten und Analy...

Advanced,Design,Figma,UserExperience

Dynamic Zone Visibility Without Calculated Fields

Jun 17, 2024 Cecily Santiago | www.thedataschool.co.uk

There is a known issue in some versions of Tableau where when using calculated fields from an extract with dynamic zone visibility or dynamic axis titles, refresh extracts fail. If you come across that bug, you might want to use dynamic zone visib...

Advanced,Design,Figma,UserExperience

Fundamentals of Accessibility Design Making Your Dashboards a Friendlier...

Jun 17, 2024 Rafael Simancas | playfairdata.com

“What are your accessibility design standards?” It’s a question that can catch us off guard during project discussions. But when…The post Fundamentals of Accessibility Design: Making Your Dashboards a Friendlier Place appeared first on Playfair Data.

Advanced,Design,Figma,UserExperience

How To Be A Confident Newcomer

Jun 16, 2024 Yan Peng | www.thedataschool.co.uk

Navigating a career change can be daunting, especially when starting something new feels uncomfortable, and you fear failure. A year ago, I decided to change my career, and my life has transformed in many ways thanks to that decision and my dedica...

Fire Prevention Heatmapping Fire Risk Groups

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

or how to analyse ‘at risk’ groups through data analysis. In the second internal client project, I was responsible for the following question: fire and rescue services need to demonstrate that they have carried out an analysis to identify the demo...

Reflecting on the Importance of SOPs Lessons from My Academic Journey

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

or “How To Organize A One Week Client Project As Project Manager SOP”. It is now week 11 and two weeks ago I already had the opportunity to slip into the role of project manager. For my reflection log, I started to summarise my experiences during ...

Chart Swapping Without DZV in Tableau

Jun 14, 2024 Cecily Santiago | www.thedataschool.co.uk

There is a known issue in some versions of Tableau where when using calculated fields from an extract with dynamic zone visibility or dynamic axis titles, refresh extracts fail. If you come across that bug, you might want to swap charts without us...

WorkoutWednesday,WOW2024,BarChart,ButterflyChart,CustomLabels,Parameters,ReferenceLines,StackedBarCharts,Week24

Can you visualise headcount distribution in multiple ways on a single sh...

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

This week’s challenge focuses on allowing the user flexibility in both how they want to ‘slice’ the measure being reported (actual headcount), and how they want the results displayed to meet the needs of the question they are trying to answer. Whi...

WorkoutWednesday,WOW2024,BarChart,ButterflyChart,CustomLabels,Parameters,ReferenceLines,StackedBarCharts,Week24

Alteryx Auto Insights Usage Requirements Reflections

Jun 12, 2024 Cecily Santiago | www.thedataschool.co.uk

A couple months ago, I attended an Alteryx Cloud Training provided by Alteryx to Data School consultants, which covered several of their cloud products including the exciting Alteryx Auto Insights. The information I’m sharing here is based on that...

Its gonna get so much harder...

Jun 11, 2024 Tim Jeffries | www.thedataschool.co.uk

A quick reflection on the first week of training, two days into the second.

Data,python,Snowflake

Data School Blog Roundup - May 2024

Jun 11, 2024 Mel Niere | www.thedataschool.co.uk

Compiled by Rusha Limba, Intern

Snowflake External Access Send Alerts to Teams

Jun 11, 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,Snowflake

Overcoming Adversity

Jun 10, 2024 Dillon Thomas | www.thedataschool.co.uk

Adversity is Normal: