Not sure if anybody is using Microsoft Virtual Academy.. if you are not – you should… What’s the compelling event? Well, 7 freshly minted modules have just been posted for our perusal: Developing and Managing a BI Semantic Model Configuring and Securing Complex BI Applications in SharePoint Enriching your BI Semantic Models with Data Analysis
Month: March 2012
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