Track Your Weekly Fantasy Football Scores With Python and Tableau

Sep 8, 2023 Stefanie Mircovich | interworks.com

It’s one of my favorite times of year.  The weather is cooling, kids are going back to school (phew), and the thrill of Fantasy Football seasons are upon us. Since 2010, a group of my college friends have played in a competitive Fantasy Football l...

Data,fantasyfootball,python,Tableau

Tableau Hacks Vertical Synchronised Scrolling Endless Row-by-Row

Sep 8, 2023 Robin Schouten | interworks.com

Instead of scrolling page by page, what about scrolling row by row instead?  Picking Up Where We Left Off Let’s reuse our dashboard and views from the previous Page by Page Vertical Synchronized Scrolling blog and make some small changes to go fro...

Data,Tableau,TableauTips

Can you build a dashboard for pre-aggregated metrics

Sep 8, 2023 Donna Coles | donnacoles.home.blog

For the challenge this week, Kyle asked us to recreate the visualisation above using an adapted version of Superstore which had a customer count metric for 3 dimensions (Category, Segment and Region) along with ‘no’ dimension (null) pre-aggregated...

WorkoutWednesday,WOW2023,AggregatedData,DynamicZoneVisibility,Filters,Parameters,RelevantValues,Week36

Tableau How-To Create neat-looking KPI cards

Sep 6, 2023 Lisa Hitch | www.thedataschool.co.uk

Business Dashboards have the intention to convey key metrics quickly to the user  or stakeholder, which is why a lot of business dashboards use little sections (so-called “cards”) to highlight those key metrics and how they are trending. Under the...

LayoutContainers,TableauDashboards

Leveraging Project Management Principles for Effective Data Consulting

Sep 6, 2023 Michael Bellamy | www.thedataschool.co.uk

As businesses have become more data-driven, their reliance on in-house data teams or data consultants has become more pronounced. data professionals and the insights they derive are now the main drivers for informed decisions related to gaining co...

LayoutContainers,TableauDashboards

Tableau Layout Containers Tips Tricks and Uses

Sep 6, 2023 Eric Parker | onenumber.biz

Over the years, I’ve had an up and down relationship with layout containers in Tableau dashboard. I remember they saved me on my first big project when I needed to design a worksheet with a dynamic height.

LayoutContainers,TableauDashboards

Tableau Hacks Vertical Synchronised Scrolling Page-by-Page

Sep 6, 2023 Robin Schouten | interworks.com

Following up from the previous post, vertical synchronised scrolling can be even more of an issue. We’ve come up with two options here depending on the use case (and preference). The first option is pagination. Our business is selling stuff all ar...

Data,scrolling,Tableau,TableauTips

Tableau Cloud Admin Insights Unveiling the Secrets Within

Sep 6, 2023 John Saunders | interworks.com

As a Tableau admin or enthusiast, you’re always on the lookout for ways to elevate your data management game and gain invaluable insights into your environment. That’s where Tableau Cloud Admin Insights steps in, igniting your curiosity and drivin...

Data,AdminInsights,Tableau,TableauCloud

60 Unique Ways to Visualize Time in Tableau

Sep 5, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Unlock the full potential of time series data in Tableau with this comprehensive tutorial! Time series data is everywhere—from finance and healthcare to marketing analytics, but are you utilizing it to its fullest? In this session, I walk you thro...

areachart,barchart,barbell,barcode,bumpchart,calendar,circletimeline,donut,dotplot,heatmap,howto,linechart,seismogram,slopegraph,stacked,stock,stripplot,tableau,timeseries,waterfall

When Blue Meets Green Dimensions vs. Measures and Discrete vs. Continuous

Sep 5, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

When working in Tableau, green and blue pills are dragged on to the shelves or marks cards to create a visualization. Understanding the meaning of these pills is important when creating visualizations.  

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Recreating a Tableau Dashboard in PowerBI

Sep 5, 2023 Jules Claeys | www.thedataschool.co.uk

This week’s task was to recreate our original application dashboard in PowerBI. In all honesty, at first, just the idea of it sounded incredibly hard. For some part it was, how were we supposed to rebuild a dashboard which took many hours to build...

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Pre-attentive Attributes

Sep 5, 2023 Alexander Wood | www.thedataschool.co.uk

Pre-Attentive Attributes are so useful to data analyst as they help us draw the users focus to the aspects of a chart or visualization that we want them to be interested in. The ten attributes are shown in the picture and can be used in a variety ...

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Power BI Journey.05 Logical Functions

Sep 5, 2023 Numa Begum | www.thedataschool.co.uk

This blog is part 3 of an introductory guide on how to use DAX (Data Analysis Expressions). Today will be covering logical functions within Power BI Desktop.

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Power BI Journey.04 Date Functions

Sep 5, 2023 Numa Begum | www.thedataschool.co.uk

This blog is part 2 of an introductory guide on how to use DAX (Data Analysis Expressions). Today will be covering date functions within Power BI Desktop.

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Power BI Journey.03 Text Functions

