I spent years trying to kill Excel. Not literally. But as an analytics architect, I approached every spreadsheet like a building that needed to be condemned. Manual data entry. No source of truth. Formulas nested inside formulas. One wrong change and the whole thing breaks. I was...
If you ever want to ingest data from an Excel file into Snowflake using Matillion, you can do so with the Excel Query component. If you know the name of the sheet you want to ingest, you can simply enter the name into the component and...
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...
Question: I have multiple tables on a single Excel sheet. Can Tableau point to a specific range of cells in Excel, or do I need to make new sheets? The Challenge In an ideal situation, you will always want to structure your data so that it is...
Running multiple flows every day from your computer and opening them one by one is a method that’s far from perfect. The reason why we put work into implementing more robust solutions than copy-paste between Excel workbooks was to cut the time on manual, repetitive...
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...
Question: I have new records in my Excel data that were not there when I created my custom groups. Tableau Desktop isn’t letting me update the group anymore. How can I make these changes so that they take effect across all my workbooks? This question...
Question: I want to only connect to certain rows in my Excel file, but I’m not seeing how to do that from Tableau. Is there a way to do this? Tableau connects to Excel as if it were a database. By default, it will connect and...
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...
If you’ve used Portals for Tableau’s Data Manager feature, it’s likely you have utilized the Tableau-friendly table in your dashboards. However, there are times when you need to get at the raw data but don’t have or don’t really need direct access to the database....
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...
In this post, we'll have a little fun with Brazilian Jiu-Jitsu or BJJ for short. I recently began training in BJJ at the Renzo Gracie Academy in Portland, OR. I feel very fortunate to have found a facility full of great people to be around,...
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