Glossary of Terms Used in Microsoft BI Projects
At the beginning of many new BI projects it can be challenging to get everyone using common terminology and language. …
Paul Turley's SQL Server BI Blog
sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009
At the beginning of many new BI projects it can be challenging to get everyone using common terminology and language. …
There have been a lot of changes in and around Microsoft in the past few months. Under the leadership of…
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular…
Last year Dun and Bradstreet, the world’s leading business data authority, recruited leading SQL Server MVPs to help their customers…
This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer. What is it and why…
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…
Thank you to the Microsoft MVP Program for awarding me MVP for six years running! I love this program and…
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.
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This…
This series of video sessions will demonstrate how to create a business intelligence solution with sets of business data from…
by Paul te Braak, from Packt Publishing on Amazon Good technology books usually come in one of two forms. Some…
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. …
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several…
I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance…
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot…