Tuesday, October 28, 2014

Course on Microsoft Self-Service Business Intelligence using SharePoint 2010/2013, SQL Server 2012, SSAS Tabular and PowerView.

$149 - Special introductory price for Denver area companies until end of year only.

Kick start your Self-service BI initiative with training from a Microsoft BI leader local to Denver.  Whether you have already explored self-service or not, if you have SharePoint 2010 or 2013 and SQL Server 2012, I can show you enough of the basics to get you started on your own, using the tools you already have!

The following will be covered at your offices from either 8:30AM to 12 Noon or 1:00PM to 4:30PM:



1. Differences between SSAS Tabular and SSAS Multidimensional and why you should consider tabular.

2. How to add data sources into a tabular model: from SQL Server, odbc, flat-files, Excel spreadsheets, SSRS reports.

3. Modeling in tabular by joining the disparate tables.

4. Creating calculated measures, rankings and calculated columns using DAX.

5. How to deal with tabular annoyances such as:

   Memory Constraints preventing the model from refreshing.

   Joining tables that have a "many-to-many" relationship.

   Queries timing-out.
   
   Data "sticking" to the SSAS database even though it is no longer in the source systems.

6. How to create a SSAS Tabular data connection in SharePoint 2010 or 2013.

7. How to create lightning-quick, stunningly beautiful data visualizations using PowerView in SharePoint 2010 or 2013.


Contact me now for more information on this special introductory course offer.


Noah Meyer, aka The SQL Fix-It Guy, is a Denver-based database developer, trainer and coach and has spent the past two decades helping leading organizations (banks, hospitals, energy companies and government agencies) improve their reporting capabilities by fixing and fine-tuning their customized software implementations.

No comments :

Post a Comment