We all know that we can create some pretty cool maps in Tableau using fields like City, State and ZIP Code; however, Tableau cannot natively map street addresses. In order to plot specific addresses, we’ll need to use latitude and longitude coordinates. Through the use...
Recently, I was working with a client on a dashboard using a wildcard filter to search for thousands, if not millions, of unique item part numbers. This was a very large company, where a “big” data set meant at least a few billion rows of...
Import.io is the best tool for scraping structured data off the web. Alteryx is the best tool for self-service data analysis. It doesn’t take long to realize that we should put the two together. Using the Import.io API, the InterWorks Import.io connector allows you to read...
If anyone ever told you it’s not possible to make a dynamic fiscal calendar in Tableau, then you weren’t talking to someone from InterWorks. It may require a few steps, but as is often the case, all we need are a few clever calculations. So, what...
While not a regular occurrence, I have come across situations where a client wants to display a hidden sheet with an action filter but wants to enable different worksheets to activate the hidden sheet. If the sheets are filtering on different fields when you set an...
Even with the best planning, we occasionally end up with less than speedy dashboards. Tableau is great at crunching large amounts of data – but when you are looking at many different slices of millions of records, anything would be slow. There are many ways to improve the...
Tableau Dashboards are great for a lot of things; however, one need I hear often is the ability to add notations to dashboards. You can obviously add notations inside Tableau Desktop, but in an Enterprise level dashboard, there are many issues with this approach. Any user annotating...
In Microsoft Exchange, you may have received these error messages: "The signature is too big. Please try a smaller format." "The Property X is out of range, the valid range is x to x." "The length of the property is too long. The maximum length is 8000 and the...
In Part 1 of this is series, I explained the general premise behind our Quantified Office dashboard. In this part of the series, I'll explain why we chose a visualization type called the "sunrise chart" and show how we created it. I'm the first to admit that the sunrise chart in our dashboard doesn’t...
The Run Command tool allows you to extend the capabilities of Alteryx by running external commands the same as you would from the command line. Need to run a Python script? Gzip a file? Utilize tabcmd? All of this can be done using the Run...
We live in an amazing world. Anything and everything can be monitored; usually without us even knowing. Just the other day, I installed an app on my smart phone and realized that my phone had been quietly recording my daily step count for years! In our...
In most real world data sets, we want to compare “year over year” values. How were we doing last year? How does that compare to this year? Monitoring these comparisons can provide valuable insights to your business; however, the calculation is cumbersome and slow to generate in...
Have you heard that if you send your husband to purchase diapers at the grocery store it is statistically more likely he will also purchase beer? Unexpected relationships like this in your data can be found with what is known as market basket analysis, or...
When dealing with large data sets speed can be crucial. Fortunately, Alteryx Predictive Tools utilizes R to provide a seamless framework to extend the toolset that comes with Alteryx Designer. This means that Alteryx users benefit from all of the powerful packages developed by the...
Some of my favorite mobile apps like Slack, Feedly and Google Maps have a slide-out menu that appears when I tap a small icon. That common design element makes plenty of room for user inputs and gets them out of the way when you’re done...
About a week ago, I shared a blog post that demonstrated a new way to visualize Key Performance Indicators (KPIs) in Tableau. This week, using the same viz, I’ll show how to set up single-click hierarchy navigation. The Challenge Those of us familiar with Pivot Tables in...
Parameters are one of the most loved features of Tableau. You can use them in calculations, across multiple datasources, in titles and labels, and in countless other ways. Unfortunately, they are static. Unlike filters, parameters are a set list of values. You can build them based off...
Key Performance Indicators are one of the most common things people need to display in a dashboard. This usually involves comparing current values or historical trends against a target value. Tableau makes it easy to show current values and trends in one dashboard, but this...
A common question that often comes up in trainings is: “How can I add conditional formatting to my visualizations?” Conditional formatting can be a useful way to call attention to textual data. Common cases of conditional formatting involve using Color or Symbols (That’s symbols for all...
With Windows 2012 / Windows 2012R2 now offering a way to failover DHCP, many organizations have opted to migrate their DHCP functions from an older operating system. There are multiple, creative ways to handling a migration from an old server a new server; this article...
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