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: 18 Write a review.

  0 of 0 people found the following review helpful:
 
5 of 5 Course Review August 10, 2023
Reviewer: Carol Stout  
The examples were great. The slides were very succinct and the voice over added the right amount of detail. I think this course was an excellent use of my time.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course review August 10, 2023
Reviewer: Saeed Zargari  
It is a good course. The sound recording has some problem. it seems that the microphone was very close to his mouth and recorded unwanted sounds like lips cleaning. Sounds like 'mch mch'. He speeks too slow and mono-tone.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
5 of 5 Course Review March 31, 2017
Reviewer: Kimberly Wolff  
This was a good introduction into the type of material I've been looking for.  Adding in some examples that we work through (to ensure we understand the concepts) would be a nice addition to this course.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review March 29, 2017
Reviewer: Matt Chapman  
Coming from the Logical Data Modeling course the first module became very redundant. The definitions and review of normal forms were a great addition.

Was this review helpful to you?

  0 of 0 people found the following review helpful:
 
4 of 5 Course Review June 29, 2015
Reviewer: Jakub Pawlicki  
The course was excellent. The instructor was human and the material interesting. One could describe higher levels of normalization.

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