SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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:

SPEAKER BIO:
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.


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

AGENDA:

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.


LOCATION & TIME
:
Microsoft office
101 Wood Avenue South
Suite 900
Iselin (Metropark), NJ

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.