If you guys want to learn more about data engineering, then sign up for my newsletter here seattledataguy.substack.com/ or join the discord here discord.gg/2yRJq7Eg3k
would be awesome to see example of conceptual data modelling. There are tons of materials about logical and physical, but not about the conceptual. At the interviews people really like to ask how you are going to gather business requirements. Would be even better if you can record an interview-cracking video. I couldn't find anything decent on youtube for conceptual modelling.
Absolutely love your videos!!! Thanks for paving the way for millions of people to get their hands into data engineering and land a job. If I land any data engineering job, you definitely provided a major chunk of guidance !!
Yessss very excited about your next video on data modelling. Seeing actual examples will be incredibly useful, especially things like when to use one big table vs kimball etc.
thanks for solid intro. I found it very useful. I'd like to provide feedback in that studies have shown that all caps are more difficult to read so I'd recommend sentence case for your slides. Also, the yellow and black contrast on the slides is a little jarring but I love the content!
serve data in a useable way - thats pretty much how i've always explained what i like to do. Doubt i'll ever manage to get into a data modeler role though
Benjamin, thank you for sharing these insights! This is an off-topic question but essential for me to - if I want to know more about data engineering/data modeling, what courses would you recommend? I am not a data person, these topics are becoming increasingly interesting to me, so I thought I could change my career
Imo, not all entities require to be extracted out as a table. Sometimes the business value is not there, even though the business folks might talk about it. The perfect model doesn't exist, that is why migration exists when changes happen. It is the products or the production process that generate the data, checking how the product and process work will reveal more than what the business folks might talk about. Just my 2 cents.
I know that data engineers have to learn python but how much python is utilized for data engineering? What I'm saying is, do I need to know python inside out or should i direct it as specific aspects used for data engineering
Are custom fields the equivalent of feature engineering in Data Analysis? Are they decided on the business side through requirements, or does the DE make the best guess and present their model to the business stakeholders, who then accept or reject them?
Hi ! I’m a junior analytics engineer, and I’m building my first data warehouse. What’s your opinion about the books from Kimball “The data warehouse toolkit, 3rd edition” ? Is it good to understand the therocial part data modeling, or is it obsolete ? Thanks
Thanks for the nice information, if you could decrease your talking speed around 10% then it'll help more to non-native english speaking guys like me :)
Do you have to be an engineer to work in data modeling? I am not an engineer but my brain organizes data in this way and I have experience with having to conceptualize how data is organized for efficient business queries. I think I'd be good at this with the proper training. I'm wondering how someone gets started in data modeling without a developer or tech background? Is that even possible?
![NISAMANEE - TADA (ท้าดา) [ OFFICIAL MV ]](http://i.ytimg.com/vi/hcQHEPMmJpU/mqdefault.jpg)
If you guys want to learn more about data engineering, then sign up for my newsletter here seattledataguy.substack.com/ or join the discord here discord.gg/2yRJq7Eg3k
would be awesome to see example of conceptual data modelling. There are tons of materials about logical and physical, but not about the conceptual. At the interviews people really like to ask how you are going to gather business requirements. Would be even better if you can record an interview-cracking video. I couldn't find anything decent on youtube for conceptual modelling.
Absolutely love your videos!!! Thanks for paving the way for millions of people to get their hands into data engineering and land a job. If I land any data engineering job, you definitely provided a major chunk of guidance !!
Glad I could help! Thank you for all your support!
Yessss very excited about your next video on data modelling. Seeing actual examples will be incredibly useful, especially things like when to use one big table vs kimball etc.
Yup! It'll be coming in the next one, probably in january
This is the best explanation on the internet
you're too kind!
Great job! Thanks for the explanation
Excellent presentation!
Thank you kindly!
Looking forward to the follow-up videos to this! 👍🏻
thank you! I have got an intro to data warehousing in the works and then another one that i am going to try to film soon.
What is the difference between data modelling for data storage compared to data modeling as in applying ML models to data? Thank you so much
thanks for solid intro. I found it very useful. I'd like to provide feedback in that studies have shown that all caps are more difficult to read so I'd recommend sentence case for your slides. Also, the yellow and black contrast on the slides is a little jarring but I love the content!
Thanks for watching, I have stopped using the yellow in black in my new videos
great video, please talk about data modeling more
I am planning to! Aiming for January
Excellent video. Where can I see the video of Joe that is mentioned?
the video should be here - th-cam.com/video/g82HUtjTPMg/w-d-xo.html
serve data in a useable way - thats pretty much how i've always explained what i like to do. Doubt i'll ever manage to get into a data modeler role though
This is beautiful!!!!
Thank you!
Benjamin, thank you for sharing these insights! This is an off-topic question but essential for me to - if I want to know more about data engineering/data modeling, what courses would you recommend? I am not a data person, these topics are becoming increasingly interesting to me, so I thought I could change my career
Did you ever get this question answered? I have the same question. :)
Imo, not all entities require to be extracted out as a table. Sometimes the business value is not there, even though the business folks might talk about it. The perfect model doesn't exist, that is why migration exists when changes happen.
It is the products or the production process that generate the data, checking how the product and process work will reveal more than what the business folks might talk about. Just my 2 cents.
thank you
You're welcome
I know that data engineers have to learn python but how much python is utilized for data engineering? What I'm saying is, do I need to know python inside out or should i direct it as specific aspects used for data engineering
Thanks for another fine video. But the yellow backgrounds just want to make my eyes explode!
I did recently stop with the yellow..
Are custom fields the equivalent of feature engineering in Data Analysis? Are they decided on the business side through requirements, or does the DE make the best guess and present their model to the business stakeholders, who then accept or reject them?
Do you recommend a tool to create diagrams for data models?
Hi ! I’m a junior analytics engineer, and I’m building my first data warehouse. What’s your opinion about the books from Kimball “The data warehouse toolkit, 3rd edition” ?
Is it good to understand the therocial part data modeling, or is it obsolete ?
Thanks
Data Engineering with Dbt: A Practical Guide to Building a Cloud-based, Pragmatic, and Dependable Data Platform with SQL
@@FunctionalOdyssey thanks ! I’ll look into it
Thanks for the nice information, if you could decrease your talking speed around 10% then it'll help more to non-native english speaking guys like me :)
Thanks for the tip, I am trying!
SHare the tool you used to create the database tables visualization models
Please? 😂
Do you have to be an engineer to work in data modeling? I am not an engineer but my brain organizes data in this way and I have experience with having to conceptualize how data is organized for efficient business queries. I think I'd be good at this with the proper training. I'm wondering how someone gets started in data modeling without a developer or tech background? Is that even possible?
8:46
lol things table. Is atoms table too far?
hard to understand