YELP BUSINESS REVIEWS ANALYSIS
End-to-end pipeline transforming 7M Yelp reviews into business insights.
Designed and implemented an end-to-end analytics pipeline on Yelp’s open dataset (~7M reviews)
to uncover business insights across categories, cities, and states. The project combined
Python ETL, Snowflake schema modeling, and sentiment analysis with interactive Power BI dashboards
to track review trends, customer sentiment, and regional performance. This work simulates a
real-world data engineering + BI workflow, demonstrating the ability to handle large-scale data from raw ingestion
to executive-level insights.
TOOLS: Python, Amazon S3, Snowflake, SQL, Power BI, DAX
đź”— View Live Dashboard
MySQL
Microsoft SQL Server
Jupyter Notebook
Snowflake
Pycharm
VS Code