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 and not the final article about using Datazen to build mobile dashboards and business intelligence solutions.  The entire article is available here.

Figure%202%20-%20%20iPad%20Dashboard%202_0[1]

(excerpt)
A few months ago, shortly after Microsoft announced their acquisition of the Datazen mobile dashboard product, I wrote two articles titled Getting Started with Datazen and Setting Up a Datazen Server.  Datazen is a simple dashboard tool with native apps for all the major mobile device platforms.  I mentioned that the tool had shortcomings with Analysis Services as a data source.  When writing MDX queries, it was necessary to create calculated members for all of the row members and place them on the columns axis.  An update released in August, 2015 improved the MDX query functionality where the work-around is no longer necessary.  In this article, I’ll demonstrate a pair of drill-through dashboards using MDX queries and navigation that pass parameters to an MDX query.  The is an overview rather than a tutorial.  My focus is on queries, parameters and drill-through commands and not so much the dashboard layout.  In the next article, I’ll show you how to go one step further and drill-through to an operational report created with Reporting Services.

A Quick Tour

To set the stage, my dataset is the airline on-time performance database from the Bureau of Transportation Statistics…

http://sqlmag.com/analysis/datazen-mobile-dashboards-analysis-services-and-drill-through

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

Starting Your Modeling Career with Analysis Services Tabular Models Part 1

Four-part series

This is the first of a four-part series about getting started with Tabular model design using SQL Server Analysis Services in SQL Server 2012 and 2014.  You will learn the basics from start to finish and build a complete solution.  A sample project is provided for for each stage of the solution so you can follow-along with each article. Continue reading

An Unusual Book–on DAX Formulas

image

One of the characteristics of a really good, classic movie is that it has a lot of memorable dialog.  I could go on for hours quoting one-liners from The Blues Brothers or Princess Bride.  Likewise, I think a good book leaves the reader with gems to ponder and to stimulate ideas.  Such has been my recent experience reading Rob Collie’s “DAX Formulas for PowerPivot, The Excel Pro’s Guide to Mastering DAX”.  Continue reading

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 to access the journal.

Editorial

Windows 8 and Kinect: Let’s Start Again
Fernando G. Guerrero

News & Events

Upcoming Courses

Business Intelligence

Give Us Your Data!
Windows Azure Marketplace DataMarket and the Open Government Data Initiative
Miguel Lopez

Let’s Get Visual: The Art of Report Design
Paul Turley

Building an SSIS Management Framework – Part 1
Rushabh Mehta

Relational

Tuning SQL Azure Databases – Part 1
Paras Doshi

Collaboration

SharePoint Best Practices
Creating and Configuring Service Applications with and without) PowerShell – Part 1
Gilberto Zampatti

Database Administration

Pump Up with PowerShell
Herbert Albert and Gianluca Hotz