Top Hiring Company
Industry Trends
Course curriculum / Syllabus
Introduction to Data Warehouse
- Overview of data warehouse and data intelligence
- Several differences between a data warehouse and a database
- How to work with ETL tools
- Schema modelling tools
- Oracle data modeler
- Data warehousing categories
- Understanding business intelligence tools
- Types of business intelligence tools
Data Warehouse Dimension and Fact Tables
- Introduction to Dimension Table
- Overview of Fact Tables
- Dimensional table categories
- Fact Table Granularity
- Categories of Fact Table
Data Warehouse Architecture
- Introduction to data warehouse architecture
- What are OLAP and OLTP
- Several differences between Data Mart and Data Warehouse
- OLAP categories – ROLAP, HOLAP, and MOLAP
- ETL Extraction
- Overview of cube
- Advantages of cube
- How to deploy a cube
- How to create the cube
- How to create a report with the help of a cube
- Source System
Building Data Warehouse with Erwin
- Future Data Requirement
- Understanding Source System
- How to develop and design Dimension Table
- How to develop and design Fact Table
- How to develop and design Entity Relationship Modelling
- How to develop and design ER Model
Overview of Data Visualization BI Tool Tableau 9x
- Introduction to Data Visualization BI Tool Tableau 9x
- How to explore Data Visualization with Tableau
- Description of Data Visualization
- How to export data and work with tableau
SQL parsing, Cubes, and OLAP
- Introduction to SQL parsing
- Learning about the types and scope of cubes
- Understanding the limitations of cubes and the evolution of in-memory analytics
- Multiple differences between Cubes and Data Warehousing
Data Modelling
- What is Data Modelling
- Introduction to Data Normalization
- Data Normalization Rules – 1NF, 2NF, 3NF
- Overview of Data De-Normalization
- Description of Dimensional Modelling
- Dimensional Modelling Principles
- Benefits of Dimensional Modelling
- Type and Technique of Dimensional Modelling
Introduction to Open Source ETL Tool Talend DI Open Studio
- Overview of Open-Source ETL Talend DI Open Studio
- Several differences between Licensed and Open Source ETL Tools
- Description of Licensed and Open Source ETL Tools
Using Components of Data Warehousing
- Using Components of Data Warehousing
What is Data Modeling and how to use it?
- Details of Logical data modeling
- Details of Physical data modeling
- Comparison of physical and logical
Data Modeling concepts
- Data Modeling concepts
What is Dimensional Modeling?
- Different Types of Dimensions
- Understanding Normalized dimension
- Understanding De normalized
- Different Types of Fact Tables
- What is Periodic Snapshot and how to use it?
- What is Accumulated Snapshot and the use of it?
- Understanding transactional grain
- What is Fact less?
OLAP system Design
- What is ROLAP ?
- Understanding MOLAP
- Understanding HOLAP
- Explain DOLAP
- What is TOLAP?
Exploring Enterprise Data Warehousing
- Exploring Enterprise Data Warehousing
Exploring Data Marts
- What is Independent data mart?
- What is Dependent data mart?
Exploring ODS (operational Data Store)
- Exploring ODS (operational Data Store)
Comparison and difference between OLTP, OLAP, ODS
- Comparison and difference between OLTP, OLAP, ODS
Difference between DWH and Data Marts
- Difference between DWH and Data Marts
Exploring Schemas
- Exploring Schemas
Difference between E-R Model and Dimensional Model.
- Difference between E-R Model and Dimensional Model.
Working with data modeling concepts.
- What is Conceptual modeling?
- What is Logical modeling?
- What is Physical modeling
Introduction to Erwin
- Introduction to Erwin
Design logical model with attributes, entities, and relationships.
- Design logical model with attributes, entities, and relationships.
Design Physical model with columns, tables, and relationships.
- Design Physical model with columns, tables, and relationships.
Working with non-identifying and identifying relationships.
- Working with non-identifying and identifying relationships.
Explanation on different types of relationships
- What is Unary relationship?
- Understanding Binary relationship
- Exploring Ternary relationship
What is 1-m and m-m relationships?
- What is 1-m and m-m relationships?
What is bridge or associate tables?
- What is bridge or associate tables?
Understanding forward engineering process
- Understanding forward engineering process
Working with reverse engineering process
- Working with reverse engineering process
Working complete comparison
- Working complete comparison
Data Warehouse Training FAQ’s:
1.What is a Data warehouse?
Data warehouse is also called as enterprise data warehouse (EDW) and is a system that can be used for data analysis and reporting. Data Warehouse is considered a main component of business intelligence. It is the process to manage and collect data from varied sources for providing meaningful business insights.
2.What is SAP Data Warehouse?
The SAP Data Warehouse is a central analytical repository for SAP source data. The data warehouse extracts and consolidates data from various SAP applications and components and makes it available in an aggregated format for reporting and analysis.
3.What is Azure Data Warehouse?
An azure data warehouse is a scalable analytical data warehouse built on the foundation of SQL Server and runs as part of the Microsoft Azure cloud computing platform.
4.How do I get Data Warehouse certification?
We would provide you with certification upon completion of the course. Many leading organizations recognize our certificate. You will gain credibility and it would be a value add to your resume.
5.What if I miss the class?
We would provide you with a recording of the class and also eLearning material for self-study,
6.Can I attend the demo?
Yes, you can attend the demo class and decide on continuing with our facility
7.Do you provide job assistance services?
Yes, we do provide job assistance services and also help you prepare for the interview.
Enquire Now
Why PROLOG INFO
Best Virtual training classrooms for IT aspirants
Real time curriculum with job oriented training.
Around the clock assistance
We are eager to solve your queries 24*7 with help of our expert faculty.
Flexible Timings
Choose your schedule as per your convenience. No need to delay your work
Mock projects
Real world project samples for practical sessions
