Dashboard Week Day 4 - American Candy Surveys

Jan 26, 2023 Shahbaz Khan | www.thedataschool.co.uk

So for day 4 of dashboard week we were tasked with building a dashboard with data taken from surveys done by the science quarterly review on American candy. Simple right? Wrong we were stipulated with only being able to do our data prep and dashbo...

Dashboard Week Day 4 - American Candy Survey Data 🍭

Jan 26, 2023 Bianca Ng | www.thedataschool.co.uk

Today’s dashboard is using American Candy Survey data (2014 - 2017) conducted by Science Creative Quarterly (SCQ), which immediately indicated to me that there was plenty of restructuring to do. We’ve spent two days of training with Sam working wi...

Dashboard Week Day 4 - American Candy Dataset

Jan 26, 2023 Stephen Moyse | www.thedataschool.co.uk

Today we were given a dataset which was looking at american candy data and their popularity over 4 years.

Dashboard Week Day 4

Jan 26, 2023 Eamonn Woodham | www.thedataschool.co.uk

Today was another odd task, for one the data was from surveys held by a candy company, and also because our data prep was limited to using Tableau Public in browser and we could only create the dashboard using Tableau in Browser. The data itself w...

Dashboard Week - Day 3 - Rick and Morty API

Jan 26, 2023 Lyon Abido | www.thedataschool.co.uk

For the third day of dashboard week we were tasked with creating a dashboard from data that was gathered from an API. This was a wonderful opportunity to revisit and further practice connecting to an API and pulling data from it. What made this pr...

Dashboard Week - Day 3

Jan 26, 2023 Juliet Craig | www.thedataschool.co.uk

Working with APIs!

DSNY2 - Dashboard Week DAY 4: Halloween Candy

Jan 26, 2023 Mohammed Uddin | www.thedataschool.co.uk

This challenge was also tough with a capital T. Today’s challenge was to create a Tableau Prep workflow and workbook on a browser. We were to work on candy datasets from 2014 - 2017. First, the dataset from 2017 had an issue with the grouping of a...

Apply All Filters Button

Jan 26, 2023 Juhie Radia | www.thedataschool.co.uk

This blog is a step-by-step guide for creating an “Apply All Filters” and “Reset” filters button.

Can you visualise survey data?

Jan 26, 2023 Donna Coles | donnacoles.home.blog

It was Sean’s first challenge of 2023, and he asked us to recreate this chart . Sean referred to it in the requirements as a floating bar chart, others may refer to it as a diverging bar chart or likert chart. Modelling the data Fake survey data w...

Rick and Morty API (and DASHBOARD!!!!)

Jan 25, 2023 Kinley Ly | www.thedataschool.co.uk

For day 3 of dashboard week we talk APIs!!!

TableauDates,TableauCalculations

How to add custom colour palettes to Tableau

Jan 25, 2023 Edward Gay | www.thedataschool.co.uk

Tableau Desktop comes with many different colour palettes to choose from, but what if you could make your own? Here’s a quick guide on how to do just that.

TableauDates,TableauCalculations

Effective Data Communication

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

For the second day of dashboard week, we took a step back and reflected holistically on our craft. Specifically, we explored what factors and considerations go into effective data communication. This subject is well within the scope of previous ar...

Data,Azure,Snowflake,Snowpipe

Dynamic Zone Visibility in Tableau (The Slightly More Complicated Way) -...

Jan 25, 2023 Kate Joyce | www.thedataschool.co.uk

In this blog, I will go through an example of a more complicated way to use Dynamic Zone Visibility.

TableauDates,TableauCalculations

Dynamic Labeling in Tableau: How to make Adding and Removing Labels User...

Jan 25, 2023 Kaitlin MacDonnell | www.thedataschool.co.uk

Adding the ability to add and remove labels in Tableau can greatly enhance the functionality and flexibility of your data visualizations. One way to accomplish this is by using a parameter to control the visibility of labels. In this blog post, I ...

TableauDates,TableauCalculations

Dashboard Week - Rick and Morty

Jan 25, 2023 Annie Casey | www.thedataschool.co.uk

On day 3 of dashboard week we were given the task to connect to the Rick and Morty API: https://rickandmortyapi.com/documentation/#introduction

TableauDates,TableauCalculations

Dashboard Week Day 3: Rick and Morty API

Jan 25, 2023 Keren Aharon | www.thedataschool.co.uk

For todays challenge we were meant to use Alteryx and APIs to get data from the Rick and morty API website.

