What is a Data Warehouse? - The Tech Side of It | DWH Part- 2

In the last video of this series, we got to know about what Data warehousing is from a business point of view and in this one we will know the technical view of Data warehouse. Watch this video to understand what Do we do actually do in Data warehousing? What is it used for? Technical view of data warehousing from receiving to storing to sending data. The steps included in this process such as ETL, Dimensional model, and along with the help of a dataset, we will understand a practical example.

===================Follow Me Here===================

===================About Me===================
Freelance Data Engineer and Solution Architect.
I love learning about technology and teaching thing I know to other people. The goal of creating this channel was to teach everything I know to the world, I have spent most of my time learning things online and I want to share all my learning on this youtube channel.
I will be posting content related to data engineering, architecting systems, data science, machine learning, and interview preparation.

Thank you for watching the video, see you in the next video :)

My Accessories

#datawarehouse #dataengineer #dataarchitect

0:00 Introduction
0:29 Data Warehouse Definition
1:39 Data Architecture and ETL Models
4:08 Dimentional Modeling (Star Schema)
5:45 Fact vs Dimension tables
7:46 Practical Example with Dataset
9:30 Exercise and prep for projection

[mustanserbillah]

The very first teacher on the planet I saw who teach data engineering from A to Z in a very simple method
Thank you, Sir

[anukuljain]

Watching and following you now and content is 100% relatable after 2 years
Please continue this series of possible.

[mohdzuhaib-rm]

hi darshil,
As a data engineer, we should have deep knowledge of source systems. And there are hardly any videos which gives you knowledge about transaction logs. How to connect to RDMS and replicate data, I mean production pipeline, where we setup system to read from snapshots and transaction logs to each out pressure on live application tables. Can you also cover such topics in future. It would be great.

[navejpathan]

Bhai you are doing really great work ... Please make video on SCD types along with coding if possible..🙏

[surojit]

Appreciate your work and giving time to us from your busy freelance schedule. If possible try to make more different kind of Data Engineering related projects 🙏

[miteshpawanarkar]

Is quantum, SPSS, wincross, dimension useful in data science field ?