…a long rant on Business Intelligence

This will one day evolve into an article, or a book, or an engaging conversation over a beer or two. For now, I just want to sketch out a few things that have been occupying my brain for the last few weeks… so here are a couple of angles to consider: Business Intelligence is not

Continue reading

colummstore compression for analysis services

Microsoft is claiming that xVelocity technology will be available across SQL Server database engine, PowerPivot AND Analysis Services… This technology works great for the first two, however, I couldn’t find anything on column store for the Analysis Services…. This would be a huge new improvement for SSAS…

xVelocity

Microsoft is re-branding its Vertipaq in-memory engine that is currently used in PowerPivot and naming it xVelocity.  That’s hardly worth a blog entry per se.. Howerver, and this is big, xVelocity now is added to both Analysis Services AND Database engines… Supposedly, this technology incrases preformance of the existing relational queries by 10-100… I will

Continue reading

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

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

Parent Child in PowerPivot

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

Continue reading