Thanks for applying for scholarship test.
Our career counsellor will inform you soon regarding the test details.
|Apr 04 th||
Course Price at
Can’t find a batch you were looking for?
Your details have been successfully submitted. Our learning consultants will get in touch with you shortly.
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.
Edureka’s Business Analyst with proficiency in DWH and BI Certificate Holders work at 1000s of companies like
Underwent Mastering in DW-BI Course. The training material and trainer are up to the mark to get urself acquainted to the new technology. Very helpful support service from Edureka.
I have been an Edureka!'s happy customer since 2013. I am a customer of Edureka enrolled for Big data developer, Hadoop Administration, AWS Architect Certification Training and PMP Exam Preparation course. I have received Outstanding support" from Edureka 24/7 team along with Sales/support team for all course. The trainers are excellent. Edureka LMS is very well organized and well structured. In LMS you will find each bit of information starting from installation, very good training materials, recording, interview blogs,assignments, quiz and much more supporting materials. It is wonderful online learning platform i have ever seen. Thanks to edureka and team to for such a quick and informative approach for queries which i had put to clear my doubts.Overall a 5 star i give for overwhelming satisfaction from course. Thanks for the wonderful learning experience!"
A total Hands Down!!! Teaching 5/5, Tech Support 5/5, Quality of education 5/5. This is by far 1 stop solution for your studies. I took Python course and was amazed by the teaching. Amazing teachers and course material. 24x7 support for even small queries now that's what I call a pure dedication. I love the whole edureka team. You just got a permanent customer Edureka. Thank you for all the small and big things you did for me. A special thanks to sales team for going out of the way to help me understand the course module and providing me with wonderful offers ;) Cheers:)
Definitely there is no doubt in saying that all the instructors at Edureka are industry experienced and the support staff provides a quick response to the tickets you log whether it be Day or Night. I like the way the sessions have been organized, with the Pre-requisites required for the next session and the assignments, QUIZ post session etc...I like the LMS a lot, You can find enough of required information in the forums. They even share the video recordings of other instructors as well in the LMS. So that if one couldn't get the content clearly in your session, you can always refer to other instructors recordings shared in your LMS. This part helped me in understanding few concepts in a better way.
Let me start of by congratulating the entire Edureka team for putting together such an amazing content for their courses. I am enrolled in their self paced and live batches courses and my learning experience has been phenomenal. I tried learning Linux Administration on my own but in every attempt i hit a dead end. However, I learned Linux Administration from the very best. The quality and experience of the instructor are excellent and this reflects in his high quality post lecture hands on projects and assignments. I must also take this opportunity to thank the support staff for prompt doubt solving via their student forums. I am a permanent member of theirs and will continue to learn from Edureka.
I would definitely like to give more than 5 stars to Edureka, i have been associated with more than two years from now, and i have never had any issue or any complains. Support staff is excellent and very professional, the amount of time they spend with each customer is really appreciated. Today I registered for the PMP training, and Mr Shyam from sales was extremely good to do the registration process. Keep up the good work , a very well organized and structured company I would say.
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.
Get a Glimpse of the course