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.

Dashboard Week - Day 5 -

Jul 26, 2024 Aileen Pfleiderer | www.thedataschool.co.uk

Dashboard Week Highlights: From Movie Magic to Personal CV and Graduation from Training Phase

Dashboard Week Day 4

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

Cheers to the last day of dashboard week and the last day of training! Today we were given a familiar dataset. Val our coach gave us the dataset we worked with 12 weeks ago on a project, but this time we were creating a dashboard for the mobile pl...

Calculations in SQL and Tableau - Part 2

Jul 26, 2024 Le Luu | www.thedataschool.co.uk

In the first part of the calculation in SQL and Tableau, I compared the calculations how to get the percent of total, the difference from the previous and next row. You can take a look at the first part here. Continue to that first part, in this b...

Why Are My Power BI Locations Mapping My Data Incorrectly

Jul 26, 2024 Wesley Cannatti | interworks.com

It can be a very confusing or frustrating experience whenever a technical tool doesn’t do what you want it to do, or even what it should be doing using common sense! I recently had some issues with the mapping visualization feature in Power BI and...

Data,PowerBI

Wie man Dynamische Suffixe in Tableau erstellt

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

Wenn ich Dashboards erstelle, arbeite ich sehr gerne mit Parametern und benutze diese um zwischen den wichtigen Kpi’s einfach wechseln zu können. Für mich Persönlich eine meiner Lieblingsfunktionen in Tableau.

What Does A Data Analyst Listen To Day Four Of Dashboard Week

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

Our fourth task in the dashboard week was to visualise the history of songs played by a Spotify user. We got a .json file that could be read directly through Tableau, which eliminated the need for data preparation. However, the instructions of the...

This is Not a Test but it should be

Jul 25, 2024 TK Zellers | www.thedataschool.co.uk

Dashboard Week Day 3 was my favorite so far - in part due to the requirement that we use Cheese.com as our data source, and in larger part because it required more time in Alteryx doing some web-scraping (which I always enjoy).  

My First Data School Projectno stress

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

My cohort and I were introduced to the project early on in the first week. With little idea of what to expect, I found myself imagining various scenarios regarding the project’s nature, its level of difficulty, and the time required. Worrying abou...

Dashboard Week - Day Three

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

The third day of Dashboard week is Fromage Day! We were asked to go to cheese.com and build a search tool in Tableau. This required web scraping and a bit of creativity.

Dashboard Week - Day 4 -

Jul 25, 2024 Aileen Pfleiderer | www.thedataschool.co.uk

What Spotify Green Has to Do with The Matrix Theme

Dashboard Week Day 3 - Super Cheesy Dashboard

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

It’s day three 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 and presenting a ...

Dashboard Week Day 3

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

Today we were giving the assignment to go to cheese.com and webscrape the data. Furthermore, we were to find category that we wanted to take the cheese data from. Just like the prior 2 days we were given one day to complete the project, create a s...

Dashboard Week 4 - Discovering PGBs Musical Taste

Jul 25, 2024 Leonardo Ceballos | www.thedataschool.co.uk

Hey P.! Ever wondered what your Spotify listening habits say about you? Well, you are about to uncover some fascinating insights with the dashboard I built 😉

Colorful or Black and White

Jul 25, 2024 Sayd Abdul Tawab Hussainy | www.thedataschool.co.uk

One of the main considerations when building a dashboard is selecting colors that match the topic, provide clear insights, and are relevant to the context. Color choices can significantly impact the readability and effectiveness of a dashboard. Fo...

An answer in search of a question

Jul 25, 2024 TK Zellers | www.thedataschool.co.uk

Dashboard Week - Day 2

Connected Scatterplots

Jul 25, 2024 Donna Coles | donnacoles.home.blog

Sean set this challenge this week, to build a connected scatterplot to allow additional insights to be gained. We need to show a circle per country related to the specified year, and then show the data for all years if a country is specified from ...

WorkoutWednesday,WOW2024,ConnectedScatterPlot,DualAxis,HighlightAction,LineChart,parameter,Path,ScatterPlot,Week30

What Do Outliers Even MEAN

Jul 24, 2024 Vivian Ng | www.thedataschool.co.uk

(cross-posted here)

TableauDates

What Are Stacked Bar Charts

Jul 24, 2024 Jessica Kwan | www.thedataschool.co.uk

A stacked bar chart, as compared to a traditional bar chart, shows two categorical variables. One variable is shown along the entire length of the bar while the other variable is represented by the stacks within each categorical bar. For example, ...

TableauDates

Standard Farben Nicht schon wieder...

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

Heute will ich Abhilfe schaffen, sollte man wie ich, der Standart Farben in Tableau überdrüssig sein.

TableauDates

Showing Your CV Using Tableau Day Three Of Dashboard Week

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

The third task of this week was to develop a professional CV in Tableau. The idea was that we used different kinds of visualisations to summarise our experience, education and skills. There is actually a vast amount of examples of CVs in Tableau P...

TableauDates