Upgrade Tableau server on Windows

Oct 15, 2021 Iwona Fredouelle | www.theinformationlab.co.uk

This post is going to explain how to upgrade Tableau server on Windows from version 2018.2 or higher to a higher version. This is also known as a tsm-to-tsm upgade. At the moment of writing this post the highest version is 2021.3 and the maintenan...

Blog,TableauServer,tableauserver

Inside InterWorks: The Importance of Content in Marketing, Part 1

Oct 15, 2021 Andrea Avey | interworks.com

Riffing on our previous series format, this two-part blog will provide a look at the inner workings of the InterWorks Marketing Team and how content is the anchor point for so much of what we do. In this post, I’ll highlight different members of t...

Culture,content,culture,InsideInterWorks,Marketing,recruiting

How to Embed a Google Slides Presentation in a Tableau Dashboard

Oct 14, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

Let’s say you are giving a presentation that includes both slides and Tableau dashboards/charts. You’d rather not switch back and forth between applications. You’d prefer to have it all in Tableau.It’s super simple with Google Slides. In this tip,...

dashboard,embed,googleslides,howto,PowerPoint,presentation,tableau,tip,trick,tutorial

DS27 First-week reflection and imposter syndrome

Oct 14, 2021 Viktoriia Slaikovskaia | www.thedataschool.co.uk

The first week went super fast like it was just one big day for me. We all comefrom different backgrounds and have a different experiences. Sometimes look ateveryone and realise how cool they are in things they are doing. I am stillimpressed by al...

Careers,journey,careeradvice,CareerInsights,datacareers,JourneytoTessellation

Live Stream – Power BI Power Hour: A Beginner’s Guide to Power BI Capabi...

Oct 14, 2021 Analytics Events | www.tessellationtech.io

Follow along with Power BI expert, Gavin Pedersen, as he guides a tour through Power BI Desktop, a quick dashboard build, hosting shared datasets, and a high-level overview of the capabilities using Power BI in just one hour. … Read MoreThe post L...

PowerBI,UpcomingLiveStream,Webinar,LiveStream,PowerBIforBeginners

Eric Carpenter’s Journey to Tessellation: From Slopes to Statistics

Oct 14, 2021 Eric Carpenter | www.tessellationtech.io

Eric Carpenter’s Journey to Tessellation: From Slopes to Statistics When your ambition is stronger than your complacency, personal growth can begin. My journey into data, and ultimately to Tessellation, started at these crossroads. For as long as ...

Careers,journey,careeradvice,CareerInsights,datacareers,JourneytoTessellation

Month over Month Comparison Summary Tiles in Tableau

Oct 14, 2021 Eric Parker | onenumber.biz

Sometimes when I’m creating summary tiles for Tableau dashboards, I like to add arrows or percent increases/decreases to let consumers know how current values relate to the comparison period.

TableauCalculations,TableauHow-Tos,TableauDashboards

How to Clean up Temporary Matillion Stages in Snowflake

Oct 14, 2021 Chris Hastie | interworks.com

When using Matillion to load data into Snowflake, temporary stages are often created in Snowflake to store the data before it lands in the destination table. Often, this is not an issue as Matillion provides a handy load option called “Clean Stage...

Data,DROPstatements,Matillion,Snowflake,staging

How much do top sub-categories contribute to sales?

Oct 14, 2021 Donna Coles | donnacoles.home.blog

A colourful #WorkoutWednesday challenge this week, courtesy of Ann Jackson incorporating pie charts, top N functionality and interactivity and a highlight table. Pie charts can cause much debate amongst the data viz community and if this one was j...

How to introduce Tableau to business users and make them fall in love wi...

Oct 13, 2021 laura.scavino | www.theinformationlab.co.uk

Tableau helps people see and understand data Tableau’s Mission It has been now 18 years since a computer scientist, a professor and a business leader were trying to design a software which could make data understandable to ordinary people – Missio...

