Who should attend
- 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 up this Data Warehousing online training course?
This course can be pursued regardless of learners’ skills.
About the course
Data Warehousing and ERwin training by Intellipaat will help you master Business Intelligence concepts like data warehousing (DW) architecture, data integration, data modeling, ERwin and the fundamentals of ETL: extract, transform and load. This online course on data warehousing also covers real-life projects.
About Data Warehouse and ERwin Training Course
Intellipaat offers data warehousing training and ERwin data modeler training. You will gain thorough proficiency in multidimensional modeling, RDBMS tools, SQL parsing, comparison of data warehouse and database and Cube and ERwin implementation. This data warehousing online training course can be taken by both freshers and advanced professionals.
What will you learn in this Data Warehouse certification training course?
- Data warehousing concepts, data modeling and BI life cycle
- ERwin database and the concepts of RDBMS
- Working with star and snowflake schema
- Slowly changing dimensions (SCD) implementation methods
- Working with SQL data, SQL modeler and SQL parsing
- Data modeling using ERwin design layer architecture
- Working on the concepts of ERwin forward and reverse engineering
Why should you take up this Data Warehousing training?
- ERwin is the worldwide market leader in data modeling with 33 percent market share – IDC Report
- Enterprise Data Management market to reach $105 billion in two years – MarketsandMarket
- An ETL Data Warehouse Developer in the USA can earn $101,000 – Indeed
Major corporations are investing huge amounts of money in order to derive more value from the data that they collect. This means that Business Intelligence and data warehousing tools like ERwin will see a huge rise due to their rapid adoption. There will be increasing demand for professionals with skills like data modeling and expertise in ETL deployment. This can lead to huge jump in salaries for the right certified candidates.
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.
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 (self paced)
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 (self paced)
Understanding of the forward and reverse engineering, comparison between the two.
Data Warehouse Projects
What projects I will be working on this Data Warehouse training?
Project 1– Logical & Physical Data Modeling Using ERWin
Data – 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)
Topics – 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.
Data Warehousing Certification
As part of this Data Warehousing training with ERwin, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.
Intellipaat Course Completion Certificate will be awarded on the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top 80+ MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
Videos and materials
Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.
We are happy to help you find a suitable online alternative.