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

🔥 Data Warehousing & BI Training (𝐔𝐬𝐞 𝐂𝐨𝐝𝐞: 𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎): www.edureka.co/search
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: goo.gl/DZEuZt.
#DataWarehousing #DataWarehouseTutorial #DataWarehouseTraining
🔴 𝐋𝐞𝐚𝐫𝐧 𝐓𝐫𝐞𝐧𝐝𝐢𝐧𝐠 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐅𝐨𝐫 𝐅𝐫𝐞𝐞! 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐄𝐝𝐮𝐫𝐞𝐤𝐚 𝐘𝐨𝐮𝐓𝐮𝐛𝐞 𝐂𝐡𝐚𝐧𝐧𝐞𝐥: edrk.in/DKQQ4Py
- - - - - - - - - - - - - -
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.
- - - - - - - - - - - - - -
For more information, please write back to us at [e-mail] or call us at IND: 9606058406 / US: 18338555775 (toll-free).
Facebook: / edurekain
Twitter: / edurekain
LinkedIn: / 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."

[@edurekaIN]

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, please write back to us at [e-mail] or call us at IND: 9606058406 / US: 18338555775 (toll-free).

[@mayuribirari8655]

It was great session sir!! My only query is whether all the sources must be related to each other or let me put it this way,should they have atleast a column in common?

[@edurekaIN]

Hey Mayuri, yes there must be in one linking column.

[@wladamacaa]

good, thanks .. (with speed 0.75x) o_O

[@user-nm1le8ro6e]

I think this is the most simple video which explains all basics about data warehouse. Thank you so much. Learned a lot from this single video!

[@jayantagarwal6339]

Single video which clarifies all my basic doubts on data ware house.. Many thanks !!

[@edurekaIN]

Hey Jayant, thanks for the wonderful feedback! We're glad we could be of help. You can also check out our complete training here: www.edureka.co/data-warehousing-and-bi. Do subscribe to our channel to stay posted on upcoming tutorials. Hope this helps. Cheers!

[@ADITYA1234588]

This was the best video to get the concepts crystal clear. Thanks a lot. It was very helpful.

[@DineshKumar-es4fr]

Thanks a lot.....!!!!!!! Eventually came to know what the DWH is all about.

[@jw4268]

This is one of the best free training videos I ever seen. Many thanks! very informative and clear!!

[@edurekaIN]

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 :)

[@chamelion100]

Best video on DWH so far

[@agj03921]

Thank You, Sir!

[@NyxView]

This is the best tutorial to get the concepts crystal clear with meaningful slides. Thanks for the sharing and expected more tutorials from you. Fantastic

[@ballistic188]

Probably the best organized channel I’ve come across on IT concepts and practical knowledge. Thanks a lot!

[@edurekaIN]

Thanks for the compliment, Singh! We are delighted to know you feel this way about our channel. Do subscribe to the channel and hit the bell icon to never miss an update from us in the future. Cheers!

[@paulyndeguzman1613]

Thank you Sir for a very clear explanation!

[@mramireddy5154]

Probably the best content DWH video that I have ever watched

[@saidanaikbanothu9767]

Thanks a lot bro!!

[@aitemiryeskenov355]

Great overview! Very interesting and well-explained.

[@nikhilmoolwani9323]

The best informative video I have came across in my whole life. Thank you so much :)

[@arehman3304]

You are a lifesaver, Thank you Edureka!

[@karthikbk4812]

Just 1 word Woww.... Superb Explanation 👌

[@ravisoma6918]

Excellent teaching, very good teacher

[@himadriacharya8796]

Great explanation!

[@chetanraj1950]

Hey Vardhan, Millions of thanks to you. It was very much informative.

[@monirzaman337]

Hi, Thanks a lot for this great tutorials. Do you mind to share the datasets used in this tutorial?

[@sathyamanikanta2784]

Thank you vardhan sir for this wonderful explanation.Hope you do these kind of videos more in the future and help people out there.

[@edurekaIN]

Hey Sathya! We do update our channel very often. Subscribe and stay connected with us. Thanks :)

[@subsins1063]

Amazing lecture...u made the concept so easy

[@Marius-vw9hp]

Rodney is pumped up for the demonstration LOL :)

[@babybitch403]

Thank you so much!!

[@bansarioza3169]

Very well explanation.Thanx for the sharing.

[@joshuaharvey9271]

Great video, thank you!

[@jituturkar9472]

Awesome explanation sir,..I got so much interest in watching this session..

