SSAS Administration – Paul Turley's SQL Server BI Blog

BI Projects, Power BI, SSAS Administration, SSAS Design, Tabular Models

Power BI for Grownups

Paul TurleyJuly 27, 2018July 28, 2018

The message from the Microsoft Business Applications Summit this week was very clear: Power BI is growing up. We have…

BI Industry, BI Projects, Business Analytics, Microsoft BI Platform, MVP Community, PASS, Power BI, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, SSRS Administration, SSRS Design, Tabular Models

Interview with Guy In A Cube’s Adam Saxton and Patrick Leblanc

Paul TurleyDecember 19, 2017December 20, 2017

Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for…

BI Industry, BI Projects, DAX, Microsoft BI Platform, Power BI, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, Tabular Models

Enterprise Analysis Services Development: Interview with Alberto Ferrari and Marco Russo

Paul TurleyDecember 2, 2017December 2, 2017

Between sessions at the PASS Summit, I had the privilege of interviewing Alberto Ferrari and Marco Russo; SSAS Maestros…

BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, SSAS Administration, SSAS Design

Implementing Row-Level Security in Power BI

Paul TurleyAugust 14, 2017October 25, 2017

The best method to implement row-level security in a published Power BI model or SSAS Tabular model consumed from the Power BI service will depend to some degree on your data structure and requirements. The method I demonstrate here is one of the most flexible approaches and one that I commonly use in my projects.

BI Industry, Business Analytics, Microsoft BI Platform, Power BI, Self-service BI, SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSRS Administration, SSRS Design

Power BI on-Premises Production Targeted for Mid 2017

Paul TurleyDecember 16, 2016

NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal. The production-ready release is targeted…

BI Industry, Business Analytics, Microsoft BI Platform, MVP Community, Power BI, Self-service BI, SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, Tabular Models

Using Power BI with Enterprise, On-premises Data

Paul TurleyJune 19, 2016

I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data. The running time for…

BI Industry, BI Projects, Excel BI, PowerPivot, Self-service BI, SQL Syndication, SQLServerPedia, SSAS Administration, Tabular Models

Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

Paul TurleyMay 26, 2015June 1, 2015

This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot. I’ve also done a bit of Power Pivot work for clients. These projects were either delivered to an analyst using Excel on their desktop or some business users through SharePoint. But, authoring in Excel Power Pivot and deploying to a server-hosted Tabular model has been mainly theoretical up to this point so I thought I’d share my experience.

Articles, BI Industry, BI Projects, SolidQ, SQL Server Pro Magazine, SSAS Administration, SSAS Design, Tabular Models

SSAS Tabular Modeling Article Series on SQL Server Pro Magazine

Paul TurleyMay 2, 2015May 27, 2015

I’ve just finished a series of four articles for SQL Server Pro Magazine, along with sample projects and hands-on exercises. The series will take you through SSAS Tabular model design from start to finish, using the Adventure Works sample data in SQL Server 2012 or 2014. Here are links to all four articles followed by an excerpt from each.

Part 1 – Getting Started with SSAS Tabular
Part 2 – Easy DAX – Getting Started with Data Analysis Expressions
Part 3 – Tabular Model Administration
Part 4 – Deep Dive DAX – Solving Complex Business Problems with Data Analysis Expressions

Download the sample projects here: Part 1, Part 2, Part 3, Part 4

SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, SSRS Administration, SSRS Design, Tabular Models

SQL Server 2014 Upgrade Sessions on the Microsoft Virtual Academy

Paul TurleyApril 12, 2015May 27, 2015

It was a great honor to be asked to join my associates from SolidQ at the Microsoft Virtual Academy Studios…

PASS, SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, SSRS Administration, SSRS Design, Tabular Models

SQL Server Upgrade Preconference at PASS Summit 2014

Paul TurleyOctober 21, 2014October 23, 2014

Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd

If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop.

Join John Martin, Sr. Technology Evangelist from Microsoft, will spend the morning discussing migration planning from SQL Server 2005.

In the afternoon, SolidQ mentors Ron Talmage, Richard Waymire, Jim Miller and Paul Turley will talk about and demonstrate upgrading specific workloads (projects and features) from older product versions to newer product versions. We will introduce the comprehensive SQL Server 2014 Upgrade Whitepaper that we recently wrote for publication by Microsoft.