SQL Data Analysis

Analysis of Gastronomic Trends : An SQL analysis of Restaurant Ratings and Prices in Brazil

This project leverages SQL and Power BI to dissect market trends, guiding the launch strategy for a new dining establishment.

Insightful data visualizations provide a roadmap for aligning with consumer preferences and identifying competitive niches.

Here I started my project by creating a new database and a new table.

To be able to utilize my dataset, I had to use Python to insert all the data in my database

Some requests to analyze the market before opening a new etablishment

Examples of data visualisation with Power BI

visualisation of the amount of restaurants by city Average rating of restaurants by the type of cuisine they offer Best restaurant by city correlation between prince range and rating