Power BI in the Workplace Part 1a: HR - Attendance & Absence

Build real-world Human Resources dashboards in Power BI using attendance & absence data

What you'll learn
- Import and clean HR survey, attendance, and absence data from CSV, Excel, and SharePoint using Power Query.
- Build data models with relationships and calculated columns to support HR reporting in Power BI.
- Create interactive dashboards to visualize absence trends, attendance metrics, and staff survey results.
- Apply corporate branding with themes, logos, and layouts to create polished, professional HR reports.
- Use DAX to calculate key HR metrics, such as absence rates and cost of absence, with dynamic measures.
- Add slicers, hierarchies, and tooltips to enable drill-downs and user-driven insights in HR dashboards.
- Export reusable report templates with navigation pages, refresh dates, and dynamic titles.
- Publish and securely share HR reports via the Power BI service and create dashboards and apps for stakeholders.

Requirements
- No prior Power BI experience required — this course starts from the basics and builds up gradually.
- A Windows PC or laptop with Power BI Desktop installed (free download from Microsoft).
- Basic familiarity with Excel or spreadsheets is helpful but not essential.
- Access to an internet browser and Microsoft Power BI License (60-day trial available) to publish and share reports online.
- Willingness to follow along with hands-on examples using real HR-style data.

Description
Unlock the power of HR reporting with real data and real tools.

In this hands-on Power BI course, you’ll build fully functional dashboards designed for HR professionals, analysts, and consultancy staff. Whether you're an internal consultant or part of a digital transformation team, this course shows how to turn raw HR data into compelling visuals that support strategic decision-making.

You’ll work with structured files that simulate typical workplace scenarios, including employee surveys, absence logs, and attendance data. Using Power Query, you'll connect to CSVs, Excel workbooks, and SharePoint files, transforming messy inputs into clean, analysis-ready tables.

The course focuses on modeling HR data effectively — building relationships, creating DAX measures, and preparing reusable templates. You'll visualize trends using cards, matrices, bar charts, slicers, and drill-down hierarchies, all styled with professional branding and layout tools.

Designed for beginners to intermediate users, this course is ideal for consultancy staff seeking to broaden their data modeling scope and deliver high-impact HR reports to clients or internal stakeholders. No prior Power BI experience is required — we guide you through each step with practical explanations and downloadable files.

By the end, you'll be equipped to build and publish insightful, professional HR dashboards that make workplace data easy to act on.

Who this course is for:
- HR professionals and administrators who want to create clear, data-driven reports in Power BI.
- People analysts or HR business partners looking to visualize attendance and absence trends effectively.
- Beginners in Power BI who want a structured, workplace-based project to build practical reporting skills.
- Excel users transitioning to Power BI and looking for real HR reporting scenarios to apply their knowledge.
- Line managers, team leads, or HR advisors seeking better ways to present staff data to stakeholders.
- Anyone working with staff survey data, attendance records, or HR systems who wants to bring their data to life with Power BI.
More Info