Скачать или смотреть Consumer Goods Sales Analytics with SQL & Power BI | Project Showcase

Welcome to this comprehensive walkthrough of my recent data analysis project focused on consumer sales for a hardware company, Atliq Hardware!

This project leverages the power of SQL for data extraction and transformation, and Power BI for creating interactive, insightful visualizations. We dive into a rich database spanning fiscal years 2020 and 2021 to uncover key business trends and opportunities in the APAC region.

📊 Project Overview:
The dataset provided a detailed view of the company's consumer goods, including product details, sales transactions, pricing, and customer information across six interconnected tables. The goal was to transform this raw data into actionable business intelligence.

✨ Key Insights Analyzed:
I explored several crucial business questions. In this video, we cover how I found:
Markets where Atliq Exclusive operates in the APAC region.
The increase in unique products between FY 2020 and FY 2021.
Products with the highest and lowest manufacturing costs.
The top five customers receiving the highest pre-invoice discounts.
Monthly gross sales amounts for Atliq Exclusive customers in 2020 and 2021.
The top three performing products within each division.

📈 Business Recommendations:
Growth Trend: FY 2021 showed better growth than FY 2020 (likely due to post-COVID recovery).
Focus Areas: To ensure continued growth, we should focus on increasing customer satisfaction and strategically reducing pre-invoice discount percentages to improve profit margins.
Let's dive into the project and explore the objectives and insights generated from the data!

🛠️ Technologies Used:
SQL: Database querying and data extraction
Power BI: Data modeling, visualization, and dashboard creation
Database: A provided schema of six relational tables