Introduction to Tableau Dashboards at Learn What The Data School Learns

Aug 9, 2024 Becky Wright | www.thedataschool.co.uk

On Thursday we had a full day of learning with members of the public in Learn What The Data School Learns. Each of our cohort had a 90 minute session on an aspect of Tableau.

Data

Dashboard Templates for Teams

Aug 9, 2024 Kate Crawford | www.thedataschool.co.uk

Client projects are a core part of the Data School Training program. They happen eight times during the 17-week course.

Data

DS46 Week 1 Project Reflective Log

Aug 9, 2024 Georgia Webb | www.thedataschool.co.uk

Today I completed my first Friday project. I was given 4 data files, 3 of which contained data about hotel reservations, and 1 which contained data about the transactions of hotel guests. 

InterWorks Blog Roundup July 2024

Aug 9, 2024 Mark Cordeiro | interworks.com

Howdy, blog readers! We’ve got some exciting stuff for you this month. We were an absolute machine with the production this past month, with 20+ blogs handwritten just for you. But before we get into the meat and potatoes this month, let me share ...

Data

Can you compare an Olympic medallists age to a users age

Aug 9, 2024 Donna Coles | donnacoles.home.blog

As the Paris 2024 Olympic Games continues, then #WOW continues with another Olympic themed challenge, this time set by Kyle. Defining the core calculations There’s a lot of LoD calcs used in this, so let’s set this up to start with. Avg Age Per Sp...

WorkoutWednesday,WOW2024,BarChart,FIXED,INDEX,LoD,parameter,TableCalcs,Week32

Dealing with Non-standard Coordinate Systems in Tableau

Aug 8, 2024 Matthias Albert | www.thedataschool.co.uk

The Problem

At the Touch of a Button

Aug 8, 2024 Vivian Ng | www.thedataschool.co.uk

Creating buttons in Tableau is a fasten-ating process! Let’s learn how!

Growing a Digital Garden

Aug 7, 2024 Kate Crawford | www.thedataschool.co.uk

TLDR; Capture ideas and archive projects in a way that allows you to edit them later or share with others. This is a multi-part series where I share how to use different software for data management and productivity.

Creating a Date Table in Power BI

Aug 7, 2024 Jyoti Gupta | www.thedataschool.co.uk

In Power BI, efficient data modeling is crucial to creating effective reports and dashboards. A core component of this process involves leveraging calculated tables. Unlike tables imported from data sources, calculated tables are defined by DAX ex...

Dynamic Zone Visibility with Tableau Dashboard Actions

Aug 7, 2024 Ollie Linley | onenumber.biz

Do you want to show and hide sheets on your dashboard with only a click? Dynamic Zone Visibility lets you do exactly that. This is far more dynamic than filter actions, as we can show or hide any number of sheets and their elements from a single i...

DynamicZoneVisibility,TableauDashboards

Conditional Calculations in Tableau and Power BI

Aug 7, 2024 Paul Vincent | interworks.com

In the video below, I go over Conditional Calculations using two of the most widely-used data visualisation tools on the market: Tableau by Salesforce and Power BI by Microsoft. Tune in here:The post Conditional Calculations in Tableau and Power B...

Data,ConditionalCalculations,PowerBI,Tableau

Re-thinking a Viz

Aug 6, 2024 Joe O'Connor | www.thedataschool.co.uk

Taking a viz and re-imagining it for a different user.

My First Blog - Understanding and Translating Client Needs

Aug 6, 2024 Thomas Duong | www.thedataschool.co.uk

On Day 2, we talked about how important it is to really understand and translate what clients want. Often, we don’t ask the right questions or assume clients know something they might not. It’s crucial to not only understand what the client is ask...

DS46 User Stories and Sketches

Aug 6, 2024 Kealan Daly | www.thedataschool.co.uk

It is with excitement and some apprehension that I submit my first blog post as I begin on my journey as part of the 46th cohort of the Data School. Today we discussed the role of a data consultant and explored some of the duties and responsibilit...

DS46 Reimagining a Sports Viz

Aug 6, 2024 Eden Thiede-Palmer | www.thedataschool.co.uk

Today in DS46 we were tasked with reimagining and resketching a sports viz while learning the core concepts of answering questions with data. One of my biggest takeaways was that it is important to understand WHY we are making a viz.

Data

DS 46 Data School Day 2

Aug 6, 2024 Georgia Webb | www.thedataschool.co.uk

Hello! Yesterday, I began my journey in the data school as a part of DS 46.

