Tableau vs. Power BI A Quick Start Guide Comparison

Jan 5, 2024 Juan Carlos Guzman | playfairdata.com

As someone who is relatively new to both Tableau and Power BI, having to navigate either platform can feel overwhelming…The post Tableau vs. Power BI: A Quick Start Guide Comparison appeared first on Playfair Data.

AuthorExperience,Engineering,Fundamentals,PowerBI,TableauDesktop

Creating an Exploding Pie Coxcomb Chart in Tableau

Jan 4, 2024 Lindsay Betzendahl | vizzendata.com

What the Heck and Why? For the past five years as a consultant at HealthDataViz, I have worked with aContinue reading

Tableau,Tutorial,CoxcombChart,Design,TableauHow-To

Tableau Tutorial - How to Make a Donut Chart in Tableau

Jan 4, 2024 Daniel Bostrom | www.thedataschool.co.uk

There’s a strong preference for donut charts over pie charts in Tableau. Donut charts are easier to interpret and look better. You may even choose to use the empty space inside them with a label for the chart. Here’s a step-by-step guide on how to...

AI,AuthorExperience,Intermediate,Strategy

Tableau Tutorial - Dealing With Exceptions in Tooltip Text

Jan 4, 2024 Daniel Bostrom | www.thedataschool.co.uk

I ran into an issue while making my dashboard for the first round of applications to the Data School. I had a line chart with the number of bike crashes by year. In the tooltip, I added in the percent change in number of crashes from the previous ...

AI,AuthorExperience,Intermediate,Strategy

Spatial in Tableau

Jan 4, 2024 Le Luu | www.thedataschool.co.uk

I wrote 2 blogs about Spatial Analytics in Alteryx. The Spatial tools in Alteryx helped me very much when I was working with Spatial data. If you haven’t read it, you can read it here. In Tableau, some Spatial functions also help to prepare the da...

AI,AuthorExperience,Intermediate,Strategy

New Measures in PowerQuery

Jan 4, 2024 Hewan Zewdu | www.thedataschool.co.uk

Follow along to create a simple DAX calculation!

AI,AuthorExperience,Intermediate,Strategy

My First Week at the Data School

Jan 4, 2024 Daniel Bostrom | www.thedataschool.co.uk

After weeks of anticipation, I’ve finally started working at the Data School and my first week is drawing to a close. If you’re considering working here, you probably want to know what you’re getting into so here’s a quick overview of what we’ve d...

AI,AuthorExperience,Intermediate,Strategy

Interactivity on Power Bi

Jan 4, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

Interactivity is a handy tool to emphasis trends and changes in our data. We can choose to highlight or filter charts and data by clicking on a a bar or point. When adding interactivity to our report, we can use slicers and drop-down bars to our r...

AI,AuthorExperience,Intermediate,Strategy

How to Build a Multi-Level Selection into a Drilldown Bar Chart with Set...

Jan 4, 2024 Samantha Fitzsimmons | www.thedataschool.co.uk

In Part I of this blog, I outlined the steps needed to build a multi-level selection into a drilldown bar chart with set action highlight. In this blog, I will outline the steps needed to use category/sub-category drilldown bar chart to filter to ...

AI,AuthorExperience,Intermediate,Strategy

Filtering highlighting and Slicers in PowerBI

Jan 4, 2024 Jessica Kirk | www.thedataschool.co.uk

Interactivity can be one of the most important components of a report. It allows you to engage the user, fit more information on a page and adds to the user story.

AI,AuthorExperience,Intermediate,Strategy

Data School Application Tips

Jan 4, 2024 Daniel Bostrom | www.thedataschool.co.uk

So you want to join the Data School? Having been in your shoes a little over a month ago, I still have the application process fresh in my memory. With my first week in the books, I’ve decided to look back at the application process and share some...

AI,AuthorExperience,Intermediate,Strategy

Colouring bars using DAX in Power BI

Jan 4, 2024 Alexandra Skelly | www.thedataschool.co.uk

The colouring of this chart is created with string values, here is the code used:

AI,AuthorExperience,Intermediate,Strategy

Alteryx Macros. What are they for

Jan 4, 2024 Volha Fiadotava | www.thedataschool.co.uk

What is a macro?

AI,AuthorExperience,Intermediate,Strategy

How To Prove Your Proficiency With Tableau Desktop to the World

Jan 4, 2024 Robby White | interworks.com

A lot of our clients are curious about ways to show their professional competency as a user of Tableau Desktop. This is where we typically introduce the certifications that Tableau offers. For context, the certification exams InterWorks’ employees...