TableauDates,TableauCalculations

Dashboard Week Day 3 - Rick & Morty

Jan 25, 2023 Andy Kriebel | www.thedataschool.co.uk

As a data analyst, it’s important to be able to get data from APIs and know how to get it into the right shape to begin the data investigation. With this project, the team will work with the Rick & Morty API to get more practice.

TableauDates,TableauCalculations

Dashboard Week Day 3: API's

Jan 25, 2023 Edward Gay | www.thedataschool.co.uk

It’s day 3 of dashboard week and today we were tasked with extracting data from the Rick and Morty API.

TableauDates,TableauCalculations

Dashboard Week: Day 3 API

Jan 25, 2023 Tara Robinson | www.thedataschool.co.uk

Todays dashboard challenge comes from Coach Robbin. He’s a huge Rick and Morty fan and we needed more practice with APIs, so we are using the Rick and Morty API.

TableauDates,TableauCalculations

Dashboard Week : Day 2 - Rick & Morty

Jan 25, 2023 Eamonn Woodham | www.thedataschool.co.uk

Intro

TableauDates,TableauCalculations

Dashboard Week 3 - Rick and Morty API

Jan 25, 2023 Flavio Matos | www.thedataschool.co.uk

Today’s challenge comes from our Coach Robbin. He’s a huge Rick and Morty fan.

TableauDates,TableauCalculations

DSNY2 - Dashboard Week Project 3: “Rick and Morty” API

Jan 25, 2023 Mohammed Uddin | www.thedataschool.co.uk

This challenge was tough with a capital T. To be completely honest, all of my time was spent figuring out the alteryx workflow. To not get too technical, my issue arises when trying to combine values from one column; into another.

TableauDates,TableauCalculations

How Calculate (and Filter) to the Max Day in a Data Set in Tableau

Jan 25, 2023 Eric Parker | onenumber.biz

Let’s say you want to filter a Tableau worksheet to only contain data from the latest date in the data set. That’s pretty simple if the latest date is consistently today or yesterday. You can just use a relative date filter! But what if the most r...

TableauDates,TableauCalculations

How to Select a Date Range with a Set Action

Jan 24, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this tip, I going to show you how to use set actions to select a date range in a line chart and summarize the values in the selected area.In just a few steps, I’ll show you how to:1. Create the custom date and set2. Use the set to create a refe...

calculation,color,customdates,daterange,dates,first,howto,last,levelofdetail,LOD,maxdate,mindate,referenceband,select,setaction,summarize,tableau,tip

A Problem with Tableau’s Ask Data and How Tableau Should Fix it

Jan 24, 2023 Craig Bloodworth | www.theinformationlab.co.uk

Ask Data is one of those features Tableau put a lot of work into both to make it useful to end users but also to fend off competition from alternative BI tools. A few years ago there was a rush in the market with vendors needing to say “we enable…...

Blog

WOW2022 | Week 50 | Annie Casey

Jan 24, 2023 Annie Casey | www.thedataschool.co.uk

Interactive Proportional Brushing

Data,Azure,Snowflake,Snowpipe

RegEx - An Introduction and Cheat Sheet

Jan 24, 2023 Sherina Mahtani | www.thedataschool.co.uk

What is Regex?

Data,Azure,Snowflake,Snowpipe

Power BI Uploading to Data Stories Gallery

Jan 24, 2023 Tara Robinson | www.thedataschool.co.uk

Today for dashboard week we were challenges to create a dashboard in Power BI and then publish it to the Power BI gallery, make it public, then post on the Power BI Data Stories Gallery. For me this was one of the hardest challenges and this a wa...

Data,Azure,Snowflake,Snowpipe

Making Accessible Dashboards

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

For the start of the notorious Dashboard Week, we were tasked with creating an accessibility-focused dashboard. Half of the day was spent talking about what accessibility means in the context of design and how tools like screen readers interact wi...

Español,#Gauge,#MultipleLayers,#NPS,#TransparentColor

Effective Data Communication and Chart comparisons

Jan 24, 2023 Kinley Ly | www.thedataschool.co.uk

For this day of Dashboard week, we decided to have more of a refresher/new lesson on how to best communicate with data. We talked about different topics throughout the lesson. Such topics like:

Data,Azure,Snowflake,Snowpipe

Effective Data Communication Class (Jan 24, 2023)

Jan 24, 2023 Erlina Cahyadi | www.thedataschool.co.uk