Sep 5, 2023 Numa Begum | www.thedataschool.co.uk

This blog is an introductory guide to how to use DAX (Data Analysis Expressions) for text functions within Power BI Desktop. This is to be used to create calculated columns, which are columns created by the user that are calculated from a row leve...

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Designing a Mobile Dashboard on Tableau

Sep 5, 2023 Tabitha Diaz | www.thedataschool.co.uk

This past week I was lucky enough to be challenged to build a mobile dashboard for a client. As excited as I was for this new challenge, I realized I didn’t know where to start. If you do a search on building out mobile dashboards there are very f...

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

DS41s Favourite Office Games

Sep 5, 2023 Numa Begum | www.thedataschool.co.uk

One month into training, and as a cohort we have definitely settled into the office culture at TIL. Here is a fun blog, documenting what we have been playing in the office as a cohort. Keep reading for the tier list!

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

3 Sets for the win.

Sep 5, 2023 Jules Claeys | www.thedataschool.co.uk

Today we learnt about sets, as basic as these can seem they permit to highlight extremely well specific values in your data. They are custom fields which represent a defined part (or a set) of a dimension.

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Profit Loss Tabla Avanzada

Sep 5, 2023 Rosario Gauna | rosariogaunag.wordpress.com

El objetivo de este blog es ofrecer una explicación paso a paso del proceso de construcción del ejemplo número seis, que se puede encontrar en “The Ultimate Profit & Loss Statement Workbook“. Este libro de trabajo se desarrolló como parte de l...

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Profit Loss Advanced Table

Sep 5, 2023 Rosario Gauna | rosariogaunag.wordpress.com

The aim of this blog is to offer a step-by-step explanation of the construction process for example number six, which can be found in “The Ultimate Profit & Loss Statement Workbook“. This workbook was developed as part of “Tableau for Financia...

English,FinancialReporting,PL,ProfitLoss,Tableau

ST_SIMPLIFY Shape-Shifting in Snowflake

Sep 5, 2023 Max Giegerich | interworks.com

SHP Files in Tableau Shape files (.shp) allow us to encode geospatial information like countries, continents or more specific custom regions specific to our use cases. These work similarly to dot-to-dot puzzles. One file stores a series of shapes,...

Data,CBIStudio,geospatial,shapefiles,Snowflake,Tableau

Pass Tableau Filters via https://www.flerlagetwins.com/2023/08/filterval...

Sep 5, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 There are severalscenarios where you might want to be able to pass the currently selectedfilters to another workbook (or a related URL) using URL actions. One I see regularlyis the need to jump to another workbook and use the same filters. Typica...

How-To,Tableau

28 Charts in 60 Minutes - Forbes Cloud 100 Companies Scaling Up and Scal...

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

How many people power the Forbes Cloud 100? Is there a correlation between company rank and employee size? Have they expanded or contracted.Learn how to build 28 charts in 60 minutes that compare two years.

barchart,barinbar,barbell,bulletgraph,butterfly,comet,comparison,dashboard,floatingchart,howto,lollipop,MakeoverMonday,scatterplot,seismogram,slopegraph,tableau,tadpole,variance

Rebuild my initial viz using Power BI

Sep 4, 2023 Abby Poon | www.thedataschool.co.uk

Last week, we have been went through on how to build a dashhoard on Power BI. The Friday project was not surprised - recreate the initial viz from Tableau. This is what i have created:

Reapplying for the Data School But in Power BI

Sep 4, 2023 Alexander Wood | www.thedataschool.co.uk

At the end of my 4th week at the data school, and after a week of Power BI training I was tasked with recreating my data school application (initially done using Tableau Public) in Power BI. Overall I am really happy with the outcome and feel that...

Ranking in Alteryx Using Multi-Row Formula

Sep 4, 2023 Charles Yi | www.thedataschool.co.uk

Last week, we looked at how to rank in Alteryx using the Record ID and Join tools. This week, I’ll be demonstrating how to rank using the Multi-Row Formula tool. I’ll be using the dataset from Alteryx’s Weekly Challenge #9 to showcase the tool.

Espaol,FinancialReporting,PL,ProfitLoss,Tableau

Power BI - Using Parameters to Change Charts

Sep 4, 2023 Alexander Wood | www.thedataschool.co.uk

In Power BI you can use parameters to change the view of a chart. Its a way of adding interactivity to a chart, allowing the user to explore the data and when done appropriately it can really enhance the user experience.

Alteryx The 23 Tools on the Core Exam

Sep 4, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

The Alteryx Core Exam focuses on 23 tools, which are shown below. The 23 tools are divided into six different categories.

Show Hide Multiple Containers in Tableau

Sep 3, 2023 Benjamin Wortmann | www.thedataschool.co.uk

On my most recent friday project I created a straightforward dashboard to showcase specific information about planets such as Venus and Mercury. To add a creative touch, I decided to incorporate a map, as shown below:

