Dashboard Week Day 1 - Bundesliga

Oct 23, 2023 Benjamin Wortmann | www.thedataschool.co.uk

Heute hat die Dashboard Week angefangen und um es gleich vorweg zu sagen: “Mein Zeitplan ging nicht auf!”. Unsere Aufgabe war es die Spiele der letzten 20 Saison zu zu analysieren. Die Daten mussten wir uns auf der entsprechenden Seite beschaffen....

Dashboards,Storytelling,TipsTricks,UserExperience

Creating 3D Scatterplots in PowerBI using PlotlyJS

Oct 23, 2023 Maddalena Mariano | www.thedataschool.co.uk

This blog was inspired by the Workout Wednesday challenge 2023 Week 41 Power BI: 3D Scatter – Workout Wednesday (workout-wednesday.com).

Dashboards,Storytelling,TipsTricks,UserExperience

Communicating via Explanatory vs. Exploratory Analysis

Oct 23, 2023 Dan Wade | www.thedataschool.co.uk

Find out the differences in explanatory and practical exploratory analysis. Learn about the pros and cons of both. Check out some of examples to give you inspiration.

Dashboards,Storytelling,TipsTricks,UserExperience

3 Creative Ways to Add Instructions for Your Users in Tableau

Oct 23, 2023 Ethan Lang | playfairdata.com

When you publish a Tableau dashboard, you want to ensure that every user, regardless of their data literacy, can easily…The post 3 Creative Ways to Add Instructions for Your Users in Tableau appeared first on Playfair Data.

Dashboards,Storytelling,TipsTricks,UserExperience

Ten Tips Techniques Including the Easy Way to Clear All Filters Round 7

Oct 23, 2023 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Well, I’ve done six previous Ten Tableau Tips blog posts, how about a seventh one?  I hope at least one tip is something you’ve never seen before.Please note that some of these GIFs may appear small on screen.  They are, however, reco...

How-To

Pivot and Unpivot in SQL

Oct 22, 2023 Jules Claeys | www.thedataschool.co.uk

Just like in other data preparation methods there is a way to pivot and unpivot in SQL.  Let’s start with Unpivot.

Choosing Between Alteryx Designer and Alteryx Cloud Whats Best for You

Oct 20, 2023 Will Sutton | www.theinformationlab.co.uk

Despite all the advancements we see with generative AI technologies, cleaning and preparing datasets is still a time-consuming challenge for data professionals. Anaconda’s 2022 State of Data Science report indicates that 38% of a data scientist’s ...

Blog,Alteryx,AlteryxCloud,AlteryxDesigner

Output Sanity Using Strings to Organize Alteryx Output

Oct 20, 2023 Aaron Potts | www.thedataschool.co.uk

Alteryx’s Output Tool is a less-heralded hero in your data’s journey - it doesn’t look like much, but it offers context-sensitive flexibility in the production of your final data product. It can output data directly to databases, Tableau hyper fil...

Data,AI,ML

Interrogating Data

Oct 20, 2023 Aurora Malinauskaite | www.thedataschool.co.uk

Interrogating data is a crucial part of the analysis and visualisation process. This blog provides some useful questions to approach the data with, if you don’t know where to start!

Data,AI,ML

How to Make the Client Happy...

Oct 20, 2023 Hannah Bartholomew | www.thedataschool.co.uk

A 5 minute guide on how to manage a project with a client, from that Monday morning kick-off, to presentation Friday.

Data,AI,ML

Hello World

Oct 20, 2023 Stanley Chen | www.thedataschool.co.uk

Wondering if the data school is right for you?

Data,AI,ML

File Organization 101 Its More Important Than You Think

Oct 20, 2023 Tyler Ha | www.thedataschool.co.uk

POV: You’re looking for an important file from months ago, but no matter where you look—you can’t find it. You’re rifling through all of your disc drives and folders, but that pesky little file just won’t turn up! The worst part? It somehow ALWAYS...

Data,AI,ML

DSNY6 Week 2 in Review Pre-attentive Attributes and Parameters

Oct 20, 2023 Stanley Chen | www.thedataschool.co.uk

The first of 15 posts in a series where I review each week of my data school training journey.

Data,AI,ML

What Is the Deal With All This AI And Why You Should Care

Oct 20, 2023 Chris Chang | interworks.com

AI use cases are spreading rapidly across the workforce, but many companies don’t seem to have a policy in place to prevent workplace disasters. The Conference Board recently conducted a survey of 1100 US employees (Which you can find here) and fo...

Data,AI,ML

Interpreting Predictive Grouping Tools K-Centroids Diagnostics

Oct 19, 2023 louisa.obrien | www.theinformationlab.co.uk

Alteryx Designer makes supervised and unsupervised learning tasks pretty easy through two tool palettes, Predictive and Predictive Grouping. However, the results from the Predictive Grouping tools can be difficult to interpret - arrays of numbers ...

