BD 120 – Data Flow Diagram
After collecting requirements and creating a target data model, it is time to create a source to target map known as an ETL Data Flow Diagram (DFD). This course both describes the role of a DFD and demonstrates the creation of a simple DFD.
This course continues from where BD 110 (dimensional modeling introduction) left off. With a simple data model in place this course dives deeper into the ETL design. The source system, AdventureWorks, is researched and a data flow diagram is created.
- Introduce ETL data flow diagrams
- Create a simple ETL data flow diagram
- BD 100 – Development Workflow
- BD 110 – Dimensional Modeling Introduction
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 BD 110 (attached)
SalesDFD_v01.vsd – Visio ETL data flow diagram created during this course (attached)
DateCTE.sql – Sample common table expression used to generate a date dimension (attached)
LeapFrogBI Components.vss – Visio stencil used during this course (attached)
Kimball Group – The Kimball Group offers dimensional modeling training, white papers, and user forums.
AdventureWorks 2012 – SQL Server 2012 Sample OLTP Database