My Week as a Project Manager

Mar 7, 2024 Tobias Colmer | www.thedataschool.co.uk

Hello Reader,

Data,funnel,Tableau,TipsandTricks

Make a point

Mar 7, 2024 Jessica Kirk | www.thedataschool.co.uk

A look into the MAKEPOINT() function in Tableau…

Data,funnel,Tableau,TipsandTricks

Improve your Tableau graphs in 2 minutes

Mar 7, 2024 Andrew Tobin | www.thedataschool.co.uk

There are lots of ways to improve the clarity and professionalism of a graph in Tableau, but I’ve found just four simple changes can significantly improve a graph in only a couple of minutes. These changes are about making a chart look less clutte...

Data,funnel,Tableau,TipsandTricks

INT vs. FLOOR What is the difference and when does it matter

Mar 7, 2024 Randee Johnson | www.thedataschool.co.uk

INT (short for integer)

Data,funnel,Tableau,TipsandTricks

How to create Fake Data using Mockaroo and ChatGPT

Mar 7, 2024 Tobias Colmer | www.thedataschool.co.uk

Hello Reader, how are you?

Data,funnel,Tableau,TipsandTricks

4 Efficient Ways to Visualise Change Over Time in Power BI

Mar 7, 2024 Hewan Zewdu | www.thedataschool.co.uk

Here we go through four straightforward methods for illustrate change over time to help you harness the full potential of your data ASAP

Data,funnel,Tableau,TipsandTricks

How To Build a Colored Smooth Funnel in Tableau

Mar 7, 2024 Alex Madrigal | interworks.com

As we’ve published before, a funnel is a great way to represent and track a flow or stages in a process. Whether in business, science or engineering, for instance, we can use funnels to easily see and analyze how large or small those stages are,…T...

Data,funnel,Tableau,TipsandTricks

Can you visualise when it gets busy

Mar 7, 2024 Donna Coles | donnacoles.home.blog

It was Yoshi’s first challenge as a #WOW coach this week, and it provided us with an opportunity to develop our data densification and date calculation skills. I will admit, this certainly was a challenge that made me have to think a lot and refer...

WorkoutWednesday,WOW2024,BaselineTimeAxis,CustomFormat,Dates,DualAxis,FixedSizeBar,LOOKUP,ParameterActions,TableCalcs,Time,WindowMax

What does Level of Detail mean in Tableau

Mar 6, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

If you’re serious about learning Tableau, you must understand the level of detail of the view. Another way to think about it is the level of granularity.This is essential for ensuring you know the aggregations that Tableau will perform as this wil...

aggregation,concept,granularity,learn,levelofdetail,tableau

What Makes Tableau Spatial Objects Geodetic

Mar 6, 2024 Andrew Tobin | www.thedataschool.co.uk

The Tableau help page defines the LENGTH() function as returning “the geodetic path length of the line string or strings”. This simply refers to the fact that, as a sphere, the shortest route between two points will not usually appear as a straigh...

Data,labels,Tableau,TableauHacks

Learn What the Data School Learns

Mar 6, 2024 Tobias Colmer | www.thedataschool.co.uk

My own personal reflection on Learn What the Data School Learns.

Data,labels,Tableau,TableauHacks

Creating Maps with MakePoint and MakeLine Functions in Tableau

Mar 6, 2024 Holly Jones | www.thedataschool.co.uk

