Drop Us a Query:
HOME > ALL COURSES > IT & ITES > PRO-DABI
Program in Datawarehousing & Business Intelligence (PRO-DABI)
PRO-DABI is a specialized course meant for engineering graduates from CSE. It is developed to target the emerging growth sector of DW & BI. PRO-DABI will lay the foundation of a successful career ahead.
Upcoming PRO-DABI Batches:
About The Course:
PRO-DWBI is a specialized learning capsule designed for engineering students and professionals who want to build a successful career in the upcoming field of Data Warehousing and Business Intelligence. This program is designed to help students grasp the fundamentals of DWBI and project management practices in practical context using extensive case studies and on the job scenarios.
Course Objectives
The three key focus areas of this course are:
-
A comprehensive overview of all important DWBI fundamentals along with practical and scenario based understanding for a thorough preparedness for technical interviews in DWBI.
-
Focus on case studies and projects to design solutions in DWBI domain.
-
One to one mock interview and personalized feedback and attention to problem areas.
DWBI is a hot skill in IT today and yet the fundamentals of DWBI are not yet included in university curriculums for IT courses. This course will provide much needed base work for students and professionals who want to pursue a career in DWBI.
Module 1: Data Warehousing Overview
This is a primer module that will introduce the students to the field of DWBI and how to derive maximum benefit from the course. This module will also set the stage about the various terminologies used in the domain and understanding the paradigm and processes involved in DWBI solutions. This module will have case study to further illustrate the need for Enterprise DWBI solutions.
Topics:
-
Introduction to the course and how to derive maximum benefit from the course
-
Introduction to Data Warehousing
-
Understanding the various DWBI terminologies
-
Understanding Data warehouse features
-
OLAP vs OLTP
Module 2: DWBI Process Flows
Understand the framework for DWBI, the various process flows and data flows involved in DWBI solutions. Also, understand and differentiate between the various sub disciplines within DWBI.
Topics:
-
Application of a Data Warehouse
-
Understanding Metadata
-
Understanding the process flows in Data Warehouse
-
Understanding Data Marts
-
Understanding ETL and Reporting
-
Introduction to Data Mining and Business Intelligence
Module 3: DWBI Architecture
Learn about DWBI Architecture and the various design methodologies used by practitioners who implement DWBI solutions. Understand and learn to differentiate between Kimball and Inmon methodologies and understand the various pros and cons of the various design approach.
Topics:
-
Data Warehouse Architecture
-
Business Analysis Framework
-
Understanding the Kimball and Inmon design methodologies
-
Designing an Enterprise Data Warehouse
-
DWBI Tools
-
Case Study
Module 4: Understanding OLAP and Dimensional Modelling
Understand the need for OLAP systems and the various operations used for data manipulations. Understand the basic concepts related to schemas to understand data modelling for OLAP systems.
Topics:
-
OLAP Operations
-
Understanding hierarchy, Roll-Up and Drill Down
-
Understanding Slice and Dice
-
Relational OLAP
-
Data Warehousing Schemas - Star and Snowflake
-
Understanding Facts and Dimensions
Module 5: Extract, Transform and Load
Understand ETL system, workflows and jobs. Learn about the various transformations used in ETL processed and practice designing simple ETL jobs.
Topics:
-
Understanding ETL
-
Designing an ETL Job
-
Understanding workflows
-
Setting up environment for ETL jobs
-
Transformations used in ETL jobs
-
Using Joins, Unions and Filters
Module 6: ETL Transformations
Learn more complex data transformation techniques like Change Data Capture and Normalization and practice creating ETL jobs using Talend Open Studio.
Topics:
-
Understanding complex transformations
-
Normalization of data
-
Understanding Change Data Capture
-
Performance tuning techniques
-
Project on Designing an ETL job
Module 7: Understanding Reporting for DWBI
Understand the reporting function of DWBI jobs. Learn about cubes, slice and dice and other reporting operations. Understand the business aspect involved in creating Reporting and designing BI solutions. Learn about various reporting tools and compare their capabilities.
Topics:
-
Understanding cubes
-
Understanding Report Designs
-
Strategies for Business Intelligence solutions
-
Comparing the various Reporting tools
-
Testing for BI projects
Module 8: Retail Case Study
Design and implement an end to end DW-BI solution for a retail domain. Design the process flows, design the data model and identify the jobs and reports to be created for retail domain.
Topics:
-
Transaction fact tables
-
Denormalized dimension table hierarchies
-
Dealing with nulls
-
Degenerate dimensions
-
Surrogate keys for dimensions
-
Date and time-of-day dimension considerations
-
Snowflake schemas with normalized dimensions
-
Factless fact tables
Course Curriculum
EduVantage Certification:
EduVantage certifies that you have successfully completed its skill assessment course. At the end of your course, you will work on a real time Project and will receive a Problem Statement to work.
Once you are successfully through the project which will be reviewed by an expert, you will be awarded a certificate with a performance-based grading.
If your project is not approved in 1st attempt, you can take extra assistance for any of your doubts to understand the concepts better and reattempt the Project free of cost.
PRO-DABI FAQ
Frequently asked questions are listed questions and answers.
Who Should attend this course?
Though aspirants from CSE background are a natural fit candidates to join this course however students from any background can join this course for an aspiring career in Data Warehousing & Business Intelligence.
What is the eligibility?
Aspirants joining this course should have elementary knowledge of IT.
Who are the instructors?
All our instructors are working professionals from the Industry and have at least 10-12 yrs of relevant experience in respective domains. They are subject matter experts and are trained by Eduvantage for providing training so that participants get a great learning experience
Is the course material available to the students even after the course training is over?
Yes, the course material is provided permanently to the students and they can refer to it whenever they need. We also provide you fee access to relevant online modules.
What if I miss a class?
If the same session is available in other classes in next few weeks, you can be accommodated in another class depending upon the seats available in that class.
I have paid the enrolment fee but I am unable to continue in the present batch. Can I reschedule it to a future date?
Yes, you can do that subject to the availability of the seats available in the upcoming batches.
Do you provide placement assistance?
Eduvantage is a startup education company and lots of recruitment firms contacts us for our students profiles from time to time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don't guarantee any placements however if you go through the course diligently and complete the project you will have a very good chance of securing a jpb of your choice.
​
Can I attend a Demo Session?
We have limited number of participants in a live session to maintain the Quality Standards, hence, participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
What are the payment options?
You can pay by Credit Card, Debit Card or NetBanking from all the leading banks. We use a CCAvenue Payment Gateway. For USD payment, you can pay by Paypal. We also have EMI options available.
What if I have queries after I complete this course?
Our instructors will be available to you on phone and you can also personally meet them any time even after you have completed the course.
What if I have more queries?
You can give us a CALL at +91 9999 608 499 or email us at sales@eduvantage.co.in
PRO-DABI Course Features
Assignment
Assignments will be an integral part of the assessment
Certification
After the completion of the course and based on your Project Report you will receive the EduVantage Certification of Qualification. You will also be graded based on your performance in the course.
Project
Aspitants will be evaluated on the performance of the Project will be given at the end of the training capsule
24 x 7 Support
Aspirants will get access to the support team (available 24 x 7) in resolving queries during and after the course completion
Lifetime Access
Aspirants will be given Lifetime free access to our training resources