Platinum Sponsor

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.
Presented by Vincent Rainardi at SQLBits IV
  • Downloads
    Slide deck available Slide Deck 1.6 MB
  • SpeakerBIO
    vincent_rainardi.jpg
    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).
    http://www.datawarehouse.org.uk/ http://www.datawarehouse.org.uk/feed/
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.