Blog,CustomerSuccess

Implementing Advanced Capabilities in dbt

Oct 13, 2021 Colin Murray | interworks.com

After you’ve finished setting up your dbt environment and begun working in dbt, you may find that you’ll need more than just the basics. As mentioned in The Transformational Power of dbt in Analytics, dbt allows data teams to leverage the capabili...

Data,dbt,Jinja,macros,sql

DS27 Training Blog - Week 1

Oct 12, 2021 Tom Smith | www.thedataschool.co.uk

A quick overview of my first week at the Data School as part of DS27.

Dashboards,Tableau,Technical,Tutorial,ExcelforTableau,formatting,tableau

How to Succeed in Your First Analytics Role

Oct 12, 2021 Sunny Yan | www.tessellationtech.io

This blog summarizes a webinar hosted by three analysts who described their journeys into analytics and how they found success early in their careers. … Read MoreThe post How to Succeed in Your First Analytics Role appeared first on Tessellation.

Business,Careers,careeradvice,CareerInsights,datacareers,industry

Working with Dates in Tableau: Optimizing Date Selection Logic

Oct 12, 2021 Ben Calder | interworks.com

In the previous post, we discussed the benefits of supplementing traditional to-date reporting periods with rolling periods. In this post, we will dive into the optimal practices (and not-so-optimal practices) for creating the logic for effective ...

Data,datelogic,dateselection,Tableau,WorkingwithDatesinTableau

Title Case Formatting in Tableau Prep with RegEx

Oct 12, 2021 Igor Garlowski | interworks.com

We have all seen this problem in data transformation: names automatically becoming CAPITALISED NAMES or all lowercase names. If we have a list of cities consisting of only one word, it is quite straightforward to capitalise the first one using the...

Data,formatting,PrepBuilder,regularexpressions,Tableau,TableauPrep,titlecase

Change Filters From "AND" to "OR"

Oct 12, 2021 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 THE PROBLEMAt work a few weeks ago, my colleague, Ethan Hahn, and I were presented with a problem. He was putting together some data and building a dashboard for our Marketing department. It contained a list of customers and their cor...

How-To,Tableau

Lollipop Charts in Tableau

Oct 10, 2021 Juhie Radia | www.thedataschool.co.uk

step by step guide on how to make a lollipop chart in Tableau

TableauEnterprise

How backgrounder.timeout.single_subscription_notify works?

Oct 10, 2021 markwu2000@gmail.com | enterprisetableau.com

Tableau released new backgrounder.timeout.single_subscription_notify  config key as part of v2021.2. It works 10 times better than existing subscriptions.timeout. However Tableau’s documentation is not clear and not accurate. I had to talk with Ta...

TableauEnterprise

How to use different chart types in a single dashboard container

Oct 9, 2021 Jonatan Raphael-Amanrich | www.thedataschool.co.uk

A quick and simple way to use a parameter to alternate between multiple chart types contained in a single container

How to upload multiple files and sheets to Alteryx

Oct 9, 2021 Viktoriia Slaikovskaia | www.thedataschool.co.uk

Input in Alteryx is the first tool you will learn and need to start working withdata. It’s easy to use by Drag & Drop to your Workflow or choosing FileConnection in Input Configuration. But what if we need more than one file, sheetor even seve...

Introducing Dremio, a Gnarly Data Solution

Oct 8, 2021 Justin Lemmon | interworks.com

InterWorks recently joined Dremio’s Global Partner Network, so naturally we’re here to give you a rundown of what Dremio is and when you’d look to use it. Dremio is a SQL Lakehouse Platform that features a shared semantic layer and provides high-p...

Data,AmazonS3,Azure,datalake,Dremio,GlobalPartnerNetwork,SQLlakehouse

Can you make stacked bar charts easier to compare?

Oct 8, 2021 Donna Coles | donnacoles.home.blog

