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

20 Comments



***** Data Warehousing & BI Training: https://www.edureka.co/data-warehousing-and-bi *****
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

– – – – – – – – – – – – – –

Check our complete Data Warehousing & Business Inelligence playlist here: https://goo.gl/DZEuZt.

#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 24×7 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.

– – – – – – – – – – – – – –

For more information, please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll-free).

Facebook: https://www.facebook.com/edurekaIN/
Twitter: https://twitter.com/edurekain
LinkedIn: https://www.linkedin.com/company/edureka

– – – – – – – – – – – – – –

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.”

source

20 Comments
    • blank
      Akshara Sri
      May 06, 2022 15:10 pm Reply

      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 👍🏻

    • blank
      sathyam siddhu
      May 06, 2022 15:10 pm Reply

      How to Handle hierarchical kinds of data like Parent, Child & Flat Data in ETL Work Load in Data WareHouse. As there is no need for a parent-child relationship in data WareHouse in such cases How can we handle such Data in Data warehouse House…?

      2) How to do Data Processing with Late Arriving Dimensions?

    • blank
      Shubham Rathi
      May 06, 2022 15:10 pm Reply

      What is the measure in the 2nd fact table(i.e Product) of galaxy schema?

    • blank
      Singireddy CHAITANYA REDDY
      May 06, 2022 15:10 pm Reply

      This is really well explained. I am grateful for it. Thanks for the great work

    • blank
      Lella Jagadeeswar
      May 06, 2022 15:10 pm Reply

      really helpful🙂🙂

    • blank
      Anvay Nikam
      May 06, 2022 15:10 pm Reply

      Amazing explaination

    • blank
      Sumit Kumar
      May 06, 2022 15:10 pm Reply

      Can I get this pdf

    • blank
      Mayuri Shimpi
      May 06, 2022 15:10 pm Reply

      Really interactive and informative tutorial. Thank you so much.Well explained

    • blank
      Feloxa “Thee man”
      May 06, 2022 15:10 pm Reply

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

    • blank
      wamiquesarwar
      May 06, 2022 15:10 pm Reply

      Great video

    • blank
      Madhulika Tomar
      May 06, 2022 15:10 pm Reply

      this lecture helped me a lot in my exam. Thanks

    • blank
      KC de Leon
      May 06, 2022 15:10 pm Reply

      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!

    • blank
      syed naheed
      May 06, 2022 15:10 pm Reply

      Supperbbb explanation brother.many thanks

    • blank
      sands7779
      May 06, 2022 15:10 pm Reply

      comprehensive, good diagram and explanation, recommend

    • blank
      Gaurav Mulik
      May 06, 2022 15:10 pm Reply

      Worth watching! Thank you for your efforts.

    • blank
      Becaye Baldé
      May 06, 2022 15:10 pm Reply

      Thank you!

    • blank
      Raman Nanda
      May 06, 2022 15:10 pm Reply

      Nice explanation !!

    • blank
      Amarnath Baranwal
      May 06, 2022 15:10 pm Reply

      Thanks a lot for this great video 🙂

    • blank
      Jayasri -FT
      May 06, 2022 15:10 pm Reply

      Excellant

    • blank
      Ravindu Mihiranga
      May 06, 2022 15:10 pm Reply

      Thanks a lot❤️

Leave us a comment