Leverage PowerShell and Tableau to Extract Server Datasources
Question: Of all the workbooks on Tableau Server, which (1) use a Tableau Server data source and (2) what workbook(s) use them? Answer: Since there’s no simple and straightforward way to extract this information from the default views on Tableau Server (_datasources, etc.), we’ll use a short and sweet PowerShell script to do the heavy […]
ShoreTel: Time and Date Wrong on Phones
When installing a fresh copy of ShoreTel or migrating an existing ShoreTel install to a new server, by default the ShoreTel phones will try to retrieve their date and time from the ShoreTel server. By default, the NTP settings will not be enabled in a Windows 2008 operating system. If the ShoreTel phones are not […]
Encrypting Your Mac with FileVault
Encryption has been becoming an increasingly popular implementation when it comes to data storage and transfer, and it’s not always a difficult thing to do. I recently encrypted a Mac Book Pro running OS X 10.8 (Mountain Lion) with FileVault 2 and was surprised at just how easy it was. Despite the ease of the […]
Civic Data and Tableau: Exploring Volunteer Metrics
Is data visualized more insightful than data stockpiled? It certainly depends on who you ask but, in some very specific cases, data visualized can shed light on some tightly guarded tribal knowledge. To that end, the team for the Civic Data Challenge has provided numerous datasets on, well, civic data (volunteering, civic engagement, etc.). It’s […]
Twitter Ads Available to All US Businesses: Why You Should Care
On April 30, Twitter announced that Twitter Ads will now be generally available to all US-based businesses. Previously, Twitter Ads was available by invitation only, allowing only a select number of businesses and artists to take advantage of the platform. Now any small business, or even individuals who feel so inclined, can create a Twitter Ads […]
Exchange Activesync maximum partnerships
So I know my title at InterWorks, Inc. says “Systems Engineer”, however many of the people know me here simply as “the cell phone guy”. Why? Because I always have the newest, latest and greatest, and not always just one. I generally do a full business test of the phones which includes syncing them to […]
Querying Vertica System Tables in Tableau
One of the easiest-to-use diagnostic and troubleshooting tools we use here at InterWorks when working with Vertica clusters is Tableau. Vertica tracks a vast amount of information about cluster and database status. Diving into that data and quickly building visualizations and dashboards from these system tables can be very useful for system and database administrators. […]
Leverage Multiple Tableau Data Extracts for Big Data in Tableau 8
What you will cover: Aggregating extracts to different levels (Year / Month) Data blending Calculations Parameters Step 1: Model your Data (read: What are you trying to analyze?) For our specific case, we’ll have a total of 5 TDE files and our dashboard will move seamlessly through each of them using just one parameter control. […]
Drupal Quick Tip: Auto “node/nid” Paths from Alias in Menus
“In learning you will teach, and in teaching you will learn.” Words spoken by (or, at least, attributed to) the great Phil Collins (side story: my first conversation with anyone at InterWorks was with Aaron Confer discussing Genesis and Phil Collins). During my last training at OSU, I definitely learned something new. For people brand […]
Customizing Tableau Tooltips
Whenever I get the chance to introduce someone to the world of Tableau, one of the first things people tend to fall in love with are the tooltips and the ability to quickly view the underlying data of a mark. The default tooltips in Tableau are a great starting place to quickly see details about […]