InterWorks Earns 2 ThoughtSpot 2023 Partner of the Year Awards

Oct 26, 2023 Garrett Sauls | interworks.com

Our friends at ThoughtSpot just made a huge announcement concerning their partner ecosystem, and we’re thrilled to share that InterWorks earned two ThoughtSpot Partner of the Year awards for 2023: ThoughtSpot Americas Emerging Partner of the Year ...

News,awards,EMEA,PartneroftheYear,ThoughtSpot,USA

Can you create a dynamic small multiple chart

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

For this week’s #WOW2023 challenge, Lorna asked us to recreate this small multiple (or trellis) chart which organises the time series charts per Sub-Category into a grid format, where the number of columns is determined by the user. Whenever I nee...

WorkoutWednesday,WOW2023,Atthelevelof,ATTR,DualAxis,INDEX,LAST,LineChart,SmallMultiples,TableCalcs,transparentshape,TrellisChart,Week43

How many lines are too many

Oct 26, 2023 Steve Wexler | www.datarevelations.com

And how many colors are too many, too? Overview There are a lot of ways to show measures over time for multiple categories. I want to explore what works, when it works, and make sure that a particular technique catches your interest. But first… a ...

BusinessVisualizations,Makeovers,linechart,smallmultiples,trellischart

Why you should document your Cleaning Steps in Power Query

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

In this tutorial find out why should we document our cleaning steps? How do you keep track of your data cleaning steps? And more..

can-bus,data-engineering,tesla,foxglove,ros2

Web scraping in Alteryx

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

There are many ways to retrieve data from the web, one way is using the download tool in alteryx. Other ways which might be simpler are using python, google sheets or online resources which will webs crape for you. One more thing before we get int...

can-bus,data-engineering,tesla,foxglove,ros2

Web Scraping on Alteryx Designer

Oct 25, 2023 Abby Poon | www.thedataschool.co.uk

Web scraping is a technique used to extract useful information from websites programmatically. It involves retrieving information from web pages by making HTTP requests to the web server, downloading the HTML content of the web page, and then pars...

can-bus,data-engineering,tesla,foxglove,ros2

WHAT IS REGEX

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

An introduction to RegEx, and how to use it in your Alteryx flows

can-bus,data-engineering,tesla,foxglove,ros2

The Order Of Operations - Tableau Style

Oct 25, 2023 Randee Johnson | www.thedataschool.co.uk

Please Excuse My Dear Aunt Sally…

can-bus,data-engineering,tesla,foxglove,ros2

Regular Expression RegEx in Alteryx - Part 2

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

Welcome back if you are from Regular Expression (RegEx) in Alteryx - Part 1. In part 1, I introduced the qualifiers, quantifiers, and 4 main output methods (Replace, Tokenize, Parse, Match) in the RegEx tool of Alteryx. To continue part 1, I am go...

can-bus,data-engineering,tesla,foxglove,ros2

How to create a table using SQL

Oct 25, 2023 Abby Poon | www.thedataschool.co.uk

To create a table in SQL, you can use the CREATE TABLE statement. Here’s the basic syntax for creating a table:

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

How to collect data from an API using Alteryx

Oct 25, 2023 Abby Poon | www.thedataschool.co.uk

What is API?

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

How to Setup TabPy in Tableau to Supercharge Your Data Analysis

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

Have you ever thought about what you do in Tableau if you were able to integrate powerful Python scripts into your analysis? That’s where TabPy comes into play. TabPy (the Tableau Python Server) is an Analytics Extension implementation that expand...

can-bus,data-engineering,tesla,foxglove,ros2

How to PIVOT and UNPIVOT tables using SQL

Oct 25, 2023 Abby Poon | www.thedataschool.co.uk

In SQL, Pivot and Unpivot serve as relational operators employed to reshape one table into another, aiming to create a more streamlined table view. In conventional terms, the Pivot operator restructures the data from rows in the table into columns...

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

How to Make this Graph in PBI...

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

How to make an adjustable bar chart based on setting a parameter.

can-bus,data-engineering,tesla,foxglove,ros2

GDPR Principles

Oct 25, 2023 Adam Sultanov | www.thedataschool.co.uk

Echoing my last blog post, I’d like to talk about principles of the GDPR (General Data Protection Regulation), and why we should adhere to them. Introduced in 2018, the GDPR is European legislation that is enforced in the European Union and Europe...

