Data Warehouse Concepts | Data Warehouse Tutorial | Data Warehouse Architecture | Edureka

This tutorial on data warehouse concepts will tell you everything you need to know in performing data warehousing and business intelligence. The various data warehouse concepts explained in this video are:

1. What Is Data Warehousing?
2. Data Warehousing Concepts:
3. OLAP (On-Line Analytical Processing)
4. Types Of OLAP Cubes
5. Dimensions, Facts & Measures
6. Data Warehouse Schema

- - - - - - - - - - - - - -

#DataWarehousing #DataWarehouseTutorial #DataWarehouseTraining #DataWarehouseConcepts

Subscribe to our channel to get video updates. Hit the subscribe button above.

- - - - - - - - - - - - - -

How it Works?

1. This is a 5 Week Instructor led Online Course, 25 hours of assignment and 10 hours of project work
2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
3. At the end of the training you will have to undergo a 2-hour LIVE Practical Exam based on which we will provide you a Grade and a Verifiable Certificate!

- - - - - - - - - - - - - -

About the Course:

Edureka's Data Warehousing and Business Intelligence Course, will introduce participants to create and work with leading ETL & BI tools like:
1. Talend 5.x to create, execute, monitor and schedule ETL processes. It will cover concepts around Data Replication, Migration and Integration Operations
2. Tableau 9.x for data visualization to see how easy and reliable data visualization can become for representation with dashboards
3. Data Modeling tool ERwin r9 to create a Data Warehouse or Data Mart

- - - - - - - - - - - - - -

Who should go for this course?

The following professionals can go for this course:
1. Data warehousing enthusiasts
2. Analytics Managers
3. Data Modelers
4. ETL Developers and BI Developers

- - - - - - - - - - - - - -

Why learn Data Warehousing and Business Intelligence?

All the successful companies have been investing large sums of money in business intelligence and data warehousing tools and technologies. Up-to-date, accurate and integrated information about their supply chain, products and customers are critical for their success.

With the advent of Mobile, Social and Cloud platform, today's business intelligence tools have evolved and can be categorized into five areas, including databases, extraction transformation and load (ETL) tools, data quality tools, reporting tools and statistical analysis tools. This course will provide a strong foundation around Data Warehousing and Business Intelligence fundamentals and sophisticated tools like Talend, Tableau and ERwin.

- - - - - - - - - - - - - -

- - - - - - - - - - - - - -

Customer Review:

Kanishk says, "Underwent Mastering in DW-BI Course. The training material and trainer are up to the mark to get yourself acquainted to the new technology. Very helpful support service from Edureka."

[Kashyap_y]

This 52 mins video is better than my whole semester. Thankyou so much!

[vincentmalinga]

Man, you are genius at this. I think now i'm ready for my exams. All thanks to you man

[udayradhe]

So well explained the whole concept of Datawarehousing in one 50 mins session. Highly recommend this. Thank you!

[aksharasri]

Hi Vardhan, Thank you so much for the detailed explanation. It really helps to understand basics. And, the explanation was clear. I have a 2 doubts.

1. What is aggregate date in DWH?
2. In Galaxy schema (49:52), Fact Table Product doesn't have a measure. Can we have a Fact Table without measure?

Thanks in Advance 👍🏻

[deepikaupadhyay]

One of the best-explained videos on Edureka 👍 Edureka needs more mentors like Verdhan sir!

[feloxatheeman]

I wasn't aware this channel gives such a higher quality tutorial. I am finally here and forever.

[lekkalaakhila]

Your teaching skills was amazing bro and I understand easily about data warehousing and I thank to u

[destinyamanze]

This video was really simple and easy to understand. Great work, thank you so much.

[thulasibalaji]

wonderful totally worth watching. Done justice for the time spent

[subsins]

Just amazing
..
very nice explaination..

[kcdeleon]

I love this tutorial about data warehouse. It only took a matter of 52 minutes to understand the concepts. Thank you so much! I've already subscribe to gain more any topics beneficial to me. Keep up the good work!

[sanjayMishra-vsum]

Great Tutorial! Thank you for creating this mind-blowing tutorial. One thing that I would suggest here is to include some use cases specifically for types of OLAP.

[saikiranp.r]

Hands down, the best video about Data warehousing. Great work.

[naushadveepee]

Fabulous, no other word to say, you made really life easy!!!

[haripapisetty]

Very good explanation, especially schemas

[JobQuestUnveiled]

Thank you for your time. Could you also please explain "point in time" concept?

[Nacholibb]

Thank you so much sir...your explaination was really awesome and understandable💕💕💕💕

[madhulika]

this lecture helped me a lot in my exam. Thanks

[vochau]

where can I find the link of practice? I need to practice how to load data to Data warehouse

[poonamkalamkar]

Awesome Video👍 I came here last minute before exam it covered everything Great video