Data Warehousing and Business Intelligence Introduction
Introduction of Data Warehousing and Business Intelligence with various ETL Tools and BI Tools with ERwin r9 Data Modeling
Introduction to Data Warehouse & Business Intelligence
Objective: In this module, you will get an introduction of Data Warehousing and Business Intelligence with various ETL Tools and BI Tools with ERwin r9 Data Modeling.
Topics: What is Data Warehousing?, Definitions by W.H. Inmon [Top-Down Design], Ralph Kimball [Bottom-Up Design], Inmon Vs Ralph Kimball, Data Warehousing Tools, Schema Modeling Tools, CA, ERwin, Dell Toad Data Modeler, Oracle Data Modeler, ETL Tools: Informatica Power Center, Talend DI Open Studio, IBM Data Stage, SAS, Data Warehousing categories. What is BI - Business Intelligence?, BI Definition, BI Tools, Classification of BI Tools.
Data Warehouse Architecture
Objective: In this module, you will learn about the Data Warehouse Architecture which talks about the Various Source Systems i.e., Production Data into Relational, Flat File and various legacy system to Staging Area and finally into the Data Warehousing/Data Mart for presentation layer.
Topics: Relational Vs Analytical. What are - OLTP, OLAP, OLAP categories - MOLAP, ROLAP, 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 cube?, How to create the cube?, How to deploy a cube?, How to create a report using a cube?
Data Warehouse Dimension & Fact Tables
Objective: In this module, you will learn about different categories of Dimensional and Fact Type tables. Dimension - Slowly Changing Dimension concepts with Hierarchies and Level Attributes. Fact - Granularity for the fact data and also talks about the Measure Type.
Topics: DIMENSION TABLE - What is a Dimension Table?, Dimension table categories, FACT TABLE - What is Fact Table?, Fact Table Granularity, Fact Table categories.
Data Modelling
Objective: In this module, you will learn about What is Data Normalization and their 3 types of forms. Here you learn about the type of dimensional modeling, benefits, principles and characteristics.
Topics: What is Data Normalization?, Data Normalization Rules - 1NF, 2NF, 3NF, Data De-Normalization, Dimensional Modeling - What is DM?, Principles, Benefits, Type and Technique.
Building Data Warehouse with ERwin
Objective: In this module you will see how we create a staging and target data warehouse and data marts from scratch to final. Decide the surrogate key, Dimension and Fact Tables. You also learn to generate the SQL scripts via ERwin r9.
Topics: Source System Understanding, Future Data Requirement and Understanding, Designing and Developing Dimension Table, Designing and Developing Fact Table Designing and Developing ER Model With ERwin, Designing and Developing Entity Relationship Modeling.
Introduction to Open Source ETL Tool Talend DI Open Studio 5.x
Objective: In this module, you will learn about the open source and commercial ETL Tools available into the market and it various comparisons. You will learn to create the flat file and relational target via Talend DI Open Studio 5.x using various Transformations.
Topics: Open source ETL Talend DI Open Studio -Difference between Licensed and Open Source ETL Tools, What are Licensed and Open Source ETL Tools, Working with ETL Transformation in Talend Open DI Studio.
Building ETL Project With Talend DI Open Studio 5.x
Objective: In this module, you will learn to create the actual business model and data integration jobs with management of various ETL items. You will learn how the actual ETL Projects work with BRD[Business Requirement Document] and TDD [Technical Design Document] and its uses.
Topics: Building ETL Project Talend DI Open Studio, Understanding the Data Source System which will be a future Data Requirement, Identify Business Requirement Gathering, Building the ETL Talend Technical Design Document, Building an ETL Project.
Introduction to Data Visualization BI Tool Tableau 9.x
Objective: In this module, you will learn about the Data Visualization Tools available in the market. You will learn to create reports and dashboards via Tableau 9.x using various functions.
Topics: Data Visualization BI Tool : Tableau 9.x-Introduction to Data Visualization with Tableau, Exploring Data Visualization with Tableau. What is Data Visualization?, Exporting Data and Working With Tableau.
Building Data Visualization BI Project With Tableau 9.x
Objective: In this module, you will learn to create reports and dashboards via Tableau 9.x using various advance features and functions. You also need to understand the various current and new report requirement.
Topics: Building Data Visualization BI Project With Tableau 9.x, BI Reporting Understanding, Report and Dashboard Template Document, Tableau Design and Development Database Source Connection.
An Integrated Data Warehousing & BI Project
Objective: This is an integrated Data Warehousing and Business Intelligence Project which starts from User Source System and Business Requirement Gathering till end of Project Development with production support strategies developments.
Topics: An Integrated Data Warehousing & BI Project, Developing a Data Warehouse and BI Project, Source System understanding today's data that will be the future data requirement, 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 and Developing Dimension Modelling.
Online live courses have become extremely popular due to the following reasons:
- Flexibility and convenience of location and time.
- As the course is spread over a few weeks, you get a chance to practice what you have learnt in a session before the following session. This results in much better understanding and learning
- You get 24x7 learning support and access to excellent learning resources, subject materials at one place.
- You can interact and collaborate with the industry experts, instructors, other learners of the course during and after the course
- Access to the sessions recordings – this is important if you miss a session or want to do a quick revision
- Provision of real-time cloud based labs.
On enrollment, each student is given access to a personalized LMS - Learning Management System. This features your class recordings, presentations, assignments, installation guides, data-sets, quizzes, forums and project documents.
This LMS access is for life-time.
We have a 24/7 support team featuring expert professionals with at least 3 years of experience in the specific technology. In addition to this, they're also given soft-skills training to ensure the best possible experience for you.
The support team is accessible via phone, email, live chat & video-calls. Please note, this is a lifetime facility. Even after course completion you can access the support facilities.
We are only happy, if you are happy. If you have any reason to doubt the content, delivery & expertise of our program, you are eligible for a 100% refund within 7 days of enrollment.
Your payment only comes into our accounts after 7 days, thus ensuring that your refund will be immediately processed.
If you enroll for 2 or more courses at once; your refund policy only stands till the completion of the first course.
We offer 100% placement assistance to its learners who are open to new job opportunities:
- We have collaborated with many companies who give us their hiring requirements
- These hiring partners also have access to the profiles of the learners who are looking for career opportunities, to initiate a contact with them
- Learnests will also send you a curated list of job postings that come up on various websites pertaining to your field of interest.
Note: Learnests offers placement assistance to every learner who wishes to look at career opportunities. However, we do not offer any job guarantee.
During this course; you will be provided with 5 live industry grade projects. Each project will feature data-sets, use-cases & guides from the following industries:
- Finance
- Healthcare
- Social Media
- Entertainment
- Retail
It will take you an average of 10 hours to complete each project.
Each student will be given a certification of course completion only after they finish the classes as well as their projects. The grade will be based on their performance as judged by the instructor. This certificate is recognized by all our corporate partners.
