Alteryx: Directory Tool & Dynamic Input

Jan 10, 2023 John Power | www.thedataschool.co.uk

As well as the Text Input and Input Data Tools, if we need to specify a certain directory to pull data in from we can use the Directory Tool.  

Español,#DrillDown,#DrillUp,#Hierarchy,#ParameterActions

Funcionalidad de Expandir y Colapsar el Menú + Selección Múltiple de Val...

Jan 10, 2023 Rosario Gauna | rosariogaunag.wordpress.com

En el blog previo compartí la técnica que utilizó para ofrecer la funcionalidad de selección múltiple de valores en jerarquías, ahora el ejemplo con el que estaremos trabajando busca mostrar como complementar la funcionalidad de selección múltiple...

Español,#DrillDown,#DrillUp,#Hierarchy,#ParameterActions

Expand and Collapse Menu Functionality + Multiple Selection of Values fo...

Jan 10, 2023 Rosario Gauna | rosariogaunag.wordpress.com

In the previous blog, I shared the technique used to offer the functionality of multiple selection of values in hierarchies, now the example with which we will be working seeks to show how to complement the functionality of multiple selection, wit...

English,#DrillUp,#DrllDown,#Hierarchy,#ParameterActions

Getting to Know dbt

Jan 10, 2023 Paul Vincent | interworks.com

On a recent project, I heard a colleague recommend dbt and it sounded amazing. Every feature of this product seemed to address challenges I run into on almost every data project. I decided it was time to take a look. Unravelling the Spaghetti As a...

Data,database,dbt,documentation,sql

#MakeoverMonday 2023 Week 2 - The Spartacus Gay Travel Index

Jan 9, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

I found the subject of this week’s data set on the Instagram account of The Map Zone. It’s a simple map of what’s called the “Gay Travel Index”. The annually updated SPARTACUS Gay Travel Index informs travellers about the situation of lesbians, ga...

country,curve,curvedlines,curvybumpchart,gayindex,howto,instagram,map,sexuality,tableau,tip

PM Reflective Log

Jan 9, 2023 Elaine Yuan | www.thedataschool.co.uk

Project Date: 1/3/2023-1/6/2023

Data,Azure,functions,Microsoft,python,Snowflake

Intro to Azure Functions and Snowpark: Populating Snowflake Control Tables

Jan 9, 2023 Jason Hoehn | interworks.com

Snowflake is a powerful software that can store data points that are important for auditing the ETL process. This is done by creating a control table, which tracks ETL jobs that have been run and their statuses. There are a variety of methods for ...

Data,Azure,functions,Microsoft,python,Snowflake

3 Methods for Excel Download Buttons in Tableau

Jan 9, 2023 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 In my work dashboards, it’s very common for me to allow my users to download certain data. Some people think that this is a weakness, that my dashboard didn’t answer their questions well enough, so they are forced to download the data...

How to Create a Two Color Area Chart in Tableau

Jan 6, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this week’s Watch Me Viz, I showed the problem this tip helps solve. An area chart in Tableau only allows a single color. Like this…

areachart,axis,calculatedfield,dualaxis,formatting,howto,max,min,multiplecolors,referenceline,tableau,tip,twocolor,window

Introduction to SQL

Jan 6, 2023 Edward Gay | www.thedataschool.co.uk

Many occupations rely on SQL for data retrieval and management. Since SQL is robust and easy to learn, some job portals consider it the most in-demand skill an employee can have. Here is a quick introduction to SQL.

How to in Tableau: create a word cloud

Jan 6, 2023 Elena Raluca Mazareanu | www.thedataschool.co.uk

Tableau is a business intelligence and data visualization software that offers a wide range of development tools and APIs for integrating, customizing, automating, and extending Tableau features for the needs of specific organizations. A useful vi...

How to access the data source of a packaged workbook.

Jan 6, 2023 Shahbaz Khan | www.thedataschool.co.uk

