Data Warehousing & BI Online Training | BI Certification Course | Edureka

Data Warehousing and BI Certification Training


Watch the demo class

Why should you take Data Warehousing and BI course ?

About the Course

Become an expert in Data Warehousing and Business Intelligence techniques covering concepts like DW Architecture, Data Modeling, ERwin, ETL fundamentals, Business Reporting and Data Visualisation

Instructor-led Data Warehousing and BI live online classes

14

Dec
Fri - Sat ( 5 Weeks )
09:30 PM - 12:30 AM ( EST )
10% Off
17995
16195
Select This Batch

19

Jan
Sat - Sun ( 5 Weeks )
10:00 AM - 01:00 PM ( EST )
10% Off
17995
16195
Select This Batch
EMI Option availableCall us: +91 96060 58413
100% Satisfaction guaranteed

Learning Objectives - 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.

Learning Objectives - 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?

Learning Objectives - 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.

Learning Objectives - 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.

Learning Objectives - 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.

Learning Objectives - 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.

Learning Objectives - 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.

Learning Objectives - 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.

Learning Objectives - 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.

Learning Objectives - 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 Modeling.

Like the curriculum? Enroll Now
Structure your learning and get a certificate to prove it.
Enter a valid mobile number

Edureka’s Business Analyst with proficiency in DWH and BI Certificate Holders work at 1000s of companies like

5000 Total number of reviews
4.57 Aggregate review score
80% Course completion rate
No data found
STILL HAVE QUESTIONS. CALL US 1833 833 0587
READ MORE TESTIMONIALS
STILL HAVE QUESTIONS. CALL US 1833 833 0587
VIEW MORE REVIEWS
Loved reviews? Enroll Now
Structure your learning and get a certificate to prove it.
Enter a valid mobile number

Towards the end of the Course, you will be working on a live project where you will be using Adventure Work Dataset, Sales Dataset to perform various Data and Reporting Analytics. 

Project #1 : Creation of Sales Data Warehouse & Data Marts.

Industry : Retail 

Data : North-wind/Adventure Works dataset.

Problem Statement : Creation Sales Data Mart using ERwin r9 

Project #2 : Transaction Analysis for Retail 

Industry : Retail 

Data : Sales data from Real time retail project. (Data will be masked)

Problem Statement : Analysing & Loading Retail Transaction Data using Talend. 

Project #3 : Transaction Analysis for Retail Analytics 

Industry : Retail 

Data : Real Time Retail Analytics Dashboard Project. 

Problem Statement : Building Real Time Retail Analytics Dashboard using Tableau.

The pre-requisites for this course include basic knowledge of SQL, General Relational Database (Oracle), Microsoft Windows GUI, Basic Unix, Windows Command line.
For doing the practicals we will help you to setup ER Win r9, Talend 5.x and Tableau 9.x. The detailed installation guides are provided in the LMS for setting up the environment. In case you come across any doubt, the 24*7 support team will promptly assist you.
The pre-requisites for this course include basic knowledge of SQL, General Relational Database (Oracle), Microsoft Windows GUI, Basic Unix, Windows Command line. 

Instructor-led Live Sessions

30 Hours of Online Live Instructor-led Classes. Weekend class : 10 sessions of 3 hours each.

Real-life Case Studies

Live project where you will be using Adventure Work Dataset, Sales Dataset to perform various Data and Reporting Analytics. 

Assignments

Every class will be followed by practical assignments which aggregates to minimum 25 hours.

Lifetime Access

Lifetime access to Learning Management System (LMS) which has class presentations, quizzes, installation guide & class recordings.

24 x 7 Expert Support

Lifetime access to our 24x7 online support team who will resolve all your technical queries, through ticket based tracking system.

Certification

edureka! certifies you as 'Data Warehousing & BI Expert' based on your project performance, reviewed by our expert panel.

Forum

Access to global community forum for all our users that further facilitates learning through peer interaction and knowledge sharing.
You will never miss a lecture at edureka! You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session in any other live batch.
To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the "create your resume" option.
We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment 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.
All instructors at edureka are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by edureka to provide impeccable learning experience to all our global users.
You can Call us at +91 98702 76457 /1844 230 6362 ( US Tollfree ) OR Email us at sales@edureka.co . We shall be glad to assist you.
You no longer need a credit history or a credit card to purchase this course. Using ZestMoney, we allow you to complete your payment with a EMI plan that best suits you. It's a simple 3 step procedure:
  • Fill your profile: Complete your profile with Aadhaar, PAN and employment details.
  • Verify your account: Get your account verified using netbanking, ekyc or uploading documents
  • Activate your loan: Setup automatic repayment using NACH to activate your loan
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Enter a valid mobile number

Checkout our Business Intelligence Masters Program

Business Intelligence Masters Program makes you proficient in tools and systems used by Business Intelligence Professionals. It includes in-depth training on Data Warehousing and BI, Teradata, Informatica, Microsoft BI and Tableau. The curriculum has been determined by extensive research on 5000+ job descriptions across the globe.

Explore Business Intelligence Masters Program
Business Intelligence Masters Program