Relying on p-values to reach business decisions is common, which is reason for concern. Conducting analysis that’s too heavily based on p-values and engages in an unfettered quest for statistical significance can lead to decisions that are fundamentally unsound. To understand why, we’re going to...
Welcome, diligent readers of the InterWorks blog. Today, I am kicking off a great two-part blog. Internally, we have been tossing around conversation about a really unique tool called Airtable. Overview Airtable is a cloud-based spreadsheet-database-formbuilder piece of technology that offers a very unique approach to the...
On this episode of Quantified, host Garrett Sauls welcomes back InterWorks analytics consultant and training lead Katie Wagner to discuss data collection. Katie shares some manual and automated processes for acquiring data, responsibilities and ethics that inherently come with data collection, and important questions we...
By now, most of us have utilized the tableau-server-obliterate.cmd script that comes with version 2018.2 and beyond (if you haven’t, you are about to find out what that is). But what do the rest of those built-in scripts do!? These are, by default, located under the...
Let me start off here by laying out the pros and cons of using table calculations when it comes to measuring distance. Pros: Table calcs do all of the work instead of us having to type out every latitude and longitude coordinate in a calculated...
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...
It’s no secret that Tableau Prep is a game changer for those looking to clean, explore and connect their data sources together. There are myriad join options, from your traditional left, right and inner joins to more advanced options such as Left Unmatched Only, which...
Whether you just made the investment in Tableau Software or you’re leading an established Tableau community, getting the most out of Tableau is a goal that most analytics decision-makers have in common. This all starts with your users. How do you spark and keep their...
This blog came out of a desire to see which Canadian province is the “most Canadian.” After some extensive research into what metrics might quantify this (see below) and some searches for data, I settled on maple syrup production to at least get started. Who...
We're kicking off a new show aimed at getting to the roots of data - what it is, what it means and how we can work with it. We'll cover all of these topics and more over the course of the first season. In the first...
I’m a bit of a Jeopardy! fanatic. Okay, that’s an understatement. I love Jeopardy! and I love trivia. Given the recent airing of the All-Stars tournament, it was a no-brainer for me to create a dashboard celebrating the Jeopardy! GOATs—the greatest of all time. Well,...
By now, you probably know that data is valuable, and you need it to make the best decisions for your business. But what does that really look like, and how do you put the right infrastructure into place to get the results you’re seeking? In this...
In the last blog, we looked at comparing all locations against a single, static point. Now, we can build on this and account for a selection of points in our distance calculation by using a parameter. This will enhance the interactivity of our viz and allow...
Join Garrett Sauls and Katie Wagner as they talk about the basics of data and tackle important baseline questions about a career in data during this special preview of our new podcast, Quantified. Subscribe to Podcast Your Data through iTunes, Stitcher, Pocket Casts or your favorite...
A couple years ago, as I was trying to teach myself programming, I managed to wipe out my computer. It was a silly mistake—all I was trying to do was learn how to work in command line and set a directory for R. Through some...
This blog post focuses on different aspects of the Alteryx platform that I’ve received questions on while delivering training. Hopefully, this will help answer some questions you may encounter in your analytics work. Transpose and Crosstab You can use the Crosstab tool and the Transpose tool to...
This question comes from my student Christie. She wanted a quick way to create a date slider that started after a certain point in her data. The issue is, if you set your Range of dates or Starting Date filter to begin at a certain...
As you may have heard, InterWorks’ best asset is by far our people. It’s the thing I’m thankful for day in and day out and one of the first answers I give when asked why I enjoy working here. Today is International Women’s Day, and...
New Year, New Year’s Resolution. I’m not a huge believer in resolutions, but I do have a list of to-dos on my desk, and now seems as good a time as any to get things going. One of those things I’ve been meaning to do...
Question: How would I go about calculating how many states generate a specific percentage range of sales? Like > 10% of total sales as an example? I want to know where to target more marketing efforts. Can you help me get started? As with most things...
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