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…
We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several…
BI Industry, Microsoft BI Platform, MVP Community, SolidQ, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia, SSRS Administration, SSRS Design
SQL Server Pro Article: Custom Programming to Enhance SSRS Reports
I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance…
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…
Time to Complete the 2013 BI Survey
It’s that time of year again… end of the school year, graduation, Fathers’ Day and of course; time to take…
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…
GeoFlow Released for Public Preview
In this morning’s keynote address at the PASS business Analytics Conference, Amir Netz demonstrated using GeoFlow, a geographic data visualization…
Report Expression Sample Reports
These are the sample reports from the Penton eLearning session today on SSRS Report Expressions: http://sqlserverbi.blog/?attachment_id=1058 This view is necessary…
Mastering Reporting Services Expressions, March 26
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using…
BI Industry, Microsoft BI Platform, SolidQ, SQL Syndication, SQLServerPedia, SSAS Design, SSRS Design, Tabular Models
Visual Studio 2012/SSDT Addition for BI Project Version Compatibility & Themes
We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo. In the past,…
BI Industry, Microsoft BI Platform, MVP Community, PASS, SolidQ, SQL Saturday, SQL Server, SQL Syndication, SQLServerPedia
SQL Server Community World Tour with GeoFlow
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This…
Please Vote on Microsoft Connect Items
I’ve posted two feedback items on the Microsoft Connect today, suggesting feature enhancements to Power View and Reporting Services. If…
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,…