Sales Insights using Power BI & SQL

Problem Statement 🔖

The Sales Director at AtliQ Hardware, a company selling computer hardware and accessories across India, faces a crucial challenge. Despite ongoing discussions with regional managers to understand sales and market trends, the reliance on Excel files for data analysis creates frustration. This difficulty in interpreting numerical data delays the identification of business issues and limits informed decision-making. Consequently, there is a pressing need for a more user-friendly data analytics solution to improve performance evaluation and strategic planning across the organization.

Technologies used ⚙️

• Excel

• MySQL

• Power BI

• Statistics

Power BI Dashboard Link 🔗

Approach - Project Planning & Aims Grid

Setup Process

Step 1: Download file: db_dump.sql

Step 2: Import it in MySql do EDA(Exploratory Data Analysis)

Step 3: Download Power BI Desktop (Free)

Step 4: Connect Power Bi with MySql database

Step 5: Save the file as (.pbix)

Data Analysis Using SQL

1. Show all customer records

   SELECT * FROM customers;

2. Show total number of customers

   SELECT count(*) FROM customers;

3. Show transactions for Chennai market (market code for chennai is Mark001)

   SELECT * FROM transactions where market_code='Mark001';

4. Show distrinct product codes that were sold in chennai.

   SELECT distinct product_code FROM transactions where market_code='Mark001';

5. Show transactions where currency is US dollars.

   SELECT * from transactions where currency="USD"

6. Show transactions in 2020 join by date table.

   SELECT transactions.*, date.* FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020;

7. Show total revenue in year 2020.

   SELECT SUM(transactions.sales_amount) FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020 and transactions.currency="INR\r" or transactions.currency="USD\r";

8. Show total revenue in year 2020, January Month.

   SELECT SUM(transactions.sales_amount) FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020 and and date.month_name="January" and (transactions.currency="INR\r" or transactions.currency="USD\r");

9. Show total revenue in year 2020 in Chennai.

   SELECT SUM(transactions.sales_amount) FROM transactions INNER JOIN date ON transactions.order_date=date.date where date.year=2020and transactions.market_code="Mark001";

Data Analysis Using Power Bi

Data Modelling in Power BI

Power BI Dashboard

Key Insights

Profit Analysis

Performance Insights

Project References: 🔗

Sr.No. 🔢	References 👨‍💻	Links 🔗
1	Tutorial	YouTube 1
2	MySQL installation	YouTube 2
3	Star Schema: Fact Table & Dimension Table	Microsoft docs.