Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Analysis Services - The New Tabular Engine Pre-Conference by Mark Stacey

Lincoln SQL Server User Group

Friday, October 5, 2012 from 8:00 AM to 4:00 PM (CDT)

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Regular Price   more info 16 Tickets Ended $119.00 $7.54

Share Analysis Services - The New Tabular Engine Pre-Conference by Mark Stacey

Event Details

Level 300

Prereqs:

Understands SQL, in terms of T-SQL, basic database design and some familiarity with dynamic SQL and SQL jobs

 Topic

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.

Agenda

BISM

     a. An introduction to tabular

     b. Tabular vs Multi-dimensional

     c. An evolution of BI

Creating a tabular model in PowerPivot

     a. Star schema

     b. Relationships

     c. RELATED

     d. Hierarchies

     e. Mark as Date table

Introduction to DAX

     a. Calculated columns

     b. Calculated measures

Presentation layer - consuming in Excel

Advanced DAX

     a. Context

     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

     c. Image

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.

Have questions about Analysis Services - The New Tabular Engine Pre-Conference by Mark Stacey? Contact Lincoln SQL Server User Group

When & Where


The Knolls Country Club
2201 Old Cheney Rd
Lincoln, NE 68512

Friday, October 5, 2012 from 8:00 AM to 4:00 PM (CDT)


  Add to my calendar

Organizer

Lincoln SQL Server User Group

Lincoln SSUG is a local PASS Group. We strive to connect SQL Server Professionals and facilitate SQL Server educational opportunities through monthly meetings and hosting SQL Saturday events.

This year's SQL Saturday will be held Saturday, October 27th at E.T. Mahoney State Park. For details and registration: http://www.sqlsaturday.com/767/eventhome.aspx

Be sure to register visit our website http://lincoln.pass.org. To receive our newsletters visit http://pass.org, register for free, then add Lincoln SQL Server User Group to your chapters.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.