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.
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?
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
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
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?
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 :)
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
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
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.
This is the best explanation on the internet
you're too kind!
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
Excellent video. Where can I see the video of Joe that is mentioned?
the video should be here - ua-cam.com/video/g82HUtjTPMg/v-deo.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
great video, please talk about data modeling more
I am planning to! Aiming for January
Excellent presentation!
Thank you kindly!
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. :)
Great job! Thanks for the explanation
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.
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?
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
Do you recommend a tool to create diagrams for data models?
This is beautiful!!!!
Thank you!
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 another fine video. But the yellow backgrounds just want to make my eyes explode!
I did recently stop with the yellow..
SHare the tool you used to create the database tables visualization models
Please? 😂
thank you
You're welcome
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?
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!
8:46
lol things table. Is atoms table too far?
hard to understand