can-bus,data-engineering,tesla,foxglove,ros2

Cleaning dates in Power Query - A lesson in thinking like a computer

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

Rather than expressing your desired output, you must convey the original format – the language the data speaks – to help the computer make sense of it all.

can-bus,data-engineering,tesla,foxglove,ros2

Building an Analytics App in Alteryx

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

Coming from a non-coding background, thinking about building an app certainly freaks me out a little. Fortunately, Alteryx has built in tools that will help you exactly with that.

can-bus,data-engineering,tesla,foxglove,ros2

Collecting CAN Bus Data with ROS2 and Qt

Oct 25, 2023 Tamas Foldi | medium.com

One obvious way to learn something new is to use stuff you already have. This was my thinking when I decided to invest my time in learning sensor fusion at the edge — more precisely, performing sensing and perception in ROS2 to see how...

can-bus,data-engineering,tesla,foxglove,ros2

Why does my percent of total add to more than 100

Oct 25, 2023 Ollie Linley | onenumber.biz

Sometimes we want to calculate the percent of total of a variable, but those totals add up to over 100%! What’s going on?

TableCalculations

Master Containers Build an Interactive Tableau Dashboard From Scratch

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

In this video you will learn step-by-step how to create an interactive Tableau dashboard. We’ll start with a 2 datasets:1. Beverage sales2. Custom shape for US statesI will show you how relationships work in Tableau to combine these two datasets.O...

barchart,charts,containers,dashboard,data,filters,graphs,howto,interactive,KPI,layout,linechart,map,parameter,relationships,tableau,timeseries

What did it take to get into DSDE5

Oct 24, 2023 Peter Gamble-Beresford | www.thedataschool.co.uk

DSDE5 are in the final week of the training period! As we look to congratulate them on completing their training, and welcome our next cohort, let’s take a look at what our current Consultants submitted when they were applying to join us.

Dashboards,Storytelling,TipsTricks,UserExperience

The SQL Hierarchy

Oct 24, 2023 Myles Stevenson | www.thedataschool.co.uk

When Coding in SQL there is a hierarchy that’s important to remember.

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

The Greatest Company Ever Tag 2 Dashboardwoche

Oct 24, 2023 Tobias Fitschen | www.thedataschool.co.uk

Der heutige Dienstag wird Tag 2 der Dashboardwoche gewidmet. Das Ziel ist es ein Power BI KPI Dashboard zu produzieren, dieses zu veröffentlichen und selbstredend einen Blog zu schreiben. Gestern war es noch Tableau und Alteryx, heute Power BI. Es...

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

The Core of the Matter Prepping for the Alteryx Designer Core Certificat...

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

The Alteryx Designer Core certification exam is worth doing, and you can beat it by following these steps to prepare.

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

The Basics of RegEx

Oct 24, 2023 Alexander Wood | www.thedataschool.co.uk

Here you can find the basics of how to use RegEx. RegEx is a powerful way of allowing us to work with strings, it gives us the ability to be precise and extract particular parts of a string. Within this blog you will find cheat sheets and also a f...

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Tackling the Tableau Data Analyst Exam Part 3

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

Another blog, another Tableau Data Analyst Exam practice question for us to sink our teeth into.

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Tackling the Tableau Data Analyst Exam Part 2

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

Welcome to blog #2 of my Tableau Data Analyst Exam mini-series. The question we will look into in today’s blog focuses in on Moving Averages and how we can utilise them in Tableau Desktop.

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Tackling the Tableau Data Analyst Exam Part 1

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

As my date with the Tableau Data Analyst Exam edges closer and closer, I’ve decided to document some interesting questions that come up in practice. Hopefully these blogs can help others prepare for the exam as well as consolidate some of my own l...

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Quick Dirty A Quality Analysis Dashboard in Power BI

Oct 24, 2023 Matthias Albert | www.thedataschool.co.uk

Today’s task has been to build a KPI dashboard using Power BI and one of the sample datasets found here. Let me share with you how that went down.

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Getting Started with APIs

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

An API stands for an application programming interface. It is a pipeline to get data easily from a server. There are many different types of APIs, however in this blog we will just focus on REST APIs.

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Dashboard Week - First Day

Oct 24, 2023 Ali Fawwaz | www.thedataschool.co.uk

Here we come to the last week of the Data School training journey. It is the dashboard week.

Dashboards,Storytelling,TipsTricks,UserExperience

Dashboard Week Day 2

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

