Monday, 27 March 2017
Task Pane 
Remember Me
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?

[show results]
Business Intelligence Semantic Model – Denali | Raj N
Author: Grant Paisley Date Posted: 27/06/2011 4:27:36 AM
Introduction to BI Semantic Model of SQL Server code named Denali, and its features, distinct difference between MDX and DAX and when to use Tabular mode(DAX) and OLAP mode(MDX) of SQL Server Analysis Services - Future trend of SQL Server Business Intelligence

Description / Key features covered :-

· Introduction to BISM

· When to use Traditional OLAP with MDX and when to use Tabular (Vertipaq) with DAX and their distinctive differences

· Demo of BISM with Denali :-

o Connect and import from source

o Creating relationships

o Managing Defining Relationships

o Creating Hierarchies

o Creating Measures and KPIs

o Perspective and Partitions

o Analysing BISM using Excel

o Defining Security

o Partitions Handling

o Importing Power Pivot model into BISM

Raj works in technical support at Microsoft so again we will get information from someone with first hand experience.

Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) | On: Tuesday, 12 July 2011