Category: SSAS Design

BI Projects, Gartner, Microsoft BI Platform, MVP Community, Paginated Reports, PASS, Power BI, Power Query, Self-service BI, SSAS Design, Tabular Models

DevOps & CI/CD for Power BI

Paul Turley

DevOps isn’t difficult to implement for small and medium-scale projects, and simple things like managing version control in a code repository can save hours of lost time. Organization who are accustomed to managing large application development initiatives might expect to have a fully automated build and deployment process in concert with an Agile delivery process, managed with specialized tools like Jira, GitHub and Azure DevOps.

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

Power BI for Grownups

Paul Turley

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

Business Analytics, Power BI, Power Query, SSAS Design

How to add KPI indicators to a Table in Power BI

Paul Turley

Yesterday a friend asked for a little help getting started with Power BI.  He’s a DBA and system administrator and wanted to cut his teeth on Power BI with a really simple dashboard-style scorecard report.  Using a list of database servers with license expiration dates, he thought it would be a simple matter to calculate and show the expiration status for each server using a simple traffic light indicator.  The envisioned server list might look something like this:

Makes perfect sense, right?  This is a basic use case and a good application for simple KPIs; with the one minor caveat that POWER BI DOESN’T SUPPORT THIS!

This topic has become a bit of a soapbox topic for me

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

Implementing Row-Level Security in Power BI

Paul Turley

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.

24 Hours Of PASS, Data Visualization, Excel BI, Microsoft BI Platform, Power BI, SQL Server, SSAS Design, SSRS Administration, SSRS Design

Can’t We Just Get Along? Making SSRS, Power BI and Excel Play Well Together

Paul Turley

Please join me and other 2017 PASS Summit speakers for 24 Hours of PASS: Summit Preview on July 19th and 20th.  24HOP is a series of 60 minute on-line sessions presented back-to-back for 24 hours, from the same professionals who will deliver preconference and main conference sessions during the Summit the first week of November this year.  These online sessions are free of charge and normally attended by thousands of individuals to gain insight and knowledge about the topics.  24 Hours of PASS features free educational webinars delivered over 24 hours. Topics covered in this edition include Performance Tuning, SQL Server 2017, Linux, DevOps, Azure, PowerShell, SSRS, Power BI and much more. Browse all sessions. These webinars provide a sneak peek at some of the best practices, expert tips and demos you’ll find at this year’s PASS Summit in Seattle.

Articles, BI Projects, Business Analytics, DataZen, SQL Server Pro Magazine, SSAS Design

SQL Server Pro Magazine: Datazen Mobile Dashboards with Analysis Services and Drill-through

Paul Turley

This post is a teaser for an article I just published to SQL Server Pro Magazine.  This is the third…

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 Turley

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

%d bloggers like this: