This is part 2 of my mini-series on exploring Tableau workbooks with PowerShell. If you missed it, you should read Part 1: Opening Workbooks, before continuing. Welcome back! Last time I showed you how to open a Tableau workbook (TWB or TWBX) in PowerShell so you...
New and old Tableau users alike struggle with grasping Tableau's concept of Layout Containers. I put together this exercise last week for a recent training course to help explain what is going on behind the scenes. Layout Containers in Tableau 8 force spatial relationships between dashboard...
In this mini-series I'm going to show you some cookbook style examples for using PowerShell to explore your Tableau workbooks. Follow along, this is going to be fun! Tableau workbooks (TWB files) are just XML files. Packaged workbooks (TWBX files) are just ZIP files that contain...
I saw an interesting post and data set this morning from ProCon.org. The information was in tabular form, so I copied it and extracted the data into Tableau. 20 minutes later, I had a fully-interactive dashboard that presented the information relevant to me in a...
(This is a multi-part series about the proper care & feeding of a Vertica cluster. There’s simply too much content for one post, so I’ll be splitting this up into a three-part series. Check back in a few days for the next installment.) Vertica is a...
Some fun Table Calculation questions came in this week. With four hours in the air heading home to New York from Portland, OR, I thought I’d quickly add these to the learning library. Here’s the first – I’ll put up another post with the second,...
Tableau Server is officially online. Users can now take advantage of their data from virtually anywhere with Tableau Online, a hosted (SaaS) version of Tableau Server. The benefits of a comprehensive, cloud-based business intelligence platform in Tableau Online are massive: Greater Access to Tableau Server With Tableau Online,...
About a month ago, HP Vertica released its latest service pack, HP Vertica 6.1 Service Pack 2 (version 6.1.2). It may sound like a small release, but the service pack actually includes a couple of major changes that could have a dramatic impact on the...
Is your Tableau extract done? Don’t wait to find out! Send yourself (or a group) an email. If you haven’t already, make sure you’ve done this and this. Oh, and make sure you’ve got PowerShell v3 installed. Done? Perfect. Let’s get to the fun stuff. We’ll be...
A Quick Way to Reengineer Worksheets & Workbooks for New Data - Imagine you are receiving updated versions of the same or similar set of data. Possibly, you are sent an excel file each week with the current market data, or perhaps a colleague that works...
Tableau has the ability to recreate any colour by using the RGB colour model. By using this you can customise your charts and dashboards to match your corporate branding guidelines. The chart below shows the top 5 BBC Television Channels by expenditure in 2012. It is...
Tableau, DataSift and Google BigQuery are intent on taking social media analytics to the next level. The three recently forged a partnership that will enable users to seamlessly integrate their data within these platforms, allowing near endless possibilities for social media data analysis. Users will...
This Marimekko chart was fun to get right. There are some great examples of complex table calculations built in to it. The use case is similar to that of a series of stacked bars. It has graphical similarities to a treemap but it lacks the...
Scenario Our sales team collects information and forecasts possible sales using a data-table called ‘Opportunities’. If a sales opportunity converts to an actual sales lead, the customer and his information is moved to the ‘Leads’ table. Opportunities that do not convert remain on the original table. Additionally,...
Your ‘To-Do’ list: We’ll use Oracle for this example. In future posts, I’ll discuss other databases (including SQL Server). Download and install the ODAC (Oracle Data Access Components) from here. Make sure you have PowerShell v3 installed. Step 1: Set up the link between PowerShell and Oracle Copy the attached...
The Tableau Customer Conference 2013 turned out to be a truly inspiring event. Hans Rosling captured the hearts and minds of the packed event room as did Andy Kriebel (Facebook), JP Rangaswami (Salesforce), Tableau’s own Christian Chabot and many customer speakers such as Cisco’s Rob...
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...
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...
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...
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...
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