🏭 Hallmarking Center Performance Analysis Dashboard

An interactive Power BI dashboard designed to analyze and visualize the operational and financial performance of a hallmarking center over a 5-year period (2020–2024). This end-to-end data analytics project transforms raw operational data into strategic insights for decision-makers.

---

🎯 Project Objective

To develop a centralized, visual performance tracking tool that enables management to monitor hallmarking activity, revenue distribution, and profitability trends, and to optimize operations using real-time insights.

---

🛠️ Tools & Technologies Used

• Power BI – Dashboard creation, KPI visualization, drill-down interactivity
• Excel – Data cleaning, standardization, and preprocessing
• Domain – Operational Analytics / Financial Reporting

---

🔄 Workflow Overview

1. 📥 Data Collection & Cleaning

• Extracted data from multiple operational sources
• Cleaned and standardized using Excel (handled missing values, fixed formats, removed errors)

2. 📊 Data Analysis & Dashboard Design

• Designed in Power BI using DAX and Power Query
• Integrated multiple metrics:
  • Pieces processed (received, hallmarked, rejected)
  • Monthly and yearly financial analysis (GST, BIS royalty, total revenue)
  • Profit and loss metrics across 5 years

3. 📈 Interactive Visualizations

• Dynamic year-based filtering
• Monthly trends for profit, hallmarking efficiency, and rejection rates
• Tax breakdown and financial flow visualizations
• Custom KPIs and drill-through views

---

📌 Key Metrics Visualized

• ✅ Total Hallmarked Pieces
• 🔁 Rejected vs. Processed Ratio
• 💸 Financial Metrics: GST, BIS Royalty, Other Taxes
• 📅 Profit Trends by Month and Year
• 📈 Rejection Rate & Operational Efficiency

---

🧠 Insights & Impact

• 💡 Identified seasonal and operational trends for profit and rejection rates
• 📉 Improved hallmarking efficiency by 15%
• 🎯 Informed strategic decisions with multi-year financial visibility
• 📊 Reduced data analysis time and manual reporting through automation

---

✅ Outcome

This project demonstrates my ability to:

• Handle raw multi-source data
• Clean, prepare, and model large datasets
• Design executive-ready dashboards for strategic use
• Extract actionable insights for operational improvement

---

🔍 This project is part of my Data Analyst portfolio focused on real-world business problem-solving.