Mein Rckblick auf den ersten Monat in der Data School

Dec 8, 2023 Franziska Schwade | www.thedataschool.co.uk

Ein Monat ist tatsächlich schon vergangen, seit unsere DSDE 6 Kohorte bei der Data School gestartet ist. Es ist so viel passiert in dieser kurzen Zeit. In diesem Blog Post wollte ich eine kleine Zusammenfassung unserer ersten 5 Wochen hier in Hamb...

How to Be Prepared for Data Preparation.

Dec 8, 2023 Holly Jones | www.thedataschool.co.uk

What is the best way to plan how to prepare your data in Tableau Prep?

DSNY 5 - Dashboard Week - Day 3

Dec 8, 2023 Le Luu | www.thedataschool.co.uk

The DSNY 5 team was assigned to work with the Genius API on the third day of the dashboard week. Genius API is the page where the user can search for song lyrics. Michael McFadden listened to Christmas songs, so I would like to help him find some ...

Can you find how many quarters it took for a customer to order again

Dec 8, 2023 Donna Coles | donnacoles.home.blog

It was Lorna’s turn to set the challenge this week, and she opted for a gentle workout to soothe us into the Christmas holidays – I certainly appreciated it as I am super busy and super stressed trying to finalise Christmas presents and preparatio...

WorkoutWednesday,WOW2023,CohortAnalysis,FIXEDLODs,LevelofDetail,Week49

Who Knew Data Could Be Dirty

Dec 7, 2023 Hewan Zewdu | www.thedataschool.co.uk

Once you’ve your hands on some data, it’s not as simple as plugging in numbers for analysis! In this post we explore clean vs dirty data, and a couple of signs to watch out for because you might need to prep your data before diving into the good s...

ChartTypes,Engineering,Intermediate,PowerBI

Tableau a Rectangular Pie Chart

Dec 7, 2023 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

If we talk about a Pie Chart, we all have a same image in our head: a circular pie chart. It can be 2D, or it can also be a 3D version of Pie Chart (but please please, don’t ever try to create a 3D Pie Chart for whatever reason except for memes). ...

ChartTypes,Engineering,Intermediate,PowerBI

Tableau Data Modeling - Join

Dec 7, 2023 Nuki Susanti | www.thedataschool.co.uk

Continuing the last post on Tableau Relationship, I would like to discuss about Join here. We can achieve the same result as previously discussed in the last post using Join feature. However, we have to choose by ourselves the type of join. We use...

ChartTypes,Engineering,Intermediate,PowerBI

Prsentieren mit Zoomit

Dec 7, 2023 Finn Kappus | www.thedataschool.co.uk

Die Zeit der hölzernen Zeigestöcke liegt schon weit in der Vergangenheit. Trotzdem besteht durch die hohe Anzahl an Online-Präsentationen der Bedarf für einen virtuellen Zeigestock im heutigen Zeitalter. Hierfür hat Microsoft das sogenannte Zoomit...

TableCalculations,TableauParameters

Minimum Viable Products

Dec 7, 2023 Finn Kappus | www.thedataschool.co.uk

With my perfectionist tendencies, I often struggle to create a presentable outcome for my project within a given time frame. Yet, to keep a customer happy, it is of great importance to deliver a satisfactory outcome, even though it is not necessar...

TableCalculations,TableauParameters

Datenanalyse So schaffst du den Sprung als Quereinsteiger

Dec 7, 2023 Franziska Schwade | www.thedataschool.co.uk

Ich habe damals die Data School gefunden, als ich “Quereinsteiger Data Analytics” bei Google gesucht habe. Wenn ihr auch auf diesem Weg auf meinen Blog kommt, dann hoffe ich, dass ich euch ein paar Tipps geben und euch etwas Mut machen kann.

TableCalculations,TableauParameters

3 Ways to Make Lovely Line Graphs in Power BI

Dec 7, 2023 Matt Snively | playfairdata.com

If you read the first installation in this series on how to make Power BI bar charts more engaging, this…The post 3 Ways to Make Lovely Line Graphs in Power BI appeared first on Playfair Data.

ChartTypes,Engineering,Intermediate,PowerBI

What did it take to get into DS43

Dec 6, 2023 Lorna Brown | www.thedataschool.co.uk

DS43 started this week, let’s take a look at their initial application and final visualisations that got them into this cohort.

TableCalculations,TableauParameters

Videos for Data Best Practices and Tips Part 1

Dec 6, 2023 Aaron Potts | www.thedataschool.co.uk

Making videos for data analytics isn’t something everyone has experience. Take advantage of lessons learned by DSNY6 to level up your video storytelling skills.

TableCalculations,TableauParameters

Pivoting your data...

Dec 6, 2023 Alexandra Skelly | www.thedataschool.co.uk

Day 3 we focused on the theory of pivoting your data. Essentially there are two ways in which your data can be pivoted.

