Showing Header for Text Table with Single Measure in Tableau

I had a question from one of my students tonight about how to show the header for text table with a single measure. It’s not super straightforward to do this in Tableau. You can’t simply to go the measure pill and show the header (because it doesn’t have it).

Let’s recreate the default Tableau behavior first, using Superstore Sales.
1. Double click on a dimension, for example, Product Category
2. Double click on a measure, for example, Sales

What you will get is something like this:

default behavior - no header

Continue reading

Installing SQL Server using PowerShell Desired State Configuration (DSC)

Note: DSC can only be run if you have at least Windows Management Framework 4.0 and if your operating system is at least Windows 8.1 or Windows Server 2012 R2.

The PowerShell team has released the xSQLPs module as part of the Desired State Configuration (DSC) Resource Kit. xSQLPs contains xSqlServerInstall, which you can use as a starting script when installing SQL Server via PowerShell and DSC. Download the module here.

This is what I needed to do to install SQL Server using DSC and the xSQLPs module. Many of these steps are from the xSQLPs documentation page.

Continue reading

Microsoft Big Data Hackathon is happening in Vancouver, April 18-19, 2015

Microsoft Big Data Hackathon April2015

The Microsoft Big Data Hackathon is happening in Vancouver. (Register here)

April 18-19, 2015 (Saturday and Sunday)

Simon Fraser University – Morris J Wosk Centre for Dialogue (Map)
580 W Hastings St
Vancouver British Columbia V6B 1L6

You will need to register for the event. Register here.
To participate, you will need to be part of a 3-5 member team.

Continue reading

Looking for someone to jumpstart your visual analytics project or prototype?

Looking for someone to jumpstart your visual analytics project or prototype?

At BCIT, we have been offering a course on Visual Analytics using Tableau to Part Time Studies students. This course is offered three terms:

  • Winter (January to March/April)
  • Spring (April to June/July)
  • Fall (September to December)

Many students who register for Part Time Studies are working professionals who are taking courses to complete additional certificates/diplomas, or for professional development, or just plain curious.

Students enrolled in the COMP 2256 class learn visual best practices, some data analysis, and visualization using Tableau Desktop. Part of this twelve (12) week course is a term project which requires data analysis and visualization around a topic of their choice. They will need to submit a series of dashboards and a final project report at the end of the term.

The project requires the students to either:

  1. look for a sponsor (could be their employer, a non-profit organization, etc) for their visual analytics project, to be presented to their peers at the end of the term
  2. look for a number of sizable public data sets that they’re interested in, and essentially create dashboards that will support their story

I encourage students to, as much as possible, choose #1. This is as “real world” as it gets. However, looking for a sponsor can become tricky and time consuming for already-working professionals, so I am hoping I can help match up my students to your projects.

Continue reading

#LikeAGirl – It means … doing the best you can

I really liked the @Always #LikeAGirl Superbowl XLIX halftime commercial. For me, it doesn’t really matter whether you’re male or female. But it is sad that there are still prejudices out there based on gender (among other things), but I hope it won’t stop anybody from trying – to live, to grow, to learn, to reach your dreams, and to do the best you can with anything that you do.

PowerShell V5 (WMF 5.0) Preview: OneGet and PowerShellGet

The most recent Windows Management Framework (WMF) 5.0 Preview, the November 2014 preview, provides a glimpse of many improvements you can expect when PowerShell V5 is released.

A couple of the most noticeable additions are OneGet and PowerShellGet. If you have experience in *nix, these two new features are very similar to apt-get or yum or RPM. It allows you to connect to web-based package repositories, and install them.

Continue reading