Data Warehousing Certification Training

[vc_row full_width=”stretch_row” css=”.vc_custom_1559286923229{background-color: #f6f6f7 !important;}”][vc_column width=”1/2″][vc_tta_accordion color=”peacoc” active_section=”1″][vc_tta_section title=”Introduction to Data Warehouse” tab_id=”1559286383409-ab730398-6c03″][vc_column_text]Learning Objectives – Discussing about the basic concepts of a data warehouse and why it is needed. Difference between an operational system and an analytical system, Datamarts. Approaches to build a data warehouse.

Topics – 
1. What is a data warehouse? – Definition and explanation of the four terms – subject oriented, integrated, non volatile and time variant

2. Need for a data warehouse 3. Difference between a database and a data warehouse. OLTP and OLAP? 4. Datamart – The smaller cousin of the data warehouse

5. ODS – Operational Data Store – Definition and explanation of 4 terms – Subject oriented, Integrated, Current, Volatile, Detailed

6. Benefits of ODS 7. Design approach – Top down approach, bottom up approach, Federated[/vc_column_text][/vc_tta_section][vc_tta_section title=”Dimension and Fact” tab_id=”1559286522681-3bf94e12-e7b7″][vc_column_text]Learning Objectives – Learning what a dimension and a fact is, the different types of dimensions and facts. Reporting concept of Hierarchy.

Topics – 
1. Dimensions and facts – What are dimensions and facts?

2. Types of dimensions – emphasis on SCD 1,2,3 implementations 3. Types of facts 4. What are hierarchies – Types of Hierarchies[/vc_column_text][/vc_tta_section][vc_tta_section title=”Normalization and Schemas” tab_id=”1561382593569-b1979b66-b066″][vc_column_text]Learning Objectives – Organizing data in multiple tables. Understanding normalization and its different forms. Learning what is a schema and the different types of schemas along with meta data.

Topics – 
1. Normalization

2. Schemas – What is a schema. Types – Star, Snowflake, Galaxy 3. Significant role of meta data[/vc_column_text][/vc_tta_section][vc_tta_section title=”Modeling” tab_id=”1561382595833-dd54d407-26c0″][vc_column_text]Learning Objectives – Understanding principles of requirement gathering to build a warehouse and dimensional modeling.

Topics – 
1. Requirement gathering

2. Principles of dimensional modelling

3. Modeling – ER diagrams[/vc_column_text][/vc_tta_section][vc_tta_section title=”ETL in Detail” tab_id=”1561382597303-5168678c-55b9″][vc_column_text]Learning Objectives – Understanding where will the data come from and how will the data come and Populating the warehouse.Learning concepts of Extracting data, Transforming data and Loading the data into different tables.

Topics – 
1. ETL Concept – Architectural components – like Source, Staging, Atomic, Dimension

2. Transformation – Data Validation, Data Accuracy, Data Type Conversion, Business Rule Application

3. Data Loading techniques.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Project” tab_id=”1561382598718-1fee5a6b-29dd”][vc_column_text]Learning Objectives – Implementing a data warehouse Project.

Topics – Discuss a project, its problem statement, probable solutions, and implement one solution.[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][vc_column width=”1/2″][vc_tta_accordion color=”peacoc” active_section=”1″][vc_tta_section title=”About The Course” tab_id=”1561382561432-7f73ef2a-cc67″][vc_column_text]This Data warehousing course enables participants with concepts of Data warehousing like Facts, Schema, Metadata, Normalization, Data transformation, Dimensional Modeling and ETL Concepts.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Course Objectives” tab_id=”1561382561455-654071d3-eb53″][vc_column_text]After the completion of Data warehousing course at Edureka, you will be able to:

1. Understand the concept and need of Data warehouse

2. Implement concepts of dimension and fact table

3. Implement data modelling, normalization and schema concepts 4. Model a Data warehouse

5. Implement ETL jobs[/vc_column_text][/vc_tta_section][vc_tta_section title=”Who should go for this course?” tab_id=”1561382611424-56181e07-6453″][vc_column_text]This course is a foundation to anyone who aspires to become a Data warehouse Architect, a Data warehouse Developer or a Data warehouse Business Analyst in the field of Data warehousing and Business Intelligence. The following professionals can go for this course :

1. BI /ETL Professionals

2. Project Managers

3. Testing Professionals

4. Mainframe Professionals

5. Analytics Professionals

6. Software Developers and Architects[/vc_column_text][/vc_tta_section][vc_tta_section title=”Pre-requisites” tab_id=”1561382613753-7c9c9136-4ca1″][vc_column_text]The pre-requisites for this course includes basic understanding of Databases.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Why learn Data Warehousing?” tab_id=”1561382614729-6b63842b-62b1″][vc_column_text]As we move from intuition based decision making to factual decision making, it is increasingly important to capture data and store it in a way that allows us to make smarter decisions. This is where Data warehouse comes into picture. There is a huge demand for Data warehousing professionals and this course acts as a foundation which opens the door to a variety of opportunities in Business Intelligence space.[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][/vc_row]

WhatsApp us