BD 110 – Dimensional Modeling Introduction
Defining a desired data mart structure prior to beginning development is key to success. Data models are the blueprint of data mart development. This course demonstrates the creation of a simple dimensional data model while describing the role it serves.
This course serves as a brief introduction to dimensional data modeling.
- Introduce dimensional modeling.
- Create a simple dimensional model.
Configuration & Tools
- SQL Server 2012 Database Engine
- SQL Server 2012 Management Studio
- Sample Database – AdventureWorks 2012
- Visio 2010
To review the project created during this course log into LeapFrogBI using the following credentials and select the corresponding project from the Training Account project list. Send a request to firstname.lastname@example.org to add a fully editable copy of this course’s project to your LeapFrogBI account.
User Name: Student
Project Name: None – This course does not include a LeapFrogBI project.
Supporting Materials & References
SalesDataModel_v01.vsd – Visio data model diagram created during course (attached)