Data Modeling Best Practices

Summary

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

Introduction

Enterprise Data Warehouse Architecture

Schemas

Data Types

Templates

Summary

Results

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

Duration

2, 4 hour sessions

Prerequisites

Data Warehouse Architecture