Blog,Alteryx,AlteryxDesigner,Predictive

My First Time... with Power BI

Oct 19, 2023 Dan Wade | www.thedataschool.co.uk

“Do I learn Tableau or Power BI?” is a question you often see from aspiring data. After an introductory session this week, I can now say I have used both and they are very, very different.

How powerful is Power BI

Oct 19, 2023 Thomas Smith | www.thedataschool.co.uk

During my session today at The Data School, I was introduced to the world of Power BI and Power Query. Power BI is a data visualization software launched by Microsoft back in 2015, and has been making significant strides to compete with establishe...

Date Functions in Tableau

Oct 19, 2023 Hannah Bartholomew | www.thedataschool.co.uk

A quick guide to explain how date functions work in Tableau. Ideal as a reference guide that has no time limit!

Can you proportionally brush from multiple selections

Oct 19, 2023 Donna Coles | donnacoles.home.blog

For this week’s #WOW2023 challenge, Kyle wanted us to build a viz that used selections on the viz rather than a set of filter controls to show how the sales for those selections were distributed. This concept is referred to as proportional brushin...

WorkoutWednesday,WOW2023,Bar,DashboardActions,KPI,LayoutContainers,proportionalbrushing,SetActions,SetControls,Sets,Single-SelectOnly,transparentshape,Week42

Using Figma to Enhance Tableau Dashboards

Oct 18, 2023 hannah.millington | www.theinformationlab.co.uk

This blog post explores how to use Figma and Tableau together to create more visually appealing and effective data visualizations. What is Figma? Figma is a web-based design and prototyping tool that allows designers, developers, and other collabo...

Blog,DEsign,Figma,Tableau,TableauDesktop

How to Have a Clean and Sleek SQL Handover

Oct 18, 2023 Numa Begum | www.thedataschool.co.uk

Ensuring your SQL code is easy to read is essential for spotting mistakes as well as easing the adoption process for whoever may have to read it next! This can be done through the addition of whitespace, line breaks and comments which will make th...

ThoughtLeadership,TableauDashboards,Design

Common Aggregate Functions

Oct 18, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

In Tableau, the use of aggregate functions enables you to either summarize or alter the level of detail in your data. When building a calculation, you cannot combine an aggregated value and a disaggregated value.

ThoughtLeadership,TableauDashboards,Design

An Introduction to SQL

Oct 18, 2023 Numa Begum | www.thedataschool.co.uk

SQL stands for Structured Query Language, this is a programming language that allows the user to access and manage databases through writing commands to retrieve, modify, insert, and delete data. SQL is used across many technologies, and is widely...

Data,admin,Intro,ThoughtSpot

Alteryx Analytical Apps Common Mistakes and How to Solve Them

Oct 18, 2023 Lisa Hitch | www.thedataschool.co.uk

Alteryx’s analytical apps are a great functionality where the user can choose certain values which then change the workflow and create a customized output. For example, the user could choose a certain category or date range that filters the final ...

ThoughtLeadership,TableauDashboards,Design

What is the Purpose of Data Analysis

Oct 18, 2023 Eric Parker | onenumber.biz

Do you ever find yourself working on a data-related project and wonder “What are we doing here?”. While data-related endeavors can drive massive values, many of them are fairly directionless. Maybe there’s a top-down mandate to “become more data-d...

ThoughtLeadership,TableauDashboards,Design

The End of an Era Watch Me Vizs Decline Unveiled

Oct 17, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

That’s a wrap. Watch Me Viz has retired, for good. This week’s data was about the performance of all of the WMV livestreams. There was some incredible viewer participation, which ultimately led to this viz that explains why WMV should quietly disa...

barchart,formatting,howto,livestream,MakeoverMonday,tablecalculation,tableau,tiles,WatchMeViz,youtube

Enhancing Tableau Drill-Downs Use LODs in Hierarchies

Oct 17, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Have you ever felt your drill-downs could be more insightful? Dive into this tutorial to see the magic of LOD expressions within hierarchies. This will help us unlock deeper insights and makes data exploration even more insightful. Whether you’re ...

aggregate,calculation,disaggregate,hierarchy,howto,levelofdetail,LOD,tableau,tip

How to update your PowerPoint slides and charts using Alteryx

Oct 17, 2023 carmen.rapariz | www.theinformationlab.co.uk

Companies are often reluctant to change the way certain things are presented, especially when it comes to Excel and PowerPoint files and reports. These programs have been around for many years and most users in the firm are now somewhat used to na...

Blog,Alteryx,Excel,PowerPoint,xml

Web scrape with Power BI

Oct 17, 2023 Aurora Malinauskaite | www.thedataschool.co.uk

A handy way to explore and analyse data directly from a web page.

