Thanks for applying for scholarship test.
Our career counsellor will inform you soon regarding the test details.
A Self-Paced course designed to give you a head start into Data warehousing and train you on different concepts of Data warehousing along with the implementations of these concepts.
Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You'll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.
Learn Data Warehousing and ETL Live Online from top industry professionals
Interactions with an Live Expert, get your doubts cleared in Real Time.
Access to World Class Instructors, from anywhere
Your guide from Edureka, to ensure you achieve your learning goals.
Live course assures 6 times more probability of getting certified
Learning Objectives - Discussing
about the basic concepts of a data warehouse and why it is needed.
Difference between an operational system and an analytical system,
Datamarts. Approaches to build a data warehouse.
1. What is a data warehouse? - Definition and explanation of the four terms - subject oriented, integrated, non volatile and time variant
5. ODS - Operational Data Store - Definition and explanation of 4 terms - Subject oriented, Integrated, Current, Volatile, Detailed6. Benefits of ODS 7. Design approach - Top down approach, bottom up approach, Federated
Learning Objectives - Learning
what a dimension and a fact is, the different types of dimensions
and facts. Reporting concept of Hierarchy.
1. Dimensions and facts - What are dimensions and facts?
Learning Objectives - Organizing
data in multiple tables. Understanding normalization and its
different forms. Learning what is a schema and the different types
of schemas along with meta data.
Learning Objectives -
Understanding principles of requirement gathering to build
a warehouse and dimensional modeling.
1. Requirement gathering
2. Principles of dimensional modelling
3. Modeling - ER diagrams
Learning Objectives -
Understanding where will the data come from and how will the data
come and Populating the warehouse.Learning concepts of Extracting
data, Transforming data and Loading the data into different
1. ETL Concept - Architectural components - like Source, Staging, Atomic, Dimension
2. Transformation - Data Validation, Data Accuracy, Data Type Conversion, Business Rule Application
3. Data Loading techniques.
Learning Objectives -
Implementing a data warehouse Project.
Topics - Discuss a project, its problem statement, probable solutions, and implement one solution.
This Data warehousing course enables participants with concepts of Data warehousing like Facts, Schema, Metadata, Normalization, Data transformation, Dimensional Modeling and ETL Concepts.
1. Understand the concept and need of Data warehouse
2. Implement concepts of dimension and fact table
3. Implement data modelling, normalization and schema concepts 4. Model a Data warehouse
5. Implement ETL jobs
This course is a foundation to anyone who aspires to become a Data warehouse Architect, a Data warehouse Developer or a Data warehouse Business Analyst in the field of Data warehousing and Business Intelligence. The following professionals can go for this course :
1. BI /ETL Professionals
2. Project Managers
3. Testing Professionals
4. Mainframe Professionals
5. Analytics Professionals
6. Software Developers and Architects
As we move from intuition based decision making to factual decision making, it is increasingly important to capture data and store it in a way that allows us to make smarter decisions. This is where Data warehouse comes into picture. There is a huge demand for Data warehousing professionals and this course acts as a foundation which opens the door to a variety of opportunities in Business Intelligence space.
Edureka is providing the best software training I have seen in my 10 years of IT career. I have been an Edureka student for over one year now. Having completed courses such as AWS Architect Certification Training, DevOps Certification Training and Hadoop Administration. I must say Edureka has excellent course content for some of the latest software technologies and is suplimented by well experienced trainers. I am impressed by all the trainers I came across with edureka. Also Edureka provides unique training platform where each live session of the course is recorded and this can be played back unlimited times by the student and has lifetime access to these recordings. This is great way to learn and stay ahead.
The unique combination of Online Classes with 24*7 On-Demand Support and class recordings/ppt/docs etc in Learning Management System (LMS) on the site made me fall in love with edureka! There could not be a better Android Training Avenue to quench my thirst for learning Android Development.
I have been subscribing to Edureka's courses for almost a year now, primarily related to Big Data and Data analytics. These courses have helped me to gain that competitive edge which is required at the job. Also, their courses cover a breadth of topics and range from computer programming languages like Java to Data Visualisation. There is also constant updation done on these courses, and you can talk to their support staff at any time for any assistance. I found the faculties very knowledgeable, and all the courses that I enrolled in were delivered in a very detailed and professional manner. For any person looking for online training, I can recommend Edureka without hesitation.
I was taking a course for Data Visualization with Tableau , and had wonderful experience with edureka, The instructors are well presentable and dedicated and have gone extra mile to provide the insights for the course. The instructor had done a great job to explain each and every feature with a real life example and provided hands on live examples during the sessions. Very well done edureka, I am willing to take some courses from you in near future and thanks you for making my learning experience knowledgeable and enjoyable. Definitely worth the effort and good value for money.
Very good courses covering lots of topics. Excellent class delivery and lecture notes. I really learnt a lot and will surely miss not having the classes any more. I will definitely keep in touch with edureka! and my instructor through LinkedIn and emails. I would also like to convey my special thanks to the edureka! support team for their prompt technical support that is available 24/7 and for their awesome Learning Management System (LMS) on the website with all the class recordings and the material.
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.