InterWorks’ Tableau Conference 2023 Primer

May 8, 2023 Garrett Sauls | interworks.com

Whether you’re currently picking up your badge in Las Vegas or anxiously awaiting the livestream, Tableau Conference 2023, a.k.a. #data23, is officially here! Buckle up for a few days packed full of jaw-dropping Tableau updates, fantastic breakout...

Uncategorized

A Guide to Embedding Tableau # 2-- Embed Examples

May 8, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

The previous blog in this series, A Guide to Embedding Tableau # 1: A Primer on Embedding, introduced you to the concept of embedding, defined someimportant terms, discussed the primary methods we’ll be using, and discussed afew common scenarios. ...

How-To,Series--GuidetoEmbeddingTableau,Tableau,Templates

Writing comments into your calculations (Tableau Tip #5)

May 6, 2023 Shreya Arya | www.thedataschool.co.uk

Adding comments into your calculations can help improve the overall clarity and understanding of your work.

Tableau Conference 23 – Live Experience

May 6, 2023 Ryan Alexander | interworks.com

The post Tableau Conference 23 – Live Experience appeared first on InterWorks.

Data,conference,Event,liveblog,Tableau

Intro to SQL CTEs

May 5, 2023 Edward Hayter | www.thedataschool.co.uk

In our 3rd SQL session we covered Common Table Expression (CTEs). We can think of CTEs as temporary tables created for use in a SQL query. We use CTEs to breakdown longer queries into a structure that is easy to logically follow and debug. By maki...

Data,BI,Governance,TheBICantos

Alteryx Core Certification Reflection and Tips

May 5, 2023 George Ledger | www.thedataschool.co.uk

Today I took the Alteryx Core Exam for the first time and thankfully passed with 89% which made me very happy and showed myself that hardwork paid off.

Data,BI,Governance,TheBICantos

The BI Cantos: Establishing a Governance Framework

May 5, 2023 Dan Murray | interworks.com

In the last post, I provided guidelines on security and preventing unauthorized access to your data. I warned you that an overly restrictive security model could encourage bad behavior. BI system security is like my wife’s purse. I might want to l...

Data,BI,Governance,TheBICantos

Can you combine relative and custom date filters?

May 5, 2023 Donna Coles | donnacoles.home.blog

For this week’s challenge, Kyle revisited a previous challenge from 2020, but remade it over utilising some of the newer features of Tableau, specifically Dynamic Zone Visibility. I blogged my solution to the original challenge here, so this blog ...

Tableau Techniques for Top Notch Spatial Analytics

May 4, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Looking to level up your data visualization skills? Enjoy this live stream from the April 2023 Analytics Tableau User Group (TUG) where I dive deep into spatial data analysis in Tableau!In this session, I will walk you through the process of impor...

airlines,analytics,distance,emoji,howto,lines,London,mapping,path,rats,routes,shape,shapefile,spatial,tableau,tug,video

Tile Maps in Tableau and When to Use Them!

May 4, 2023 Tanbir Jalil | www.thedataschool.co.uk

A tile map is a type of map you may well have come across on tableau public. A tile map turns each region in the map into the same dimensions. For example, a US tile map may turn each state into a hexagon of equal dimensions. And this blog will co...

Data,BI,security,TheBICantos

The Day-to-Day of a Data Schooler in Training

May 4, 2023 Elaine Yuan | www.thedataschool.co.uk

Last week at an informational session, someone asked me about the day-to-day at the Data School - particularly, what does training look like? Great question! For those interested in joining the Data School, this one’s for you!

Data,BI,security,TheBICantos

How to make a Pea in a Pod Chart - Tableau

May 4, 2023 Habeeb Gayle | www.thedataschool.co.uk

The pea in a pod chart is a chart used to visualize the change between multiple data points. It is typically used to illustrate the change or compare the difference between two data points, but can also be used for more.

Data,BI,security,TheBICantos

#HowTo - Create a Connected Dot Plot (Peas in a Pod)

May 4, 2023 Trea McElhone | www.thedataschool.co.uk

In this #HowTo, I will be walking you through how to make a connected dot plot, also know as a peas in a pod chart, in Tableau Desktop - with this walkthrough demonstrating how they can can be used as a timeline.

Data,BI,security,TheBICantos

The BI Cantos: Understanding Security Considerations

May 4, 2023 Dan Murray | interworks.com

Security and data governance are often treated as the same thing. They aren’t. Security is about preventing unauthorized access. Governance is making it easier for people to find the information they need. One is about prevention, and the other is...

Data,BI,security,TheBICantos

Set Actions Guide

May 3, 2023 George Ledger | www.thedataschool.co.uk

I am writing a quick guide on the Set/Parameter Actions pane and what each part does.

TableauCalculations,TableauSets

Difference in Sales using LOD's vs Table Calculations

May 3, 2023 Reshika Chilakapati | www.thedataschool.co.uk

A session with Erica Hughes on advanced Table and Level of Detail Calculations showed us how to build the same chart using two different techniques. Before learning these, remember to read my blog on the difference between Table Calculations and L...

TableauCalculations,TableauSets

Client Projects - Initiation Phase &

May 3, 2023 Amelia Holland | www.thedataschool.co.uk

During training, your cohort is expected to complete 8 Client projects. These are free to the client and provide an amazing opportunity to utilize our newly taught skills in real-world scenarios. Each project is a week in length, starting on the M...

TableauCalculations,TableauSets

Use Multi-Select Sets in Tableau Calculations

May 3, 2023 Eric Parker | onenumber.biz

Did you know you can reference Tableau Sets in calculations? Most Tableau users don’t.

TableauCalculations,TableauSets

The BI Cantos: Training Your Team

May 3, 2023 Dan Murray | interworks.com

If you skimp on training, you may burn every penny you save later in the project when it’s inconvenient and more costly. Even your expert team members need training and time to become confident in their skills and knowledge of new tools and method...

Data,BI,ProfessionalDevelopment,TheBICantos,Training

Table Calculations and LOD's

May 2, 2023 Lorenz Nacilla | www.thedataschool.co.uk

Table Calculations and LOD’s can be very useful for providing extra analysis with your data. In this blog, I will briefly show you how these techniques can be performed and what you can do with them.

Uncategorized,Alteryx,AlteryxDesigner,datablending,datapipeline,dataprep,ELT,ETL,Matillion

The BI Cantos: Releasing Your First Dashboards

May 2, 2023 Dan Murray | interworks.com

Most people in your company are not database experts. They are interested in something other than databases and ELT programs. They want information that supports their work needs. Human beings are visual creatures, and interactive dashboards are v...

Data,BI,dashboards,TheBICantos

How To Use Tableau Repository to Monitor Your Tableau Server

May 2, 2023 Gheorghe Ghidiu | interworks.com

Looking to optimize your Tableau Server? If you are reading this, you are most probably on the right path. But how do you know where to start? Just like our health, before any treatment can be prescribed, a diagnosis is required. When it comes to…...

Data,Tableau,tableaurepository,TableauServer

Choosing Data Pipeline Tools: Matillion or Alteryx Designer

May 2, 2023 Colin Murray | interworks.com

What are the differences or similarities between Matillion and Alteryx Designer? Both Matillion and Alteryx are popular low-code/no-code tools that help with data transformation and integration, so it’s no surprise we have to clarify these two too...

Uncategorized,Alteryx,AlteryxDesigner,datablending,datapipeline,dataprep,ELT,ETL,Matillion

Small Changes That Make Big Impacts

May 1, 2023 Reshika Chilakapati | www.thedataschool.co.uk

This week’s project involved recreating an old dashboard from Andy Kriebel and making small changes to it. Only until this week, I have never used containers or even the tiled option to design my dashboard. However, a design and layout lesson with...

Data,BI,POC,ProofofConcept,Sprint,TheBICantos

Making a running total in Alteryx using the Multi-Row Formula Tool

May 1, 2023 Ross Killington | www.thedataschool.co.uk

This blog demonstrates step by step how to create a basic running total column in Alteryx using the Multi-Row Formula to carry out a row by row calculation where the current row value is added to the sum of the previous row values.

Data,BI,POC,ProofofConcept,Sprint,TheBICantos

Making a custom distribution for mock data using Alteryx Tools

May 1, 2023 Ross Killington | www.thedataschool.co.uk

In this blog I will show you how to generate rows with a specific distribution set to your preferences. This process involves various Alteryx tools such as: Text Input, Summarize, Append, Formula, Generate Rows and Join.

Data,BI,POC,ProofofConcept,Sprint,TheBICantos

Adding missing dates in Alteryx using the Generate Rows tool

May 1, 2023 Ross Killington | www.thedataschool.co.uk

In this blog I will demonstrate how to fill in missing date rows in a time series data set where you need at least a row for every date.

Data,BI,POC,ProofofConcept,Sprint,TheBICantos

The BI Cantos: Planning a Proof-of-Concept Sprint

May 1, 2023 Dan Murray | interworks.com

The plans, quotes and project deliverables your selected consulting partner helped you develop should include a proof-of-concept project recommendation based on your combined due diligence. The proof-of-concept (POC) sprint is a crucial subproject...

Data,BI,POC,ProofofConcept,Sprint,TheBICantos

A Guide to Embedding Tableau # 1-- A Primer on Embedding

May 1, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

Thisis a blog I’ve been wanting to write for quite a while, but I’ve admittedlybeen very hesitant to do so. Why? Because the fact is that embedding requiresquite a bit of programming knowledge and, while I was a programmer many yearsago, I’m just ...

How-To,Series--GuidetoEmbeddingTableau,Tableau,Templates

Adding a custom colour palette to Tableau Desktop (Tableau Tip #4)

Apr 29, 2023 Shreya Arya | www.thedataschool.co.uk

Did you know that you can add custom colour palettes to Tableau by editing your “Preferences” file? Here’s how…

ChartTypes,sankey,Tableau

How to Create a Sankey Diagram in Tableau Public

Apr 29, 2023 Marc Reid | datavis.blog

For a limited time, you can now create a Sankey diagram in Tableau Public in under 10 seconds with just a few clicks. Learn more in this step-by-step blog post.

ChartTypes,sankey,Tableau

How to Make a Mobile Splash Page in Tableau

Apr 28, 2023 Rafael Simancas | playfairdata.com

As creators, splash pages can serve to inform dashboard users of something that may affect their journey. In the case…The post How to Make a Mobile Splash Page in Tableau appeared first on Playfair Data.

Dashboards,Tips&Tricks,UserExperience

How to Create a Multi-Row Formula in SQL (Because Tableau Can't)

Apr 28, 2023 Eric Parker | onenumber.biz

I was recently working with a client when we hit a roadblock. We came across a situation where we needed to create a multi-row formula and Tableau Desktop is not equipped to do that. Let me walk you through the situation.

Data

The BI Cantos: Building Data Workflows and Best-of-Breed Solutions

Apr 28, 2023 Dan Murray | interworks.com

Data workflows are like hiking boots — good-fitting ones can take you anywhere. Ill-fitting ones spawn misery. As you document the existing workflows in discovery meetings, these details will influence your software selections — the tools for the ...

Data,BI,cloud,data,TheBICantos

5 IT Tips for New Businesses

Apr 28, 2023 Todd Walls | interworks.com

After working in the IT Managed Services industry for over 18 years, particularly in medium and small business markets, I’ve come across businesses of all shapes and sizes.  The underlying goal has always been simply to keep business processes up ...

IT,NewBusinesses,TipsandTricks

The Value and Variations of Jitter Plots

Apr 27, 2023 Elaine Yuan | www.thedataschool.co.uk

A Possible AnswerThe top visualization, AVG DANCEABILITY BY GENRE, is a jitter plot and the bottom left visualization, DANCEABILITY VS POPULARITY is a scatter plot.

Data,BI,Discovery,Meetings,TheBICantos

Quick LODs

Apr 27, 2023 Ozlem Sigbeku | www.thedataschool.co.uk

If you’re in a rush while making a dashboard, maybe you forgot your mum’s birthday and want to build her a quick dashboard or maybe your boss is upset you haven’t done any work for 6 months and you want to create a dashboard to distract them from ...

Data,BI,Discovery,Meetings,TheBICantos

Building a Control Chart in Tableau with Table Calculations

Apr 27, 2023 Edward Hayter | www.thedataschool.co.uk

A control chart can be an effective way of analyzing whether a process is being executed effectively over time. Drawing emphasis to points in time where a process is either over-performing or under-performing relative to a constant measure or rela...

Maps

Bench times two

Apr 27, 2023 Ozlem Sigbeku | www.thedataschool.co.uk

What has your favorite blogger been up to? What is bench and how has it been?

Uncategorized,Alteryx,AlteryxDesigner,datablending,datapipeline,dataprep,ELT,ETL,Matillion

User-Centered Dashboard Development: Maintain

Apr 27, 2023 Kendra Allenspach | interworks.com

If you’re new to User-Centered Dashboard Development (UCDD), please check out the earlier posts in this series (also found at the bottom of this post) to get acclimated, then come back here! We’re almost to the end of our UCDD Framework and today ...

Data,projectmanagement,UCDD

The BI Cantos: Conducting Discovery Sessions

Apr 27, 2023 Dan Murray | interworks.com

An essential part of any business intelligence system plan is to collect information on the vital data workflows within your company. An ounce of discovery is worth a pound of remediation. -Adapted from Benjamin Franklin During discovery, identify...

Data,BI,Discovery,Meetings,TheBICantos

Custom Map Analysis

Apr 27, 2023 Donna Coles | donnacoles.home.blog

For the final week of Community Month, my colleague, Nik Eveleigh, posed this challenge to apply some tricky filters to a map. Let’s dive straight in! Identifying the States and Profitability The core functionality of the map display is driven by ...

Web-scraping in Alteryx

Apr 26, 2023 Edward Hayter | www.thedataschool.co.uk

We recently had a session on how to web-scrape in Alteryx and this blog is intended to outline the process of how to do it. Firstly, it is worth pointing out that web-scraping comes with two caveats; when web-scraping material we should make sure ...

Maps

#How to - Change the order of a stacked bar chart

Apr 26, 2023 Amelia Holland | www.thedataschool.co.uk

This blog will show how to reorder your bar chart by selecting a category:

Maps

Fundamentals: Dashboard design

Apr 26, 2023 Muhammad Choudhury | www.thedataschool.co.uk

When creating a dashboard, there are several fundamental principles in to follow to make the dashboard easy to understand and navigate.

Maps