Microsoft has posted 16 virtual labs online. The labs cover three major areas: Business Intelligence Mission Critical Operations Database Management Those of us who are trying to jump start Self Service BI in our organizations should checkout the following three: Creating a PowerPivot Model and Report in the Excel Client Defining DAX Calculations with Microsoft
Kasper de Jonge posted a great article about building PowerPivot hierarchies against dimension tables that implement parent/child relatioship… Basically, a new PATH() DAX function is used to build a string that contains a path from the leaf to the top parent level member in the hierarchy and then a PathItem() function is used for each
Hierarchycal Data is an interesting way to implement Parent/Child or tree-like relationships… Microsoft has posted a great tutorial here on how to convert data into the Hierarchycal format.
Welcome to my site… starting out with an obligatory Hello World!… I decided to name this site AQTInsight.. or phonetically, acute insight… or a cute insight… all of these work… and I also came up with a logo