Dashboard Week - 1. Dashboard

Jul 22, 2024 Leonardo Ceballos | www.thedataschool.co.uk

As a tribute to Johnny Depp’s remarkable film career, I created a Tableau dashboard that digs into the various aspects of his movies. This project aims to provide insights into his filmography, highlight key statistics, and explore trends over tim...

Data,Snowflake

Calculations in SQL and Tableau - Part 1

Jul 22, 2024 Le Luu | www.thedataschool.co.uk

I wrote a blog about comparing the calculations between Power BI and Tableau. In 2 blogs, I shared how to write DAX in Power BI and compare it with the calculations in Tableau through some use cases (Part 1, Part 2). In this blog, I will share som...

Data,Snowflake

Are You Choosing the Right Chart

Jul 22, 2024 Dillon Thomas | www.thedataschool.co.uk

When figuring out which charts to use on a Tableau viz there’s definitely different ways to achieve the same goal, but there is also a right vs wrong we have learned. You can make the viz look beautiful, but every chart has a time and a place. For...

Data,Snowflake

Exploring Random Number Generation in Alteryx Techniques and Applications

Jul 22, 2024 Sophia Kohn | playfairdata.com

Random Number Generation (RNG) as the name suggests, is a useful tool that generates a random number, and can provide…The post Exploring Random Number Generation in Alteryx: Techniques and Applications appeared first on Playfair Data.

Alteryx,DataPrep,Intermediate,TechnicalFeatures

Collaborative Communication Tips for Visual Analytics Architects Designers

Jul 22, 2024 Conor Caldwell | playfairdata.com

