Tag: PowerPivot

PowerView in PerformancePoint

~ Business Intelligist ~ 3 Comments

PowerView is getting a lot of good press lately. I personally love it because this is the first data visualization tool available from Microsoft that actually looks good... I don't mean in a functional sense, PerformancePoint is far superior in terms of functionality. PowerView looks good, esthetically pleasing, which is hard to say about PerformancePoint.  … Continue reading PowerView in PerformancePoint

Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services

~ Business Intelligist ~ Leave a comment

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

~ Business Intelligist ~ 1 Comment

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

~ Business Intelligist ~ Leave a comment

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