***** 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 [email protected] 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
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 šš»
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?
What is the measure in the 2nd fact table(i.e Product) of galaxy schema?
This is really well explained. I am grateful for it. Thanks for the great work
really helpfulšš
Amazing explaination
Can I get this pdf
Really interactive and informative tutorial. Thank you so much.Well explained
I wasn't aware this channel gives such a higher quality tutorial. I am finally here and forever.
Great video
this lecture helped me a lot in my exam. Thanks
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!
Supperbbb explanation brother.many thanks
comprehensive, good diagram and explanation, recommend
Worth watching! Thank you for your efforts.
Thank you!
Nice explanation !!
Thanks a lot for this great video š
Excellant
Thanks a lotā¤ļø