DAX: Returning the Nth Selected Value in a Slicer
A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that…
Category: PowerPivot
SSAS Tabular Models: The Good, the Bad, the Ugly & the Beautiful
After working on a couple of serious tabular model projects, I’ve been talking to other BI practitioners lately about their…
Book Review: Instant Creating Data Models with PowerPivot How-to
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot…
BI Industry, Microsoft BI Platform, MVP Community, PowerPivot, SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, Tabular Models
Taking the Tabular Journey
A Getting-Started and Survival Guide for planning, designing and building Tabular Semantic Models with Microsoft SQL Server 2012 Analysis Services.…
BI Industry, Microsoft BI Platform, Power View, PowerPivot, SolidQ, SSAS Administration, SSAS Design
Power View for Multidimensional Cubes Released
The Power View connectivity for Multidimensional Models has been released to the public as part of SQL Server 2012 Service…
Microsoft BI Platform, MVP Community, PASS, Power View, PowerPivot, SolidQ, SQL Saturday, SQL Server, SQLServerPedia
Data Visualization Choices SQL Saturday Presentation
Today in Vancouver, British Columbia, at the SQL Saturday #198; I presented a session titled “Data Visualization Choices”. As promised,…
BI Industry, Microsoft BI Platform, Power View, PowerPivot, SQLServerPedia, SSAS Administration, SSAS Design, Tabular Models
Power View Now Works with Cubes!
This is a very significant day in the progression of the Microsoft Business Intelligence platform. Earlier this year, Power View…
An Unusual Book–on DAX Formulas
One of the characteristics of a really good, classic movie is that it has a lot of memorable dialog. I…
Is PowerPivot the Next Access?
I’m impressed with the current generation of semantic modeling technology from Microsoft. I’ve had the opportunity to use both PowerPivot…
BI Industry, Microsoft BI Platform, PASS, Power View, PowerPivot, SolidQ, SQL Saturday, SQL Server, SQL Syndication, Tabular Models
Office 2013 BI and Mobility
I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about…
Articles, BI Industry, Microsoft BI Platform, PerformancePoint, Power View, PowerPivot, SQL Syndication, SSRS Design, Tabular Models
The State of Microsoft Self-Service Reporting
(article published on the MVP Award Program Blog) I really enjoy this topic. One of the reasons, I suppose, it’s…