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...
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...
Let’s be honest, the new version of Tableau is pretty slick. Despite how one feels about various additions/omissions to the software, the most recent update is a step in the right direction. While never perfect for every person, the software will certainly encourage more people...
As a new employee of InterWorks, and a new disciple of Tableau, I had the pleasure of attending the Tableau 8 Tour events on the east coast in Washington D.C., Reston and Philadelphia, as well as the Texas events in Austin, Houston, and Dallas. The...
“Data for data’s sake is a path to disaster” As is so often the case, various colleagues, friends and random members of the data culture offer up ideas regarding the use of Tableau, data and design. Sure, some of these “Huh, I wonder if I can...
Our business intelligence consultants are constantly engaged in tackling challenge after challenge. The individual capabilities of each are impressive enough, but what they accomplish together is what makes them such an effective team. We’ve decided to share some of the solutions they’ve created together in...
In light of the Tableau 8 launch today, I decided it might be a great time to share one last tip for Tableau 7, for those who might not be upgrading right away. Here we go.All starts with a question: Can I use a URL action...
This week I had the pleasure of speaking in Boston at EACUBO with a friend and business associate, Ted Curran (Executive Director of Finance at Carnegie Mellon University). EACUBO aims to promote high-quality, professional development opportunities to higher education officers. This, year Ted and I...
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
