Microsoft recently published a Using DirectQuery in the Tabular BI Semantic Model white paper. The white paper provides a great introduction for the DirectQuery technology, xVelocity and columnstore indexes. It also covers security, capacity planning and deployment best practices.
Category: PowerPivot
Columnstore index vs MOLAP
I have been trying to wrap my brain around the various options that Microsoft offers around near real-time analytical experience for the end users. Clearly, a semantic model is needed to isolate the end from the complexity of SQL/Relational Data Warehouse. So I see three options to explore: traditional MOLAP model for Analysis Services New … Continue reading Columnstore index vs MOLAP
Using Microsoft PerformancePoint PowerView Excel Services on Windows 8 Tablet
I have been spending more and more time with my Windows 8 Tablet. As I have mentioned numerous times before, there is a lot to like about it. My Samsung Series 7 is running a lot better after I installed the latest drivers for Windows 8 that were just released by Samsung, with touch input being the … Continue reading Using Microsoft PerformancePoint PowerView Excel Services on Windows 8 Tablet
Drillable charts in Mcrosoft Office 15
I believe that Microsoft has delivered a very solid release with SQL Server 2012. I love MDS V2, I am giddy with excitement about columnstore indexes (still trying to hunt down any hints that would substantiate the claimed availability of this technology for Analysis Services), I think that PowerView will be a huge success, although … Continue reading Drillable charts in Mcrosoft Office 15
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...
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
business intelligist 