Taught by Ann Jackson and co-facilitated by Michael McFadden

Data,Azure,Snowflake,Snowpipe

Effective Data Communication: Chart Choices

Jan 24, 2023 Erlina Cahyadi | www.thedataschool.co.uk

Today we learned about effective data communication to help prepare us for our future placements and client work. Most of the lesson was like a summary that tied together everything we learned within these past four months. We learned about:

Data,Azure,Snowflake,Snowpipe

Dashboard Week - Effective Data Communication

Jan 24, 2023 Annie Casey | www.thedataschool.co.uk

Explore vs Explain

Data,Azure,Snowflake,Snowpipe

Dashboard Week Day 2: Power BI

Jan 24, 2023 Keren Aharon | www.thedataschool.co.uk

For today’s task, we were each given a dataset and were instructed to create a KPI dashboard using Power BI. After having only a few hours of experience with this software this was a big challenge and would require some time to become familiar wit...

Data,Azure,Snowflake,Snowpipe

Dashboard Week Day 2 - Communicating with Your Audience

Jan 24, 2023 Bianca Ng | www.thedataschool.co.uk

DSNY2 was spared a day of Dashboard Week (though not the accompanying blog post…) and discussed effective data communication with coaches Ann and Michael.

Data,Azure,Snowflake,Snowpipe

Dashboard Week Day 2: Charty Party

Jan 24, 2023 Elaine Yuan | www.thedataschool.co.uk

Day 2 of Dashboard Week was focused on effective data visualization and information design. I’m certain many of my colleagues will share what they learned today, which includes definin

Data,Azure,Snowflake,Snowpipe

Dashboard Week - Day 2

Jan 24, 2023 Diaraye Barry | www.thedataschool.co.uk

Today is day 2 of dashboard week. The day started of interesting, no one in my cohort knew where to find the brief. Unlike before (first month of training) we would find our brief in Convo, this time it was a blog. After we found the blog, we had ...

Data,Azure,Snowflake,Snowpipe

Dashboard Week - Accessibility

Jan 24, 2023 Annie Casey | www.thedataschool.co.uk

On day 1 of dashboard week we covered what it means to build dashboards with accessibility in mind. Some key points that were new to me were:

Data,Azure,Snowflake,Snowpipe

Dashboard Week 2 - SEO Analytics

Jan 24, 2023 Eamonn Woodham | www.thedataschool.co.uk

Intro

Data,Azure,Snowflake,Snowpipe

Dashboard Week 2 – Information Design

Jan 24, 2023 Juliet Craig | www.thedataschool.co.uk

A picture is worth 1,000 data points.

Data,Azure,Snowflake,Snowpipe

Dashboard Week 1 - Power BI

Jan 24, 2023 Flavio Matos | www.thedataschool.co.uk

Today we were asked to do a dashboard - Nothing weird as this part of our job, right?! However the challenge is: We should use Power BI for this task! 😨

Data,Azure,Snowflake,Snowpipe

Dashboard Day 2 - Power BI Task

Jan 24, 2023 Stephen Moyse | www.thedataschool.co.uk

Today I was tasked to use power BI in order to create a dashboard which looked at mock data for a IT help desk. It proved to be an interesting challenge and it was really the first time that I had a chance to test out Power BI.

Data,Azure,Snowflake,Snowpipe

DSNY2 - Dashboard Week Project 2: Effective Data Communication - Initial...

Jan 24, 2023 Mohammed Uddin | www.thedataschool.co.uk

“Effective data communication”. Seems pretty daunting doesn’t it? Although it is a critical part of the consulting process; its purpose is understanding data. So in order to do this, it’s best to understand the general flow of a task.

Data,Azure,Snowflake,Snowpipe

Dashboarding is Like Music: Communication

Jan 24, 2023 Troy Schuh | interworks.com

Welcome to our new series, Dashboarding is Like, where we will explore connections between data visualization and other creative pursuits! For our first set of posts, Dashboarding is Like Music, we will delve into the sometimes surprisingly rich r...

Data,data,dataviz,music

Automated Ingestion from Azure Storage into Snowflake via Snowpipe

Jan 24, 2023 Chris Hastie | interworks.com

If you wish to automatically stream/ingest data from an Azure Storage container into Snowflake, using native functionality, you will most likely be considering what is commonly referred to as a Snowpipe. In real terms, a Snowpipe for Azure is actu...

Data,Azure,Snowflake,Snowpipe