This project was carried out within the scope of Upschool SQL & Power BI Capstone Project program. Database analysis was performed using Chinook database and detailed and meaningful visualization solutions were created with Power BI.
The project aims to use data analysis processes effectively with SQL queries and present the outputs with visual dashboards.
Project Objectives and Scope In this project, customer behavior, sales performance and business strategies in the Chinook database were analyzed to answer the following questions:
- **Which country or region has higher sales performance?
- **Which music genres have the highest sales?
- **How is the sales performance of the artist and album?
- **What are customers' preferred payment methods?
- **How are sales trends changing over the years?
- **What strategic recommendations can be developed based on sales data?
- SQL: Various queries were written to extract meaningful information from the Chinook database.
- Power BI: Created interactive visualizations and dashboards using the data obtained.
- Chinook Database: Sample database used in the project.
The following competencies were developed during this project:
-
SQL:
- Basic and advanced queries (multi-table joins, filtering, grouping, sub-queries)
- Data cleansing and transformation
- Categorical and time series analysis
-
Power BI:
- Data modeling and organization
- Graphics and dashboard design
- Filtering and slicers
- Create a user-friendly dashboard
-
Analytical Thinking and Problem Solving: Generate meaningful answers to business questions.
The outputs of the project are presented in the following dashboards:
-
General Sales Analysis Dashboard
- Total sales, breakdown by region and country
- Best artists and albums
-
Customer Behavior Dashboard
- Purchasing habits and payment methods
- Product preference analysis
-
Trend Analysis Dashboard
- Time series analysis (sales trends by years and months)
- Database: Use the Chinook database with a database manager like PostgreSQL or SQLite.
- Power BI Dashboard: PowerBI Desktop application is required to review the created dashboards.
- SQL Query File: All queries are included.
- Power BI File (.pbix): Dashboard and visualization file.
- Project Report: Detailed explanations of analysis results and findings.
I want to thank Upschool team and program mentors for the knowledge and skills I gained in this project.
** Prepared by:** Fatma Nur Karaman
Date: 8/12/2024