Context is Key

Aug 6, 2024 Rory Moxom | www.thedataschool.co.uk

In our first task at The Data School, we were tasked with taking some visualisations that had already been made and sketching out how we would change them to answer different questions.

Recap of Current Snowflake Tools

Aug 6, 2024 Steve Taylor | interworks.com

As Snowflake becomes more and more feature rich, we’ve become surrounded by all manner of suffixes to the word “Snow.” In this post, I’ll summarise the tools available and what their intended use is. This is only meant to be a brief overview, so I...

Data,Snowflake

Scaffolding

Aug 5, 2024 Alfie King | www.thedataschool.co.uk

Today we were set a challenge to create a 6-month moving average of sales by state in the Sample-Superstore.xlsx dataset in Tableau Prep. 

Detailed vs Summary Tables Why Not Both

Aug 5, 2024 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Imagine a scenario where your datasource has hundreds of millions or even billions of rows. If you try to usethis data in Tableau, it’s likely that you’ll run into some problems. One ofthe first problems you’re likely to encounter is that your da...

How-To,Tableau

What is date modelling and how to utilise this within Power BI

Aug 2, 2024 Ben Winsey | www.thedataschool.co.uk

What are date models?

Data,dashboards

Using Lookup Tables in the Data Model - PBI

Aug 2, 2024 Bridget Ama Boateng | www.thedataschool.co.uk

In today’s data-driven world, efficient data modelling is critical to making informed decisions. Lookup tables play a vital role in achieving this by providing a streamlined way to manage and analyse data. They not only help in organising informat...

Data,dashboards

Time Comparison Functions in Power Bi

Aug 2, 2024 Jessica Robbin | www.thedataschool.co.uk

Power Bi offers a range to time intelligence functions to manipulate and analyze date and time data effectively. Among these functions, SAMEPERIODLASTYEAR(), PARALLELPERIOD(), and 2024-08-02ADD() are commonly used to compare data over different ti...

Data,dashboards

Syncing filters when using unrelated datatables

Aug 2, 2024 Curtis Paterson | www.thedataschool.co.uk

In Power BI it’s simple enough to connect to two different datatables and not have a relationship between them. You can then head into report view and create some charts using datatable A, and some other charts using datatable B. But in a report l...

Data,dashboards

Show only relevant values in Power BI

Aug 2, 2024 Tom Gould | www.thedataschool.co.uk

When building reports on Power BI we usually want to add slicers that allow the user to filter charts and unlock new insights or visualise emerging patterns or trends. However, when a report is built upon the popular star schema data model it is p...

Data,dashboards

Power BI Field Parameters - Easy Switching

Aug 2, 2024 Tom Stinson | www.thedataschool.co.uk

Field Parameters are a useful feature of Power BI if you want to have features on your dashboard that can quickly change between different fields. The most obvious way to see this is to have a measure switcher on the axes of a chart, but there are...

Data,dashboards

Optimizing Performance in Power BI with DAX

Aug 2, 2024 Peter Hajnal | www.thedataschool.co.uk

In Power BI Desktop, you can find out how each of your report elements, such as visuals and DAX formulas, are performing. By using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when us...

Data,dashboards

Nested Sorting in Power BI

Aug 2, 2024 Beau Foletti | www.thedataschool.co.uk

Nested sorting refers to sorting a dataset or chart by multiple columns or fields. This varies from regular sorting, which sorts by one field.

Data,dashboards

Improving performance of DAX calculations in Power BI

Aug 2, 2024 Dorinna Pentchev | www.thedataschool.co.uk

Say you’ve been handed a Power BI workbook which uses a large dataset and runs rather slowly. If your stakeholders don’t want to lose any functionality with the visualisations, you could look to improve performance by optimising the DAX calculations.

Data,dashboards

Beginners guide to DAX in Power BI Creating a Date Table

Aug 2, 2024 Juan Carlos Guzman | playfairdata.com

In the same way that you can’t bake a cake without flour, you can’t use Power BI Desktop without Data…The post Beginner’s guide to DAX in Power BI: Creating a Date Table appeared first on Playfair Data.

Engineering,Fundamentals,PowerBI,TechnicalFeatures

Intern Dashboards The Rise and Fall of Indias EdTech Market

Aug 2, 2024 Kartikaya Srivastava | interworks.com

The decline of a large enterprise is often the result of numerous small issues compounding over time. However, there is a tendency to focus on less relevant aspects and overlook the single most crucial element: the customers. This case study, pres...

