Data Warehousing and BI Certification Training


Data Warehousing and BI Certification Training

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

$469.00 $399.00

Instructor-led Data Warehousing and BI live online classes





Dec 26th SAT & SUN (5 WEEKS) Weekend Batch ⚡FILLING FAST Timings – 08:30 PM to 10:30 PM (IST)
Jan 30th SAT & SUN (5 WEEKS) Weekend Batch Timings – 07:00 AM to 10:00 AM (IST)

Introduction to Data Warehouse & Business Intelligence

Answer: 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.

Data Warehouse Architecture

Answer: 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?

Data Warehouse Dimension & Fact Tables

Answer: 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.

Data Modeling

Answer: 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.

Building Data Warehouse with ERwin

Answer: 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.

Introduction to Open Source ETL Tool Talend DI Open Studio 5.x

Answer: 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.

Building ETL Project With Talend DI Open Studio 5.x

Answer: 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.

Introduction to Data Visualization BI Tool Tableau 9.x

Answer: 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.

Building Data Visualization BI Project With Tableau 9.x

Answer: 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.

An Integrated Data Warehousing & BI Project

Answer: 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.

What are the pre-requisites for this course?

Answer: The pre-requisites for this course include basic knowledge of SQL, General Relational Database (Oracle), Microsoft Windows GUI, Basic Unix, Windows Command line.

How will I execute the practicals?

Answer: 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.

Which case studies will be the part of this course?

Answer: 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.

What if I miss a class?

Answer: You will never miss a lecture at CertAdda 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.

What if I have queries after I complete this course?

Answer: Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

How soon after Signing up would I get access to the Learning Content?

Answer: Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover the access to our 24x7 support team will be granted instantly as well. You can start learning right away.

Is the course material accessible to the students even after the course training is over?

Answer: Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

Will I Get Placement Assistance?

Answer: More than 70% of Edureka Learners have reported change in job profile (promotion), work location (onsite), lateral transfers & new job offers. Edureka\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'s certification is well recognized in the IT industry as it is a testament to the intensive and practical learning you have gone through and the real-life projects you have delivered.

Can I Attend a Demo Session before Enrolment?

Answer: If you have seen any of our sample class recordings, you don\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'t need to look further. Enrollment is a commitment between you and us where you promise to be a good learner and we promise to provide you the best ecosystem possible for learning. Our sessions are a significant part of your learning, standing on the pillars of learned and helpful instructors, dedicated Personal Learning Managers and interactions with your peers. So experience complete learning instead of a demo session. In any case, you are covered by Edureka Guarantee, our No questions asked, 100% refund policy.

Why take online course? How is it better than offline course?

Answer: Learning pedagogy has evolved with the advent of technology over the years. Online training adds convenience and quality to the training module. With our 24x7 support system, our online learners will have someone to help them all the time even after the class ends. This is one of the driving factors to make sure that people achieve their end learning objective. We also provide life-time access of our updated course material to all our learners.

Who are the instructors?

Answer: All the instructors at CertAdda are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by edureka for providing an awesome learning experience to the participants.

What if I have more queries?

Answer: You can give us a CALL at +91 8178510474 / +91 9967920486 OR email at