In this project, I analyzed sales data for a fictional bike store to provide useful insights for management.
Using SQL, I joined multiple tables--including orders, customers, products, and staff--to create a detailed view of the company's sales performance.
I applied basic data formatting techniques to make the results easier to read, such as combining customer first and last names and calculating order revenue based on quantity and list price.
After pulling the data with SQL, I used Power BI to create an interactive dashboard for quick insights. The dashboard includes visuals for sales trends by year and month (drill down), sales breakdown by category and product (drill down), and performance by location. I also highlighted the top-performing sales reps and most valuable customers.