Makeover Monday - Power BI edition

Sep 3, 2023 Patrick Maguire | www.thedataschool.co.uk

This week, DS41 were tasked with completing our first ever Power BI Makeover Monday (MM). In honour of this special occasion, our dataset looked at MM itself!

Date Time Format in Alteryx

Sep 3, 2023 Le Luu | www.thedataschool.co.uk

There are many data types that data analysts usually work with. String, number and date are mostly used in preparing the data. However, the date and time are more complicated than other data types because the field could be a String or Date. Depen...

DAX Cheat Sheet - Essentials

Sep 3, 2023 Jaroslav Tomcala | www.thedataschool.co.uk

In this blog about essential DAX (Data Analysis eXpressions) expressions in Power BI, I’ll guide you through the fundamental functions you need to know.

PowerBI MakeoverMonday

Sep 2, 2023 Jules Claeys | www.thedataschool.co.uk

As a first report on PowerBI, we had to use a dataset composed of information about the different MakeOvermondays since the start of the learning event.

Tips,highlightactions,Tableau

How to Create Data Points for a Custom Polygon Map in Tableau using a HT...

Sep 1, 2023 Jia Yan Ng | www.thedataschool.co.uk

The way Tableau creates a map is essentially the same as how it generates a scatter plot. When you provide X and Y coordinates, Tableau draws a dot. You can import an image, such as a layout of a place, and then map the coordinates of the dots you...

Data,HorizontalScrolling,Tableau,TableauDesktop

Flunk-Cost Fallacy

Sep 1, 2023 Vivian Ng | www.thedataschool.co.uk

I don’t really like talking about my successes, and I like talking about my failures even less, but as I just passed the Alteryx Advanced Certification Exam on my second try a week ago, I thought I’d blog about it while the memory is still fresh. ...

Tips,highlightactions,Tableau

Tray Snowflake Connector SQL Compilation Error ninvalid identifier

Sep 1, 2023 Gavin Holzworth | interworks.com

Tray.io is an easy-to-use low code API Integration tool that’s great at streamlining your workflows and data in the workplace. I recently tried it out! I wanted to create a basic data flow that pulls Typeform survey data into a Snowflake server fo...

Data,connectors,Snowflake,Tableau,Tray,Typeform

Tableau Hacks Horizontal Synchronised Scrolling

Sep 1, 2023 Robin Schouten | interworks.com

Have you ever been in a situation with Tableau where you have developed a couple of great views, you put them in a dashboard, and they won’t fit to width unless you squash everything up? And then you cannot make sense of things anymore and…The pos...

Data,HorizontalScrolling,Tableau,TableauDesktop

Can you build an interactive Viz in Tooltip

Sep 1, 2023 Donna Coles | donnacoles.home.blog

This week’s #WOW2023 challenge was inspired by Sam Parson’s TC presentation where he demonstrated the concept of an interactive Viz in Tooltip (the workbook he presented is here). I was aware when I set this challenge, that this was likely to be o...

WorkoutWednesday,WOW2023,AllowSelectionbyCategory,Interactivetooltip,ParameterActions,ScatterPlot,SetActions,VizinTooltip

Workout Wednesday KPI Dashboard

Aug 31, 2023 Maddalena Mariano | www.thedataschool.co.uk

During Week 4 of The Data School, we have been learning PowerBI, so this Wednesday we could have a go at build a KPI dashboard.

User selection axis in Power BI

Aug 31, 2023 Myles Stevenson | www.thedataschool.co.uk

When changing categorical axis on power BI its easy to create a Tile with a changing axis. To do this make a Parameter with the fields you would like to chose between.

Transform on Alteryx Transpose Tool

Aug 31, 2023 Sabrina Vazquez | www.thedataschool.co.uk

Transforming data from columns to rows.

Transform on Alteryx Cross Tab Tool

Aug 31, 2023 Sabrina Vazquez | www.thedataschool.co.uk

Transforming data from rows to columns.

Power BIs Format Painter

Aug 31, 2023 Jules Claeys | www.thedataschool.co.uk

While figuring out how to do my first Workout Wednesday (Week 2, 2021)on PowerBI, I found a tool that everyone should be aware of. I have found formatting extremely tedious on PowerBI, having to always go into the format tab and find exactly which...

Power BI Journey.06 Data to Viz in a Whiz

Aug 31, 2023 Numa Begum | www.thedataschool.co.uk

Today Robbin Vernooij challenged us to an extended #MakeoverMonday challenge (2023 week 19) to wrap up our introductory week of Power BI. Read up on all the steps I did to get from start to end!

Power BI - How to add a visual into a tooltip

Aug 31, 2023 Alexander Wood | www.thedataschool.co.uk

Adding visuals into a tooltip can be a good way to show users further information to the graphs without adding too many charts to the initial visual. Other use cases for visuals in tooltips can include showing breakdowns of the data behind the vis...