ChartTypes,Engineering,Intermediate,PowerBI

Is my data... out of date

Dec 6, 2023 Tobias Colmer | www.thedataschool.co.uk

How to identify data that has expired or is past its prime.

ChartTypes,Engineering,Intermediate,PowerBI

Importance of Distinction Between Left and Right Joins

Dec 6, 2023 Michał Mioduchowski | www.thedataschool.co.uk

Among the array of join options, the left join and right join stand out as one-sided connectors. While from a technical point of view, there is no apparent benefit of using one over the other, the selection of one may serve the purpose of shaping ...

ChartTypes,Engineering,Intermediate,PowerBI

How to clean data

Dec 6, 2023 Saampave Sanmuhanathan | www.thedataschool.co.uk

On day 3 at The Data School, we investigated cleaning data, a fundamental concept when it comes to data prep. To know what clean data is, we must first understand what it means for data to be dirty. Data is dirty is if it breaks one of Carl’s 4 ru...

ChartTypes,Engineering,Intermediate,PowerBI

Design Design Design A Dashboard Makeover Journey

Dec 6, 2023 Harvey Joyce | www.thedataschool.co.uk

With only a few small changes, you too can dramatically improve your dashboard for your user!

TableCalculations,TableauParameters

Day 3 of the Data School

Dec 6, 2023 Jessica Kirk | www.thedataschool.co.uk

Today was DS43’s third day at The Data School - the focus of today was ‘preparing data’. Throughout the day we covered cleaning, reshaping and preparing multiple data sources.

ChartTypes,Engineering,Intermediate,PowerBI

Day2 at the Data School Terminology

Dec 6, 2023 Alexandra Skelly | www.thedataschool.co.uk

My first day at the data school we began with focusing on core concepts in data. A specific take away for me was learning the terminologies:

ChartTypes,Engineering,Intermediate,PowerBI

Datenbankstruktur 4 - Vorteile Nachteile

Dec 6, 2023 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

In den vorherigen Artikeln dieser Serie wurde schon über zwei Datenbankschema diskutiert: Star-Schema und Snowflake-Schema. Visuelle Unterschiede kann man schon von den Abbildungen sehen, aber wann sollte man eine nutzen, und wann sollte man die a...

TableCalculations,TableauParameters

Build a Bee Swarm Chart

Dec 6, 2023 Zak Saucede | www.thedataschool.co.uk

A Bee Swarm Chart is a great visualisation and a nice alternative to a histogram when we want to show the distribution of data points. It can also be helpful to understand the quality of your data by seeing the variation of scores and whether the ...

TableCalculations,TableauParameters

ShowHide Columns in Tableau with a Parameter

Dec 6, 2023 Ollie Linley | onenumber.biz

Have you ever been asked to include a table of data that’s way too detailed for the dashboard you’re working on? Sometimes we really just want to see all the numbers. But we might not necessarily want to display all that information at once.

TableCalculations,TableauParameters

InterWorks Blog Roundup November 2023

Dec 6, 2023 Mark Cordeiro | interworks.com

Happy holidays, loyal readers! I thought about lacing this whole intro with subtle references to common holiday season slogans (“It’s the most wonderful time of the year, isn’t it?” for reference), but I figured that might be a bit too cliche. I’l...

Data,monthlyroundup,Snowflake,Tableau

Advice on learning technical skills

Dec 6, 2023 Elliott Stam | medium.com

Save yourself money and learn from my mistakes.Continue reading on Medium »

advice,tech,engineering,career-advice,learning

Understanding Power Query Preparing Data for Power BI Analysis

Dec 5, 2023 Mihai Mazareanu | www.thedataschool.co.uk

In this article, which is part of a Power BI Series (here you can read the previous article) we will take a look at another powerful tool from the Power BI Ecosystem, namely Power Query. We will find out what Power Query is and what makes it so us...

Data,EventRecap,Events,VizitBerlin

Tableau Data Modeling - Relationship Part 2

Dec 5, 2023 Nuki Susanti | www.thedataschool.co.uk

I actually wanted to continue the post with “Join”, however, I think there is still one aspect that needs to be mentioned about “Relationship”. Relationship is able to handle different granularity data with little bit adjustment.

Data,EventRecap,Events,VizitBerlin

How to Create a Sort Button in Power BI

Dec 5, 2023 Volha Fiadotava | www.thedataschool.co.uk

Power BI offers various features to improve visualization, and in this article we will look at creating a sort button for your charts.

Data,EventRecap,Events,VizitBerlin

Datenbankstruktur 3 - Snowflake Schema

Dec 5, 2023 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

Im zweiten Teil dieser Artikelserie wurde über ein Modell der Datenstruktur diskutiert. Es heißt das Star-Schema. In diesem dritten Teil reden wir weiter über das gleiche Thema, und zwar haben wir das nächste Datenstrukturmodell: das Snowflake-Sch...