Candra McRae was back to set the challenge this week. I found it relatively straightforward, so if you’re relatively new to Tableau, this is quite a good challenge to start with. In this we’ll cover Grouping the states Applying the sort Adding the...

From Small Organisms to Small Multiples: Mitch Lee’s Journey to Tessella...

Oct 7, 2021 Mitch Lee | www.tessellationtech.io

In this blog post, Mitch Lee tells the story of how he started from a career in microbiology to transitioning to the data analytics industry. … Read MoreThe post From Small Organisms to Small Multiples: Mitch Lee’s Journey to Tessellation appeared...

Careers,journey,careeradvice,CareerInsights,datacareers,JourneytoTessellation

Identify and Modify Grouped Values in Tableau Prep

Oct 7, 2021 Eric Parker | onenumber.biz

The numerous grouping options in Tableau Prep are one of the best parts of the tool. In addition to manual grouping, you can group based on common characters, pronunciation and spelling. However, scrolling through existing values and grouped value...

TableauPrep,Data

Tableau and Slack: New Beginnings

Oct 7, 2021 Roger Garcia | interworks.com

Tableau is committed to helping people see and understand data. This translates into many things: building products with intuitive platforms, making AI available in a no-code/low-code environment and investing in data literacy and governance, just...

Data,2021.3,dashboards,Salesforce,Slack,Tableau

How to Configure Remote Git Integration for Matillion with SSH Keys

Oct 7, 2021 Chris Hastie | interworks.com

Remote git integration is a way of backing up a local git repository to an online git management provider, such as GitHub, GitLab or Azure DevOps. If a customer has multiple Matillion instances for any reason, this also allows them to make changes...

Data,authentication,Git,keypair,Matillion,SSH

InterWorks Blog Roundup – September 2021

Oct 6, 2021 Andrea Avey | interworks.com

And just like that, another month gone! September on the blog saw 13 new posts and 18 contributors, and a lot of this month’s focus was on security, convenience and recognition of individual contributions to the data community and beyond. It was a...

News,Matillion,monthlyblogroundup,SSH,Tableau

Automating Matillion VM Start & Shutdown Process for Azure

Oct 6, 2021 Chris Soule | interworks.com

This is a walkthrough for adding a task that automatically starts the Matillion instance at a certain time and another task that shuts down (deallocates) the resources of the Matillion instance via an API endpoint. These two tasks are intended to ...

Data,automation,Azure,Matillion,VM

Snowflake: The Basics

Oct 5, 2021 Hannah Murphy | www.thedataschool.co.uk

An introduction to Snowflake and why we use it. This blog aims to be a not so brief overview of the interface and how to use it in preparation for my online session with TIL Events.

Data,2021.3,Dev,Governance,PROD,Sandbox,Tableau,WebinarReplay

Webinar Replay: Tableau Governance 101

Oct 5, 2021 Debbie Yu | interworks.com

Does any of this feel familiar? Our end users struggle to find the dashboards they’re looking for in my Tableau Server/Online environment. Stakeholders are confused as to which dashboard(s) should be the source of the truth for reporting. Stakehol...

Data,2021.3,Dev,Governance,PROD,Sandbox,Tableau,WebinarReplay

Live Stream – Do More with Data: An Introduction to Tableau CRM

Oct 4, 2021 Analytics Events | www.tessellationtech.io

Learn how to boost efficiency, develop data-driven predictions, and overcome obstacles by integrating Tableau CRM at your organization. … Read MoreThe post Live Stream – Do More with Data: An Introduction to Tableau CRM appeared first on Tessellat...

Tableau,UpcomingLiveStream,Webinar,LiveStream,tableau,TableauCRM

Data Science Stats Review: Pearson’s, Kendall’s, and Spearman’s Correlat...

Oct 4, 2021 Zac Zinda | www.tessellationtech.io

