Data Warehousing Training
![Intellipaat](https://static.mytechlogy.com/cache/120eb50138d5e4ddec9e3d84afbf6e36_w30_h30_cp_sc.gif)
Intellipaat
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 Description
About Data Warehouse and Erwin Training Course
What you will learn in this Data Warehouse Certification Training Course?
- Learn Data warehousing Concepts, Data Modeling and BI Life cycle
- Learn about Erwin database and the concepts of RDBMS
- Work with Star and Snowflake Schema
- Understand slowly changing dimensions (SCD) Implementation methods
- Learn to work with SQL data, SQL Modeler and SQL Parsing
- Learn Data Modeling using Erwin design Layer Architecture
- Work on the concepts of Erwin Forward & Reverse Engineering
Who should take this Data Warehouse training Course?
- Database Administrators and Database Modelers
- Analytics Managers, ETL and BI Developers, Data Scientists and Analysts
- Those looking for a career in Data warehousing
What are the prerequisites for taking this Data Warehousing online training Course?
This course can be pursued regardless of the individual’s skillsWhy you should take this Data Warehousing Training?
- ERwin is worldwide market leader in data modeling with 33% market share – IDC Report
- Data warehouse management market to reach $17 billion by 2018 – Global Industry Analysts
- An ETL Data Warehouse Developer in the USA can earn $101,000 – indeed.com
-
+
Course Syllabus
Data Warehouse Course Content
Introduction to Data WarehouseIntroducing Data Warehouse and Business Intelligence, understanding difference between database and data warehouse, working with ETL tools, SQL parsing.Architecture of Data WarehouseUnderstanding the Data Warehousing Architecture, system used for Reporting and Business Intelligence, understanding OLAP vs. OLTP, introduction to Cubes.Data Modeling conceptsThe 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 NormalizationUnderstanding the process of Data Normalization, rules of normalization for first, second and third normal, BCNF, deploying Erwin for generating SQL scripts.Dimension & Fact TableThe 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 & OLAPSQL 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 ArchitectureLearning 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 EngineeringUnderstanding of the forward and reverse engineering, comparison between the two.Data Warehouse ProjectProject 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.
This course is listed under
Development & Implementations
, Data & Information Management
, Project & Service Management
and Quality Assurance & Testing
Community
Related Posts: