Power BI Basics How to add comma to your cards

Feb 20, 2024 Justinas Aleksiejus | www.thedataschool.co.uk

If you encountered a problem where your cards do not separate numbers by comma.

Data,Einstein,Tableau,TableauPulse

Gewichteter Durchschnitt

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

Die meisten von uns wissen, was ein Durchschnitt ist. Man addiert einfach alle Werte und teilt sie durch die Anzahl der Werte. Das ist ziemlich einfach, bis es kompliziert wird. €Nehmen wir das folgende Beispiel:Peter möchte für ihn und seine Freu...

Data,Einstein,Tableau,TableauPulse

Data Vertigo - Level of Detail Granularity

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

In first week of training at The Data School you will spend a lot of your time learning from basics. Sometimes you may feel like this is superfluous, especially since you demonstrated some proficiency in Tableau for your application.

Data,Einstein,Tableau,TableauPulse

Streamlining User and Role Management in Snowflake via Okta

Feb 20, 2024 Fadi Al Rayes | interworks.com

In an insightful blog series, my colleague Danny dived into setting up SCIM and SSO with Azure Active Directory (AAD) – a must-read for organizations using AAD for managing Snowflake users and roles. AAD’s popularity is clear, but it’s not without...

Data,Okta,Snowflake,UserManagment

How Does Tableau Pulse Support My AI Strategy

Feb 20, 2024 Alex Wiebe | interworks.com

In today’s dynamic business landscape, harnessing the power of AI is no longer just a competitive advantage — it’s a necessity. Companies across industries are realizing the transformative potential of AI in driving insights, optimizing operations...

Data,Einstein,Tableau,TableauPulse

What Did It Take To Get Into DS44

Feb 19, 2024 Ruth Amarteifio | www.thedataschool.co.uk

DS44 have now completed 2 weeks of their initial training so it’s a great time to look at what it took for them to get into The Data School. On the left was their initial application and on the right, their final interview applications after feedb...

POWER BI BOXPLOTS WITHOUT CUSTOM VISUALS

Feb 19, 2024 Robbin Vernooij | www.thedataschool.co.uk

Turns out there is no native boxplot visual in Power BI so in this blogpost we walkthrough building one with native visuals, including the calculations using DAX.

Embracing the Data Analysis Journey Tips for Navigating the Landscape of...

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

Embarking on a journey through the vast and varied landscape of data analysis can be as thrilling as it is daunting. With a plethora of tools at our disposal—Tableau Desktop, Alteryx, Tableau Prep, Power BI, SQL, Python—it’s akin to setting off on...

9 Ways to Connect to Web-Based CSVs in Tableau

Feb 19, 2024 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

That title is a bit of a mouthful andthis may seem like a somewhat niche topic, but if you’ve ever tried to connectto a csv from the web, you know how painful it can be. There are many publicservices, including government data portals, that make t...

How-To,Tableau

Power BI - Drill options

Feb 18, 2024 Alexandra Skelly | www.thedataschool.co.uk

Drill-down

Creating Parameters in Power BI

Feb 18, 2024 Alexandra Skelly | www.thedataschool.co.uk

A parameter in Power BI is a named value or set of values that can be referenced in expressions, queries, filters, and various calculations within the Power BI Desktop. This feature allows for the user to explore and customize the analysis of the ...

Buttons and Bookmark option in Power BI - Interactivity

Feb 18, 2024 Alexandra Skelly | www.thedataschool.co.uk

In Power BI, buttons, page navigation, and toggling features provide additional interactivity and control to users when exploring reports or dashboards.

Basic Interactivity in Power BI

Feb 18, 2024 Alexandra Skelly | www.thedataschool.co.uk

Basic Interactivity:

Will A.I. take over data analytics

Feb 16, 2024 Justinas Aleksiejus | www.thedataschool.co.uk

During my application to The Data School, a recurring question kept coming to my thoughts: Will A.I. ever replace data analysts?

Espaol,Menu,Parameter,ParameterActions

The Difference Between Can I and Should I

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

In the world of data visualization, and really, any creative field, the line between what’s possible and what’s practical often blurs. We’re equipped with incredibly versatile tools like Tableau, capable of turning the most complex data into visua...

Espaol,Menu,Parameter,ParameterActions

Reflecting on Crafting User Stories for Data Projects

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

In our latest project, the goal was to immerse ourselves into a specific job role, thoroughly researching its tasks and decision-making processes. From this deep dive, we were tasked with creating user stories - a description of what the user want...

Espaol,Menu,Parameter,ParameterActions

Custom Options Selection Control

Feb 16, 2024 Rosario Gauna | rosariogaunag.wordpress.com

For Week 7 of #WOW2024, Donna Coles has launched an exciting challenge: to build a custom control that allows users to include or exclude, according to their choice, any of the states in the Top 5 sales. The main requirements of the challenge are:...

English,Menu,Parameter,ParameterActions

Control Personalizado de Seleccin de Opciones

Feb 16, 2024 Rosario Gauna | rosariogaunag.wordpress.com

Para la semana 7 de #WOW2024, Donna Coles ha lanzado un desafío emocionante: construir un control personalizado que permita a los usuarios incluir o excluir, según su elección, cualquiera de los estados en el Top 5 de ventas. Los requerimientos pr...

Espaol,Menu,Parameter,ParameterActions

Can you include and exclude options with a custom control

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

It was my turn this week to set the challenge which I based on an example of a viz that I’d seen at work. I built the viz using 3 sheets and using techniques similar to that described in a previous challenge documented here where I used parameter ...

WorkoutWednesday,WOW2024,BarChart,deselectmarks,LabelBars,LineChart,MeasureNames,ParameterActions,Week7

The Simple Power of Planning in Data Cleaning

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

In our latest project, the goal was to plan out how to clean a dataset and, time permitting, start the cleaning process. This experience brought to light an invaluable lesson on planning and clarity in managing data projects—a lesson reminiscent o...

Data,AI,Chatbot,LLM

The Outline Bar Chart

Feb 15, 2024 Alex McManus | www.thedataschool.co.uk

Introduction

Data,AI,Chatbot,LLM

Spatial Data 101 Alteryx Spatial Tools for Beginners Part 3

Feb 15, 2024 Aaron Potts | www.thedataschool.co.uk

In this final part in the three part series, learn how to use Spatial Match, Spatial Info, Poly-Build, and Find Nearest to perform the most essential spatial analytics tasks.

Data,AI,Chatbot,LLM

Prepping for Change Intro to Alteryx to Tableau Prep Migrations

Feb 15, 2024 Aaron Potts | www.thedataschool.co.uk

Tableau Prep and Alteryx both let you prepare data for visualization. Some organizations that use both Alteryx and Tableau want to consolidate their efforts behind one data prep solution - after all, why pay for twice the licenses and handle twice...

Data,AI,Chatbot,LLM

Is it Analysis or just Description

Feb 15, 2024 Anne Porcia Affi-Asamani | www.thedataschool.co.uk

While describing what’s happening in your data is essential, it is just as important to move beyond just description and delve deeper into analysis. Rather than stopping at surface-level observations in your dashboard, analysis prompts the user to...

Data,AI,Chatbot,LLM

How to Create Separate Colour Legends in Tableau

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

A useful Tableau technique we learned today is how to use different colour legends for different Measure Names in a table.

Data,AI,Chatbot,LLM

How I Made My Chess Dashboard

Feb 15, 2024 Michael Imbriale | www.thedataschool.co.uk

Last week, I tasked myself with creating a Guess the Chess Rating dashboard, allowing users to view a chess game and guess the rating of the players based on their moves. This idea was inspired by GothamChess’ Guess the Elo series, and I aimed to ...

Data,AI,Chatbot,LLM

Dynamic Zone Visibility

Feb 15, 2024 Salome Grasland | www.thedataschool.co.uk

Dynamic zone visibility (DZV) on a dashboard refers to the capability to control the visibility of specific zones or sections of the dashboard based on certain conditions or user interactions. This feature allows dashboard designers to create more...

Data,AI,Chatbot,LLM

Different Ways to Filter a Dimension Field

Feb 15, 2024 Caitlyn O'Connor | www.thedataschool.co.uk

This blog shows you the different ways to filter a dimension field and how they can be used to achieve different outcomes.

Data,AI,Chatbot,LLM

Decoding Dashboards Drawing Parallels with Menu Psychology

Feb 15, 2024 Alex McManus | www.thedataschool.co.uk

Back in my finance analyst days at a major pub and hospitality company, we had an intriguing training session about menu layouts. It was fascinating to learn that humans naturally read menus in a “Z” pattern – from top left to bottom right, like f...

Data,AI,Chatbot,LLM

Alumni Spotlight Lorna Brown

Feb 15, 2024 Mel Niere | www.thedataschool.co.uk

Learn more about Lorna’s experience, from the time she applied to The Data School, to her career as a Data School Coach at The Information Lab. Lorna was part of Cohort 2 of The Data School London, which took place from December 2015 to April 2017.

Data,AI,Chatbot,LLM

4 Key Things You Need To Understand About Your End User

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

When building a dashboard, it’s crucial to understand who your end user is. Unless your audience consists of data-savvy peers, they likely have a different perspective, objectives, and understanding of what they’re viewing. This is why, before cre...

Data,AI,Chatbot,LLM

InterWorks Blog Roundup January 2024

Feb 15, 2024 Mark Cordeiro | interworks.com

Welcome to the blog recap for January! You may ask yourself, “Mark, my friend, it’s already halfway through February. Why are you just now getting to recap January?” To that, dear reader, I would say, “We already did this bit with the hypothetical...

Data,BlogRoundup,Snowflake,Tableau,ThoughtSpot

How Do You Make an AI Chatbot

Feb 15, 2024 Ben Bausili | interworks.com

Have you ever considered creating a chatbot? It might seem like a straightforward task, but, in reality, it involves more complexities than you might initially anticipate. The central challenge lies in enabling the AI to respond meaningfully to th...

Data,AI,Chatbot,LLM

Thinking of Joining A Couple of Tips About Join Type and Clauses

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

Joins are not just the-scary-thing-that-pops-up-when-I-add-more-data.

TableauDates,TableauHow-Tos

Multiple Measures One Chart Dos and Donts

Feb 14, 2024 Anne Porcia Affi-Asamani | www.thedataschool.co.uk

When using multiple measures in one chart in Tableau it can very easily become overcrowded and difficult to read. However doing so can allow for a good visual comparison between two measures in one data set, for example, comparing sales and profit...

TableauDates,TableauHow-Tos

Interactivity on Tableau

Feb 14, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

Interactivity on Tableau Desktop

TableauDates,TableauHow-Tos

How and When to Use Regex in Alteryx

Feb 14, 2024 Adam Sultanov | www.thedataschool.co.uk

For many, having to use RegEx in their workflow is good reason to burn it all down. Hopefully this blog can make that process a little easier. However, this is not a blog about the rules of RegEx itself - there are plenty of blogs on that topic al...

TableauDates,TableauHow-Tos

Everyone Talks About Granularity and Im Too Afraid to Ask

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

Have you ever found yourself nodding along to a conversation about data granularity, too embarrassed to jump in and ask for an explanation? You’re not alone. Let’s break it down with an easy analogy: think of a pile of sand next to a pile of rocks.

TableauDates,TableauHow-Tos

How to Add a Quarter Year Dropdown Filter in Tableau

Feb 14, 2024 Ollie Linley | onenumber.biz

How do you add a Quarter and Year list filter in Tableau? By default, Tableau lets us add a Quarter Number filter (e.g. Q1), but getting a Quarter and Year filter list isn’t a standard option! As a result, we need to workaround this a bit with thr...

TableauDates,TableauHow-Tos

Just how carefully did you look at the data

Feb 14, 2024 Steve Wexler | www.datarevelations.com

Delight, dismay, and why it’s your responsibility to vet the data Thank you to Alli Torban, Anna Foard, and Ben Jones for their feedback. My Delight A few weeks ago, I saw this terrific interactive graphic in one of my social media feeds. It was p...

BusinessVisualizations,GeneralDiscussions,Makeovers,makeovermonday

Where are the Up and Down Arrows

Feb 13, 2024 Calvin Gao | www.thedataschool.co.uk

Have you ever seen a Tableau dashboard where there are up and down arrows indicating when something is good or bad? If you have a windows, here is where you can find those arrows:

TableauDates,TableauHow-Tos

To The Point Sorted Doughnut Charts in Tableau Desktop

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

Doughnut (donut) charts can be effective ways to convey percentages, but can’t be used when your percentages don’t add to 100, can’t be sorted easily, and can sometimes be hard to compare values for…

TableauDates,TableauHow-Tos

To The Point Sorted Doughnut Charts

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

Doughnut (donut) charts can be effective ways to convey percentages, but can’t be used when your percentages add to 100, can’t be sorted easily, and can sometimes be hard to compare values for…

Data,Azure,PrivateEndpoints,security,Snowflake

Thinking of joining A couple of tips for anyone considering Data School

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

I know how hard it is to go through the application process for Data School. It seems long and resource-intense but believe me when I say, it is more than within your reach! As someone who went through the process quite recently, I thought I’d sha...

Data,Azure,PrivateEndpoints,security,Snowflake

Tableau Tutorial - Parameter Actions

Feb 13, 2024 Daniel Bostrom | www.thedataschool.co.uk

Interactivity is part of what makes Tableau so great. The end user can select values for things like parameters, filters, and sets. If you’ve already learned about these, there are still things you can learn to make your dashboard even more intera...

Data,Azure,PrivateEndpoints,security,Snowflake