Working in team settings can be challenging. Coordinating schedules, balancing multiple opinions, and ensuring clear communication are already demanding. Managing…The post Collaborative Communication Tips for Visual Analytics Architects (Designers...

Design,Fundamentals,TipsTricks

A Guide to Power BI Desktop for Tableau Developers

Jul 22, 2024 Wesley Cannatti | interworks.com

You may have the job title of data analyst, or you may work in HR or sales. Regardless, the versatility of modern data visualization tools allows everyone access to self-serve analytics. If you already have Tableau experience but are interested in...

Data,Guides,PowerBI,Tableau

Ten Tips Techniques Round 8

Jul 22, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

      Alright, I am back with 10 more Tableau Tips and Techniques. Be sure to check out the entire series on our website. Many of our tips in this blog post will focus on speed…just some quicker ways of doing things in Tableau.1. Quick...

SeriesTips

Normalizing Values in PBI

Jul 19, 2024 Alfie King | www.thedataschool.co.uk

When working on a project, I had the Idea that a Radar Chart would be extremely beneficial to the story I wanted to tell. To create a radar chart with all of the points representing different categories all with different scales, I had to normaliz...

Data,Snowflake

Tips from Assist Tableau Map Layers Disappearing

Jul 19, 2024 Lindsey Ison | interworks.com

Customer Question: “When I’m using filters on my map visualization, if the filter returns null values for any state, that state disappears from the map. How can I make a map that will show state outlines even when there’s no data?” There are, as w...

Data,Assist,Maps,Tableau

Creating a Data Governance Framework That Drives User Adoption

Jul 19, 2024 Dan Murray | interworks.com

In this six-part series, we’ve discussed the adoption history, planning a BI Rollout, decentralizing ownership of data workflows and operational definitions of key terms like data governance, data lineage and data provenance. We discussed change m...

Data,data,DataGovernance

Formatting Intermediate Tableau Charts

Jul 19, 2024 Donna Coles | donnacoles.home.blog

Erica set this challenge primarily aimed at building a beautifully presented dashboard, with the requirement to consider the use of layout containers and padding. She threw in creating some very specific chart types too. The easiest way to blog th...

WorkoutWednesday,WOW2024,Bar,DotPlot,Formatting,Histogram,LayoutContainers,Line,Lozenge,Padding,Path,Slope,Week29

Harnessing Power BI Buttons for Interactive Insights

Jul 18, 2024 Troy Schuh | interworks.com

In the following example, users can switch between a line chart displaying Sales by Month and a bar chart for Sales by Region by clicking a button:  This interactive feature was developed in Power BI. The same functionality can be accomplished in ...

Data,PowerBI

Business Intelligence System Maintenance

Jul 18, 2024 Dan Murray | interworks.com

An issue and an opportunity for nearly every existing business intelligence system is keeping it running well and minimizing costs.   Cloud-based software makes it easy to spin up a data warehouse or a data lake, use data transformation tools, cre...

Data,BusinessIntelligence,data

Change Management for Improved Profits

Jul 17, 2024 Dan Murray | interworks.com

Business intelligence software which includes databases, data transformation tools and software for searching and presenting interactive reports, as dashboards have been around for 25 years. In the last ten years, these tools have become easier to...

Data

What is Data Governance

Jul 16, 2024 Dan Murray | interworks.com

Often, discussions about data governance begin and end with security. Preventing unauthorized access or the loss of proprietary data is crucial. Data governance also ensures that your data systems comply with regulatory requirements and protect pr...

Data,data,DataGovernance

An Introduction to Snowflakes Marketplace

Jul 16, 2024 Sripriya Vemula | interworks.com

This article intends to provide a brief overview of what all the talk about Snowflake Native Apps Marketplace is about, how organizations can utilize the space to monetize their offerings, and how consumers can benefit from these third-party off-t...

Data,Marketplace,Snowflake

Using the Tableau Output Tool and Resolving Common Errors

Jul 15, 2024 Luke Bennett | www.thedataschool.co.uk

Whether you’re trying to get familiar with the Tableau Output tool or trying to troubleshoot an error that’s come up, this blog provides an overview of the tool’s settings and recommendations for resolving errors. The first section goes over the t...

Data,data,strategy,SVR

How to create a Plum Pudding Chart in Tableau

Jul 15, 2024 Lorraine Ferrusi | www.thedataschool.co.uk

A plum pudding is a traditional British dessert usually served on Christmas dinner. It’s a dome shaped cake-like sweet desert with fruit pieces on the inside. In the early 1900 the plum pudding made its way into science when it was proposed as a m...

Data,data,strategy,SVR

Bayesian Statistics The Fun Way - Book Review

Jul 15, 2024 Bruno Gasparotto Ponne | www.thedataschool.co.uk

With the new acquisitions for the library at The Data School in Hamburg, I was lucky to be able to choose one of the new books. For a long time, I have heard about the term “Bayesian statistics” but never fully understood what it means and how we ...

Data,data,strategy,SVR

Planning a Business Intelligence System

Jul 15, 2024 Dan Murray | interworks.com

Selecting business intelligence software and planning a rollout is a significant undertaking. The real work should begin well before you start selecting software. You must comprehensively assess your entire organization’s information needs, wants ...

Data,data,strategy,SVR

Building a Data Culture Through Effective Planning Governance and Measur...

Jul 12, 2024 Dan Murray | interworks.com

Executives understand the value of high-quality, timely information. When asked why they invested in business intelligence software, they can cite examples that explain how their investments paid off. Most feel the paybacks achieved justify their ...

Data

Can you design a multi-dimensional Panel Chart for detailed analysis

Jul 12, 2024 Donna Coles | donnacoles.home.blog

Yusuke set this week’s challenge which is pretty tough-going. I got there eventually, but it wasn’t smooth sailing, and had a lot of false starts and changes to calculations throughout to get to the end. I will endeavour to explain where I had dif...

WorkoutWednesday,WOW2024,DualAxis,Fixedsize,INDEX,LOOKUP,parameter,SIZE,TableCalcs,Week28,Window_Max

SQL Joins

Jul 11, 2024 Le Luu | www.thedataschool.co.uk

Join and Union is usually used in SQL queries to combine 2 or more data sources. I wrote one blog before to summarize all types of join. If you haven’t read it yet, you can read it here. In that blog, I divide types of join into 4 groups: Outer Jo...

Data,data,strategy,SVR

Power BI DAX Iterator Functions Guide

Jul 11, 2024 Wesley Cannatti | interworks.com

DAX Iterator functions are a subset family of aggregator functions used to iterate over a table of rows. First, they evaluate an expression for each row in a table. Then they apply some form of aggregation to the row-level results of the first exp...

Data,DAX,iterator,PowerBI

My First Attempt at Visual Storytelling in Tableau

Jul 11, 2024 Kartikaya Srivastava | interworks.com

This article reflects on my attempt at transforming a previously created Tableau dashboard. This transformation was greatly influenced by the insights gained from the excellent two-week Tableau data visualization training provided to me as a BI in...

Data,Dashboarding,datavisualization,Tableau,TableauDesktop,TableauTraining

InterWorks Causes Special Olympics Oklahoma

Jul 11, 2024 Robby White | interworks.com

As I’ve touched on in prior posts, being involved with important causes in our local communities is one of the things that makes InterWorks a special place to work for. There are plenty of company-organized opportunities lined up throughout the ye...

Culture,InterWorksCauses,SpecialOlympics,volunteering

How to Set Up Tableau Pulse

Jul 10, 2024 Ollie Linley | onenumber.biz

Let’s take a look at Tableau Pulse!

TableauServer

Interworks Blog Roundup June 2024

Jul 10, 2024 Mark Cordeiro | interworks.com

Hey, there, party people! Hope you all had an amazing June. We’re halfway through the year. Hope you all have been keeping up with your New Year’s Resolutions. (Didn’t think we’d remember that, did you?) We had some great blogs out in June, so we…...

Data

How to Build a Report in Power BI Desktop

Jul 10, 2024 Robby White | interworks.com

Getting started in the Power BI Desktop application is a fun and exciting time. There are so many components that make up this masterful business intelligence tool, that at first glance it can appear a bit overwhelming.  Not to fret.   The good ne...

Data,PowerBI,Report

Querying Stock Data with an API Query Profile in Matillion ETL

Jul 9, 2024 Chris Hastie | interworks.com

Matillion ETL is a GUI-based orchestration and transformation tool for data movement that has many functionalities, including querying external data via API. There are three primary ways to query this data from Matillion ETL: Create a custom Pytho...

Data,Matillion,MatillionETL

Build an interactive Tableau dashboard in 3 minutes

Jul 8, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Build 80% of your dashboards with these 4 charts, a bit of interactivity, and that’s it.You probably won’t need to create anything fancy, formatting will be minimal, and you won’t need to wrestle with containers.This video show you how to create i...

barchart,dashboard,interactive,linechart,map,performance,profit,sales,tableau

Understanding Advanced Tableau Calculations Like Standard Deviation Movi...

Jul 8, 2024 Maddie Dierkes | playfairdata.com

Tableau is a useful tool for an analyst to have in their repository, with its drag and drop interface allowing…The post Understanding Advanced Tableau Calculations Like Standard Deviation, Moving Average, and More appeared first on Playfair Data.

Advanced,DecisionScience,Engineering,TableauDesktop,TechnicalFeatures

User Toggle for Consistent or Independent Axes A solution for stacked ba...

Jul 8, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

     I really don’t like stacked bar charts - they have so many inherent problems. But sometimes, they are, in fact, the best chart for the job. But when I design a stacked bar chart, I take numerous steps to make the chart the most in...

Tableau

How to Use KPI Cards as Action Buttons in Tableau

Jul 7, 2024 Yan Peng | www.thedataschool.co.uk

Switching between KPIs in a Tableau chart typically requires a parameter control. However, there are times when you might want to introduce another layer of interactivity, either because your dashboard is already loaded with filters or to make it ...

Can you show YTD and PYTD whilst also being able to change the date rang...

Jul 5, 2024 Donna Coles | donnacoles.home.blog

It was Lorna’s turn to set the challenge this week – to compare YTD with Previous YTD while also filtering date ranges which updated based on the year of focus. She hinted it was a great use case for an INCLUDE LoD and I have to admit that seemed ...

WorkoutWednesday,WOW2024,BaselineDate,datenormalise,Filtering,KPI,LineChart,RangeofDates,RelevantValues,Week27,YoY,YTD

The Top 3 Resources For Your Tableau Certified Data Analyst Exam

Jul 3, 2024 Bruno Gasparotto Ponne | www.thedataschool.co.uk

Last month I passed the Tableau Certified Data Analyst exam. Even though the exam is not especially difficult, it is very important to prepare for it several days before the examination. If you are about to sit the exam and are running out of time...

Data,Snowflake

Snowflake External Access Retrieve Data from an API

Jul 2, 2024 Chris Hastie | interworks.com

Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to com...

Data,Snowflake

Can you filter a donut without highlighting the pie

Jul 2, 2024 Donna Coles | donnacoles.home.blog

For this week’s challenge, Kyle looked to solve a problem that he’s seen discussed within another blog – how to solve a highlighting problem when filtering donut charts. I’ve been away on a little holiday abroad for a family wedding, so am on catc...

WorkoutWednesday,WOW2024,deselectmarks,DonutChart,DualAxis,fakeaxis,filteractions,MIN0,PieChart,Polygon,ServerSideRendering,Week26

Finding in DAX

Jul 1, 2024 Alfie King | www.thedataschool.co.uk

We had to generate an email address for these customers that were of the form “FirstName Surname” as seen here.

Data,IT,Podcast,sales

IT Sales Simplified Intern to Employee with Seth Maston

Jul 1, 2024 InterWorks | interworks.com

  In this episode, IT Sales Simplified host Genna Callahan sits down with InterWorks Client Manager Seth Maston to chat about transitioning from an IT intern to a fully fledged IT salesperson at a global tech company.The post IT Sales Simplified: ...

Data,IT,Podcast,sales

Data Deprecation with Confidence A Step-by-Step Guide

Jul 1, 2024 | www.prosvetova.com

In today’s fast-paced environment, organizations are constantly evolving their data ecosystems to keep up with changing business requirements and technological advancements. As new data sources and models are introduced to the data mart, it become...

migration,select_star

How to Rank Filter the Top 5 in Tableau in Under 60 Seconds

Jun 30, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this tip, you will learn how to show the rank of each team in MLB by homeruns for 24 seasons. We’ll start by computing the RANK table calculation for each Season before filtering to only the top 5 Teams in each Season.

filter,howto,MLB,rank,rankfilter,tablecalc,tablecalccalculation,tableau,top10,top5

What Are Specific Dimensions in Table Calculations in Tableau

Jun 30, 2024 Yan Peng | www.thedataschool.co.uk

When setting up table calculations in Tableau, the “Compute Using” section offers options to define how comparisons are made. For instance, when computing percent difference down the table, each quarter is compared to the previous one within each ...

How to Replace a Datasource Fields in Tableau

Jun 28, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Need to change a datasource but don’t want to rebuild the workbook? Has a field name changed? It can be a real pain to update each sheet in a workbook one by one. Conveniently, Tableau allows you to change the entire datasource with the “Replace D...

changefield,dashboard,howto,replacedatasource,replacereferences,tableau,workbook

Data School Blog Roundup - June 2024

Jun 28, 2024 Mel Niere | www.thedataschool.co.uk

Compiled by Dylan Moore, Intern