Data,dashboards

How do you compare against the worlds best 100m runners

Aug 2, 2024 Donna Coles | donnacoles.home.blog

As we’re in the midst of the 33rd Summer Olympics, I set an Olympic-ish themed challenge this week which was a recreation of a Viz built by my Biztory colleague, James Newton (Twitter X / Linked In). Whilst fun, I knew this was li...

WorkoutWednesday,WOW2024,Animations,BackgroundImage,DataModelling,Pages,Scaffold,Week31

To The Point How to Change Tableau Server Site in a Tableau Desktop Work...

Aug 1, 2024 Jeffrey Brian Thompson | www.thedataschool.co.uk

Sometimes you want to change Tableau Server sites in the middle of building a dashboard. The usual way to do this is to navigate to Server > Signed In to … > Sign In to Another Site…

Data Scaffolding in PowerBI

Aug 1, 2024 Zachary Ryan | www.thedataschool.co.uk

What is it?

Creating a Chart Swap Toggle in Power BI Using Bookmarks

Aug 1, 2024 Edward Hayter | www.thedataschool.co.uk

This guide will walk you through the process of creating a chart swap toggle in Power BI using bookmarks. The process is broken down into two main parts: building the bookmark infrastructure and associating the bookmarks with specific displays.

Power BI - Data Models Reports Version Control in Github and the PBI Se...

Jul 31, 2024 Carol Mhlanga | www.thedataschool.co.uk

Version Control, or Source Control, in Power BI involves managing different versions of Power BI reports, datasets, and other assets to ensure consistency, traceability, and collaborative development. Here’s an overview of how version control can ...

Data,analytics,Products,projects

Data Ethics and AI

Jul 31, 2024 Dillon Thomas | www.thedataschool.co.uk

In the data school we had an introduction and awareness into the ethics of data. Not really giving the topic much thought until today, I had quite a bit of surprising information come to my attention. Regarding data, there is much to think about w...

Data,analytics,Products,projects

Maturing Analytics Analytics as a Product

Jul 31, 2024 Ben Bausili | interworks.com

Welcome back to our journey in maturing analytics. In Part 3, we discussed why user adoption stumbles and explored different delivery paths for analytics. Now, in Part 4, we will talk about product management. I know — you’re in analytics and data...

Data,analytics,Products,projects

LWTDSL Drilldowns

Jul 30, 2024 Dillon Thomas | www.thedataschool.co.uk

For Learn What The Data School Learns (LWTDSL) we each chose a topic to teach to the participants coming to the session. My topic was drilldowns. I took copious notes of how I would like the presentation to go and here they are. This blog will als...

Data

Final Day Of Dashboard Week

Jul 30, 2024 Bruno Gasparotto Ponne | www.thedataschool.co.uk

The last day of the dashboard week, and also last day of training for DSDE 07, was dedicated to working on our personal project. This project had already been under development during the training and we were free to choose what we would like to w...

Data

Intern Dashboards Spotify Insights on World Music

Jul 30, 2024 Sripriya Vemula | interworks.com

Being an avid music lover, I always wondered about various factors that make up an entire song. This project provided me an opportunity to do so. I stumbled upon an amazing data source in Kaggle that had authentic Spotify data with a lot of key…Th...

Data,dashboards,music

Federated Governance

Jul 30, 2024 Mike Oldroyd | interworks.com

Over the last couple of years, there has been a lot of interest in the data mesh architecture first proposed back in 2018 by Zhamak Dehghani. It offers a practical alternative to the previously dominant notion of a single centralised data warehous...

Data

Dashboard Week Day Four

Jul 29, 2024 Kate Crawford | www.thedataschool.co.uk

On the fourth and final day of Dashboard week, we were given a familiar dataset but an new task – build a mobile dashboard. That’s right. We set out to build a dashboard designed for phones in a day.

Dashboard Week Day 4 - Mobile Dashboard

Jul 29, 2024 Brenda Chavez | www.thedataschool.co.uk

It’s day four and the final day of Dashboard Week at the Data School New York! In case you aren’t familiar, Dashboard Week takes place during our final week of training here at Data School. During this week Data Schoolers are tasked with creating ...

Meine Dashboard Week

Jul 26, 2024 Dominik Wieser | www.thedataschool.co.uk

So… mit Tag 5 endet die Dashboard Week für die DSDE 7. In diesem Post will ich nochmal die Woche Revue passieren lassen.