Snowflake for a real estate firm
Fall 2025 · Hult, MSBA
A real estate analytics firm, made up for the assignment, needed somewhere to keep its housing data and a safe way to share it. It was also choosing between Snowflake and Microsoft's Azure Synapse.
What we made
The technical side
I set up access to the housing listings in Snowflake so outside users, like my professor, could see the data but never change it. Then I wrote a query that ranks US cities by how much space a homebuyer gets for their money.
The business side
Then I explained the choice for a manager. Snowflake suits teams that run analysis in bursts, because you pay for computing by the second. Synapse suits steady, always on enterprise work. For this firm, Snowflake was the better fit.
Why two videos
The same work, explained twice: once for the people who build it, once for the people who pay for it.