Data,Certifications,Tableau,TableauDesktop

Can you compare salaries to the median

Jan 4, 2024 Donna Coles | donnacoles.home.blog

For the first WOW challenge of 2024, I set the task of completing a viz related to HR salary data. Creating the calculations To start, we’ll build out all the necessary calculations required, and display them in tabular form. First create Employee...

WorkoutWednesday,WOW2024,DotPlot,DualAxis,FIXEDLOD,Gantt,HR,Median,ReferenceLines,Week1

What does it mean to Append Data on Power Query

Jan 3, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

Appending data on Power Query is the same as the union of data Tableau. When we have two tables and we would like to add one table to the bottom of another, we can use the append function on Power Query.

TableauParameters,TableauCalculations

Weighted Averages in Tableau

Jan 3, 2024 Faith Rotich | www.thedataschool.co.uk

A weighted average is the average of values which are scaled by importance. In other words, it’s a way to calculate an average where some points contribute more than others.

TableauParameters,TableauCalculations

Tableau Hack Remove Unwanted Highlighting

Jan 3, 2024 Cecily Santiago | www.thedataschool.co.uk

In Tableau, marks get highlighted when you click them, causing all other marks to fade into the background.

TableauParameters,TableauCalculations

Stats in Tableau Using Z-scores for Further Investigation

Jan 3, 2024 Aurora Malinauskaite | www.thedataschool.co.uk

Z scores can help us investigate our data. This blog will show you an example of how this can be done.

TableauParameters,TableauCalculations

Spatial Analytics in Alteryx Part 2

Jan 3, 2024 Le Luu | www.thedataschool.co.uk

Continue to the first part of Spatial Analytics in Alteryx, in this second part, I am going to share about other Spatial tools in Alteryx. When you first hear about Spatial data, what will you do with that data? To me, I think about finding the di...

TableauParameters,TableauCalculations

Power Query Tips How to clean up spelling mistakes and typos

Jan 3, 2024 Numa Begum | www.thedataschool.co.uk

This is the start of a blog series providing you with tips for data preparation within the Power Query interface and advice for using M code to achieve this!

TableauParameters,TableauCalculations

Power Query Tips How to append queries with the table name as a column

Jan 3, 2024 Numa Begum | www.thedataschool.co.uk

This is the start of a blog series providing you with tips for data preparation within the Power Query interface and advice for using M code to achieve this!

TableauParameters,TableauCalculations

Normalise the use of Z-Scores

Jan 3, 2024 Hannah Bartholomew | www.thedataschool.co.uk

How to use Z-scores in Tableau.

TableauParameters,TableauCalculations

IntoTheArchives Workout Wednesday

Jan 3, 2024 Lorraine Ferrusi | www.thedataschool.co.uk

Your journey into Tableau has kicked off - you’ve watched some videos, put some basic graphs together, played around with dashboards and stories… but how do you practice more to solidify your understanding?

TableauParameters,TableauCalculations

Interesting Findings From My Final Application Viz

Jan 3, 2024 Alan Grunberg | www.thedataschool.co.uk

For the final round of my application to the Data School, I was given a dataset about horror movies. For my Tableau viz, I focused on the words in the horror movie titles, and what we can learn by analyzing them. Working on this project led me to ...

TableauParameters,TableauCalculations

How to build a Histogram

Jan 3, 2024 Beza Taye | www.thedataschool.co.uk

A histogram is a graphical representation of the distribution of a dataset. It provides a visual summary of the underlying frequency or probability distribution of a set of continuous or discrete data.

TableauParameters,TableauCalculations

Ethical Considerations in Data Analysis

Jan 3, 2024 Alex Briody | www.thedataschool.co.uk

There are some ethical considerations in data analysis that one might have to uphold the integrity and social responsibility of the analysis process. Here are some of them: Privacy and confidentiality - As data analysts, we must ensure that compa...

TableauParameters,TableauCalculations

Creating a Splicer from Measures in PowerBI

Jan 3, 2024 Tobias Colmer | www.thedataschool.co.uk

Using measures as a splicer in PowerBI.

TableauParameters,TableauCalculations

Creating a Drill Down Bar Chart in Tableau

Jan 3, 2024 Salome Grasland | www.thedataschool.co.uk

In this blog, we’ll explore how to create a drill-down bar chart in Tableau using the built-in Superstore Dataset. This bar chart allows us to drill down from category to subcategory with just a click on the category bar.

TableauParameters,TableauCalculations

