Project Overview
Developed an integrated executive BI dashboard to centralize and visualize comprehensive training performance data across internal programs and external learning platforms. The dashboard delivers strategic, real-time insights into enrollment dynamics, attendance compliance, feedback quality, and learning outcomes. Designed to align learning initiatives with organizational objectives while enhancing data-driven decision-making across departments.

Technologies Used: VBA, Power Query, DAX, Excel Power Pivot, Interactive Slicers, Card Visuals, Matrix Tables

Technical Highlights:

• Engineered a unified dashboard framework combining internal and external learning datasets into a single analytical model.
• Built advanced ETL pipelines using Power Query for data cleansing, transformation, and unification across multiple sources.
• Modeled dynamic KPIs using 40+ custom DAX measures to track attendance rates, survey dimensions (knowledge, activities, logistics, trainer), and external engagement (progress %, course/instructor/overall ratings).
• Integrated drill-through analysis for departmental-level engagement and program-level effectiveness.
• Created user-centric UX with interactive slicers and storytelling visuals for seamless navigation and executive clarity.

Strategic Impact:

• Enabled 360° visibility on employee learning engagement and performance across both internal initiatives and external platforms.
• Provided executive leadership with a consolidated, data-rich perspective on training ROI and learning effectiveness.
• Improved monitoring of training alignment with organizational goals, increasing accountability across departments.

Reduced manual report preparation by 85%, while delivering richer, more actionable insights for talent development strategy.

Project Overview
Designed and delivered a dynamic, multi-dimensional dashboard to assess and navigate employee behavioral performance across hierarchical and functional structures. The system enables managers to interactively explore check-in data by Company,

Department, Position, Employee, Month, and Level, offering targeted insights into core behavioral competencies. Embedded verbatim feedback functionality allows leadership to view direct manager input for each employee, enhancing coaching, feedback loops, and leadership alignment.

Technologies Used: Power Query, Pivot Tables, Power Pivot, VBA, Advanced Filters, Slicers, Interactive Forms, KPI Cards

Technical Highlights:

• Developed a layered dashboard framework with seamless navigation between filters (Company > Department > Position > Employee > Month > Level).
• Engineered behavior check-in scoring logic across three critical competency clusters: 
  • Accountability
  • Results & Quality Orientation
  • Teamwork & Collaboration
• Created intuitive dropdown and slicer-based UX for real-time performance tracking and segmentation.
• Incorporated a qualitative layer allowing managers to input verbatim feedback, visible instantly on employee profiles.
• Designed visual performance indicators and conditional formatting to emphasize behavioral trends and improvement areas.
• Built structured answer categories (Rarely/Never, Occasionally, Sometimes, Often, Always) with weighted scoring to support data-driven development planning.

Strategic Impact:

• Enabled managers and leadership to conduct targeted behavioral assessments with clarity and structure.
• Reinforced a culture of continuous feedback and accountability across all organizational levels.
• Facilitated alignment between performance conversations and actual behavioral data, driving fair and consistent evaluations.
• Strengthened leadership visibility into soft skills and teamwork dynamics at both individual and departmental levels.
• Empowered L&D to design tailored development interventions based on real-world behavior trends.