Analysis Services - The New Tabular Engine Pre-Conference by Mark Stacey
Friday, October 5, 2012 from 8:00 AM to 4:00 PM (CDT)
Understands SQL, in terms of T-SQL, basic database design and some familiarity with dynamic SQL and SQL jobs
Analysis Services has changed – many of the old assumptions about doing OLAP need to be thrown away, and new ones learnt.
You will start with the basics – creating a tabular model using PowerPivot, and developing it to a user friendly interface in Excel.
You will then import this model into a Visual Studio Project, and deploy to Analysis services –decorating the model to enhance frontend tools such as PowerView will be done at this point.
Performance comparisons between multi-dimensional and tabular will done.
A deep dive into methods of partitioning, and management using XMLA will take us through to the final piece – how to automate a conversion from Multi-Dimensional to Tabular.
a. An introduction to tabular
b. Tabular vs Multi-dimensional
c. An evolution of BI
Creating a tabular model in PowerPivot
a. Star schema
e. Mark as Date table
Introduction to DAX
a. Calculated columns
b. Calculated measures
Presentation layer - consuming in Excel
b. Using value slicers
c. Pre calculating Formulae
d. Dynamic Buckets
Publishing to Sharepoint
Importing a model into Tabular SSAS
Decorating a model
a. Field Sets
b. Table Behaviour
Consuming tabular models: PowerView, PPS
Partitioning - a new strategy for dev and prod
XMLA to automate processing
An automated conversion of multi-dimensional to tabular – an introduction
OTHER COURSE INFORMATION:
Food: Lunch will be provided at The Knolls Country Club.
Recommended Hotel: The Victorian Suites http://newvictorianinn.com/ Rooms blocked under SQL Saturday.
Cancellation policy: no cancellations/refunds/exchanges allowed except if event is cancelled for any reason. Full payment of $99 is due at the time of registration.
When & Where
Lincoln SQL Server User Group
Lincoln SSUG is hosting pre-conference sessions for SQL Saturday 165 featuring Mark Stacey, Kevin Kline and William E. Pearson III. Be sure to also register for our FREE full day conference style event, SQL Saturday which will be held Saturday, October 6th. For details and registration: http://www.sqlsaturday.com/165/eventhome.aspx
Also be sure to register visit our website and register to receive the Lincoln SSUG newsletters by going to http://lincoln.sqlpass.org.