Power BI Workshops – Dates and Locations

The Hands-On Power BI Workshop has been a great success and and a good opportunity to learn this technology first-hand.  The following workshops are scheduled in the next couple of months:

Huntington Beach / Orange County, CA – April 1, 2016

This is a full-day learning event on the Friday before Huntington Beach SQL Saturday #497

Phoenix, AZ – April 15, 2016

This is a full-day learning event on the Friday before Phoenix SQL Saturday #492

San Jose, CA – May 3, 2016

PASS Business Analytics Conference 2 hour micro workshop.  Tuesday, May 3rd 2:30 – 4:45

SQL Server 2016 RC0 SSRS and Mobile Report Features

SQL Server 2016 RC0 hit the streets today and I just barely got it installed in my test sandbox.  I’ve been using the CTP 3.2 & 3.3 previews and anxious to see if a few broken or missing features are working  now …so here it goes…

The Mobile Report Publisher was (how shall I put it) a little fragile in CTP 3.3.  Let’s see how it does in the release candidate:

First Thing – Mobile Report Publisher had some issues before this release but I had no problems building a simple report.  No weird video issues…

image

But will it style?  The color styling features didn’t work in the last version…

OK! Styling works with all the color palette choices!  Nice.

image

The phone and tablet layouts were wonky in the previous version.  Let’s see what happens if…

image

Tablet layout visualizes and seems to work as designed.

Last but certainly not least …phone…

image

WORKS, ding dig ding, we have  winner!

Stay tuned.  I promise more, later after I’ve had a chance to do some serious mobile report design and testing.

February 2016 TechNet Guru Competition

Every month I judge entries in the TechNet Wiki Guru competition SQL Server Business Intelligence category.  Over the years, we have seen excellent contributions and insightful articles about advanced techniques and product tips.  The next time you need to solve a particularly vexing BI problem, go to the TechNet Wiki and do a focused search.  You’re likely to find useful solutions. 

This month, there are three particularly good entries that I would like to showcase.  These are all great entries and valuable contributions.  The winners we will announced here: http://social.technet.microsoft.com/wiki/contents/articles/33351.technet-guru-contributions-february-2016.aspx

SSIS – Transfer data from Multiple tables using a single DFT
A framework for importing multiple tables and adapting to different column data types.  This is a common challenge in large-scale ETL projects that often requires third-party products or deep programming.  This approach solves the problem with out-of-the-box SSIS.

DAX: Dates Prior to 1900
A common issue when working with historical dates.   These techniques work-around the native data type and DAX function limits with dates earlier than 1/1/1900.

SSRS Tips : Implementing OR Based Logic for Dataset Filters
SSRS report filters are powerful but not always intuitive.  This technique applies OR logic to compound Boolean filters to work-around limitations of the designer.