Powershell: How to encrypt and store credentials securely for use with automation scripts.
I recently worked on a quick and dirty Powershell script to send me email notifications when content on a web page changed. To send the email, I also went for the quick and dirty method and just used SMTP with my Gmail account. After I finished this dirty masterpiece, I couldn’t handle seeing my password […]
Editing Connections in Tableau
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 for your company, within a different business unit, would […]
Using Custom Colour Palettes
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 using the default Tableau Colour Palette To amend a […]
InterWorks to Attend HP Vertica Big Data Conference in Force
STILLWATER, OKLA. – A large contingency of InterWorks team members will attend the upcoming HP Vertica Big Data Conference in August. Included in the group are several InterWorks database developers and analysts, possessing extensive experience with the Vertica Analytics Platform. The inaugural HP Vertica Big Data Conference is scheduled for Aug. 5-7, 2013 and will […]
InterWorks Ranked #3 in ‘Best Places to Work In Oklahoma’ Competition
OKLAHOMA CITY, OKLA. – okcBiz Magazine ranked InterWorks #3 in their recent Best Places to Work in Oklahoma competition. This marks the third consecutive year in which InterWorks made the top 10 in the Small/Medium category. The #3 ranking is the highest for InterWorks to date. The top 30 companies attended an awards dinner on […]
Tableau Software Partners with DataSift, Google BigQuery
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 be able to delve deeper into data from Facebook, Twitter, […]
Marimekko in Tableau
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 visual superiority when dealing with large numbers of members; however […]
Outer Joining Multiple Excel Tables in Tableau 8
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, there are some sales leads that are added […]
Ditch the Schedule! Use PowerShell to Trigger Tableau Extract Refreshes
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 ‘GetOracleData’ text file and save […]
Tableau European Conference TCC 2013
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 Higgins / Paul Laza, Unilever and Medway Youth Trust’s Gary […]