Keyboard Settings for Excel via VMFusion

Ever have problems using your standard keyboard shortcuts in Excel when running it on a Mac in VMFusion? Me too… So, after some digging and testing I found some of my basic Excel navigation functions would trigger rather heinous responses by my Mac (currently running Lion). Here is what I was able to do to…

Continue reading →

How to add an ‘All’ parameter option in Tableau

Ever wanted to include an ‘All’ option in your Tableau parameters? Simple! Here’s how: Create your parameter with the options available. In this example I’m creating one for [Region]. Make sure to manually add the ‘ALL’ option. Drag the corresponding field you will be filtering on to the filters shelf Right click on the field…

Continue reading →

Customizing Tableau Server Logos and Icons

When deploying Tableau Server for a client, I often find that clients wish to customize their Tableau Server environment with their own branding. The Tableau Server Administration Guide offers some options for customizing Tableau Server however it is limited in what it allows. Here are the default options that you can customize using tabadmin commands…

Continue reading →

Amazon EC2 Hosting and Tableau

Recently I started working with the Amazon EC2 (more) and have been pleasantly surprised. In about 20 minutes I was able to create my own Windows 2008 R2 Data Center Edition Server in the cloud with enough space to run Tableau Server. Choosing one of the basic configurations from Amazon makes life easy to provision…

Continue reading →

Full Device Encryption on Android 4.0

After upgrading my mobile device to the Nexus S from Google, I was poking around in the security settings when I found something new. Android 4.0 now has full-device encryption capabilities. This means that while enterprises wishing to gain the usefulness and beauty of information design presented by mobile BI vendors like Roambi but have…

Continue reading →

Excel Tip – Hacking Excel Web Queries

If you are unfamiliar with web queries its OK, their easy, and I’m gonna explain how they work and how to manipulate them beyond their intended use to increase their flexibility. Excel Web Queries Overview Briefly, an Excel Web Query is a great way to automate the mundane task of going to a web page…

Continue reading →

Predictive Analytics Applications for Business

The application of predictive analytics towards business provides companies with competitive advantage and removes the guesswork of strategic decision-making. Predictive analytics is the practice of applying statistical data mining algorithms on historical business data to predict future customer behaviors or trends. This practice encompasses many methods and processes outside the scope of this paper. In this paper, I will dive into segment of predictive analytics related directly to predicting business outcomes using statistical data mining practices.

Continue reading →