Microsoft Outlook – Exchange is unavailable, Outlook must be online or connected.
The Issue: I ran across an interesting issue today while setting up a new laptop in which I was getting an error while trying to add a new email account. During the process Outlook informed me that, “The connection to Microsoft Exchange is unavailable. Outlook must be online or connected to complete this action.” The […]
Big Changes in Vertica 6.1 SP2 (6.1.2)
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 way you use Vertica. Enterprise Features Now Available in Community […]
Creating Email Notifications for Complete Tableau Extracts
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 using some PowerShell and, of course, Tableau. Imagine […]
Table Calculations – Why apply them ‘By Cell’
A question I was recently asked by an in training Tableau User was ‘Why would I apply a table calculation by cell?’. To answer this I have produced a simple example of a by cell Table Calculation. Before I get to it I would like to run through some Table Calculation basics. Calculation Direction One […]
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, […]