Tableau Aggregator

Pivoting in Tableau Prep - Part A

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

We learned about pivoting in our first week. Essentially, pivoting is a data transformation technique used in databases and spreadsheets to reorganize and reshape data by changing the layout of the data from one form to another. It involves rotati...

Monday Music Musings No thats not James Jamerson Part 2

Aug 12, 2023 Steve Wexler | www.datarevelations.com

I wrote previously about a great bassline that people attribute to James Jamerson, but was performed by then 18-year-old Michael Henderson. Here’s another bassline that sounds like Jamerson, but isn’t. In 2015 the music world lost Wilton Felder. M...

MusicMusings,SportsandEntertainment,JamesJamerson,music,WiltonFelder

What did it take to get into DS41

Aug 11, 2023 Jenny Martin | www.thedataschool.co.uk

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

Joins expand data horizontally Unions expand data vertically ... Or not

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

Researchers, data analysts, and data consultants will -at some point- have to combine multiple datasets to create a larger or more complete one. There are different ways on how to combine them.

Alteryx .Bak Alright

Aug 11, 2023 Jessica Kwan | www.thedataschool.co.uk

On a recent project, I received some files and among those files, one had a .bak file extension. I tried all the methods I could think of, but I still couldn’t file to open and show the workflow. I had to ask my bestie, Google, for help.

What does a data consultant do Or how a sandwich becomes a business deci...

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

When I told everyone that I wanted to be a Data Consultant, I often got impressed nods, but puzzled looks. The terms data and consultancy certainly sound impressive, but what does that actually mean? How would you explain what a data consultant do...

Data,credits,internship,Snowflake

What did it take to get into DSNY5

Aug 10, 2023 Mel Niere | www.thedataschool.co.uk

Introducing Cohort 5 of The Data School New York - an incredible group that has left us utterly impressed with their exceptional prowess in data analysis. They have demonstrated their skills by exploring a wide range of datasets, and we encourage ...

Data,credits,internship,Snowflake

So what actually is data

Aug 10, 2023 Patrick Maguire | www.thedataschool.co.uk

As mine and DS41’s first week at the Data School comes to a close, I’m beginning to reflect on everything I have learnt this week. From data structure, data sources, and data preparation to name just a few, its amazing how much can be covered in a...

Drawing out your Data Journey

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

…and you don’t need to be an artist! A huge lesson I learnt in my very first week at the data school is that a plan is what takes you from chaos to clarity when preparing and cleaning a dataset. A plan is the difference that will make or break you...

What I Learned from Totally Messing Up Joins and Snowflake Credits

Aug 10, 2023 Bridget Marrara | interworks.com

The Day Before: Bringing our Snowflake Data into Tableau As the week began, we entered the development stage of our big intern project. My role thus far has been preparing for development by creating wireframes for the new dashboards. For this pro...

Data,credits,internship,Snowflake

Doing Your Laundry Fun Example to Understanding Macros in Alteryx

Aug 9, 2023 Jessica Kwan | www.thedataschool.co.uk

My favorite example to understanding the difference between standard macros, batch macros, and iterative macros during training uses laundry.

ChartTypes,Storytelling,TechnicalFeatures,TipsTricks

Back to the Drawing Dashboard

Aug 9, 2023 Vivian Ng | www.thedataschool.co.uk

If you’ve been following my blog, you’ll know that I’ve been writing about how I created my HIPAA breaches dashboard. I recently completed my reviz of it—finished reviziting it—by going Once More Unto the Breach, so now I’m going to start blogging...

ChartTypes,Storytelling,TechnicalFeatures,TipsTricks

Exploring International Birth Rate Data in Tableau

Aug 9, 2023 Eric Parker | onenumber.biz

How do you approach a new data set in Tableau? Do you spend a while studying the fields and data types? Or do you Google what other people have built using similar data? Maybe you like jumping straight into building to see how things shake out?

Design,TableauHow-Tos

How to Master the 3-Level Drill Down in Tableau with Dynamic Zone Visibi...

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

Welcome to my guide on mastering the 3-Level Drill Down in Tableau! In this tutorial, I show you step-by-step how to make the most of using dynamic zone visibility to create this functionality. We’ll go through both scatter plot drill downs from R...

3leveldrilldown,barchart,bestpractices,boolean,calculatedfield,demo,dynamiczonevisibility,howto,interactivity,parameter,parameteraction,scatterplot,tableau,tip

My time at the Data School so far

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

During my first day of training at the data school it became information overload, with so many technical terms and new vocabulary that I needed to learn. I thought this would be the perfect opportunity to write my first blog post. About terminolo...

