If you like data engineering and you are looking to start you're own data engineering/analytics consulting company, then you should check out my new course here - courses.technicalfreelanceracademy.com/courses/starting-6-7-figure-consulting - and use the coupon code "deconsult" to get 50% off
Thanks Ben! I used something like this to fiqure out Opendoor listings across the Atlanta region and ran it against what they bought at and how much decline they are seeing. It was fun excersize. Kind of cool how much free information is out there as long as your willing to scrap the data and make sense of it.
Great content! Just a suggestion, it might be helpful to slow down and enunciate your words a bit more for better understanding. Keep up the good work!
@@SeattleDataGuy nice thank you! ill try this project and see if i can get a legit DE role. Right now im Senior analyst and not sure if my company will give me opportunities
Thank you for the vid!! Not sure if this question is obvious or not as i’m VERY much a novice but when you’re working on snowflake (~17:14) where you using SQL queries or coding in a different language? Just not sure what you used to parse everything
It's SQL just likely not all ANSI SQL. A lot of solutions like Snowflake and Databricks (actually postgres has some of these as well) have added in additional functionality. For example, when I create the "Stage" thats not regular SQL. Snowflake lets you query from S3 directly (other tools let you do it too). T
In filming time, probably like 4 hours, i went back a few times when I realized I had been mumbling like SBF for like 5 minutes and had to reshoot. A little planning too. I had to get used to brightdata, and then there is all the fidgeting around with tableau.
If you like data engineering and you are looking to start you're own data engineering/analytics consulting company, then you should check out my new course here - courses.technicalfreelanceracademy.com/courses/starting-6-7-figure-consulting - and use the coupon code "deconsult" to get 50% off
Thanks Ben! I used something like this to fiqure out Opendoor listings across the Atlanta region and ran it against what they bought at and how much decline they are seeing.
It was fun excersize.
Kind of cool how much free information is out there as long as your willing to scrap the data and make sense of it.
Id also hold on buying a home until 2024... Lot of inventory going to be hitting the market in the next 9-12 months.
👀
Oh yea, its interesting to see even from a high level. Houses are staying on the market at least 2x as long as were only a few months ago
Hello Ben, I just wanted to say that I would love to watch your videos with a better sound quality 😁
I liked the snowflake part of this video.,
Glad you liked it!
Hello data man
Hello!
Thanks for making this video. I’ve been contemplating switching to data engineering. This video just reminded me how boring data is to me😂😂😂😂
Glad it was helpful hahahha
Really good!
thank you!
Great content! Just a suggestion, it might be helpful to slow down and enunciate your words a bit more for better understanding. Keep up the good work!
I'll do my best, yeah I think this video in particular I started mumble rapping
Thanks so much for this video.
Glad you found it helpful!
Is snowflake free to use to build this project for my portfolio? I only see a trial
You can use it free for like 30days, and you can pretty much keep setting up free instances over and over again.
@@SeattleDataGuy nice thank you! ill try this project and see if i can get a legit DE role. Right now im Senior analyst and not sure if my company will give me opportunities
Hi! Recent subscriber here👋 I'm very much a novice on the subject - are the tools you use free? If not, are the free alternatives you can recommend?
There are always free alternatives, you can code similar things.
and how do you connect it to tableau?
Thank you for the vid!! Not sure if this question is obvious or not as i’m VERY much a novice but when you’re working on snowflake (~17:14) where you using SQL queries or coding in a different language? Just not sure what you used to parse everything
It's SQL just likely not all ANSI SQL. A lot of solutions like Snowflake and Databricks (actually postgres has some of these as well) have added in additional functionality. For example, when I create the "Stage" thats not regular SQL. Snowflake lets you query from S3 directly (other tools let you do it too). T
Do we need to pay for using the api from bright data?
Thanks Ben. Any resources on swapping out a Python selenium script downloading a csv file for the scraping portion in this vid?
For the Tableau part, can we use Tableau public or should we use Tableau Desktop
SQL parts in snowflake are really confusing and not well explained. Are the scripts available somewhere?
How long did this take you?
In filming time, probably like 4 hours, i went back a few times when I realized I had been mumbling like SBF for like 5 minutes and had to reshoot.
A little planning too. I had to get used to brightdata, and then there is all the fidgeting around with tableau.
@@SeattleDataGuy I mean total time. Just trying to get a gauge to compare against a newbie like myself :)
Good content.
As a sort of native speaker you are speaking too fast and audience would find it difficult to pace with.
This vidoe isn't beginner-friendly!
Hard to follow what you saying when you are not english speaker because you don't articulate...