Vincent is a data warehouse & BI architect, specialising in SQL Server, MSBI, banking and asset management. He wrote a book
on SQL Server data warehousing & BI, and many articles on www.datawarehouse.org.uk
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.