NJ SQL UG Event: 13 Advanced SSAS Tips - Kevin S. Goff returns!


He's baack!  If you missed the first presentation in March, due to inclement weather, and you are local, or in the NY/Central NJ area, come see Kevin S. Goff, June 10, 2015 @ 6:00PM TONIGHT!, in Iselin, NJ's Microsoft Office, hosted by the Central New Jersey SQL Server User's Group (CNJSSUG). Kevin will pick up where he left off and go beyond the basics of creating SSAS cubes in his presentation,  Baker's Dozen: 13 Advanced SQL Server Analysis Services tips. Kevin will also talk about new engine

features in SQL Server 2012/2014 that can potentially help certain SSAS

OLAP databases.  This awesome upcoming user group presentation will be sponsored by SoHo Dragon Solutions, experts in Sharepoint/BI.  For details, read on:


Kevin S. Goff has been a Microsoft MVP for 11 consecutive years. He is a

SQL Server Data Warehouse/Business Intelligence consultant, author, and

technical mentor.


Baker's Dozen: 13 Advanced SQL Server Analysis Services tips


In his standard "Baker's Dozen, 13 tip" format, this presentation will cover demo examples for  the following
advanced SSAS topics:

1) XMLA Processing options

2) Pros and Cons of ROLAP

3) Many to Many Bridge Tables, DefaultMember, and IsAggregatable

4) Extending the Analytic Path with SSAS Report Actions

5) Dynamic SSAS Roles

6) Advanced MDX in SSRS

7) MDX Performance Tips

8) Partitioning and Performance

9) Aggregations and Performance

10) Accessing OLAP data from .NET Applications

11) Data Driven KPIs

12) Dimension Attribute Discretization

13) Miscellaneous SSAS Performance Tuning

This presentation assumes attendees have basic knowledge of SSAS OLAP cubes,
along with fact and dimension tables.


Microsoft office

101 Wood Avenue South

Suite 900

Iselin (Metropark), NJ