MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Data Warehousing Training

Course Summary

Data Warehousing and Erwin Training by Intellipaat will master you in Business Intelligence concepts like data warehousing (DW) Architecture, Data Integration, Data Modeling, Erwin, fundamentals of ETL - Extract, transform, load. This online course on data warehousing also covers real life projects.

  • +

    Course Syllabus

    Data Warehouse Course Content

    Introduction to Data Warehouse
    Introducing Data Warehouse and Business Intelligence, understanding difference between database and data warehouse, working with ETL tools, SQL parsing.
    Architecture of Data Warehouse
    Understanding the Data Warehousing Architecture, system used for Reporting and Business Intelligence, understanding OLAP vs. OLTP, introduction to Cubes.
    Data Modeling concepts
    The various stages from Conceptual Model, Logical Model to Physical Schema, Understanding the Cubes, benefits of Cube, working with OLAP multidimensional Cube, creating Report using a Cube.
    Data Normalization
    Understanding the process of Data Normalization, rules of normalization for first, second and third normal, BCNF, deploying Erwin for generating SQL scripts.
    Dimension & Fact Table
    The main components of Business Intelligence – Dimensions and Fact Tables, understanding the difference between Fact Tables & Dimensions, understanding Slowly Changing Dimensions in Data Warehousing.
    SQL parsing, Cubes & OLAP
    SQL parsing, compilation and optimization, understanding types and scope of cubes, Data Warehousing Vs. Cubes, limitations of Cubes and evolution of in-memory analytics.
    Erwin Design Layer Architecture
    Learning the Erwin model, understanding the Design Layer Architecture, data warehouse modeling, creating and designing user defined domains, managing naming and data type standards.
    Forward & Reverse Engineering
    Understanding of the forward and reverse engineering, comparison between the two.
    Data Warehouse Project
    Project 1– Logical & Physical Data Modeling Using ERWinData – Invoice Management (Sales)Topics–This project is involved with creating logical and physical data model using the CA Erwin data modeler design layer architecture. You will learn about the techniques for turning a logical model into a physical design. With this project you will be well-versed in the process of reverse and forward engineering. You will understand both the top down and bottom up design methodology.Project 2– End-to-End implementation of Data Warehouse (Retail Store)Data –SalesTopics – In this project you will learn about the process of loading data into a data warehouse using the ETL tools. You will learn about the ways to create and deploy the data warehouse. Oracle provides support for multiple physical but only one logical model in the data warehouse. This project will provide you extensive experience in integrating, cleansing, customization and insertion of data in the data warehouse for a retail store.

Course Fee:
USD 113

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url