📊 ADL - ATT Tracker (Quarterly) 🧠 Overview

The ADL - ATT Tracker (Quarterly) Power BI Dashboard provides a detailed quarterly performance overview of analytical test tracking (ATT) across multiple plants. It helps in monitoring delays, waivers, and completion status of different techniques and practices, ensuring effective decision-making and improved operational efficiency.

⚙️ Features

✅ Dynamic Filters — Filter data by Status, Technique, Quarter, and Plant 📈 Interactive Visuals — Visualize practice status, technique count, and quarterly trends 🧩 Observation Summary — Displays key metrics such as: Minor, Major, and Critical Observations LI (Laboratory Incidents) Total Demos 🔍 Quarterly Analysis — Breakdown of performance across Q1–Q4 🌍 Plant Comparison — Compare performance between Kolkata, Delhi, Mumbai, Bengaluru, and Chennai 📊 Key Metrics Metric Description Minor / Major / Critical Classification of observations based on severity LI Laboratory Incidents count Total Demo Total demonstration activities completed Practice Status Tracks task completion, delays, and pending activities Technique Count Shows frequency of techniques used (GC, HPLC, Titration, etc.) 🏭 Plants Covered Kolkata Delhi Mumbai Bengaluru Chennai

🧩 Technologies Used Power BI – For data visualization and interactivity Excel / CSV Data Sources – For input and transformation DAX & Power Query – For calculations and filtering logic

📅 Dashboard Highlights Count of Practice Status by Plant Count of Technique by Plant Quarter-wise Status Analysis Observation Summary (Minor, Major, Critical) Status Distribution: Within Timeline, Delay, Waiver

🚀 How to Use Download or clone this repository: git clone https://github.com//adl-att-tracker.git

Open the .pbix file in Power BI Desktop. Refresh data connections to load the latest dataset. Use slicers (filters) for Plant, Quarter, Status, or Technique to interact with the report.

📷 Dashboard Preview 💡 Future Enhancements 🔄 Auto-refresh with Power BI Service 📤 Integration with SQL or SharePoint data sources 📧 Automated email alerts for delays