CodePlexProject Hosting for Open Source Software

Tabular Modeling (Adventure Works Tutorial) Completed Lessons

This project contains the solutions to the above mentioned tutorial. This tutorial can be found on the following link; - http://msdn.microsoft.com/en-gb/library/hh231691(v=sql.110).aspx

The aim of this download is to provide a point of reference for people wishing to work through this tutorial. Of course you will learn more by attempting to complete the solutions to the lessons yourself.

I recommend downloading and unzipping the solutions to the C:\Projects on your computer. Check that the newly unzipped files are read only.

The solutions assume that you have the AdventureWorksDW database installed on a local server with the default local server name.

The solutions assumes that you have an Analysis Services tabular model service running on instance name localhost\SSAS_TAB

There are a few points of clarification I would like to make to avoid confusion; -

Lesson 7, Sub section "To create a Days Current Quarter to Date measure in the Date table" Step 4 the sentence; -

"Notice the top-left cell now contains a measure name, Measure 1, followed by the result, 30. The measure name also precedes the formula in the formula bar."

should read

"Notice the top-left cell now contains a measure name, Measure 1, followed by the result, 92. The measure name also precedes the formula in the formula bar."

So the number 30 should be replaced with 92.

Don't worry about the measure results being blank you will be able to analyse these measures in the correct context after you have completed the lessons and connected an Excel spreadsheet.

Lesson 8: Don't worry about the Key Performance Indicators(KPIs) being blank at this stage. As above you will be able to analyse these KPIs in the correct context after you have completed the lessons and connected an Excel spreadsheet to this tabular model.

Any constructive feedback is of course very welcome.

Last edited Dec 20, 2014 at 10:51 PM by KieranWood, version 11