Data Modeling Best Practices


The business requirement for immediate access to business-critical information would be challenged by the scope of an enterprise data warehouse (EDW), as well as the response time when large numbers of users are developing and running reports from the same source. The complexity and slow response time will drive business user back to their reporting silos and away from the benefits of standardized naming conventions and advanced analytics. An EDW investment will yield a high ROI when these problems are solved.

The Data Modeling course provides an overview of how enterprise data warehouses (EDW) and data marts (DM) are designed, developed and maintained to reflect consistent data quality attributes, and include only relevant data to focus and minimize analytic time. Sample EDW and DM models will be provided that can be enhanced and modified to reflect an organization’s unique needs and wants.

Intended Audience

Strategic Business Unit executives/managers, business analysts and subject matter experts

Course Outline


Enterprise Data Warehouse Architecture


Data Types




Participants will complete the program with an understanding of how EDW and DM data models are designed, developed and maintained.


2, 4 hour sessions


Data Warehouse Architecture