So I’m sure all of us viz of the day enthusiasts have all seen dashboards we are all taken aback by and would love to see the data source that was used to create this dashboard and maybe play around with it ourselves.

Guide to Tableau Actions

Jan 6, 2023 Eamonn Woodham | www.thedataschool.co.uk

In Tableau, actions allow you to create interactive dashboards and reports by linking different worksheets and dashboards together. When you create an action, you specify a source sheet and a target sheet, and define what the action is and what it...

3 Innovative Ways to Use Image Role in Tableau

Jan 6, 2023 Felicia Styer | playfairdata.com

In version 2022.4, Tableau Desktop introduced us to a brand new feature: Image Role. This UX-enhancing tool allows users to…The post 3 Innovative Ways to Use Image Role in Tableau appeared first on Playfair Data.

Storytelling,TechnicalFeatures,Tips&Tricks,UserExperience

Can you use Image Role & Dynamic Zone Visibility?

Jan 6, 2023 Donna Coles | donnacoles.home.blog

New year means only one thing – a change to the WorkoutWednesday hashtag! We’re now #WOW2023, and it was Lorna’s turn to kick the next year of challenges off with a focus on the latest Tableau features. This challenge uses the image role function ...

My Top 10 App-Building Tips in Retool

Jan 6, 2023 | andredevries.dev

Retool is the fastest way to build internal applications. In this blog post I am going to highlight ten of my favourite app-building tips that will make your life as a Retool developer a lot easier!

What is an Analytical App

Jan 5, 2023 Tara Robinson | www.thedataschool.co.uk

An analytic application (app) is a workflow with interactive elements that allow a user to use/run the workflow without knowing or using the underlying structure. This blog will look at what an analytical app is, why they are beneficial, what make...

data-platforms,open-source,data-engineering,data

Variance based on a selected value in Tableau (using parameters)

Jan 5, 2023 Jack Arnaud | www.thedataschool.co.uk

Bar charts offer quick and easy comparisons, but you can enhance them to let users decide what selected value is the focus of your bar chart, and shape bar charts around how other values relate to the selected value.

data-platforms,open-source,data-engineering,data

Trailhead- Sales Force

Jan 5, 2023 Tara Robinson | www.thedataschool.co.uk

This blog will be covering the learning service know as trailhead. It will cover what this is, who can use it and how you can overcome a challenge.

data-platforms,open-source,data-engineering,data

#Throwback Thursday - Week 9 at The Data School

Jan 5, 2023 Serena Purslow | www.thedataschool.co.uk

Join me for my weekly reflection on life at the Data School!

data-platforms,open-source,data-engineering,data

Tableau vs Power BI vs CRM Analytics: What’s the difference?

Jan 5, 2023 Edward Gay | www.thedataschool.co.uk

This week we have been trying out a couple of different Tableau alternatives: Power BI and CRMA. After having spent a day on each of them, testing out both of their data prep and dashboard creation capabilities I couldn’t help but compare them to ...

data-platforms,open-source,data-engineering,data

Tableau vs CRM vs Power BI

Jan 5, 2023 Shahbaz Khan | www.thedataschool.co.uk

So the past week DS35 have had the pleasure of playing around with some other data visualization tools available for use. In order to get some practice in with these other tools we’ve spent some times recreating dashboards we have made previously ...

data-platforms,open-source,data-engineering,data

Tableau vs CRM A vs Power Bi

Jan 5, 2023 Eamonn Woodham | www.thedataschool.co.uk

CRM Analytics and Power Bi are two alternatives to Tableau when it comes to cleaning and visualizing data, the main focus of our training here is with Tableau but we have now been given an introduction into both Microsoft’s PowerBi and Salesforce’...

data-platforms,open-source,data-engineering,data

Reordering Bar Charts: Utilising Sets

Jan 5, 2023 Morgan A Rennie | www.thedataschool.co.uk

