Welcome

BI-301

Level 300

Building and Querying Multidimensional Cubes

What Will We Cover?

Overview of Microsoft® System Center Operations Manager, Used for Building Analysis Services CubesMultidimensional Expression Queries to Access and Manipulate CubesAccess and Analyze System Center Operations Manager Cubes Using Office Excel®

Agenda

Business Intelligence (BI) Overview Building Multidimensional Cubes Using SQL Server 2008 Analysis ServicesQuerying Cubes Using Multidimensional ExpressionsAccessing and Analyzing Cube Data Using Office Excel

Business Intelligence Overview

Delivery

End-User Tools and Performance Management Applications

BI Platform

Office Excel Office PerformancePoint™ Server

SQL Server Reporting Services

SQL Server Analysis Services

SQL Server database management system (DBMS)

SQL Server Integration Services

Reports Dashboards Office Excel Workbooks

AnalyticViews Scorecards Plans

Microsoft Office SharePoint® Server

Microsoft Dynamics

Search Collaboration Content Management

Database Flat Files

Generic Data Flow to Build a Business Intelligence Solution

System Center Operations

Manager Data Warehouse

Support Database

BI Data Warehouse

Analysis Services Cubes

Office Excel

Cube Browser

Reporting Services

Agenda

Business Intelligence (BI) Overview Building Multidimensional Cubes Using SQL Server 2008 Analysis ServicesQuerying Cubes Using Multidimensional ExpressionsAccessing and Analyzing Cube Data Using Office Excel

Building Multidimensional CubesCube Designer

Data Source—to connect BI Data

WarehouseData Source View—logical relationship

between entities

Create Data Source and Data Source View

Building Multidimensional CubesCube Designer

Cube Designing Using Cube Designer

Multidimensional Cubes Creating Dimensions

Dimension Designer

Attribute Hierarchy

Attribute Relationship

Task 1: Create Analysis Services DatabaseTask 2: Create Data Sources and Data Source ViewTask 3: Create Dimensions for Performance DataTask 4: Define Measures and Design Cube

Building Multidimensional Cubes

Demo

Agenda

Business Intelligence (BI) Overview Building Multidimensional Cubes Using SQL Server 2008 Analysis Services

Querying Cubes Using Multidimensional Expressions

Accessing and Analyzing Cube Data Using Office Excel

Querying CubesMultidimensional Expressions (MDX)

Access Cubes Using Multidimensional Expressions

Basic MDX Query

Querying CubesSQL Server Management Studio

Access Cube Using SQL Server Management Studio Cube Browser

Cube Browser

Querying CubesSQL Server Reporting Services

Access Cube Using SQL Server Reporting Services

Report Manager

Report Designer

Task 1: MDX Statements to Query CubesTask 2: Update Cube data using MDX query

Querying Cubes Using Multidimensional Expressions

Demo

Agenda

Business Intelligence (BI) Overview Building Multidimensional Cubes Using SQL Server 2008 Analysis ServicesQuerying Cubes Using Multidimensional ExpressionsAccessing and Analyzing Cube Data Using Microsoft Office Excel

Accessing and Analyzing Cube Data Using Office Excel

Access Cube Data with Office Excel PivotTables and PivotCharts

PivotChart

Data Grid

Task 1: Configure and Access Analysis Services Cubes

Task 2: View Cube Measures, Dimensions, and Perspectives

Task 3: Analyze Performance KPIs and IT Server Availability

Accessing and Analyzing Cube Data Using Office Excel

Demo

Session Summary

Designing Cubes

Accessing and Manipulating the Cube Data

Accessing Cube Data Using Office Excel

Where to Find More Information

Visit TechNet at technet.microsoft.com

Also, check out TechNet Edge

edge.technet.com

Or, just visit www.microsoft.com/?

linkid=9638675

for additional information on this session

For more titles, visithttp://www.microsoft.com/?linkid=9638675

Supporting Publications

Course ID Title

6234A Implementing and Maintaining Microsoft

SQL Server 2008 Analysis Services

For more training information http://www.microsoft.com/?linkid=9638675

Training Resources

Become a Microsoft Certified Professional

What are MCP certifications?Validation in performing critical IT functions

Why Certify?Worldwide recognition of skills gained via experienceMore effective deployments with reduced costs

What Certifications Are There for IT Pros?MCTS, MCITP

www.microsoft.com/certification

Microsoft TechNet Plus

TechNet Plus is an essential, premium, Web-enabled, and live support resource that provides IT Professionals with fast and easy access to Microsoft experts, software, and technical information, enhancing IT productivity, control, and planning.

Evaluate and Learn Plan and Deploy Support and Maintain

Use the TechNet Library to plan for deployment using the Knowledge Base, resource kits, and technical training

Use exclusive tools, like System Center Capacity Planner, to accurately plan for and deploy Exchange Server and System Center Operations Manager

Two complimentary Professional Support incidents for use 24/7 (20-percent discount on additional incidents)

Access more than 100 managed newsgroups and get next business day response—guaranteed

Use the TechNet Library to maintain your IT environment with security updates, service packs, and utilities

Get all these resources and more with a TechNet Plus subscription.For more information visit: technet.microsoft.com/subscriptions

Evaluate full versions of all Microsoft commercial software for evaluation—without time limits; this includes all client, server, and Microsoft Office system applications

Try out all the latest betas before public release

Keep your skills current with quarterly training resources, including select Microsoft E-Learning courses