Video není dostupné.
Omlouváme se.
Data Warehouse Tutorial For Beginners | Data Warehouse Concepts | Data Warehousing | Edureka
Vložit
- čas přidán 5. 08. 2024
- 🔥 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 sales@edureka.co 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."
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 sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll-free).
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?
Hey Mayuri, yes there must be in one linking column.
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!
good, thanks .. (with speed 0.75x) o_O
Single video which clarifies all my basic doubts on data ware house.. Many thanks !!
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!
This was the best video to get the concepts crystal clear. Thanks a lot. It was very helpful.
Thanks a lot.....!!!!!!! Eventually came to know what the DWH is all about.
This is one of the best free training videos I ever seen. Many thanks! very informative and clear!!
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 :)
Probably the best organized channel I’ve come across on IT concepts and practical knowledge. Thanks a lot!
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!
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
Best video on DWH so far
Hi, Thanks a lot for this great tutorials. Do you mind to share the datasets used in this tutorial?
The best informative video I have came across in my whole life. Thank you so much :)
Probably the best content DWH video that I have ever watched
I couldn't stop myself from commenting. Awesome explanation Mr. Vardhan! Everything is crystal clear. Thank you so much!
Thank you fr your kind words, Varun! Keep learning by watching out videos. Subscribe, like and share. Cheers :)
Great overview! Very interesting and well-explained.
extremely nice, organised and crystal clear content delivered by helpful instructor of world class youtube channel of my loving country India.
Thank you vardhan sir for this wonderful explanation.Hope you do these kind of videos more in the future and help people out there.
Hey Sathya! We do update our channel very often. Subscribe and stay connected with us. Thanks :)
Thank You, Sir!
Thank you Sir for a very clear explanation!
Hey Vardhan, Millions of thanks to you. It was very much informative.
Very easy to understand language not using technical jargons difficult to follow, thank you so much
Thanks a lot bro!!
You are a lifesaver, Thank you Edureka!
Fantastic Explanation. Full clarity. Great Job. Thank you very much for the help.
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!
Thanks a lot.. i have understood very well.. all my doubts are cleared.. thank u soo much..
Hey Anusha, thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
Great video, explains the technologies very well and he also teaches relevant useful points.
Thank you for appreciating our efforts. Do subscribe to our channel and stay connected with us. Cheers :)
Awesome explanation sir,..I got so much interest in watching this session..
Excellent teaching, very good teacher
Just 1 word Woww.... Superb Explanation 👌
Amazing lecture...u made the concept so easy
Thanks for uploading. Do you have a slide deck available for this video?
Great explanation!
Rodney is pumped up for the demonstration LOL :)
Great video that provides an overall introduction to BI and data warehousing.
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!
Very well explanation.Thanx for the sharing.
Love it...Thanks
Great explanation for every small concept thanks
Hey Mayur! Thank you for watching our videos and appreciating our work. Do subscribe to our channel and stay connected with us. Cheers :)
Great video, thank you!
Best video on data warehousing. Keep it up guys!
Truly Awesome explanation...Perfect...
Hey Neeraj, thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
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.
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
It's Amazing Good
Thank you so much!!
you are excellent! you help me a lot. it is so organized! Thanks so much!
You're welcome 😊 Glad it was helpful !! Keep learning with us ..
Hi, nice explanation
great video！！！ clear，cut-through，simple
absolutely useful for beginners!!!
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 : )
great one, thanks
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 ?
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 :)
Amazing! This is my most favorite Edureka video so far.
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 "CZcams20" and enroll in our courses with Flat 20% off.
nice explanation sir keep it up
Sukriya... It's very Helpful..
👌Love your videos.
It was nice training, interactive video where I didnot sleep. Many thanks! very vivid informative and crystal clear lecture!!
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 : )
One of the best video. Thank you!
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!
informative
You are doing the needful!
Superb edureka for this video, i will score good marks in my end sem exam
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 : )
nice information keep it up..
I have a question sir
As you mention that we are not going to add new operational data to our DWH ...
Then how the CZcams and amazon make suggestion to use when we see or purchase something
Please explain this .....
Thanks 🙂
This lecturer sounds like a lot of fun. Great video!
Glad you liked it!!!
A really informative video. Thank you Vardhan.
Thanks for explaining in simpler way. Very useful 👍
Glad it was helpful!
Greate!
Very precisely explained! Very helpful.
Hey Ashwini, thanks for the compliment. We are glad you loved the video. Do browse through our other videos. Cheers! :)
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.
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 :)
Clear explanation... very audible and sound knowledge on the subject taken
Thank you for watching our video. Do subscribe, like and share to stay connected with us. Cheers :)
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
;-)
Check out our SQL Full Course: czcams.com/video/BPHAr4QGGVE/video.html
got a crystal clear knowledge which was very helpful, thanks
You are welcome👍
You can also check out our complete training here:
Data Warehousing and BI Certification Training - bit.ly/2BUdg5P
Use code "CZcams20" to get Flat 20% off on this training.
Amazing lecture. Can we get the slide used in this video? It will be very helpful if we can.
Great
Nice video ..thanks ...could you please give the same demo using informatica ?
Hey Afsar Ali, thanks for checking out our tutorial.
You can check out our Informatica tutorials and demos here: czcams.com/play/PL9ooVrP1hQOHQotG5nDJ1LjXiUDIgkeov.html.
Hope this helps. Cheers!
excellent man... you are amazing
This video is so helpful for my career
Glad to hear
thank you very much
Excellent Work Kudos:)
Very useful!
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
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 !
Very nicely done!
Very nice
Excellent , thanks
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 :)
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...…
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:)
Hi, this is awesome, I am wondering where I can find the presentations?
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!
greatly appreciate your explanation and demonstration- Good job
Thank you 😊 Glad it was helpful! Keep learning with us...
Best course. I have cleared all concepts.
Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fulfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
what is the difference between getting solution from your approach and getting solution using SQL. You will get the same output by writting a SQL query by joining 2 tables and apply the condition. why we are following datawarehousing approach to answer this, when we can use sql and can get the same output. Thanks
Hi Ankush, the important fact is that a transactional database ( even with SQL joins) doesn't lend itself to analytics. To effectively perform analytics, you need a data warehouse. A data warehouse is a database of a different kind: an OLAP database.And that's where a data warehouse comes into play.
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
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 :)
awesome video buddy....cam late across this videi but still helped in lot of areas...Thanks
Thanks for the compliment! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.
Hi,
Thanks for your wonderful explanation. Would you please give me access to the excel files?
Hey Ashis, you can mentio your email address and we will send it over. Cheers :)
I appreciate your video man, outstanding explaination.
Thank you
awesome explanation. thank you
Thanks a lot........... Vardhan, this one session cleared all my doubt regarding datawarehouse
Hey Prabitra, we are glad to have helped. Thank you for watching our video. Do subscribe and stay tuned to all our updates. Cheers :)
Very useful. Thank you. Content was well explained
Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)
Thanks!!
sir. it' s great session. could you please give solution for designing the warehouse tool. which is best
Thank you sir!
Hi, thanks for this video. But I have 1 question. You have 8342 customers and 50000 transactions. Result of TJoins is 8342 rows. It means that you are grouping result based on cust_id so you have to use some aggregate functions (sum, count, min, ...) on columns from transaction table. Also in final result you have invoice_no from transaction table. But I don't see any definition of these aggregating. So where is my assumptions wrong ?
Hey Vaclav, That's because of the key-dependency and not aggregation. Hope this helps!
Great info..👌👍
Can you please elaborate the point of DWH being subject-oriented?
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!
thankyou sir for sharing your knowledge
very nice information...
thanks for the video...
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!