Creating Dimension Parameters in PowerBI Desktop

Jan 3, 2024 Holly Jones | www.thedataschool.co.uk

Creating dimensional parameters in PowerBI Desktop allows your data to be more dynamic by changing the context of your report by selecting different values such a dates and other categories to switch between graphs such as in the short video below.

TableauParameters,TableauCalculations

Control Charts Standard Deviations Averages

Jan 3, 2024 Beza Taye | www.thedataschool.co.uk

A Control Chart is essentially a line chart with reference lines for the average as well as one standard deviation above and below the average. This can be useful to measure targets and performance to be able to see when profits or performance is ...

TableauParameters,TableauCalculations

Conditional Colour Formatting in Power BI

Jan 3, 2024 Andrew Tobin | www.thedataschool.co.uk

How to use gradient and rule-based colour conditioning in Power BI.

TableauParameters,TableauCalculations

Can ChatGPT Make Realistic Synthetic Data

Jan 3, 2024 Alexander Wood | www.thedataschool.co.uk

In this blog I outline the ways in which you can write better prompts to ChatGPT so that you can generate better synthetic data sets.

TableauParameters,TableauCalculations

Box and whispers Reveal the secrets in your data

Jan 3, 2024 Dan Wade | www.thedataschool.co.uk

Using boxplots/ box and whisker charts to enhance your data analysis and identify outliers in your distribution.

TableauParameters,TableauCalculations

Visual Analytics Trends for 2024

Jan 3, 2024 Ryan Sleeper | playfairdata.com

Portions of this post originally appeared on LinkedIn. Follow us on LinkedIn for frequent updates on visual analytics trends and…The post Visual Analytics Trends for 2024 appeared first on Playfair Data.

AI,AuthorExperience,Intermediate,Strategy

Customizable TopBottom Highlighter in Tableau

Jan 3, 2024 Ollie Linley | onenumber.biz

Text tables can be overwhelming for users. It’s hard to know where to focus your attention!

TableauParameters,TableauCalculations

Tableau Pulse Set Up and Use Case Demo

Jan 3, 2024 InterWorks | interworks.com

If you’re wanting to see someone work in Tableau Pulse, we have you covered: We wanted to share a video we put together when we got our hands on the hotly-awaited Tableau Pulse beta, and the use case we developed to show some of the…The post Table...

Data,TableauPulse,TableauPulseDemo,TableauSetUp

Take a Byte of that

Jan 2, 2024 Lorraine Ferrusi | www.thedataschool.co.uk

Save space. Keep it compact. Make it small. It wouldn’t be the first time you have to be aware of the space something takes up.

Spatial Data 101 Alteryx Spatial Tools for Beginners Part 1

Jan 2, 2024 Aaron Potts | www.thedataschool.co.uk

Alteryx has an extensive set of tools that let you work with spatial data. There’s a good chance you’ll rarely or never use them as a data analyst, but if you do, you can manipulate spatial data to analyze a wide range of scenarios. The goal of th...

Pivoting in PowerBI

Jan 2, 2024 Holly Jones | www.thedataschool.co.uk

Pivoting can be a crucial step in Power Query to transform and reorganize your data to facilitate visualization of your data. Data can be pivoted in several ways and depends on the requirements you have for your data.

Parameters in PowerBI

Jan 2, 2024 Hewan Zewdu | www.thedataschool.co.uk

Unsure how to use parameters to specify file path? Hopefully this blog post helps!

Merges in PowerBI

Jan 2, 2024 Jessica Kirk | www.thedataschool.co.uk

Today DS43 covered a lot of content on PowerBI and PowerQuery. We tackled the first 4 weeks of the preppin’ data challenges in PowerQuery, learning how the steps differ to Tableau Prep. One of the steps that seemed to be quite different from Table...

Loading Every Sheet in an Excel Workbook

Jan 2, 2024 Tobias Colmer | www.thedataschool.co.uk

Hello reader,

How to Create Custom Weeks in Tableau

Jan 2, 2024 George Ledger | www.thedataschool.co.uk

When using different Date Parts in Tableau it can be annoying when using weeks. Tableau displays weeks as the week number based on the entire year (which isn’t very helpful for an end user of a dashboard). Thankfully, there’s an easy way to make y...

How to Add Dynamic Titles in Tableau

Jan 2, 2024 Beza Taye | www.thedataschool.co.uk

Often, it is the case that as you switch between different locations, categories, or filter to a specific date range for a Tableau dashboard, it can be very useful for chart titles, or the overall title to change along with it.