Data modeling is key skill data engineers need to know.
In particular dimensional modeling. Whether you eventually decide to go into one big table or you just need to go through and think about your data model.
You'll likely put together a dimensional model.
So here is a quick rundown of dimensional modeling with a walk through.
If you enjoyed this video, check out some of my other top videos.
What Is A Data Platform And Why You Should Build One
https://youtu.be/_BoM2ahSJV0
Data Modeling Challenges - The Issues Data Engineers & Architects Face When Implementing Data Models
https://youtu.be/G3m94JeuAtc
What Is Change Data Capture - Understanding Data Engineering 101
https://youtu.be/hNJCxF3IWC4
If you would like to learn more about data engineering, then check out Googles GCP certificate
https://bit.ly/3NQVn7V
If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.
https://seattledataguy.substack.com/
Or check out my blog
https://www.theseattledataguy.com/
And if you want to support the channel, then you can become a paid member of my newsletter
https://seattledataguy.substack.com/subscribe
Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio
_____________________________________________________________
Subscribe: https://www.youtube.com/channel/UCmLGJ3VYBcfRaWbP6JLJcpA?sub_confirmation=1
_____________________________________________________________
About me:
I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data.
*I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you.