AWS Step Functions Catch Em All by Loading Pokmon Data from a RESTful AP...

Aug 8, 2023 Fadi Al Rayes | interworks.com

As modern applications expand in complexity, effectively managing workflows can become a significant challenge. AWS Step Functions provides a comprehensive solution for orchestrating multi-step workflows in the cloud. Whether it’s invoking Lambda ...

Data,AWS,json,LambdaFunctions,Pokemon,python,RESTAPI,Snowflake,StepFunctions

MakeoverMonday Week 32 - The Gap in Parental Leave

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

The gap in parental leave is extremely wide across all industries in America. How do only 23% of women get 14+ weeks of maternity leave? Why isn’t progress being made to help dads take a more active role?Check out the livestream recording and inte...

barchart,calculatedfield,divergingchart,donutchart,howto,maternityleave,men,paternityleave,stackedchart,tableau,women

Track your KPIs with Tableau Metrics

Aug 7, 2023 Kirsty Wall | interworks.com

When businesses progress along the data maturity scale, the volume of data and associated dashboards will start to expand. This is great news! But, it can cause problems along the way. It is likely that your Tableau estate can start getting more d...

Data,KPI,Tableau

A Guide to Embedding Tableau 3 The Embedding Playground

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

In my previous two blogs on the topic of embedding, I introducedyou to thebasics of embedding, then shared severalembedding examples. My goal was to make embedding easier for non-programmers. Littledid I know that, while I was writing these blogs,...

How-To,SeriesGuidetoEmbeddingTableau,Tableau,Templates

Cross-Function Mobility Recap

Aug 7, 2023 Steve Wexler | www.datarevelations.com

Here’s a recording and recap of Real World Fake Data meets Chart Chat: Showing cross-function mobility in HR data https://www.youtube.com/live/ZAxzJwyBuOk?feature=share 0:00 Introduction and Agenda 2:06 Backstory / Data 10:45 Assumptions, omissio...

BusinessVisualizations,ChartChat,Makeovers,cross-functionmobility,HR,RWFD

How to Create Tabs in Tableau Using Parameters and Dynamic Zone Visibility

Aug 5, 2023 Lindsay Betzendahl | vizzendata.com

I’ve been working with a client for the past 4 years creating infographics for their printed annual report. This year,Continue reading

Design,Tableau,Tutorial,DynamicZoneVisibility,Parameters,Tabs,UIUX

Iterative Macros

Aug 5, 2023 Olivier Newman | www.thedataschool.co.uk

I finally understood iterative macros and I wanted to take this as an opportunity to cement my learning and write a blog. A common use case is looking at the effect of interest rates over time. here we have an overview of my simple iterative macro.

Alumni Spotlight Diego Parker

Aug 3, 2023 Mel Niere | www.thedataschool.co.uk

Learn more about Diego’s experience, from the time he applied to The Data School, to his career as a Data Analytics Strategy Manager at Lloyds Banking Group. Diego was part of Cohort 12 of The Data School London, which took place from December 201...

How to Create Light Mode and Dark Mode Dashboards in Tableau

Aug 3, 2023 Luke Lewis | playfairdata.com

Over the years, Playfair Data has been honored to receive and be nominated for several design awards for our products.…The post How to Create Light Mode and Dark Mode Dashboards in Tableau appeared first on Playfair Data.

Dashboards,Storytelling,TipsTricks,UserExperience

Sentiment Analysis With Native Algorithms in Dataiku

Aug 3, 2023 Azucena Coronel | interworks.com

This is the third part of a short series called “Natural Language Processing with Dataiku,” where we are analysing airline reviews. In the first part, we did very basic data preparation, used the Dataiku sentiment analysis plugin and evaluated the...

Data,Dataiku,NLP,sentimentanalysis

Can you find the most popular sub-category sales by state

Aug 3, 2023 Donna Coles | donnacoles.home.blog

Lorna’s challenge this week involved the use of nested LoDs (level of detail calculations) and ViT (viz in tooltip). The requirements were very brief (just 4 bullet points), but that didn’t mean this would be simple! Each bar in the bar chart repr...

WorkoutWednesday,WOW2023,COUNTD,FIXEDLOD,Map,MapBackground,MapLocations,NestedLOD,ParameterActions,VizinTooltip,Week31

How to make a control Chart in tableau

Aug 2, 2023 Olivier Newman | www.thedataschool.co.uk

These are often used in an industrial context to see when certain dates fall outside predefined accepted limits over a period of time.