Vincent is a data warehouse & BI architect. He wrote a book
on SQL Server data warehousing & BI, as well as many articles on www.datawarehouse.org.uk
. Vincent is certified in designing BI solutions, database design and DBA (MCTS, MCITP, MCP).
Designing dimensional and fact tables using a case study to understand data modelling
A step-by-step demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star/snowflake schema Data Warehouse/Mart first.
Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.