Eigentlich ist es ähnlich, wie gestern gelaufen. Mein Zeitplan war äußerst bescheiden, obwohl diesmal kein Data Prep notwendig war. Mein Sketch hatte ich bereits erfolgreich skizzieren können und meine Aufgabe war klar umrahmt! Trotzdem habe ich m...

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Crafting Your GitHub Persona Building Your Profile and Adding Your Chara...

Oct 24, 2023 Michael Bellamy | www.thedataschool.co.uk

When I first started using GitHub I found it very technical and intimidating and I still do. These days I find it a little easier to navigate and publish projects on the platform so I thought it would be cool to create a guide to creating a portfo...

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Connecting to an API in Alteryx

Oct 24, 2023 Myles Stevenson | www.thedataschool.co.uk

What are Api’s?

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Chained Apps in Alteryx

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

Have you ever wanted to use the output of a first app as the input in a second app? Well this is exactly what you need!

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

APIs in Alteryx

Oct 24, 2023 Alexander Wood | www.thedataschool.co.uk

This blog is running through the steps that we took to learn what and how to use an API. For the blog I showed how to use an API in Alteryx but the same steps can be followed in PowerBI and Tableau Prep.

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

APIs

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

API means application programming interface. An API is a pipeline to access data from a server. You can use them to communicate with databases, companies often provide APIs to their partners so the company can select what data their partner can ac...

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

From Space to Database Real-Time ISS Tracking Using Kafka and Snowpipe i...

Oct 24, 2023 Fadi Al Rayes | interworks.com

Ever tracked astronomical objects at a planetarium, watched real-time flights via Flightradar24 or followed your pizza delivery make its way to your door? Each of these experiences relies on the magic of streaming data, specifically benefiting fro...

Data,Apache,datastreaming,Kafka,Snowflake,Snowpipe

Creating a Day Trading Strategy in Tableau

Oct 24, 2023 Gavin Holzworth | interworks.com

Note: InterWorks is not a financial institution. This is not financial advice. Please consult a financial expert before making any major financial decision. If you’re like me, you enjoy both financial assets and data analytics in Tableau. Have you...

Data,DayTrading,Tableau

Tableau - Parameter Actions

Oct 23, 2023 Alexander Wood | www.thedataschool.co.uk

Dashboard interactivity can be a great way of getting the user to really rely and use the dashboard. It also provides them with the opportunity to dive deeper into aspects of the data that they find interesting. Here is how to set a parameter acti...

Dashboards,Storytelling,TipsTricks,UserExperience

SQL - Pivoting and Unpivoting data

Oct 23, 2023 Alexander Wood | www.thedataschool.co.uk

Helping to better show how data transformations can be done in SQL. Specifically this blog aims at showing how to Pivot and Unpivot your data. This is such a useful technic to master as it is an essential aspect of the data cleaning and preparatio...

Dashboards,Storytelling,TipsTricks,UserExperience

SQL Fundamentals

Oct 23, 2023 Alexander Wood | www.thedataschool.co.uk

This blog aims to help you better understand how to use SQL and just as importantly better document your work. It makes the world of difference when you have documentation that is easy to understand. You can refer back to it in the future or make ...

Dashboards,Storytelling,TipsTricks,UserExperience

From Plan to Product in 1 Day Webscraping Bundesliga.com

Oct 23, 2023 Matthias Albert | www.thedataschool.co.uk

The task today is to scrape data from bundesliga.com dating back at least 20 years and create some meaningful visualizations with the data. To achieve that, 3 things are needed:

Dashboards,Storytelling,TipsTricks,UserExperience

Data Discovery

Oct 23, 2023 Alexander Wood | www.thedataschool.co.uk

Data discovery has really helped me when it comes to working on client projects. It’s a great opportunity to understand what the data I have actually is and if it is suitable for the analysis that I have been tasked with.

Dashboards,Storytelling,TipsTricks,UserExperience

Dashboard Woche Tag 1

Oct 23, 2023 Tobias Fitschen | www.thedataschool.co.uk

In der letzten Woche des Trainings geht es noch einmal zur Sache. Ziel ist es jeden Tag ein Dashboard zu entwerfen und gegebenenfalls Daten zu präparieren. Heute an Tag 1 war die Aufgabe mindestens 20 Jahre Daten der Fußball Bundesliga zu webscrap...

Dashboards,Storytelling,TipsTricks,UserExperience