This week in DS43 cohort, we learned how to create spatial maps within Tableau, and Power BI. One of the map types we created that I thought could be really useful is flights from a specific destination (thinking for future holiday planning of cou...

Data,labels,Tableau,TableauHacks

Alteryx Exam Prep

Mar 6, 2024 Tobias Colmer | www.thedataschool.co.uk

How I passed my Alteryx Exam & why you should be kind to Text Input.

Data,labels,Tableau,TableauHacks

Tableau Hacks Mark Label Wrapping

Mar 6, 2024 Robin Schouten | interworks.com

A niche one today, but it does come up in some vizzes every now and then. Can you remember the forklift where we use placeholder values like “min(1)” or something similar just to draw a mark in a graph to than use for something else?…The post Tabl...

Data,labels,Tableau,TableauHacks

11 Steps to Create KPIs Sparklines in the Same Sheet in Tableau

Mar 5, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Want to cut the number of sheets you need in your KPI dashboard in half? These 11 simple steps will get much closer.Steal the calcs to speed up your work.P.S. If you like tips like this, remember to follow me on LinkedIn so you’re notified about e...

calculatedfield,dashboard,detail,filter,guide,howto,KPI,levelofdetail,LODcalc,sparkline,tableau,title,worksheet

Tableau How-To Create Parallel Coordinates Charts

Mar 5, 2024 Lisa Hitch | www.thedataschool.co.uk

Do you need a chart to compare multiple measures across members? Do you want to compare how someone ranks across different sub-scores compared to other members? Then a Parallel Coordinates Chart may be for you. This blog article will give step-by-...

Data,DataVirtualization,ELT,Snowflake

Supply Chain Dashboard Showcase- Power BI

Mar 5, 2024 Harvey Joyce | www.thedataschool.co.uk

This Power BI Dashboard looks at Supply Chains and Resource Allocation!

Data,DataVirtualization,ELT,Snowflake

Quadrant Segmentation

Mar 5, 2024 Jessica Kirk | www.thedataschool.co.uk

Quadrant segmentation is the process of dividing a chart (usually a scatterplot) into four sections. Depending on the applications, the four quadrants can take on a range of values. One application of quadrant segmentation is in business. If a bus...

Data,DataVirtualization,ELT,Snowflake

Power Up Your Skills Mastering Power Query Training Tips

Mar 5, 2024 Hewan Zewdu | www.thedataschool.co.uk

Help others unlock the potential of Power Query with some training tips!

Data,DataVirtualization,ELT,Snowflake

Power BI DAX Context Transition In The Calculate Function

Mar 5, 2024 Karina Chan | www.thedataschool.co.uk

I had a go at learning context transition, and this is my understanding of the theory. I have linked all the materials I used to learn at the end of the blog.

Data,DataVirtualization,ELT,Snowflake

Master time with Date Tables in Power BI

Mar 5, 2024 Hewan Zewdu | www.thedataschool.co.uk

Unlock the secrets of time in Power BI using date tables! In this blog we create a date table with a sorted field and use it to create a simple line chart.

Data,DataVirtualization,ELT,Snowflake

Always Changing Understanding Variables using Power BI DAX

Mar 5, 2024 Holly Jones | www.thedataschool.co.uk

How do variables using DAX in Power BI revolutionize transforming and analyzing data?

Data,DataVirtualization,ELT,Snowflake

All the Spatial Functions in Tableau

Mar 5, 2024 Andrew Tobin | www.thedataschool.co.uk

When working with spatial/geographic data, Tableau has nine built-in functions: area, buffer, distance, intersects, makeline, makepoint, length, outline and shapetype. These functions relate to spatial objects such as points, lines, and polygons.

Data,DataVirtualization,ELT,Snowflake

Data Virtualization and Why ELT to Snowflake Is Usually Better

Mar 5, 2024 Mike Oldroyd | interworks.com

What Is Data Virtualization? Data virtualization is an approach to data integration that can be thought of as an alternative to the more common ETL/ELT +  data warehouse based approach. With data virtualization, the source data is left in place an...

Data,DataVirtualization,ELT,Snowflake

The difference between operational and strategic dashboards and why you ...

Mar 4, 2024 Yoan Caboste | www.thedataschool.co.uk

Explore how you can tailor your dashboards to your stakeholders needs, by determining if they would benefit from a strategic or operational output, with resources for further exploration!

Engineering,Intermediate,TableauDesktop,TechnicalFeatures

Power BI Visual Calculations Before and After

Mar 4, 2024 Robbin Vernooij | www.thedataschool.co.uk

I’ll run us through four metrics frequently used by business, show you how we create it using the new Visual Calculations and how we (used to) do it using DAX measures.

Engineering,Intermediate,TableauDesktop,TechnicalFeatures

From Buy Now to Bye Now - The Last Dashboard of our Training Phase

Mar 4, 2024 Franziska Schwade | www.thedataschool.co.uk

All of a sudden, our four months of training ended so quickly. Friday marked the conclusion of Dashboard Week and also our final day before placements.

Engineering,Intermediate,TableauDesktop,TechnicalFeatures

The Beginners Guide to Basic Tableau Calculated Fields

Mar 4, 2024 Dan Bunker | playfairdata.com

At Playfair Data, we call calculated fields one of the “Big 3” – the three technical features that unlock the…The post The Beginner’s Guide to Basic Tableau Calculated Fields appeared first on Playfair Data.

Engineering,Intermediate,TableauDesktop,TechnicalFeatures

Tableau Hacks Small Multiples

Mar 4, 2024 Robin Schouten | interworks.com

In Tableau, it is pretty straightforward to build multiple smaller graphs in one view. Want to split this bar chart by country? Add your [Country] dimension to the Row shelf. Want small line charts by [Category] going across? Add the [Category] to...

Data,SmallMultiples,Tableau,TableauHacks

Streamlining Dashboard Design Key Takeaways and Best Practices

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

Creating a dashboard from a conceptual sketch involves more than just technical skills; it demands a thoughtful approach to design and user experience. Here are some tips and best practices based on recent project where we were tasked to take over...

Data,Tableau,TableauPulse

Dasboard Week Day 5 Personal Project - My Life in Books

Mar 1, 2024 Finn Kappus | www.thedataschool.co.uk

Mit dem fünften und somit letzten Tag der Dashboard Woche schließen wir, DSDE 6, unsere Trainingsphase ab. Als kleine Belohnung haben wir den Tag Zeit bekommen unsere bereits gestarteten Personal Projects weiter zu machen. Hier widme ich mich dem ...

Data,Tableau,TableauPulse

Leveraging Published Data Sources in Tableau Pulse

Mar 1, 2024 Paul Vincent | interworks.com

Now that you’ve decided to test drive Pulse, what do you need to get ready? In this blog post, we’ll take a closer look at the data required to harness the full power of Pulse.  Pulse Needs Your Data  From earlier posts about Pulse on…The post Lev...

Data,Tableau,TableauPulse

To The Point Using DAX to Dynamically Colour Charts in Power BI

Feb 29, 2024 Jeffrey Brian Thompson | www.thedataschool.co.uk

Power BI allows you to choose a colour via a field. This accepts string inputs as Hex such as “#7fffd4”, but also accepts some words such as “aquamarine” as a colour. Which words are accepted?

To The Point Model View Relationships in terms of joins in Power BI

Feb 29, 2024 Jeffrey Brian Thompson | www.thedataschool.co.uk

Relationships in Power BI can be mysterious, but they can be understood using the language of joins (called merges in Power BI). Here is a small mock dataset created to demonstrate with the fact (main) table on the left, and a dimension (lookup) t...

How to Conditionally Format a Gradient Colour Scheme in Power BI

Feb 29, 2024 Jessica Robbin | www.thedataschool.co.uk

With conditional formatting, in Power BI you can customize cell colours, including gradients, based on rules or field values. This blog post will explain how to format a gradient colour scheme.

How to Concatenate Strings in Power BI Tableau

Feb 29, 2024 Alvaro Gonzalez | www.thedataschool.co.uk

All Data Visualization software have their own quirks and differences. These include but are not limited to their terminology, functionality and design.

How To Add Error Bars in PowerBI

Feb 29, 2024 Alex Bernaciak | www.thedataschool.co.uk

Using average metrics in bar charts can give you a great overview of data between different categories but without additional details it fails to show the spread of your data. This is where error bars come to help out!

Getaway Suggestion App - Dashboard Week Day 3

Feb 29, 2024 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

On day 3, we needed to do some API calls to retrieve the weather, temperature, and pollution index for any countries of our choice. The limitation is, that we can only get the data for the “now” time, meaning we cannot do any time series analysis ...

Daten Metriken Glck Visualisierung globaler Trends mit Power BI und der ...

Feb 29, 2024 Mihai Mazareanu | www.thedataschool.co.uk

Tag 2 der Dashboard Week hat uns die Gelegenheit gegeben, wieder mit Power BI zu arbeiten. Die Datenquelle war ein Datensatz von Kaggle, der das Glücksempfinden der Menschen in allen Ländern der Welt anhand der GWP (Gallup World Poll) gemessen hat...

Dashboard Week Day 3 Weather Data

Feb 29, 2024 Finn Kappus | www.thedataschool.co.uk

On day three of the dashboard week, I got weather data from an API with Alteryx. These data included different measures from selected cities. I compared European capitals to see which one is the best in each measure.

Dashboard Week Day 3 Weather API

Feb 29, 2024 Volha Fiadotava | www.thedataschool.co.uk

Today is day three of our intensive final week of the 4-month Data School training. Our task on this day was to use Alteryx to make API calls and retrieve data from the AirVisual API, followed by the creation of a dashboard.We need to create a fre...

Das Aufrufen der Luftdaten-API von Alteryx - Dashboard-Woche Tag 3 - Alt...

Feb 29, 2024 Nuki Susanti | www.thedataschool.co.uk

Am dritten Tag der Dashboard-Woche haben wir es nicht mit fertig visualisierbaren Daten zu tun, sondern müssen unsere Daten selbst von IQAir mit Hilfe von Alteryx sowohl für die API-Anfrage als auch für die Datenvorbereitung abrufen. Dies ist sowo...

Bend Dont Break Succeeding as a Consultant

Feb 29, 2024 Tyler Ha | www.thedataschool.co.uk

A major part of our training at the data school is client projects. We have a total of 8 client projects through the latter half of our training, where we are matched with a client to help them solve any problems/needs that they may have. We work ...

Can you create these KPI Cards

Feb 29, 2024 Donna Coles | donnacoles.home.blog

Lorna set a table calculation filled challenge this week to recreate some KPI cards using an aggregated and amended version of the Superstore data set. Lorna purposefully used a string Period field to define the timeframe to encourage the use of t...

WorkoutWednesday,WOW2024,fakeaxis,Formatting,LOOKUP,MIN0,TableCalculations,Week9,Window_Max

What Does Wealth Give Us - Dashboard Week Day 2

Feb 28, 2024 Muhammad Dimas Abdul Aziz Cakradewa | www.thedataschool.co.uk

On the second day of the dashboard week, we get to work with the dataset that tells the information about Global Happiness Index for (almost) all countries, from year 2015 to 2019. The data is downloadable from Kaggle, meaning it is an open data, ...

TableauDates