Home > Instructors > Rick Sherman >

DW and BI Data Modeling
Data Warehousing and Business Intelligence Data Modeling - online training course
 
Alternative Views:


4-hour 15-min Online Course by Rick Sherman
Single-user access license
Our Price: $420.00


Product Code: DM-04-A


Course Exam [Add $100.00]

Description Course Outline Exam Details
 

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.

Click to play Course Sneak Peek

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.

You will learn:
  • 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
This course is geared towards:
  • 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

Average Customer Review: Average Customer Review: 4.5 of 5 4.5 of 5 Total Reviews: 55 Write a review.

  0 of 0 people found the following review helpful:
 
5 of 5 Course Review from 11/12/2022 January 28, 2024
Reviewer: Schalk Erasmus  
Excellent, well presented course

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review from 8/6/2022 January 27, 2024
Reviewer: Victoria Angela Vizmonte  
Would prefer to have more real-world examples and use cases for each dimensional modeling type. Liked the introduction on dimensional modeling. Would also be better if there are mini-exercises within the online course.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
5 of 5 Course Review from 12/29/2021 January 27, 2024
Reviewer: Roger Young  
Love this course. Would be great to have access to the training in the background to refer back to even though the .pdf notes are there. Course had deep topics that were broken up in a logical way so that it's easier to consume.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review from 11/30/2021 January 26, 2024
Reviewer: Jean-Patrick Medor  
The instructor talks slowly and takes his time to explain. It is a lot of materials for one course. May need more exercises.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review from 8/5/2021 January 26, 2024
Reviewer: Raghab Lohani  
great topic and delivery

Was this review helpful to you?

View All Customer Reviews

Browse for more products in the same category as this item:

Instructors > Rick Sherman
Courses > Metadata Management
Instructors
Courses