Managing an internship program becomes challenging when performance reports sit in different spreadsheets, attendance records come from multiple sources, and mentors track progress in separate files. HR teams need a clear overview, managers want progress insights, and leadership expects accurate reports. To solve these challenges, we created the Internship Program KPI Dashboard in Power BI — a visual, interactive, and fully automated solution that gives you real-time clarity on every intern’s performance.
This dashboard brings all KPIs together in one place: performance scores, attendance %, project completion rates, feedback ratings, skill development scores, engagement levels, and mentor evaluation metrics. Because Power BI reads Excel data and converts it into dynamic visuals, you get instant insights for MTD (Month-to-Date), YTD (Year-to-Date), and previous year comparisons. Whether you manage a corporate internship program, university internship cell, or department-specific training, this dashboard helps you track progress and make better decisions.
✨ Key Features of Internship Program KPI Dashboard in Power BI
📊 Summary Page – The Heart of the Dashboard
The Summary Page provides a complete view of internship KPIs on one screen. You get:
Month slicer for MTD/YTD analysis
KPI Group slicer for filtering categories like Training, Performance, Attendance & Behavior KPIs
3 KPI Cards showing Total KPIs, MTD Target Met & MTD Target Missed
A detailed interactive table displays each KPI’s number, unit, type (UTB/LTB), actual vs target values, MTD/YTD icons, previous year comparisons, and achievement percentages — all updating instantly when you change filters.
📈 KPI Trend Page – Track Performance Over Time
This page includes two combo charts that show:
MTD trends: Actual CY, PY Actual & Target
YTD trends: Actual CY, PY Actual & Target
A KPI Name slicer allows you to select any KPI and review progress patterns across months.
🔍 KPI Definition Page – Drill-Through Analysis
Right-click any KPI on the Summary Page to drill through and view:
KPI Number
KPI Group
Formula
Definition
Unit
Type (UTB/LTB)
A Back button brings you to the main dashboard anytime.
📦 What’s Inside the Internship Program KPI Dashboard
📁 1. Power BI PBIX File
A professionally designed dashboard with slicers, KPIs, drill-through features, combo charts, and interactive visuals.
📊 2. Excel-Based Data Source
Includes 3 important sheets:
Input_Actual – MTD/YTD actual performance
Input_Target – Monthly & Yearly targets
KPI Definition Sheet – Complete KPI reference structure
Just update Excel → refresh Power BI → all visuals update automatically.
🌐 3. Fully Automated KPI Calculations
Performance icons (▲▼), achievement percentages, month-to-month trends, and CY vs PY comparisons are auto-calculated.
⚡ 4. Filter-Friendly Dashboard
Use slicers to filter performance by month, KPI group, intern profile, and more.
🛠️ How to Use the Internship Program KPI Dashboard
1️⃣ Update Excel Sheets
Fill the Actual, Target, and KPI Definition sheets every month.
2️⃣ Refresh Power BI
Click Refresh — all KPIs, charts, and tables update instantly.
3️⃣ Use Slicers for Quick Filtering
Analyze performance by KPI category or specific time period.
4️⃣ Review Summary Cards
Check how many KPIs met or missed the target.
5️⃣ Study KPI-Level Insights
Understand achievement %, MTD/YTD values, and CY vs PY trends.
6️⃣ Use Trend Page for Progress Patterns
Identify growth, improvement areas, and performance fluctuations.
7️⃣ Drill Through for Detailed Definitions
Review KPI logic to avoid confusion.
🎯 Who Can Benefit from This Internship Program KPI Dashboard
👩💼 HR Teams
Track attendance, engagement, and progress accurately.
👨🏫 Mentors & Trainers
Review intern performance scores, feedback ratings, and skill development.
🧑💻 Program Managers
Monitor overall quality and alignment with internship goals.
🏢 Leadership Teams
Evaluate internship program impact and hiring success rates.
🎓 Interns (Optional Access)
View expectations, performance metrics, and progress patterns clearly.
### Click hare to read the Detailed blog post
Visit our YouTube channel to learn step-by-step video tutorials
👉 Youtube.com/@PKAnExcelExpert
Watch the step-by-step video tutorial:
Compatibility and Requirements
- Works in Power BI Desktop, which is free. Microsoft explains how to get it in Get Power BI Desktop.
- The data source is an Excel workbook with three sheets: Input_Actual, Input_Target and the KPI Definition sheet.
Frequently Asked Questions
Which pages does the dashboard have?
Three pages: Summary, KPI Trend and KPI Definition. The Summary page has a month slicer, a KPI Group slicer and three KPI cards for Total KPIs, MTD Target Met and MTD Target Missed.
How do I update the data?
Fill in the Input_Actual and Input_Target sheets and the KPI Definition sheet in Excel, then click Refresh in Power BI. The visuals update from the new data.
Can I compare this year with last year?
Yes. The Summary table shows previous year comparisons next to actual and target values, and the KPI Trend page charts Actual CY, PY Actual and Target for both MTD and YTD.
How do I see how a KPI is defined?
Right-click a KPI on the Summary page and drill through to the KPI Definition page. It shows the KPI number, group, formula, definition, unit and type (UTB or LTB). A Back button returns you to the Summary page.
Is there an Excel or Google Sheets version?
Yes. See the Internship Program KPI Dashboard in Excel and the Internship Program KPI Dashboard in Google Sheets.
Related Internship and Program Templates
- Internship Program KPI Dashboard in Excel: the same KPIs in Excel
- Internship Program KPI Dashboard in Google Sheets: the Google Sheets edition
- Internship Application Tracker in Google Sheets: track applications before interns start
- Volunteer Program KPI Dashboard in Power BI: a similar Power BI dashboard for volunteer programs
- HR & Workforce Analytics Bundle: 10 HR templates in one download
Browse all Power BI KPI dashboards.
Reviews
There are no reviews yet.