Blog Post

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

,

Greetings!  If you are local, or in the NY/Central NJ area, mark you calendars for WED. MARCH 11, 2015 @ 6:00PM, in Iselin, NJ's Microsoft Office, hosted by the Central New Jersey SQL Server User's Group (CNJSSUG), where Kevin S. Goff, goes well 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:

OFFICIAL User Group Event Link:

http://linkd.in/17LagUS

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

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating