BI Industry – Page 4 – Paul Turley's SQL Server BI Blog

BI Industry, BI Projects, Business Analytics, Microsoft BI Platform

Glossary of Terms Used in Microsoft BI Projects

Paul TurleyMarch 14, 2015May 27, 2015

At the beginning of many new BI projects it can be challenging to get everyone using common terminology and language. …

BI Industry, Microsoft BI Platform, SolidQ, SQL Server, SQL Server Pro Magazine, SQL Syndication

Some Thoughts About Microsoft’s Cloud Platform Roadmap

Paul TurleyFebruary 4, 2015

There have been a lot of changes in and around Microsoft in the past few months. Under the leadership of…

BI Industry, BI Projects, Business Analytics, Power BI, PowerPivot, Self-service BI, SQL Syndication, SQLServerPedia, Tabular Models

Power BI Semantic Model Supports Many-to-Many Relationships

Paul TurleyJanuary 4, 2015January 5, 2015

Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular…

BI Industry, Dun & Bradstreet, PASS, SolidQ, SQL Server

Get To Know D&B MVPs and SQL Server MVPs

Paul TurleyDecember 22, 2014December 22, 2014

Last year Dun and Bradstreet, the world’s leading business data authority, recruited leading SQL Server MVPs to help their customers…

BI Industry, Business Analytics, Microsoft BI Platform, Power BI, Power View, Self-service BI, SQL Syndication, SQLServerPedia

New Power BI stand-alone Designer, Dashboards, APIs & iOS App

Paul TurleyDecember 20, 2014December 26, 2014

This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer. What is it and why…

BI Industry, BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, PowerPivot, Self-service BI, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia, Tabular Models

Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table

Paul TurleyOctober 5, 2014October 7, 2014

Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment text in the Pivot Table report results. Here’s a quick example of the final result. My example uses Flintstones characters in-place of employee or customer names and a simple measure value. After reviewing the results, the user moves to another worksheet and enters a comment for the date and person with an expiration date for the comment. After refreshing the report, each cell with a comment is indicated with a little “dog ear” and the comment is displayed by clicking the cell…

BI Industry, BI Projects, Business Analytics, Microsoft BI Platform, MVP Community, PASS, SolidQ, SQL Saturday, SQL Server, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia

SQL Server MVP for a Sixth Year

Paul TurleyOctober 5, 2014October 5, 2014

Thank you to the Microsoft MVP Program for awarding me MVP for six years running! I love this program and…

BI Industry, PASS, SQL Server, SQL Syndication, SQLServerPedia

Remembering Reed Jacobson

Paul TurleyJuly 16, 2014October 7, 2014

I just received some bad news and found out that a friend passed away today. Reed Jacobson was one of the early leaders in the Microsoft Business Intelligence community. Somewhere around 2004-2008 I worked with Reed at Hitachi Consulting in Seattle where we travelled, taught classes and worked on client projects together. He was one of the earliest adopters and gurus in the BI community working for a small start-up called OLAP Train who helped bring SSAS (aka “OLAP Services”) to the masses. He spoke at many conferences and taught a lot of classes.

Not only was he one of the smartest people I’ve known when it came to solving business problems with Analysis Service & MDX but he was a kind, friendly man who really enjoyed helping and connecting with people.