eLearningCurve

A well designed data model is the cornerstone to building business intelligence and data warehouse applications that provide significant business value. Effective data modeling results in transforming data into an enterprise information asset that is consistent, comprehensive and current. Data is transformed from operational or source systems into a data warehouse and often data marts or OLAP cubes for analysis. This course provides the fundamental techniques to designing the data warehouse, data marts or cubes that enable business intelligence reporting and analytics.

This online training course discusses the two logical data modeling approaches of Entity-Relationship (ER) and dimensional modeling. ER modeling is used to establish the baseline data model while dimensional modeling is the cornerstone to Business Intelligence (BI) and Data Warehousing (DW) applications. These modeling techniques have expanded and matured as best practices have emerged from years of experience in data modeling in enterprises of all sizes and industries. These techniques improve the business value of the data, enhance project productivity and reduce the time to develop applications

This course includes a mix of concepts, applications and practical examples.

• the basics of Entity-Relationship (ER) and dimensional modeling
• the benefits and applicability of Dimensional Data Modeling
• how to create Dimensional Data Models for BI and DW applications
• how to learn more about Data Modeling

• Beginning Data Modelers
• Business Analysts and Architects
• Database Administrators and Analysts
• Information Technology Managers, Project Managers
• Application Development Project Team Members
• People involved in design and maintenance of Data Warehousing and Business Intelligence applications
• People involved in data quality or data governance processes