Dashboard Week Day 3 Coldplay Lyrics

Nov 28, 2023 Charles Yi | www.thedataschool.co.uk

Dashboard week day 3 consisted of using lyrics to make a dashboard.

data-engineering,itot,industrial-data,it-ot-convergence

Dashboard Week Day 3

Nov 28, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

Our dataset(s) for this week included a zip file of 21 csv’s of different singers (https://www.kaggle.com/datasets/deepshah16/song-lyrics-dataset). Since I had been considering building a dashboard comparing the success of Taylor Swift and Beyonce...

data-engineering,itot,industrial-data,it-ot-convergence

Dashboard Week Day 2 Ireland Vs France

Nov 28, 2023 Patrick Maguire | www.thedataschool.co.uk

Day 2 - Let’s get active.

data-engineering,itot,industrial-data,it-ot-convergence

Dashboard Week Day 2 - I have a wager this will be in Power BI

Nov 28, 2023 Numa Begum | www.thedataschool.co.uk

… and it was! Today Jenny gave us data from the Organisation of Economic Co-operation and Development (OECD) which had 8 datasets about wages and pay!

data-engineering,itot,industrial-data,it-ot-convergence

Dashboard Week Day 2 - Ed Sheeran

Nov 28, 2023 Erin Potter | www.thedataschool.co.uk

Welcome back to my blog series for Dashboard Week! This week we are tasked each day to produce a dashboard and blog as well as other deliverables such as a documented data prep workflow and wireframes. Today’s task was a bumpy road!

data-engineering,itot,industrial-data,it-ot-convergence

Dashboard Week Day 2 Do pay transparency policies reduce the gender pay ...

Nov 28, 2023 Maddalena Mariano | www.thedataschool.co.uk

Our second day of Dashboard week involved PowerBI, data prep in PowerQuery, and data about wages around the world.

data-engineering,itot,industrial-data,it-ot-convergence

Dashboard Week Day 2

Nov 28, 2023 Abby Poon | www.thedataschool.co.uk

This morning we received a task from Jenny and have been told to work on OECD data.

data-engineering,itot,industrial-data,it-ot-convergence

Bridging the Divide The Evolution of ITOT Integration in the Data Space

Nov 28, 2023 Peter Gy. Molnar | medium.com

By the time I became the chief data officer of an oil and gas company, I had already spent decades on the IT side in the FMCG and heavy industry sectors. For all my experience, I was still trading foreign ground in a very different and complex ind...

data-engineering,itot,industrial-data,it-ot-convergence

How to Use a Border to Highlight Selections in Tableau

Nov 28, 2023 Dan Bunker | playfairdata.com

This tutorial explores a way to elevate the user experience of your visualizations by adding borders to highlight selections for…The post How to Use a Border to Highlight Selections in Tableau appeared first on Playfair Data.

Advanced,Engineering,Storytelling,TableauDesktop

Microchip Your Data Snowflake Column Lineage

Nov 28, 2023 Taylor Miles | interworks.com

Earlier this year, Snowflake released Column Lineage functionality into general availability to much applause from data governance champions. Now hang on – I know data governance doesn’t have the most gravity as a reading topic, but I promise this...

Data,ColumnLineage,DataGovernance,schema,Snowflake

Tools that will make your life much easier

Nov 27, 2023 Volha Fiadotava | www.thedataschool.co.uk

Microsoft PowerToys

TableauConsulting,TableauOfficeHours

Dashboard week Day 1

Nov 27, 2023 Myles Stevenson | www.thedataschool.co.uk

This week is dashboard week and todays task was to create a dashboard that analysis the data from the government website on prices of items.

TableauConsulting,TableauOfficeHours

Dashboard Week - Monday

Nov 27, 2023 Alexander Wood | www.thedataschool.co.uk

Today is the 1st day of dashboard week. Today we were tasked to analyse inflation data from the ONS. In the brief that Jenny gave us, she specified that we could bring in additional data sources to further our analysis.

TableauConsulting,TableauOfficeHours

Dashboard Week Day 2 Day of Cheese

Nov 27, 2023 Adam Sultanov | www.thedataschool.co.uk

For our second day of dashboard week we have been given – a single URL! Cheese.com. And a complimentary video to accompany it (helpful). This gave us way more freedom than day 1, but also meant a lot more work in terms of scraping the web to secur...

TableauConsulting,TableauOfficeHours

Dashboard Week Day 2 Cheese.com

Nov 27, 2023 Jun Hou Kok | www.thedataschool.co.uk

First thing 9AM on a Monday, this time we are tasked to build a dashboard using information on Cheese.com. Since there wasn’t any dataset provided on the website, I decided to use Alteryx to scrape the website. My idea for the dashboard was origin...

TableauConsulting,TableauOfficeHours

Dashboard Week Day 2 Cheese Cheese Cheese

Nov 27, 2023 Charles Yi | www.thedataschool.co.uk

The second day of dashboard required us to web-scrape data from cheese.com and to build a dashboard with the data.

TableauConsulting,TableauOfficeHours

Dashboard Week Day 2

Nov 27, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

Today we were asked to perform webscraping from a cheese website (www.cheese.com). Since I was out sick for the webscraping unit, I borrowed a “pre-scraped” data set from someone in my cohort. I was determined to be more creative than my first das...

TableauConsulting,TableauOfficeHours

Dashboard Week Day 1 TV price

Nov 27, 2023 Jules Claeys | www.thedataschool.co.uk

Today our task was to use data from the ONS (https://www.ons.gov.uk/economy/inflationandpriceindices/articles/shoppingpricescomparisontool/2023-05-03?ref=thedataschool.co.uk). To analyse the change of price of shopping articles since 2018.

TableauConsulting,TableauOfficeHours

Dashboard Week Day 1 - Shopping Basket Prices

Nov 27, 2023 Jenny Martin | www.thedataschool.co.uk

DS41 have made it through 16 weeks of training and it’s time for their final week, which can only mean one thing: Dashboard Week! It’s a right of passage and a chance to put all they’ve learned into practice. The best advice we can give as coaches...

TableauConsulting,TableauOfficeHours

Dashboard Week Day 1 - Hitting the shops

Nov 27, 2023 Numa Begum | www.thedataschool.co.uk

16 weeks of training and here we are!

TableauConsulting,TableauOfficeHours

Dashboard Week Day 1 - Cheese.com

Nov 27, 2023 Erin Potter | www.thedataschool.co.uk

Welcome to the first blog of the series for Dashboard Week. This week we are tasked each day to produce a dashboard and blog as well as other deliverables such as a documented data prep workflow and wireframes. Today’s task was vague as we were gi...

TableauConsulting,TableauOfficeHours

Dashboard Week Day 1 Can ONS Data Help Your Grocery Budget

Nov 27, 2023 Maddalena Mariano | www.thedataschool.co.uk

For the 1st day of Dashboard Week, we are using a dataset with the average price per product type, the monthly and annual increases, and chained indices.

TableauConsulting,TableauOfficeHours

Dashboard Week Day 1 Biscuits Biscuits Biscuits

Nov 27, 2023 Patrick Maguire | www.thedataschool.co.uk

HERE WE GO!

TableauConsulting,TableauOfficeHours

Dashboard Week Day 1

Nov 27, 2023 Abby Poon | www.thedataschool.co.uk

Today we are required to visualise the data from this Shopping prices comparison tool.

TableauConsulting,TableauOfficeHours

How to Connect to Data in Power BI Desktop

Nov 27, 2023 Juan Carlos Guzman | playfairdata.com

Microsoft’s Power BI is one of the top data visualization platforms on the market. The Power BI platform has products…The post How to Connect to Data in Power BI Desktop appeared first on Playfair Data.

DataPrep,Fundamentals,PowerBI,TechnicalFeatures

Get Expert Tableau Help Now Tableau Office Hours

Nov 27, 2023 Eric Parker | onenumber.biz

Do you need immediate Tableau help?

TableauConsulting,TableauOfficeHours

Customize Sorting by Fields in Tableau

Nov 26, 2023 Le Luu | www.thedataschool.co.uk

In Tableau, sorting and filtering are two of the most common features that data analysts usually apply when working with data. In some cases, I would let the user sort by themselves. Therefore, custom sorting in Tableau would be helpful. In this b...

Strolling with SQL Solving Preppin Data Challenges part 6

Nov 25, 2023 Lyon Abido | www.thedataschool.co.uk

In this blog, I’ll be working through the Preppin’ Data challenge called “Is it the teacher or the student? Part 1”. Try it out here! I’ll be using the incredible SQL to solve this challenge!

Strolling with SQL Solving Preppin Data Challenges part 3

Nov 24, 2023 Lyon Abido | www.thedataschool.co.uk

In this blog, I’ll be working through the Preppin’ Data challenge called “Targets for DSB”. Check it out here! Like my other recent articles, I will be using SQL for this challenge.

Rank Charts- A way to visually rank over a range of time.

Nov 24, 2023 Jun Hou Kok | www.thedataschool.co.uk

When working with data, a lot of the time we would want to find the top performers or the worst performers in a given category. Rank charts can provide valuable insights by allowing you to quickly and easily compare data points. For instance, you ...

Dashboard Day

Nov 24, 2023 Ali Fawwaz | www.thedataschool.co.uk

I was given the task in the morning and it was to use the Federal Infrastructure Projects dataset to create a dashboard and present it in the afternoon.

Strolling with SQL Solving Preppin Data Challenges part 5

Nov 23, 2023 Lyon Abido | www.thedataschool.co.uk

In this blog, I’ll be working through the Preppin’ Data challenge called Student Attendance vs Test Scores. You can find it here. This was a pleasantly straightforward challenge where, among other functions, I got to use the ROUND function. Give t...

WOW2023,WorkoutWednesday,DashboardActions,DrillDown,filteractions,Interactivity,KPIs,ParameterActions,Rank,TableCalcs

Strolling with SQL Solving Preppin Data Challenges part 4

Nov 23, 2023 Lyon Abido | www.thedataschool.co.uk

In this blog, I’ll be working through the Preppin’ Data challenge called New Customers. You can find it here. So far, this challenge has been the most fun! This challenge involves a lot of string manipulation, stacking several tables on top of eac...

WOW2023,WorkoutWednesday,DashboardActions,DrillDown,filteractions,Interactivity,KPIs,ParameterActions,Rank,TableCalcs

Making the most out of the Data school

Nov 23, 2023 Jules Claeys | www.thedataschool.co.uk

As the end of training approaches, it is time for me to reflect on what I think is a good way to make the most of your training at the Data School. My advices here are based on my experience, the order in which I will put my tips is purely based o...

WOW2023,WorkoutWednesday,DashboardActions,DrillDown,filteractions,Interactivity,KPIs,ParameterActions,Rank,TableCalcs

Can you create a Monthly Driver Analysis dashboard

Nov 23, 2023 Donna Coles | donnacoles.home.blog

Global Recognition month continued this week for #WOW2023, and I was able to enlist Norbert Borbas to set the challenge this week, which was published in both Norbert’s native Hungarian, as well as English. Norbert provided a challenge based on a ...

WOW2023,WorkoutWednesday,DashboardActions,DrillDown,filteractions,Interactivity,KPIs,ParameterActions,Rank,TableCalcs

Tips for the alteryx advanced certification

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

Having just passed the alteryx advance exam, here are some tips!

Culture,Cooking,data,Recipes

Small multiples

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

Small multiples are directly set up in Power BI, however, if you want to use them in tableau here’s how to do so (warning it’s a bit tricky). Took me a while to understand it but this is the way that got me to finally understand!

Culture,Cooking,data,Recipes

Lessons Learned from being a Project Manager for 4 days

Nov 22, 2023 Lisa Hitch | www.thedataschool.co.uk

My Data School cohort (DSNY5) is coming to the end of our training. And with that we also finished our last client project which was with a wealth investment firm. Since it ran into Thanksgiving week, our coaches decided a special case for us: Ins...

Culture,Cooking,data,Recipes

Dashboard Week Day 1 Young People Survey

Nov 22, 2023 Jun Hou Kok | www.thedataschool.co.uk

For day 1 of dashboard week, DSNY5 was given survey data on Slovakain youths. The dataset contains information from the survey (mostly in a Likert scale of 1-5) concerning the preferences, interests, habits, opinions, and fears of young people.

Culture,Cooking,data,Recipes

Dashboard Week Day 1 Slovakian Survey

Nov 22, 2023 Adam Sultanov | www.thedataschool.co.uk

Welcome to Dashboard Week!

Culture,Cooking,data,Recipes

Dashboard Week Day 1

Nov 22, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

For the start of our dashboard week, my cohort was provided with survey data of Slovakian children and adults ranging from 15-30 years of age. The data included demographic information, as well as, self-ratings regarding personality, interests, ho...

Culture,Cooking,data,Recipes

Dashboard Week 1 Youth Survey

Nov 22, 2023 Lisa Hitch | www.thedataschool.co.uk

At the end of our 4-month intensive training to become Data Consultants we practice our learned skills through the so-called “Dashboard Week”. It is quite a fun invention! At 9am we receive a dataset and have until 3.30pm to clean the data, sketch...

Culture,Cooking,data,Recipes

DSNY5 - First Dashboard Week

Nov 22, 2023 Le Luu | www.thedataschool.co.uk

Time flies so fast. I still remember the first day I came to The Data School with a little knowledge in preparing data and building visualization. But now, looking back on the progress, I have learned and improved my skills thanks to all the coach...

Culture,Cooking,data,Recipes

Common Regex Expressions Cheat Sheet

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

In Alteryx, we can use the regex tool to Parse, Match, Tokenize or Replace data.

Culture,Cooking,data,Recipes

Red Pepper Vodka

Nov 22, 2023 Sean Spencer | interworks.com

Once upon a time, in the magical land of Oklahoma, where wizards brewed potions in cauldrons, dragons were known for their culinary expertise and elves mastered the art of intricate desserts, there lived the noble family of Spencer. The Spencer’s ...

Culture,Cooking,data,Recipes