[@nimeshambalalpatel3032]

extremely nice, organised and crystal clear content delivered by helpful instructor of world class youtube channel of my loving country India.

[@vkcn1399]

Love it...Thanks

[@neeraji6414]

Truly Awesome explanation...Perfect...

[@edurekaIN]

Hey Neeraj, thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)

[@varunvikram5818]

I couldn't stop myself from commenting. Awesome explanation Mr. Vardhan! Everything is crystal clear. Thank you so much!

[@edurekaIN]

Thank you fr your kind words, Varun! Keep learning by watching out videos. Subscribe, like and share. Cheers :)

[@anushabairishetty2863]

Thanks a lot.. i have understood very well.. all my doubts are cleared.. thank u soo much..

[@edurekaIN]

Hey Anusha, thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)

[@saurabhjain2005]

Very easy to understand language not using technical jargons difficult to follow, thank you so much

[@Redxtudio]

It's Amazing Good

[@kugandayalan7501]

Fantastic Explanation. Full clarity. Great Job. Thank you very much for the help.

[@edurekaIN]

Thanks for the compliment, Kugan! We are glad you loved the video. Do subscribe to the channel and hit the bell icon to never miss an update from us in the future. Cheers!

[@mayurhajare1596]

Great explanation for every small concept thanks

[@edurekaIN]

Hey Mayur! Thank you for watching our videos and appreciating our work. Do subscribe to our channel and stay connected with us. Cheers :)

[@shivtripathi2084]

Best video on data warehousing. Keep it up guys!

[@pinakpaninath4321]

Hi, nice explanation

[@MultiSpiros123]

thank you very much

[@monktyson2793]

👌Love your videos.

[@nidiasahjara2721]

Great video, explains the technologies very well and he also teaches relevant useful points.

[@edurekaIN]

Thank you for appreciating our efforts. Do subscribe to our channel and stay connected with us. Cheers :)

[@kittiperry1]

informative

[@roniovino2624]

Great video that provides an overall introduction to BI and data warehousing.

[@edurekaIN]

Thank you for appreciating our efforts. We are glad that you liked our tutorials. Do subscribe to the channel and hit the bell icon to never miss an update from us in the future. Cheers!

[@rajatrohila2589]

nice explanation sir keep it up

[@mrunalkadam886]

One of the best video. Thank you!

[@edurekaIN]

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!

[@mohdshahrukh3036]

Sukriya... It's very Helpful..

[@almusahratirestaurant421]

great one, thanks

[@muhammadyaseenmengal4322]

nice information keep it up..

[@saeedmohajeryami5060]

Amazing! This is my most favorite Edureka video so far.

[@edurekaIN]

Thanks for the compliment! We are glad you loved the video. You can also check out our online certification training here: Data Warehousing and BI Certification Training - bit.ly/2BUdg5P You can use code "KZbin20" and enroll in our courses with Flat 20% off.

[@fatimahussain9004]

Great

[@satvindersinghrana]

Excellent Work Kudos:)

[@prasanthalpha]

A really informative video. Thank you Vardhan.

[@idlewild]

You are doing the needful!

[@munirkhamis]

Greate!

[@sunying6340]

great video！！！ clear，cut-through，simple absolutely useful for beginners!!!

[@edurekaIN]

We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@bhavishyakaran5733]

Thanks for uploading. Do you have a slide deck available for this video?

[@seyitkurt7319]

thanks for this video. i was searching for datawarehousing data implementation however i couldn't find anywhere. i found only descriptions and techniques but here you made a demonstration and it became very helpful and beneficial.

[@edurekaIN]

Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update

[@alicefan3711]

you are excellent! you help me a lot. it is so organized! Thanks so much!

[@edurekaIN]

You're welcome 😊 Glad it was helpful !! Keep learning with us ..

[@ashwinikolvekar4088]

Very precisely explained! Very helpful.

[@edurekaIN]

Hey Ashwini, thanks for the compliment. We are glad you loved the video. Do browse through our other videos. Cheers! :)

[@irfanfiis253]

Thanks for explaining in simpler way. Very useful 👍

[@edurekaIN]

Glad it was helpful!

[@sushantmaji5613]

excellent man... you are amazing

[@TheAshy1212]

Clear explanation... very audible and sound knowledge on the subject taken

[@edurekaIN]

Thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)

[@rupakkumar7760]

It was nice training, interactive video where I didnot sleep. Many thanks! very vivid informative and crystal clear lecture!!

[@edurekaIN]

Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@ashivishwakarma3985]

got a crystal clear knowledge which was very helpful, thanks

[@edurekaIN]

You are welcome👍 You can also check out our complete training here: Data Warehousing and BI Certification Training - bit.ly/2BUdg5P Use code "KZbin20" to get Flat 20% off on this training.

[@NeerajSingh-wo4tx]

Very useful!

[@aliabbottonian]

I appreciate your video man, outstanding explaination. Thank you

[@fiveotwoinmp4]

Thank you sir!

[@thirdumpire6235]

thankyou sir for sharing your knowledge

[@MFaramawy]

Excellent , thanks

[@edurekaIN]

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 :)

[@keerthikakj191]

awesome explanation. thank you

[@synthmania7275]

Very nicely done!

[@chinnasankar2813]

Very nice

[@BillusTinnus]

This lecturer sounds like a lot of fun. Great video!

[@edurekaIN]

Glad you liked it!!!

[@preetiravan4783]

Awesome training session I have ever seen.. Each and every basic concepts clearly explained and hands on session is also well explained.. thanku for this session

[@edurekaIN]

We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !

[@byrondelgado8165]

Thanks!!

[@papachoudhary5482]

Thanks! Sir Kindly more videos

[@varaprasadm4514]

Awesome explanation sir, i have very much interested to watch you sessions. and Really its very helpful session to who are Beginners .might be the session is very long but , those who are confusing with a little bit doubts on Dara ware House concepts . once watched it they should get full clarification. Anyway thanks a lot...…

[@edurekaIN]

Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)

[@Flivgh]

greatly appreciate your explanation and demonstration- Good job

[@edurekaIN]

Thank you 😊 Glad it was helpful! Keep learning with us...

[@pabitrakumartripathy5000]

Thanks a lot........... Vardhan, this one session cleared all my doubt regarding datawarehouse

[@edurekaIN]

Hey Prabitra, we are glad to have helped. Thank you for watching our video. Do subscribe and stay tuned to all our updates. Cheers :)

[@sujithkumarjack]

Great info..👌👍

[@sgrhr024]

awesome video buddy....cam late across this videi but still helped in lot of areas...Thanks

[@edurekaIN]

Thanks for the compliment! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.

[@techwithbasil]

Very useful. Thank you. Content was well explained

[@edurekaIN]

Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)

[@manojkularatne6647]

thats good

[@sandipdigambarnarwade284]

Thank you sir

[@rohan8758]

Superb edureka for this video, i will score good marks in my end sem exam

[@edurekaIN]

You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@afsarali92]

Nice video ..thanks ...could you please give the same demo using informatica ?

[@edurekaIN]

Hey Afsar Ali, thanks for checking out our tutorial. You can check out our Informatica tutorials and demos here: kzbin.info/aero/PL9ooVrP1hQOHQotG5nDJ1LjXiUDIgkeov. Hope this helps. Cheers!

[@123canalis]

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 ?

[@edurekaIN]

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 :)

[@hasibulhayat9572]

Amazing lecture. Can we get the slide used in this video? It will be very helpful if we can.

[@FF-bp9bj]

very nice information... thanks for the video...

[@edurekaIN]

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!

[@saipavan4377]

if possible could you please make a tutorial on SQL queries ? if it is already posted, then please share the link that means a lot for me. thank you for the wonderful session ;-)

[@edurekaIN]

Check out our SQL Full Course: kzbin.info/www/bejne/eIGrcqVqhqx6jKc

[@asfandyarahmad7109]

I have a question sir As you mention that we are not going to add new operational data to our DWH ... Then how the KZbin and amazon make suggestion to use when we see or purchase something Please explain this ..... Thanks 🙂

[@nitishbisht8950]

thanks for the video

[@samchan2535]

Hi, this is awesome, I am wondering where I can find the presentations?

[@edurekaIN]

Hey Sam, thanks for checking out our tutorial! Here are the slides for this video: www.slideshare.net/EdurekaIN/data-warehouse-tutorial-for-beginners-data-warehouse-concepts-data-warehousing-edureka Hope this helps. Cheers!

[@KalyanS]

Super sir

[@user-xd1od8kx8h]

This video is so helpful for my career

[@edurekaIN]

Glad to hear

[@hemarajani2711]

Thanks for tutorial👍

[@riyapriya]

sir. it' s great session. could you please give solution for designing the warehouse tool. which is best

[@zhouxinxin3861]

thanks