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
Learn about ReadyForBI™, our complete BI in the cloud solution that includes all services, software and hosting for one low monthly price.
Speak with us
We’re always glad to discuss BI, answer questions and meet new people involved with the practice. You can reach us from 8am-6pm Pacific time at 1-833-BI-READY.