Data Warehouse Data Modelling

In this session we will discuss what is dimensional data model, why do we use it for data warehousing, when to use and when not to use, what are the advantages and disadvantages and what are the alternatives. We will put dimensional modelling into practice by designing a data mart using a case study. That way we can get first hand experience about how a 3rd normal form transactional database is translated into fact and dimension tables in a dimensional model. Time permitting, we will also discuss some particular points in dimensional modelling such as smart date key, choosing dimensional grain, and real time fact table.

Vincent Rainardi

Very passionate with data warehousing, Vincent works in London as data warehousing & BI architect specialising on SQL Server BI. He currently works at IMS, and previously for Catlin, lastminute.com, Veolia, Avery Dennison and Accenture. He wrote a book on SQL Server data warehousing, titled 'Building a data warehouse with examples on SQL Server', published by Apress. He started working with data warehousing and OLAP in 1996 when he was working for Accenture. He wrote data warehousing & BI articles on SQLServerCentral.com. His blog is www.datawarehouse.org.uk. You can contact him at vrainardi@gmail.com. Vincent would welcome any questions and discussions on data warehousing and BI.

Vincent Rainardi's blog http://www.datawarehouse.org.uk/

---

Downloads

File Type Ext ContentName Presentation .pptx Slide Deck

<< 1 >>

---

Other sessions from this conference

AddIns for SSMS - build your own

Comparing Azure storage and SQL Data Services

Data Mining and SSIS - makes sense.

Data Warehousing features in SQL 2008

Database Maintenance Optimization

Designing Effective Aggregations in Analysis Services 2008

Effective test-driven database development

End to End Report Creation and Management in SQL Server Reporting Services 2008

High Availability in SQL Server 2008

Implementing Clustering using SQL Server

Instrumenting, Monitoring and Auditing of SSIS ETL Solutions

Making the SQL developer one of the family with Visual Studio Team System

Message in a bottle: Service Broker from 1 to 100 in 75 minutes!

NHibernate – Open Source Object Relational Mapping (ORM)

Performance Optimization with SQL Server 2008

Performance Tuning your TSQL

Securing and Hardening a SQL Server Implementation - Notes from the Field

SQL Server Architecture: The life of a query

SQL Server’s storage engine

SSIS by example

SSIS Nuggets Live

Stop throwing hardware at the problem !

Understanding ADO.NET Data Services

Understanding Graphical Execution Plans

Universal calculated measures in MDX queries

Upgrading To SQL Server 2005 & 2008: Notes & Best Practices

What’s New in SQL Server 2008 T-SQL