Mohammed Rashad
← The Vault

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.

The business side, for managers
The technical side: setting up users and access

What we made

Snowflake against Azure Synapse, side by side.

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.