Objective
This project demonstrates my ability to explore business relevant questions through data analysis. I used SQL to clean, query, and aggregate real-world sales data, and Excel to visualize key insights and trends. The goal was to showcase my analytical thinking, SQL proficiency, and data visualization skills in a cohesive, business oriented project.
What you can find in this project
You can find this project on Github. In the project's README you can find the executive summary, the project setup and the objectives. In the files and folders you can find the database creation script, a file with queries the original data and the dashboard in Excel. Even though this was a small and clean dataset I added a view queries to demonstrate some cleaning and validation techniques. The Excel dashboard visualizes the data and you can see some clear trends in the charts. You can use the dashboard together with the executive summary to understand my findings.
Tools: Postgresql, Excel
Tags: Data Analysis, Data Visualization