Tableau offers several ways to reorder bar charts, this blog will explore the use of sets to allow the end user to reorder a bar chart by clicking on a measure, you can observe this set action in the below Tableau dashboard

data-platforms,open-source,data-engineering,data

Parameter Action - Reordering Bars

Jan 5, 2023 Anita Longa | www.thedataschool.co.uk

Tableau explains parameter as a workbook variable such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line. And I would like to show you a practical use of a parameter.

data-platforms,open-source,data-engineering,data

INDEX vs RANK

Jan 5, 2023 Diaraye Barry | www.thedataschool.co.uk

Index and Rank are part of Tableau table calculation. The main difference between the two is that Index computes by looking at the physical position of the record without any regards to the value whereas Rank computes the data row based on the pre...

data-platforms,open-source,data-engineering,data

How to use Set Actions to create a Bar Chart Drill Down

Jan 5, 2023 Sherina Mahtani | www.thedataschool.co.uk

Starting Note: We will be using Sample Superstore for the example for this blog, feel free to open that up and follow along.

data-platforms,open-source,data-engineering,data

How to build a drill down bar chart in Tableau

Jan 5, 2023 Edward Gay | www.thedataschool.co.uk

A drill down allows you to navigate data from a comprehensive view to a more detailed one. Here is a guide on how to make a drill down bar chart using set actions Tableau.

data-platforms,open-source,data-engineering,data

How to Create a Bar Chart showing the Variance in Monthly Sales from a S...

Jan 5, 2023 Kaitlin MacDonnell | www.thedataschool.co.uk

This week at the data school, DS37 have been learning about using set actions to create interactive graphs. This blog will use the Superstore data set to take you through how to create a bar chart showing the variance in monthly sales between a se...

data-platforms,open-source,data-engineering,data

How To Create a Drill Into Bar Chart Using Parameters

Jan 5, 2023 Curtis Paterson | www.thedataschool.co.uk

It’s often useful for a user to be able to see data at a high level, with the option to dive deeper into certain areas if required. A drill into bar chart can be the perfect way to achieve this, letting the user choose the level of detail they req...

data-platforms,open-source,data-engineering,data

Drilling down to data points by clicking category in Tableau

Jan 5, 2023 Stanley Chan | www.thedataschool.co.uk

Today I would like to share how to make the chart below, where you can click the category (here is the region) to drill down all the data points in that selected category.

data-platforms,open-source,data-engineering,data

Alteryx Designer: how to Pivot (Cross Tab and Transpose)

Jan 5, 2023 Lucas Carvalhal Sirieiro | www.thedataschool.co.uk

If you come from an Excel background (you’re not alone),  you probably have the same problems as I do with pivoting datasets in Alteryx. Or you have never done it before and just don’t quite understand Cross Tab and Transpose, the two native Alter...

data-platforms,open-source,data-engineering,data

Hand-Picked Tools for Building an Open-Source Data Platform

Jan 5, 2023 Anjan Banerjee | medium.com

Photo by Marcello Gennari on UnsplashLarge organizations will pay for tools and technologies which offer a lot of advanced features and then barely use them. Many times, there will be multiple tools in use trying to solve the same exact problem. S...

data-platforms,open-source,data-engineering,data

InterWorks Blog Roundup — December 2022

Jan 5, 2023 Mark Cordeiro | interworks.com

