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.anyalitica.dev

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

Breaking down the Cube

Jun 28, 2024 Aileen Pfleiderer | www.thedataschool.co.uk

or “Rolling the Dice with Power BI: My Dive into an Expert Challenge”

What did it take to get into DS45

Jun 26, 2024 Jenny Martin | www.thedataschool.co.uk

DS45 are in the 4th week of their journey at the Data School. A perfect time to look at what it took for them to get in!

How to Create a 9-Box Matrix in Tableau

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

In this video, I show you how to build a 9-box matrix. These are commonly used in talent management and HR to map a company’s workforce along two dimensions, potential and performance. Each of these two dimensions is split up into three categories...

9-box,employee,grid,heatmap,howto,HR,humanresources,matrix,performance,scatterplot,tableau,tip

Scraping multiple webpages - in Power Query

Jun 25, 2024 Tim Jeffries | www.thedataschool.co.uk

One of the most enjoyable days so far today, as the planned Power Query WOW webpage scraping wasn’t working as expected, so another had to be found quickly, and TL;DR no-one was entirely sure exactly how to get all the pages in properly. It was a ...

Data,python,Snowflake

Data Models

Jun 25, 2024 Alfie King | www.thedataschool.co.uk

Creating a data model is like a lot of projects in data. It is significantly easier if you plan first.

Data,python,Snowflake

Containers

Jun 25, 2024 Alfie King | www.thedataschool.co.uk

When starting my application for the data school we had to create a visualisation, and when it came to actually creating the dashboard I struggled throughout the application. This is because I was using floating panes instead of containers.

Data,python,Snowflake

Avoiding Common Pitfalls in Chart Design

Jun 25, 2024 Alyssa Huff | playfairdata.com

Choosing and designing charts is a deceptively challenging aspect of data visualization. It can seem obvious when someone else made…The post Avoiding Common Pitfalls in Chart Design appeared first on Playfair Data.

ChartTypes,Design,Figma,Intermediate

Python and Snowflake FAQ

Jun 25, 2024 Chaitanya Joshi | interworks.com

Python is a first class language in the Snowflake eco system, and there are multiple ways to use Python with Snowflake: Snowflake Connector for Python: Listed in Snowflake drivers, this is a standard connector to Snowflake written using Python. It...

Data,python,Snowflake

Maturing Analytics Why Dashboards Fail

Jun 25, 2024 Ben Bausili | interworks.com

In Part 1, we looked at our Job to be Done and why it wasn’t building Dashboards. The key takeaway is to focus on user value and solve their pain points. Now, let’s turn to why what building dashboards doesn’t deliver the user value we…The post Ma...

Data,analytics,dashboards

Maturing Analytics The Job To Be Done

Jun 25, 2024 Ben Bausili | interworks.com

The data and analytics industry is changing. Buried beneath the marketing hype and buzzwords, there’s something real happening, and the data industry is going through a giant shift. I’ve heard it described as both “overhyped and underestimated.” O...

Data,analytics,dashboards

Explaining with Data Normalization and Percentile calculations in Tablea...

Jun 24, 2024 Robbin Vernooij | www.thedataschool.co.uk

In this blog, part of the Explaining with series, I will go over two different methods of data normalization; Z-Scores and Rank Percentile calculations. Showcasing examples using Sports Data and how-to guides in Tableau and Power BI

IT,Podcast,PodcastYourData,sales

IT Sales Simplified Tech Talk with Tim Adams

Jun 24, 2024 InterWorks | interworks.com

In this episode, IT Sales Simplified host Genna Callahan sits down with IT Support Manager Tim Adams to talk about real world IT experience and Tim’s path to IT.The post IT Sales Simplified: Tech Talk with Tim Adams appeared first on InterWorks.

IT,Podcast,PodcastYourData,sales

Boost Your Tableau Workbooks With Large and Complex Data Sources

Jun 24, 2024 Robin Schouten | interworks.com

Speed is of the essence in lots of things, and Tableau dashboards are no different. Developers and end users alike want dashboards loaded in a blink of an eye. Luckily, there are many resources online that will help you optimise your dashboards, s...

Data,data,sql,Tableau

Kirk Munroe New in Tableau 2024.2 Shared Dimensions

Jun 24, 2024 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Kevin and Iare pleased to welcome back Kirk Munroe for another guest post. Kirk lives inHalifax, Nova Scotia, Canada and is a business analytics and performancemanagement expert. He is currently one of the owners and principal consultantsat Paint...

How-To,SeriesDataModeling,Tableau

How to Set Up a Date Field in a Year-Over-Year Dual Axis Chart

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

In this post, I will show you how to create a year-over-year dual axis chart in Tableau, with the x-axis displaying the month-year date format of the current year. The following chat visualizes the sums of sales from the current and the previous y...

Alteryx,DataPrep,Fundamentals,TableauPrep,TipsTricks

Why Its Important to Understand the Granularity of Data

Jun 22, 2024 Ariana Cukier | playfairdata.com

When kicking off a project involving data, one of the first questions will be, “Do we have the right data…The post Why It’s Important to Understand the Granularity of Data appeared first on Playfair Data.

Alteryx,DataPrep,Fundamentals,TableauPrep,TipsTricks

Building an Investment Portfolio Optimisation Tool with Python and Table...

Jun 22, 2024 | www.anyalitica.dev

Some time ago I wanted to create a dynamic tool in Tableau, that enables end users to iterate through different combinations of variables (companies to invest, investment value, etc.), and immediatelly see how their choices impact the output of po...

tableau,datadev,python

The Current State of Semantic Layers

Jun 21, 2024 Jack Hulbert | interworks.com

In my last blog post, where I introduced the concept of a universal semantic layer, we outlined the benefits that organizations with multiple business domains can recognize. These organizations use data and data consumption tools, and can adopt a ...

Uncategorized,AI,Cube,dbt,ML,SemanticLayers,TableauPulse

InterWorks Blog Roundup May 2024

Jun 21, 2024 Mark Cordeiro | interworks.com

I want you to know, my first draft of this blog post was almost entirely made up of me slipping “May” into casual sentences or trying to come up with puns surrounding the month’s name. I’ve spared you from reading all that, don’t worry. It…The pos...

Data,BlogRoundup,IT,Snowflake,Tableau

Can you combine part-to-whole and comparison

Jun 21, 2024 Donna Coles | donnacoles.home.blog

Sean’s #WOW2024 challenge this week was to visualise the comparisons between different entities within a limited space, by using a Viz In Tooltip (VIT) to provide additional information on hover. Building the Treemap Add Sales to Size, Category to...

WorkoutWednesday,WOW2024,HideMarks,ParameterActions,ParttoWhole,Rank,Treemap,VIT,VizinTooltip,Week25