Channel

Excel Tag

If you are transferring a dashboard from Excel to Tableau, and the Excel file uses the PERCENTILE.INC and/or the PERCENTILE.EXC functions, this is how to handle them in Tableau. Some Basics of Percentile Calculations There are several different methods of calculating a percentile score, but there are...

Traditional vs modern, apples vs pears, both tools take on the challenge of data analytics and data manipulation and give key insights but in this webinar, we explore the key differences and the considerations you should make when deciding which tool can do the job...

Kicking off a new year of Snowflake blogs seemed like a great opportunity to give you the tips and tricks of connecting to Snowflake from Excel. Businesses have been using databases to get data for Excel workbooks forever, but looking through the depths of Google,...

Do you ever have those watercooler debates at work that never get a real sense of finality? A coworker claims the trade OKC made for Carmelo Anthony was worth it, and you know in your heart that they are completely wrong, but you keep it...

Before we look at data preparation using Excel and Tableau Prep, we need to ask a question. It’s always a healthy discipline to ask questions first and use technology to answer them second. Take a look at the question, look away from the screen then take...

Four years ago, I wrote a blog post speculating about future business intelligence workflow and tools for business information systems that would provide the capabilities of high-priced legacy enterprise business information systems but at a fraction of the cost. Part of that post included a...

I rarely ever receive pristine data, and I’d wager that’s true for most of us working in data analysis or business intelligence. Data can come to us from dozens—if not hundreds—of sources, and it certainly requires some preparation to make it useful. One of the...

I'm a chartered accountant, and my background is in building finance functions and creating financial performance analysis reporting functions. I trained in a public practice, and after around six years, moved into industry. I've been working in industry for the last seven years, and analysing...

Tableau isn't just a useful tool for visualising and analysing data. There's no doubt it has enabled me to improve and optimise my team, but there's another benefit I did not initially appreciate when I first began using Tableau. Coming from the world of Excel,...

So, a little about me, the author: I'm a chartered accountant and my background is in building finance functions and creating financial performance analysis reporting functions. I trained in a public practice and, after around six years, moved into industry. I've been working in industry...

Over the course of the past year, I’ve combined my love of genealogy with an increasing interest in data visualization. I’ve long had an Ancestry.com account, but I always wanted a more visual representation of where I came from. Cue Tableau. After working in short...

This post builds off of two great previous posts about Tabcmd by Kate Treadwell and Tanner Ladd. Please refer back to these posts if you have questions about setting up Tabcmd and distributing PDFs. The goal of this post is to show you how to use...

The Problem Many times, it is necessary to display content in Tableau in a verbose manner. For example: displaying comments from a survey or showing lengthy project descriptions or calls to action in an executive dashboard. Connecting Tableau to a database with long string fields or textarea...

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!