Data Warehouse Fundamentals for Beginners

Best Practices and Concepts for Architecture and Dimensional Design

Created by: Alan Simon
Thought leader in business intelligence and enterprise data

What Will I Learn?

• Master the techniques needed to build a data warehouse for your organization.
• Determine your options for the architecture of your data warehousing environment.
• Apply the key design principles of dimensional data modeling.
• Combine various models and approaches to unify and load data within your data warehouse.

Requirements

• A basic understanding of (but not necessarily programming experience with) relational databases and SQL fundamentals, specifically how you use the SQL CREATE TABLE statement to create data structures in a relational database.

Target audience

• A business analyst, data engineer, or database designer, currently with little or no exposure to or experience with data warehousing, who desires to build a personal toolbox of data warehousing best practices and techniques.
• After completing this course, you will be ready to begin working on real-world data warehousing projects, either with expanded responsibilities as part of an existing role or to find a new position involving data warehousing. Example positions include data warehousing architect, dimensional data modeler, ETL architect and designer, and data warehousing business analyst.