Data warehousing and BI Certification Training



-45% Off
Data warehousing & ETL

Course Curriculum

Learning Objective: In this module, you will learn about data warehousing and business intelligence ETL Tools and BI Tools.

Topics Covered:
* What is Data Warehousing?
* Inmon Vs. Ralph Kimball
* Data Warehousing Tools
* Schema Modeling Tools
* Dell Toad Data Modeler
* Oracle Data Modeler
* ETL Tools: Informatica Power Center
* Talend DI Open Studio
* IBM Data Stage
* Data Warehousing categories
* What is BI - Business Intelligence?
* BI Definition
* BI Tools
* Classification of BI Tools

Learning Objective: In this module, you will study data warehousing architecture and its various source systems.

Topics Covered:
* Relational Vs. Analytical
* A brief about the OLTP, OLAP, OLAP categories - MOLAP, ROLAP, and HOLAP
* Data Warehouse Vs. Data Mart
* Dependent and Independent Data Mart
* Data Warehouse Architecture
* Source System
* ETL Extraction
* Transformation
* What is a cube?
* Benefits of the cube?
* How to create the cube?
* How to deploy a cube?
* How to build a report using the cube?
Learning Objective: In this module, you will learn about different dimensional and fact types of tables.

Topics Covered:
* What is a Dimension Table?
* Dimension table categories
* What is a Fact Table?
* Fact Table Granularity
* Fact Table categories
Learning Objective: In this module, you will learn about data normalization and its three different forms.

Topics Covered:
* What is Data Normalization?
* Data Normalization Rules - 1NF, 2NF, 3NF
* Data De-Normalization
* Dimensional Modeling - What is DM?
* Principles, Benefits, Type, and Technique
Learning Objective: In this module, you will study building a staging & target data warehouse and data marts.

Topics Covered:
* Source System Understanding
* Future Data Requirement and Understanding
* Designing and Developing Dimension Table
* Designing and Developing Fact Table Designing
* Developing the ER Model With ERwin
* Designing and Developing Entity-Relationship Modeling
Learning Objective: In this module, you will learn about the open-source and commercial ETL Tools and their differences.

Topics Covered:
* Open source ETL Talend DI Open Studio
* Difference between Open Source ETL Tools and Licensed Tools
* What are Open Source ETL Tools and licensed tools?
* How to work with ETL Transformation in Talend Open DI Studio?
* Constructing ETL Project With Talend DI Open Studio 5.x

Learning Objective: In this module, you will learn how to create working business models and data integration portals to manage various ETL items.

Topics Covered:
* Building ETL Project Talend DI Open Studio
* Understanding the Data Source System
* Identify Business Requirement Gathering
* Building the ETL Talend Technical Design Document
* Building an ETL Project
Learning Objective: In this module, you will study the data visualization tools available in the market and create reports and dashboards.

Topics Covered:
* Data Visualization BI Tool with Tableau 9.x
* Introduction to Data Visualization with Tableau
* Exploring Data Visualization with Tableau
* What is Data Visualization?
* Exporting Data and Working With Tableau
Learning Objective: In this module, you will study how to create reports and dashboards using Tableau.

Topics Covered:
* How to build a Data Visualization BI Project With Tableau 9.x
* BI Reporting Understanding
* Report and Dashboard Template Document
* Tableau Design
* Development Database Source Connection
Learning Objective: This project is related to the integrated data warehousing and business intelligence projects.

Topics Covered:
* An Integrated Data Warehousing & BI Project
* Developing a Data Warehouse and BI Project
* Source System understanding
* Identify the Business Requirement Gathering
* Report and Dashboard Template Document
* Designing and Developing Models
* Designing and Developing the Staging Area
* Finalizing the Dimension Modeling Type
* Designing & Developing Dimension Modeling

Course Description

CertOcean's Data warehousing course will award you with the architectural data skills required across a broad range of technology. In this certification, you will learn about the basics of structured data modeling, data manipulation, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design. Post the completion of the Microsoft Power BI certification. You will create dashboards and visual analytics and apply your skills to build a small warehouse of data.

The objectives of this Data warehousing course include
* Understand the fundamentals of Database management, establish Data Warehousing and Business Intelligence groups, and master SQL coding for required for answering business intelligence questions
* Learn how to design data warehouses and how to create data integration workflows
* Know about the features of relational database management systems utilized in BI reporting
* Understand the Business Intelligence Concepts, Tools, and Applications including the utilization of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capacities to make perceptions and dashboards.
Post the completion of the course, you will learn about:
* Database and DBMSs
* SQL CREATE TABLE function and how to utilize it to populate tables
* UNION and SQL SELECT functions
* Code tables to help a business design.
* About ERD symbols
* Creating Business Data Models
* Data Modeling Problems and how to create alternative designs
* Schema Conversion
* Standardization and Normalization
* Data Warehouse architecture and concepts
* Data Integration tools and infrastructure
* Utilizing Data Warehousing and Business Intelligence to help business choices
* Data Visualization and how to design a dashboard
There are no prerequisites for this Microsoft power bi certification, and anyone can take up this course. However, professionals having a sound understanding of how data works and how it contributes to building a business can ace this course.
You need a system with good internet connectivity. In any doubt, the 24*7 support line assists with all your queries and questions.
For all the projects, you can use the lab environment created for the Data warehousing course training.
Towards the course's completion, we will ask you to work on projects related to the creation of sales data warehouse and data marts, transactional analysis for retail, and transactional analysis for retail analytics.


Frequently Asked Questions (FAQs):

Candidates will never miss lectures in CERTOCEAN's Microsoft power bi certification as they can either view the recorded session or attend the next live batch.

We provide support to all the learners, even if they have completed their course training way before. Once you have registered with us, we will take care of all your educational needs and demands, resolving all your functional and technical queries

CertOcean's Microsoft power bi certification course will assist you throughout the course and help you master the concepts and practical implementation of technology for the course duration.

Our team is with each student 24/7. They need not worry about anything. Just ask your queries about the Data warehousing course training, and we will make sure that it gets solved as soon as possible.


Course Rating