A Developer’s Guide to Creating Bad Power BI Projects – Part 1

It occurred to me that we have put so much effort into promoting best practices and proper design that there is far less information about how to create bad reports and data models. In that light, the purpose of this article is to talk about what to do if you want things to go poorly and make sure your projects fail – if not immediately, then sometime in the future – and if not for you then for whoever inherits the work that you have done.

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

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

SSAS Tabular Modeling Article Series on SQL Server Pro Magazine

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

An Unusual Book–on DAX Formulas

One of the characteristics of a really good, classic movie is that it has a lot of memorable dialog.  I…

SolidQ Journal–July ‘11

This month’s SolidQ Journal contains a wealth of insights and useful information, including an article from yours truly.  Click here…

%d bloggers like this: