SQL Projects

As part of the Hotel project (the dashboard is in the Power BI portfolio), I started by cleaning and analyzing the data with Microsoft SQL Server. Being satisfied with the data wrangling, I imported it into Power BI to visualize the data.

Here are some of the queries and the reasoning behind them.

Here is the Entity Relationship Diagram (ERD) for this project.

These were the SQL queries used to derive insights from the Semester analysis of two courses for a college. The dashboard is found in the other projects section.

Here is the Entity Relationship Diagram (ERD) for this project.