What is a Data Warehouse?

What’s is a data warehouse, and how does it compare to a data mart and data lake? Is a data warehouse solution only for large enterprises?

In this lightboard video, Luv Aggarwal with IBM Cloud, answers these questions and many more as he breaks down what a data warehouse is and the benefits it can provide for an enterprise.

[vidyaanvekar]

Just loved the way you explained. Totally amazing.

[adamjgb]

Great job making a complex topic easy to understand.

[chillbro]

Finally understand what a data warehouse is! Thank you.

[parsarahimi]

Solid explanation ... A minor suggestion though ... how about describing the acronyms (e.g. ETL, ERP, ...) a bit so the context could be better understood ...

[keyboardrambo]

Can we just take a moment to appreciate the guy's ability to write right to left in English? That is amazing!

[djordjepetrovic]

Great video, thank you very much sir!

[francishubertovasquez]

In the g type tech environment things were oriented to be predictable, but in the space and microthings environment, things can be unpredictable sometimes that's why adaptable or adjustable approach are needed. Because those areas necessitates high computing capacity meaning a combination of predictable and non predictable adaptable systems are needed. Theres space warehouse materials storage facilities as an example of plug in plug out applicable systems to the problem to solve per se meaning not only computing mechanisms should be improved but also the equipments and materials to meet the focus on hand.

[francishubertovasquez]

My idea is like this, as computation branches in capability, so are the supporting structures in modern warehouses including it's materials and equipments and every inventory and specifications of items stored there improve catering to various products, those ware houses can be potential semi manufacturing areas convertibles in the near future due to variety of inventory materials stored because of famililiarization to products varieties, needing only some additional equipments and structural area changes as warehouses to semi manufacturing to be structural models for computer encoded manufacturing area structure designs in a 3d like computer structure design.

[jamesbenedict]

Hi, you mentioned about data being sourced, cleaned and transformed to load the data into the Data Warehouse. Where do you recommend the data cleansing need to take place? Is it in a separate Staging area? Or within the Data Warehouse itself? Where? Thanks!

[francishubertovasquez]

You're complete with data structure congrats. Can that meet the evolving products demands and common customer orders and big ticket items orders, are those data's able to interact with each other when it comes necessity of previously worked information product type wise with the new market demand products, specifications, trends and augmentations of products ingredients to beat the competition, how those data's able to relate to latest developments and self diagnose the lacking things needed and for augmentations tech wise or product designs to make it big worldwide in a progressive computerized environment of focused applications.

[francishubertovasquez]

Warehousing, company owned fixed to company rules, multi use warehouse capable of catering to multiple companies such as in holding companies as I analyzed only can that be structure adjustable as modern warehouse type like for example an NBA games stadium whose floor is adjustable to other sports or shows such as concerts, with products storage in modern warehouse type can the wirings plugs and other attachements in there be products items customized with it's systems inputs models product specific tailored for such such as adaptable tailored products operating systems, meaning if AI connected, AI's adjust to products brought in per se not the other way around.