Happy New Year, everyone! We hope you all had a fantastic holiday season and are coming into the new year refreshed and ready for a fantastic 12 months. To cap off 2022, we opted for quality over quantity on the blog front. (It also helps…The post...

Data,Curator,Fivetran,Snowflake,Tableau

Specific Dimensions in Table Calculation in Tableau

Jan 4, 2023 Stanley Chan | www.thedataschool.co.uk

This blog is for those who have a basic understanding of table calculation. Very often when we use the table calculation with specific dimensions. It is sometimes quite confusing how the calculation is computed. I learned that selecting and arrang...

TableauCalculations,TableauDates

How to Web scrape in Power BI

Jan 4, 2023 Tara Robinson | www.thedataschool.co.uk

One of the major benefits of power BI is its simplicity for web scrapping. This blog will show you how to web scrape on power BI.

TableauCalculations,TableauDates

Formatieren eines Dashboards

Jan 4, 2023 Jan Kaiser | www.thedataschool.co.uk

Du hast dir viel Mühe beim Erstellen eines Dashboards gegeben, die Daten durchdrungen und unterschiedliche Diagramme erstellt. Eine gute Formatierung deines Dashboards hilft einzelne Elemente zu einer vollständigen Geschichte zu verbinden. Dabei s...

Español,#DrillUp,#DrllDown,#Hierarchy,#ParameterActions

How to Tableau: Quarter to Date vs. Prior Year Quarter to Date

Jan 4, 2023 Eric Parker | onenumber.biz

Tableau is a great tool for operationalizing time period comparisons. One of the classics is comparing quarters.

TableauCalculations,TableauDates

#MakeoverMonday 2023 Week 1 - The Change in Greenhouse Gases in the Atmo...

Jan 3, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

2023 is here and #MakeoverMonday will be here the entire you to help you continue to learn and improve. Come on the journey with us each week. Build your portfolio. Showcase your skills. You just might get that job you’ve been seeking. It’s happen...

areachart,change,climatechange,combinedaxis,dualaxis,emissions,greenhousegas,howto,LOD,MakeoverMonday,sparkline,tableau,tip,tutorial,variance,WatchMeViz

Top Tips for Preparing for the Alteryx Core Certification

Jan 3, 2023 Sherina Mahtani | www.thedataschool.co.uk

With 80 questions in 2 hours, there are various ways to prepare for this exam. Lets narrow it down, shall we?

Español,#DrillUp,#DrllDown,#Hierarchy,#ParameterActions

Tips for Data Discovery Using Alteryx

Jan 3, 2023 Keren Aharon | www.thedataschool.co.uk

Before starting a data analytics project its important to make sure that you fully understand the data by doing as much data discovery as possible. Data discovery will allow you to detect patterns and answer specific questions based on your projec...

Español,#DrillUp,#DrllDown,#Hierarchy,#ParameterActions

Making Realistic Fake Datasets with help from Alteryx

Jan 3, 2023 Finn Charlton | www.thedataschool.co.uk

I recently took on the challenge of creating a fake dataset that is as realistic as possible. Along the way I learnt a lot about fake datasets - and created a framework for making them that I hope will be helpful for others looking to do the same....

Español,#DrillUp,#DrllDown,#Hierarchy,#ParameterActions

Selección Múltiple de Valores para Jerarquías

Jan 3, 2023 Rosario Gauna | rosariogaunag.wordpress.com

Me encanta trabajar con jerarquías y ha sido un tema recurrente en mis publicaciones, en donde he compartido múltiples ejemplos de selección individual dentro de una jerarquía con opciones de Drill Down & Up para navegar fácilmente entre los d...

Español,#DrillUp,#DrllDown,#Hierarchy,#ParameterActions

Multiple Selection of Values for Hierarchies

Jan 3, 2023 Rosario Gauna | rosariogaunag.wordpress.com

I love working with hierarchies and it has been a recurring theme in my posts where I have shared multiple examples of single selection within a hierarchy with Drill Down & Up options to easily navigate between the various levels of the hierar...

English,#DrillUp,#DrllDown,#Hierarchy,#ParameterActions

Quick Start Guide: Snowflake Direct Shares

Jan 3, 2023 Jason Hoehn | interworks.com

Snowflake Secure Data Sharing enables users to provide specific data points to consumers using the same cloud provider within the same region. Providers can share tables, external tables, secure views, secure materialized views or secure user defi...

Data,data,datasharing,Snowflake