Data,admin,Intro,ThoughtSpot

The Ten Commandments of Scope Heaven Part 2

Oct 17, 2023 Sakif Chowdhury | www.thedataschool.co.uk

Here is the continuation of Lex’s work in part 1:

Data,admin,Intro,ThoughtSpot

The Power of Power BI

Oct 17, 2023 Hannah Bartholomew | www.thedataschool.co.uk

A 5 minute run-down of how to navigate your way around Power Query and Power BI, including key cleaning and visualization steps.

Data,admin,Intro,ThoughtSpot

Spatial Analytics in Alteryx

Oct 17, 2023 Erin Potter | www.thedataschool.co.uk

Spatial analytics is the process of incorporating location-based information into data analysis to uncover patterns, trends, and relationships that may not be apparent when examining data alone. It involves the use of geographic data such as addre...

DataPrep,Fundamentals,TechnicalFeatures,TipsTricks

SQL 101

Oct 17, 2023 Patrick Maguire | www.thedataschool.co.uk

Today, DS41 and myself got our first introduction into Structured Query Language (SQL).  SQL is a coding language used to communicate and query relational databases.

Data,admin,Intro,ThoughtSpot

Regular Expression RegEx in Alteryx - Part 1

Oct 17, 2023 Le Luu | www.thedataschool.co.uk

Regular Expression (RegEx) is very helpful when I need to clean or prepare the data. We use RegEx to match the input text based on a sequence of characters. In this blog, I am going to talk about:

Data,admin,Intro,ThoughtSpot

Power BI - Growth Change with DAX

Oct 17, 2023 Francisco Rei | www.thedataschool.co.uk

PBI DAX - How to efficiently calculate a % growth

Data,admin,Intro,ThoughtSpot

My First Makeover Monday

Oct 17, 2023 Tyler Ha | www.thedataschool.co.uk

The Prompt: Google keyword trends for the phrase “Scary Dreams” over time from 2009-present. https://data.world/makeovermonday/2023w40

Data,admin,Intro,ThoughtSpot

My First Day with Power Query Comparing Power BI to Tableau

Oct 17, 2023 Beza Taye | www.thedataschool.co.uk

My first experience with Power Query in Power BI was an eye-opener. Power BI, a tool for creating visuals, and Power Query, the powerhouse for cleaning and preparing data, opened up a world of possibilities. As I delved into this new realm, I coul...

Data,admin,Intro,ThoughtSpot

How to Add Column from Examples in Power Query

Oct 17, 2023 Dan Wade | www.thedataschool.co.uk

Power Query is a user-friendly data transformation tool in Microsoft Excel and Power BI. “Add Column from Examples” simplifies data preparation by allowing users to create new columns based on examples they provide, especially helpful for beginners.

Data,admin,Intro,ThoughtSpot

Explain or allow to explore

Oct 17, 2023 Aurora Malinauskaite | www.thedataschool.co.uk

An overview of exploratory and explanatory formats for dashboard design.

Data,admin,Intro,ThoughtSpot

Data Cleaning and Visualization Showdown Tableau vs. Power BI

Oct 17, 2023 Yoan Caboste | www.thedataschool.co.uk

Tableau Prep + Tableau Desktop clean and visualize data seamlessly, while Power Query + Power BI offer a Microsoft-integrated alternative for data transformation and visualization. Choose the combo that fits your needs and tech stack.

Data,admin,Intro,ThoughtSpot

Conditional Column in Power Query for Beginners with Example

Oct 17, 2023 Faith Rotich | www.thedataschool.co.uk

The importance of the order of conditions in Power Query.

Data,admin,Intro,ThoughtSpot

Common Interface Tools for Apps in Alteryx

Oct 17, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

What is an Analytic App?

Data,admin,Intro,ThoughtSpot

Column From Examples- The BeeIs Knees

Oct 17, 2023 Harvey Joyce | www.thedataschool.co.uk

Data transformation doesn’t have to be a daunting task. Power Query’s ‘Column from Examples’ tool streamlines the process and cuts out the hassle!

Data,admin,Intro,ThoughtSpot

Basic Alteryx Spatial Tools to prepare your data for further analysis

Oct 17, 2023 Jun Hou Kok | www.thedataschool.co.uk

If you’ve ever had to work with maps or location-based data, chances are you’ve probably analyzed and/or visualized that type of data.

Data,admin,Intro,ThoughtSpot

ML in Snowflake with Snowpark for Python

Oct 17, 2023 Azucena Coronel | interworks.com

Earlier this year, Snowflake announced the availability of Snowpark ML during its Snowflake Summit. Snowpark ML is a set of tools, including SDKs and underlying infrastructure, to build and deploy machine learning models; all within Snowflake. It ...

Data,machinelearning,ML,python,Snowflake,SnowPark