Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services

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 … Continue reading Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services

Microsoft SQL Server 2012 Virtual Labs

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 … Continue reading Microsoft SQL Server 2012 Virtual Labs

Parent Child in PowerPivot

EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 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 … Continue reading Parent Child in PowerPivot