Data,EventRecap,Events,VizitBerlin

Datenbankstruktur 2 - Star Schema

Dec 5, 2023 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

Bereits in dem ersten Teil des Artikels wurde darüber diskutiert, dass Daten in eine bestimmte Art und Weise im Sinne verwaltet werden können, dass die Hauptinformationen in einer Faktentabelle und die weiteren Detailinformationen in Dimensionstab...

Data,EventRecap,Events,VizitBerlin

Dashboard Week Day 45 Themes in Studio Ghibli movies

Dec 5, 2023 Maddalena Mariano | www.thedataschool.co.uk

Ghibli movies are instantly recognizable and have a very distinct style, which has always inspired pieces of media of any kind, from other movies and soundtracks to videogames. They create nostalgia, and a clear feeling of familiarity.

Data,EventRecap,Events,VizitBerlin

Building a Polar Area Chart

Dec 5, 2023 Zak Saucede | www.thedataschool.co.uk

Polar Area Charts, first used by Florence Nightingale in 1856, are a popular way to present data in sports data environments. Whilst it could be argued that this visualisation is not best practice, the Polar Area Chart helps users to quickly compa...

Data,EventRecap,Events,VizitBerlin

Matillion Visionary 2023 Emerald Award NHS Greater Manchester InterWorks

Dec 5, 2023 Chris Hastie | interworks.com

InterWorks were delighted to hear that NHS Greater Manchester Integrated Care has earned a Matillion Emerald Award as a Visionary in 2023. NHS Greater Manchester is helping organisations work better together with people and communities. Profession...

News,awards,Matillion,NHS

Configure Azure Private Link Connectivity with Snowflake

Dec 5, 2023 Chris Hastie | interworks.com

Snowflake and Azure are incredibly capable of storing data securely. You can see all reports available to customers through their pages of security and compliance reports, for both Azure and Snowflake. This is fantastic for data stored in the plat...

Data,Azure,datawarehouse,database,PrivateLink,Snowflake

Improving Your SQL Logic with Common Table Expressions

Dec 5, 2023 Elliott Stam | medium.com

Making logic easier to write, read, explain, and maintainContinue reading on TDS Archive »

analytics,sql,best-practices,tips-and-tricks,data-engineering

What did it take to get into DSNY7

Dec 4, 2023 Mel Niere | www.thedataschool.co.uk

Introducing the outstanding members of Cohort 7 at The Data School New York!

Using Layout Containers in Tableau

Dec 4, 2023 Volha Fiadotava | www.thedataschool.co.uk

When I first created the Tableau dashboard, it was a bit of a mess. Things were just floating around with no order because I didn’t know about what are called layout containers and why they are useful. When I started using them, things got a littl...

Useful Apps And Chrome Extensions For Your Data Consulting Workflow

Dec 4, 2023 Franziska Schwade | www.thedataschool.co.uk

When I make dashboards, slideshows, or general sketches for client meetings, I rely on a handful of tools that I use nearly every time. These tools have been extremely helpful in streamlining my workflow, and I thought I’d share them with you today.

Datenbankstruktur - Teil 1

Dec 4, 2023 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

Wir kennen bestimmt schon die Excel-Tabelle, also die normale Tabelle, die aus Zeilen, Spalten, Index und den dazugehörigen Werten aufgebaut werden. Damit kann man Informationen in tabellarische Art und Weise strukturiert speichern und verwalten. ...

Dashboard Week Final Day - US Shark Attacks

Dec 4, 2023 Erin Potter | www.thedataschool.co.uk

Welcome to my final blog for the Dashboard week blog series! During Dashboard week we’re 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 to recr...

Dashboard Week Day 4 5 - DataPlusMovies

Dec 4, 2023 Jaroslav Tomcala | www.thedataschool.co.uk

I was excited when we received Jenny’s brief on Thursday at 9 am—a rarity in our Dashboard Week as the challenge extended to Friday too! The task at hand was the Data + Movies challenge for our final two days.However, my excitement took a swift do...

Benutzerdefinierte Sortierung in Power BI

Dec 4, 2023 Volha Fiadotava | www.thedataschool.co.uk

Wenn Sie eine benutzerdefinierte Sortierreihenfolge in Power BI erstellen, gibt es einen Trick, wie Sie das tun können.

APIs why reading is fundamental

Dec 4, 2023 Eric Williams | www.thedataschool.co.uk

How to Use APIs: A Guide for Beginners

DSNY 5 - Dashboard Week Day 2

Dec 3, 2023 Le Luu | www.thedataschool.co.uk

On the second day of the dashboard week, we were assigned to work with cheese on https://www.cheese.com/. It means that we have to do web-scraping to extract the data from that web page. This is an interesting assignment because I really love usin...

Dashboard Week Day 4 Application Rehash

Dec 2, 2023 Adam Sultanov | www.thedataschool.co.uk

With today, dashboard week comes to a close.