Data Science Stats Review: Pearson’s, Kendall’s, and Spearman’s Correlation for Feature Selection An important part of the data science development cycle is determining which features should be included in a model. While it may be tempting to thro...

DataScience,Technical

4 Tips for Writing Complicated Tableau Calculations

Oct 4, 2021 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

Writing calculated fields can be really difficult, especially when the logic is complex or there are multiple layers. In my time using Tableau, I’ve come up with a handful of techniques that I’ve found make it easier to write complicat...

How-To,Tableau

Liu Zhang's Blog Index

Oct 3, 2021 Liu Zhang | www.thedataschool.co.uk

Photo by Alfons Morales[https://unsplash.com/@alfonsmc10?utm_source=ghost&utm_medium=referral&utm_campaign=api-credit] / Unsplash[https://unsplash.com/?utm_source=ghost&utm_medium=referral&utm_campaign=api-credit]Data School Weekly...

Data School training reflective blog - DS24

Oct 3, 2021 Liu Zhang | www.thedataschool.co.uk

Looking back over the 4 months of training we had, both in terms of technical and social. My personal experience for future cohort to get the most of theirs time for the period.

DS24 Training Blog - Week 17

Oct 3, 2021 Liu Zhang | www.thedataschool.co.uk

Made it, the final week. The final challenge of Dashboard week.

Universal data visualisation design

Oct 1, 2021 Penny Richmond | www.thedataschool.co.uk

Universal design is the design of products, environments and buildings to makethem usable to as many people as possible, regardless of their age, ability oranything else. It is grounded on the idea that a broad array of human abilitiesis ordinary ...

Business,companynews

Date calculations in Tableau

Oct 1, 2021 Ollie Matthews | www.thedataschool.co.uk

Reference of Tableau date calcs

Business,companynews

Dashboard week - day 5

Oct 1, 2021 George Pattinson | www.thedataschool.co.uk

Day 5 - our final day of dashboard week and final day in DS24! We had a go at downloading and prepping Seattle bike count data.

Business,companynews

Dashboard Week - Day 5 - Cycling traffic in Seattle

Oct 1, 2021 Burcu Aksakal | www.thedataschool.co.uk

Our task is to download the data for all bike counter locations in Seattle and prepare data in Alteryx. I appreciate we had a lot of practice with Alteryx this week. For me, it’s a happy ending…

Business,companynews

Dashboard Week |Day 5 -Bike Counters in Seattle

Oct 1, 2021 Anastasija Starkina | www.thedataschool.co.uk

Today is the last day of the training and it feels surreal that 4 months havepassed so quickly. Todays task was to extract data from seattle.gov.us regardingthe cycling traffic in Seattle. There were a total of  10 datasets that we hadto extract a...

Business,companynews

Dashboard Week Day 5 - Battling with APIs and CSVs

Oct 1, 2021 Hannah Murphy | www.thedataschool.co.uk

I started today with the intention of using APIs to build a dashboard on Seattle Cycling Traffic. However, I ended up spending all day battling with APIs, CSVs and parsing in Alteryx.

Business,companynews

Dashboard Week |Day 4 -Boys Bands

Oct 1, 2021 Anastasija Starkina | www.thedataschool.co.uk

Today was the 4th day of the Dashboard Week and Andy decided to cheer us up withsome interesting datasets!  Our task for was to analyze the Boys Band data fromGithub.  The data was split between two datasets: One with the complete artistinformatio...

DataScience,Technical,Tutorial,AmazonSagemaker,AWS,MachineLearning,MachineLearningOperations

DS24 Dashboard Week - Day 5 - Bike Counters in Seattle

Oct 1, 2021 Muneeb Sajjad | www.thedataschool.co.uk

Final week of training, dashboard week,. Final day of training, day 5.

Business,companynews

DS24 - Dashboard Week Day 5

Oct 1, 2021 Liu Zhang | www.thedataschool.co.uk

Last day of training, final challenge!Suddenly some unexpected task in hand.

Business,companynews