Tabular Models – Paul Turley's SQL Server BI Blog

Azure Data Factory, Azure Databricks, BI Industry, Business Analytics, Dimensional Modeling, Microsoft BI Platform, Power BI, Power Query, Self-service BI, SQL Server, Tabular Models

Getting Data Into Shape for Reporting with Power BI

Paul TurleyAugust 31, 2022September 4, 2022

Even for small, informal BI projects, shaping the data into a dimensional model alleviates complexity, speeds up slow calculations and reduces the data model storage size. I conclude this post by reviewing seven data architectures and the data shaping methods with different degrees of scale.

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…

Articles, BI Industry, BI Projects, Microsoft BI Platform, MVP Community, Power BI, PowerPivot, Self-service BI, SolidQ, SQL Server, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia, SSAS Design, Tabular Models

Analysis Services and Power BI: Time-travel, Space-warping and Teleportation

Paul TurleyDecember 10, 2016December 10, 2016

As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. …

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 Projects, DataZen, Microsoft BI Platform, SQL Syndication, SQLServerPedia, SSAS Design, SSRS Design, Tabular Models

Row-level Security Just Got Better: Passing Report Credentials to Analysis Services in SQL Server 2016

Paul TurleyJune 13, 2016June 13, 2016

A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling…

BI Industry, BI Projects, Business Analytics, Microsoft BI Platform, Power BI, Self-service BI, SQL Syndication, SQLServerPedia, SSAS Design, Tabular Models

Tabular Models, Multiple Data Sources and Unknown Members

Paul TurleyDecember 28, 2015December 28, 2015

Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from…

BI Projects, DAX, Power BI, PowerPivot, SQL Syndication, SQLServerPedia, SSAS Design, Tabular Models

Complete DAX Function Reference

Paul TurleyNovember 25, 2015November 25, 2015

The DAX function documentation in MSDN can be found on separate pages, organized by function categories and then details 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…

BI Projects, SQL Server, SQL Syndication, SQLServerPedia, SSAS Design, Tabular Models

How to resolve connection errors when loading data in SSAS Tabular project

Paul TurleyJanuary 8, 2015January 8, 2015

This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar…

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…

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.

Category: Tabular Models

Getting Data Into Shape for Reporting with Power BI

Like this:

Power BI for Grownups

Like this:

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

Like this:

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

Like this:

Analysis Services and Power BI: Time-travel, Space-warping and Teleportation

Like this:

Using Power BI with Enterprise, On-premises Data

Like this:

Row-level Security Just Got Better: Passing Report Credentials to Analysis Services in SQL Server 2016

Like this:

Tabular Models, Multiple Data Sources and Unknown Members

Like this:

Complete DAX Function Reference

Like this:

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

Like this:

SSAS Tabular Modeling Article Series on SQL Server Pro Magazine

Like this:

SQL Server 2014 Upgrade Sessions on the Microsoft Virtual Academy

Like this:

How to resolve connection errors when loading data in SSAS Tabular project

Like this:

Power BI Semantic Model Supports Many-to-Many Relationships

Like this:

SQL Server Upgrade Preconference at PASS Summit 2014

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this: