2 - Data warehouse Architecture Overview

A quick video to understand standard Datawarehouse architecture. It consists of following layers
1. Data Source layer
2. ETL
3. Staging Area
4. Datawarehouse - Metadata, Summary and Raw Data
5. OLAP, Reporting and Data Mining
Data warehouse is populated from multiple sources for an organisation. All these source system comes under Data Source layer. Some of the source systems are listed below:
1. Operations Systems -- such as Sales, HR, Inventory relational database.
2. ERP (SAP) and CRM (SalesForce.com) Systems.
3. Web server logs and Internal market research data.
4. Third-party data - such as census data, demographics data, or survey data.
ETL Tools: Talend Open Studio, Jaspersoft ETL, Ab initio, Informatica, Datastage, Clover ETL, Pentaho ETL, Kettle
For more details visit www.vikramtakka...
Datawarehouse Playlist:
• Learn Data warehouse &...

[@NaijaPanorama]

This video is just too good. it actually helped me get some serious work done. thanks and God bless.

[@VikramTakkar]

+Abdullahi Goni Thanks Abdullahi

[@prav3nutube]

With all due respect .In some parts of the video session it is hard to listen or concentrate on the topic because of the back ground. Your voice is clear and pleasant Mr. Vikram. Thank for the tutorials.

[@VikramTakkar]

+Praveen Kumar Thanks for feedback. I will take care form next time onwards.

[@tejinder456]

Very Precise and up to the mark. Good Job

[@VikramTakkar]

+tejinder456 Thanks

[@ashuagarwal6407]

Good and elaborative publish of Data warehouse Architecture!! Nice one Vikram!

[@VikramTakkar]

+ashu agarwal Thanks alot

[@kunalchavda6099]

Rather than keeping lower sound you can use audacity tool to remove that irritating background sound . And very nice and simple explanation thank you :)

[@VikramTakkar]

+Kunal Chavda Thanks Kunal

[@princeagrawal]

you are really a life saver

[@VikramTakkar]

Thanks prince

[@haneelkumar9917]

aloha vikram sir nice explanation ............ as u said in dwh architecture video .. will u plez upload a video for olap in depth explain .....

[@devarajmanimaranYT]

Could you please help understand Staging area? do we schedule a job that extracts and store the load files in some repository so it will load into the Data warehouse periodically? if so can this perform both full load and incremental load?

[@s.e.kuzhali7014]

Sir, wonderful video. Please post more videos on Data ware house and its feature.

[@VikramTakkar]

+S.E. Kuzhali Thanks. I will add more videos.

[@VikramTakkar]

+S.E. Kuzhali Thanks. I will add more videos.

[@cheralathanilangovan911]

Good Video Vikram , can you please show us a schema link for a SQL dump for meta data , summary data , raw data (just Schema is enough) .. would be really use full to understand the DW in detail..

[@VikramTakkar]

+Cheralathan Ilangovan Sorry, I did not understand what do you mean by schema link? Can you please provide details ?

[@pmalogistics6760]

Very annoying background music...not good embed music background during lecture...you just add barrier of communication which is noise..

[@VikramTakkar]

+Logistics Oma Thanks for feedback. I will kerp in mind from next time onwards

[@AdanMarinIbarraFlores]

actually I loved the background music, usually videos like these are bored, but yours kept me up because of it... Thanks ;)

[@KapilA-ur3xh]

If any one wants to enjoy music, plz play any music for yourself..

[@payoneerfarzam9383]

It helped me alot. Please make a video on OLTP also and please slow down the volume of backgrond music. Thanks!

[@VikramTakkar]

Sure Farzam

[@singhp81]

would you also Datalake Architecture

[@bellissimo2930]

Thanks for quick and nicely explained video. I just have one doubt regarding raw data. what is that for? Will it hold information of any active transaction taking place in production database?

[@s.e.kuzhali7014]

Please post me the link where the dicing and slicing concepts where explained.

[@poonamtakkar8905]

Good Video.. thanks for creating...

[@VikramTakkar]

+Poonam Takkar Thanks

[@devkrishan2758]

why are you put the backgroud sound? bczz i am not listning your voice clearly.

[@VikramTakkar]

+devkrishna lamror I would keep volume lower from next time onwards

[@ikshwakreddy7090]

Nice explanation Sir

[@VikramTakkar]

Thanks Ikshawak Reddy for feedback

[@harishmarineni8131]

What is Raw data is not mentioned in the video

[@VikramTakkar]

Can you elaborate your question?

[@AkshayBhujbal16]

hello Vikram thanks for video. could you tell me problem of metadata in datawarehouse...?

[@VikramTakkar]

+Akshay Bhujbal can you provide more details. I did not get your question.

[@praveenboopathy885]

nice teaching vikram takkar tankx

[@VikramTakkar]

+Praveen Boopathy Thanx

[@ravikumargorle3617]

Sir a small doubt is that did u only upload warehousing videos or ull upload other videos

[@VikramTakkar]

Yes its me.

[@ravikumargorle3617]

10q sir the video is really very usefull please upload some more videos on ware housing

[@VikramTakkar]

Sure Ravi.. I am not getting much time to work on this project. But will definitely do it. Let me know which videos you want to see?

[@ravikumargorle3617]

Videos on database sir

[@mathavanmuthaiyan]

Nice explanation

[@carlodionela4996]

Cute presentation

[@shubhamlokhande5556]

sir ur explanation is very good except background music..:-)

[@VikramTakkar]

+Shubham Lokhande Thanks I will take care from next time.

[@VikramTakkar]

+Shubham Lokhande Thanks I will take care from next time.

[@jhansilakshmi1692]

Sir... Is it possible to share any email to clarify our doubts... I m a student..

[@abdulhadisiraj2848]

i am so upset that you have not covered other topics of datawarehouse :( i have my exam tomorrow

[@apurvasoni3673]

sir your contents are good but the background music is disturbing...

[@VikramTakkar]

+APURVA SONI Thanks Apurva. I will take care from next time.

[@VikramTakkar]

+APURVA SONI Thanks Apurva. I will take care from next time.

[@mayankgupta6012]

explain raw data as well..

[@pritomdas6215]

please have louder voice audio...its too difficult to hear properly without earphones

[@VikramTakkar]

+Pritom Das sure I will take care from next time onwards

[@ilanngo]

super

[@VikramTakkar]

+ilango thangaraj Thanx

[@oorishawo]

Very Good tutorial but background music a bad idea

[@archanavijayan3535]

please remove background music...Not able to hear properly because of the same.

[@SaadQureshiOfficial]

I think,he is telling one thing wrong.In the staging area,data is not fully transformed.

[@allanstanley1999]

please do remove the background music men!!

[@rodrigocms]

No music, please!

[@ravikumargorle3617]

Lecture was good bt background music was irritating

[@VikramTakkar]

Thanks Ravi for your feedback.

[@crunchymms]

This is hard to focus on

[@madhunalamaheshgoud7147]

Music is high pitched more than your voice

[@sohampradhan9061]

Nice explanation but why the fuck would you add a background music to it

[@gayathrilogu4353]

Please remove background music sir...

[@PravinJanjal92]

please don't use bg music

[@chinnaswamyreddy3828]

who are doing vidioes on education please dont play background music

[@RahulChauhan-kt6jo]

Please try to remove background music it's irritating, we are not watching some entertaining video, else video has good knowledge.

[@sadiaanjum7799]

Having music is making it worst ...

[@preetichauhan7277]

Irritated background song

[@srhaman08]

Stupid background music is over powering your Indian accent, which is very annoying to any living creature and it feels like I am in a data warehouse night club.