Getting Dimensional with Data

This session will provide an overview of the steps required to create a cube in SQL Server Analysis Services. Exploring the use of Data Sources and data source views to define the source data that the cube will use. Understanding the importance of Dimensions and how hierarchies can be added to improve the user experience of browsing a dimensional data . To bringing the cube together with measures that will hold the business metrics that intersect each dimension in a cube.

Take this tour that will show you how to build a cube from the ground up, providng you with the ability to create you very own cubes so that you can query your data far more effectively!

to be considered for Friday

Chris Testa-O'Neill

Chris Testa-O'Neill is a Practise Consultant at EMC Consulting. He specialises in SQL Server Business Intelligence Solutions  in the SQL 2005 and 2008 product range. Chris is also a technical author is currently working on E-Learning courses for SQL Server 2008 with Microsoft Learning. He also runs the Manchester SQL Server User Group and is a SQLBits Organiser. Chris is a SQL Server MVP and MCT and has Microsoft qualifications in MCDBA, MCTS and MCITP in SQL Server 2000, 2005 and 2008 as well as an MCSE in Windows Server 2000 and 2003.

Chris Testa-O'Neill's blog http://sqlblogcasts.com/blogs/testas/

---

Downloads

File Type Ext ContentName Presentation .pptx Slides

<< 1 >>

---

Other sessions from this conference

A whistlestop tour of SSIS add-ins

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study

An introduction to Master Data Services

Building cubes from ODS or Operational Systems

Cache-warming strategies for Analysis Services 2008

Common Integration Services Problems

Creating High Performance Spatial Databases

Data & Backup Compression in SQL Server 2008

Data Visualisation with Bing Maps for Enterprise

Data Warehouse on a Fast Track forwards

Data warehousing features in SQL 2008

Designing for simplification

Designing I/O systems for SQL Server

Excel - An Excellent Data Mining Tool

I need my reports..........Yesterday!

Introducing Project Madison

Introducing SQL Server Master Data Services

Introduction of MS StreamInsight.

Introduction to the Microsoft BI Technology Stack

Let’s make SQL fly – a technical session for developers and administrators who believe in magic!

Lets go more functional - F# WHAT , WHY and BI

Microsoft SQL Server 2008 R2: What’s New in Reporting Services

Optimistic Concurrency Internals

Powershell – old tricks for a new dog?

Put Your Feet Up : Simplified Management using the Enterprise Policy Management Framework

Real World SQL Server High Availability

Report Builder 3

Self Service Business Intelligence- Project Gemini

Server consolidation with SQL Server

SQL 2008 Development Features

SQL Injection Attacks (and how to prevent them)

SQL Server 2008 - Unstructured Data Storage Solutions and Best practices

SQL Server optimization stuff you won’t find on Google (yet)

SQL, NoSQL, SomeSQL - A look at non-relational databases

SQLDataSources, LINQDataSources and EntityDatasources in Database Design

SSIS in SQL Server 2008

Strapped for cache? - Troubleshooting memory problems in SQL Server 2008

The R2 Duo: Running SQL Server 2008 R2 on Windows Server 2008 R2 Core

T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig

Using Perfmon and Profiler

Virtualising SQL Server

Vital Statistics

What's new in R2 for the DBA

When a query plan goes wrong