Data Warehousing / Business Intelligence at Pluralsight

It’s been another busy month, and I’m pleased to announce my two newest modules were published today on Pluralsight. If you’re not familiar with Pluralsight, they are a training company that has a vast library of training videos.

The description of my new course can be found here:

There are two modules, the first is an introductory session for DW/BI. It’s primarily slides, by the end you’ll have a grasp on the arcane terms around Business Intelligence such as facts, dimensions, surrogate keys, OLAP, and more.

The second module is an overview of the Microsoft tools for doing DW/BI. It starts with the Adventure Works Lite database. From there a data warehouse is built, on top of which an analysis services cube is created. Finally a report will be generated off the cube that meets a specific business need.

Along the way attendees will get to see Visual Studio 2010 Database Projects, along with the SQL Server toolkit: SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services. Attendees will also get a look at SQL Server Management Studio.


PowerPivot with Pluralsight

For the last few months I’ve been cooped up here in the Arcane dungeon, working on a new project. And now that’s it’s released I can finally share all the details.

While I’m still happily employed during the days as a BI Architect for Comframe, in my spare time I’ve been acting as a technical advisor to a training company called Pluralsight.

I’ve developed a series of four training modules on PowerPivot for Excel 2010. The first module is an overview, that gives you the basic steps on creating a pivot table using PowerPivot.

Module 2 goes in-depth on working with data behind the scenes. How to add calculations, formatting data, filtering data and more.

In the third module I cover the creation and formatting of Pivot Tables, formatting them for users, using DAX (Data Analysis eXpressions), and how to use Sparklines with PowerPivot data.

In the last module we explore the charting capabilities of PowerPivot, covering various types of charts and ways to format charts. We then use the knowledge we’ve gained over the last four modules to create a realistic dashboard.

If you are already a subscriber to Pluralsight, take a look, the courses are now live. If you aren’t, take a look, Pluralsight has the best training I’ve seen on the net and it’s growing daily.

Birmingham User Group Holiday Party is on! Dec 6 2010

I’m pleased to announce the third annual Birmingham User Group Holiday Party. Each year user groups across Birmingham gather for a combined Holiday Party.

As in past years, this event will be at Richards BBQ and Grill on Acton Road. We’ll begin about 5 with a social hour, and order food around 6 pm, to begin eating between 6:30 and 7. Don’t worry though, if you are running late you’re still welcome. We’ll conclude around 8pm. As in past years, we’ll simply order off the menu which has a wide variety of selections, enough to satisfy everyone’s taste buds. With the mix of groups, each person will be responsible for their own bill.

We highly encourage everyone to bring their spouses and kids. You may bring a gift for your own kids to open if you wish. We promise to keep the geek talk to a minimum.

This event is open to all of the Birmingham tech community, there is no requirement to be part of an existing user group to attend.


For more details, e-mail me, arcanecode at