HomeОбразованиеRelated VideosMore From: edureka!

Data Warehouse Tutorial For Beginners | Data Warehouse Concepts | Data Warehousing | Edureka

1338 ratings | 177933 views
***** Data Warehousing & BI Training: https://www.edureka.co/data-warehousing-and-bi ***** This Data Warehouse Tutorial For Beginners will give you an introduction to data warehousing and business intelligence. You will be able to understand basic data warehouse concepts with examples. The following topics have been covered in this tutorial: 1. What Is The Need For BI? 2. What Is Data Warehousing? 3. Key Terminologies Related To DWH Architecture: a. OLTP Vs OLAP b. ETL c. Data Mart d. Metadata 4. DWH Architecture 5. Demo: Creating A DWH - - - - - - - - - - - - - - Check our complete Data Warehousing & Business Intelligence playlist here: https://goo.gl/DZEuZt. #DataWarehousing #DataWarehouseTutorial #DataWarehouseTraining 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. - - - - - - - - - - - - - - Please write back to us at [email protected] or call us at +91 90660 20866 for more information. 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."
Html code for embedding videos on your blog
Text Comments (89)
edureka! (5 months ago)
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Data Warehousing Training and Certification, Call us at US: +18336900808 (Toll Free) or India: +918861301699 Or, write back to us at [email protected]
Mrunal Kadam (28 days ago)
One of the best video. Thank you!
edureka! (25 days ago)
Hey Mrunal, we are glad you loved this video. Do subscribe and hit the bell icon to never miss an update from us in the future. Cheers!
MultiSpiros123 (1 month ago)
thank you very much
pranav nanda (1 month ago)
Thank you so much!!
ashwini kolvekar (2 months ago)
Very precisely explained! Very helpful.
edureka! (2 months ago)
Hey Ashwini, thanks for the compliment. We are glad you loved the video. Do browse through our other videos. Cheers! :)
shiva krishna (2 months ago)
very nice information... thanks for the video...
edureka! (2 months ago)
Hey Shiva, glad you liked the video. Do subscribe and hit the bell icon to never miss an update from us in the future. Cheers!
Munir Khamis (2 months ago)
Greate!
Fatima Hussain (2 months ago)
Great
Ali Hasnain (2 months ago)
I appreciate your video man, outstanding explaination. Thank you
Prema k (3 months ago)
Hi edureka awesome job. Please can u upload videos of hadoop developer too. Thanks in advance
edureka! (3 months ago)
Hi Prema, thank you for the wonderful feedback! We're glad we could be of help. Here is the complete playlist on Big Data and Hadoop: https://goo.gl/ieazNh You can also check out our complete course on Big Data and Hadoop: https://goo.gl/7WH4pW Do subscribe to our channel to stay posted on upcoming tutorials. Cheers!
Manoj Kularatne (3 months ago)
thats good
Manish Sawant (3 months ago)
Best video on DWH so far
Shihab Alayan (3 months ago)
Good one..
edureka! (3 months ago)
Hey Shihab, thank you for watching our video. We are glad to know that you liked our tutorial. Do subscribe and stay connected with us. Cheers :)
Mohammed Faramawy (4 months ago)
Excellent , thanks
edureka! (4 months ago)
Hey Muhammad, thank you for watching our video. We are glad to know that you liked our tutorial. Do subscribe and stay connected with us. Cheers :)
aris kritikos (5 months ago)
Indeed a great video to get introduced into data warehousing & BI! Thank you! Keep up the good work!
edureka! (4 months ago)
Hey Aris, thank you for the appreciation. We are glad that you liked our course. Do subscribe and stay connected with us. Cheers :)
JW (6 months ago)
This is one of the best free training videos I ever seen. Many thanks! very informative and clear!!
edureka! (6 months ago)
Hey JW, thanks! It's great to know that our efforts are being appreciated. We will strive harder to create more such content in the future. Hoping to see you learning from our channel again. Cheers :)
r sun (6 months ago)
how is this a beginner tutorial when you don't even explain anything when you are going thru demo?
edureka! (6 months ago)
Hey R sun, if you are looking to start right from scratch, then check out this playlist: https://bit.ly/2rhXN7A Hope this helps :)
VKC N (6 months ago)
Love it...Thanks
edureka! (6 months ago)
Thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
VKC N (6 months ago)
Love it...Thanks
Ashis Barai (7 months ago)
Hi, Thanks for your wonderful explanation. Would you please give me access to the excel files?
edureka! (7 months ago)
Hey Ashis, you can mentio your email address and we will send it over. Cheers :)
monir zaman (7 months ago)
Hi, Thanks a lot for this great tutorials. Do you mind to share the datasets used in this tutorial?
anusha bairishetty (7 months ago)
Thanks a lot.. i have understood very well.. all my doubts are cleared.. thank u soo much..
edureka! (7 months ago)
Hey Anusha, thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
karishma shrestha (8 months ago)
lucid explaination :) bt the problem is .. when i put query in oraclesql developer my items are not showing ? ? why? i created table in database ? but aftr talend connection,i cant view my items in oracle database ?pls reply soon
edureka! (6 months ago)
Hey Karishma, can you please check the database you are connecting from Talend. It may be because you are connecting to some other database through Talend. If the problem persists, please elaborate you question, so that we can provide you with a better solution. Hope this helps :)
Rajat Rohila (9 months ago)
nice explanation sir keep it up
Bryan Oliver Cliff Siyam (9 months ago)
Hey Up to 1:17:50 you have not mapped DB columns names in your Talend DBInput, but yet when you run it does fetch data into your tlogrow... how does it recognise or distinguish the columns ? Given that they are all varchar2 and not identified by name.
edureka! (8 months ago)
Yes, because Metadata connection has been used for DbInput. With metadata, you define the streams once, and it can be used for connecting to multiple tLogRows. Please seek to 1:12:35 to understand how I have configured Metadata configuration to DbInput. Hope this helps :)
Balaji Vangala (9 months ago)
Great video,1 doubt though, u said ,data wud be moved to staging area where etl wud be performed and the master data wud be moved to edw. In the demo eg, wud the process of importing 2 tables be performed on staging db and wud tjoin table be on edw ?
edureka! (8 months ago)
<!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}-->Yes, data is imported from the database and it is imported onto the DWH. In our case, it is Talend ETL tool. Hope this helps :)
ANCY T (9 months ago)
Thank you Vardhan Sir. Tutorial is very informative and demo is very nice. Please share the ppts and excel file to practice
edureka! (9 months ago)
Thank you, Ancy! You can check out our ppts at slideshare.net Hope this helps :)
Neeraj iyer (9 months ago)
Truly Awesome explanation...Perfect...
edureka! (9 months ago)
Hey Neeraj, thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
Clear explanation... very audible and sound knowledge on the subject taken
edureka! (9 months ago)
Thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
Pabitra Kumar Tripathy (9 months ago)
Thanks a lot........... Vardhan, this one session cleared all my doubt regarding datawarehouse
edureka! (9 months ago)
Hey Prabitra, we are glad to have helped. Thank you for watching our video. Do subscribe and stay tuned to all our updates. Cheers :)
Mayur Hajare (11 months ago)
Great explanation for every small concept thanks
edureka! (10 months ago)
Hey Mayur! Thank you for watching our videos and appreciating our work. Do subscribe to our channel and stay connected with us. Cheers :)
SATHYA MANIKANTA (1 year ago)
Thank you vardhan sir for this wonderful explanation.Hope you do these kind of videos more in the future and help people out there.
edureka! (1 year ago)
Hey Sathya! We do update our channel very often. Subscribe and stay connected with us. Thanks :)
Md Sayfur Rahman (1 year ago)
Hi, how can I have access to the excel files? I would like to follow the practical part of the class. Can you please provide a link for me to down the excel files please? Great tutorial bdw!
edureka! (1 year ago)
Hey Sayfur! Drop down your email ID and we'll share it with you. We are happy to know you liked our tutorial. Share, like and subscribe to remain connected with us. Thanks :)
Bhavishya Karan (1 year ago)
Thanks for uploading. Do you have a slide deck available for this video?
Varun Vikram (1 year ago)
I couldn't stop myself from commenting. Awesome explanation Mr. Vardhan! Everything is crystal clear. Thank you so much!
edureka! (1 year ago)
Thank you fr your kind words, Varun! Keep learning by watching out videos. Subscribe, like and share. Cheers :)
Saidanaik Banothu (1 year ago)
Thanks a lot bro!!
Sam Chan (1 year ago)
Hi, this is awesome, I am wondering where I can find the presentations?
edureka! (1 year ago)
Hey Sam, thanks for checking out our tutorial! Here are the slides for this video: https://www.slideshare.net/EdurekaIN/data-warehouse-tutorial-for-beginners-data-warehouse-concepts-data-warehousing-edureka Hope this helps. Cheers!
fahad pirzada (1 year ago)
If slides of above lectures are aviable then it will will great . Can someone send me slides of these lectures
edureka! (1 year ago)
Hi Fahad, thanks for watching our tutorial! Here are the slides of this video: https://www.slideshare.net/EdurekaIN/data-warehouse-tutorial-for-beginners-data-warehouse-concepts-data-warehousing-edureka Hope this helps. Cheers!
Pushpanjali S (1 year ago)
Great session .. Thank you
Dinesh Kumar (1 year ago)
Thanks a lot.....!!!!!!! Eventually came to know what the DWH is all about.
krishna budholiya (1 year ago)
I want to training in ur company...tell me procedure
edureka! (1 year ago)
Hey Krishna, thanks for checking out our tutorial and for your interest in our course. You can check out our course details, curriculum, and register for our course here: https://www.edureka.co/data-warehousing-and-bi. This live, online course is led by instructors who are industry practitioners and comes with 24x7 support and lifetime access to learning material. Please feel free to get in touch with us if you have any questions or concerns. We're available at +91 90660 20867 anytime. Hope this helps. Cheers!
JAYANT AGARWAL (1 year ago)
Single video which clarifies all my basic doubts on data ware house.. Many thanks !!
edureka! (1 year ago)
Hey Jayant, thanks for the wonderful feedback! We're glad we could be of help. You can also check out our complete training here: https://www.edureka.co/data-warehousing-and-bi. Do subscribe to our channel to stay posted on upcoming tutorials. Hope this helps. Cheers!
afsar ali (1 year ago)
Nice video ..thanks ...could you please give the same demo using informatica ?
edureka! (1 year ago)
Hey Afsar Ali, thanks for checking out our tutorial. You can check out our Informatica tutorials and demos here: https://www.youtube.com/playlist?list=PL9ooVrP1hQOHQotG5nDJ1LjXiUDIgkeov. Hope this helps. Cheers!
nice information keep it up..
Chinna Sankar (1 year ago)
Very nice
kirti rana (1 year ago)
informative
Sugandha Dogra (1 year ago)
Speed - 0.75 and go >> ! :)
edureka! (1 year ago)
Hey Sugandha, whatever rocks your boat. :) Thanks for checking out our tutorial. Do subscribe to our channel to stay posted on upcoming videos. Cheers!
pinak pani nath (1 year ago)
Hi, nice explanation
himadri acharya (1 year ago)
Great explanation!
Alka Shriram (1 year ago)
Can you please elaborate the point of DWH being subject-oriented?
edureka! (1 year ago)
Hey Alka, thanks for checking out our tutorial. When we say a DWH is subject-oriented, it means that the data accessed from the DWH will answer the business problems which are posed (they answer subject-oriented queries). However, the data stored in the Database cannot answer business problems as they are only a representation of the on-going business processes. Hope this helps. Do follow our channel to stay posted on upcoming tutorials. Cheers!
Arben Gjolaj (1 year ago)
Thank You, Sir!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.