📊 Business 360 Project Details

📁 Data Source Details

Understanding the available data is the first step before performing any analysis. This project uses two databases that contain both transactional and descriptive business data.

Databases Used

• gdb041
• gdb056

---

🗂️ Types of Tables

The tables in these databases are categorized into two types:

• Fact Tables – Store transactional data such as sales quantity, sales amount, and forecast quantity.
• Dimension Tables – Store descriptive data such as customer, product, and market information.

---

🗄️ Database: gdb041

📌 dim_customer

• 27 distinct markets (e.g., India, USA, Spain)

• 75 distinct customers across all markets

• 2 platforms:

  • Brick & Mortar (Physical/Offline Store)
  • E-commerce (Online Store)

• 3 sales channels:

  • Retailer
  • Direct
  • Distributor

---

📌 dim_market

• 27 distinct markets

• 7 sub-zones

• 4 regions:

  • APAC
  • EU
  • LATAM
  • N/A

---

📌 dim_product

• 3 Divisions

  • P & A

    • Peripherals
    • Accessories

  • PC

    • Notebook
    • Desktop

  • N & S

    • Networking
    • Storage

• 14 product categories (e.g., Internal HDD, Keyboard)

• Multiple variants available for the same product

---

📌 fact_forecast_monthly

• Stores forecasted customer demand.

• Helps in:

  • Improving customer satisfaction
  • Reducing warehouse storage costs

• Denormalized by the Data Engineering team for analytical purposes.

• Dates are stored as the first day of each month.

• Includes forecast quantity for each customer and product.

---

📌 fact_sales_monthly

• Similar to fact_forecast_monthly.
• Stores actual sold quantity instead of forecast quantity.

---

🗄️ Database: gdb056

📌 freight_cost

• Contains freight and other transportation costs for each market by fiscal year.

---

📌 gross_price

• Contains gross price details for each product.

---

📌 manufacturing_cost

• Contains manufacturing cost details for each product by fiscal year.

---

📌 pre_invoice_deductions

• Contains pre-invoice deduction percentages for each customer by fiscal year.

---

📌 post_invoice_deductions

• Contains post-invoice deductions and other deduction-related details.

Data Model

📊 Business 360 Dashboard

⭐ Data Model

• Schema Used: Star Schema

---

🎯 Objective

Develop an advanced analytics solution for AtliQ Hardware to enhance data analysis efficiency and provide comprehensive business insights. The dashboard is designed to support decision-making across multiple business functions, including:

• 📈 Sales
• 💰 Finance
• 📣 Marketing
• 🚚 Supply Chain
• 📊 Executive Management

---

📌 Dashboard Views

1️⃣ Sales View

Objective

Analyze customer and product performance using key business metrics.

Key Insights

• Analyze Net Sales and Net Profit %

• Performance matrix comparing:

  • Market vs Net Sales & Net Profit %
  • Customer vs Net Sales & Net Profit %

• Drill down into key Profit & Loss metrics:

  • Net Sales
  • COGS
  • Gross Margin

Dashboard Preview

---

2️⃣ Finance View

Objective

Analyze financial performance through detailed Profit & Loss statements.

Key Insights

• Profit & Loss analysis across:

  • Markets
  • Products
  • Customers

• Identify:

  • Top-performing Products
  • Bottom-performing Products
  • Top Customers by Net Sales
  • Bottom Customers by Net Sales

Dashboard Preview

---

3️⃣ Marketing View

Objective

Evaluate regional and market performance using sales and profitability metrics.

Key Insights

• Analyze:

  • Net Sales (NS)
  • Net Sales %
  • Gross Margin (GM)
  • Gross Margin %

• Performance matrix comparing:

  • Segment vs Net Sales & GM %
  • Category vs Net Sales & GM %

• Profit & Loss breakdown including:

  • Gross Margin
  • Operational Expenses

Dashboard Preview

---

4️⃣ Supply Chain View

Objective

Monitor forecast accuracy and supply chain performance.

Key Insights

Track important forecasting metrics such as:

• Forecast Accuracy
• Forecast Accuracy %
• Net Error
• Net Error %
• Absolute Error

Visualize trends for:

• Forecast Accuracy
• Net Error

Dashboard Preview

---

5️⃣ Executive View

Objective

Provide business leaders with a high-level overview of organizational performance.

Key Insights

• Monitor yearly trends of:

  • Gross Margin %
  • Net Profit %
  • Market Share %

• Analyze Market Share trends

• Evaluate departmental performance

• Bridge the gap between business strategy and execution through KPI monitoring

Dashboard Preview

(Insert Executive View Screenshot Here)

![Executive View](images/executive_view.png)

---

🔗 Interactive Dashboard

Power BI Dashboard Link:

(Power BI dashboard link)