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

In this hands-on lecture, you'll learn how to get started with one of the most essential steps in Power BI: importing and preparing flat file data using the "Get Data" feature. As part of our HR-focused case study, we walk through connecting to real-world survey data stored in two separate CSV files — survey questions and survey results — and begin laying the foundation for our HR Attendance and Absence report.

You'll see how Power BI handles file encoding, delimiters, and automatic data type detection, while also learning when it's appropriate to load data directly versus transforming it first. We demonstrate how to preview data, selectively load columns, and use Power Query to clean and shape your data for reporting — all with a view to keeping your data model streamlined and efficient.

By the end of the lecture, you’ll understand the benefits of using Power Query for transformation, how to manage multiple queries, and how loading choices affect your workflow. This session is perfect for learners looking to understand practical data import techniques in Power BI with a focus on clean HR data integration. Ideal for professionals dealing with CSV-based staff surveys, this lecture shows how to go from raw flat files to usable tables in your report.

In this hands-on Power BI lecture, we take our first deep dive into Power Query transformations, a key step in shaping and cleaning your HR data before it reaches your report visuals. Whether you're new to Power Query or need a refresher, this lesson guides you through a real-world example using survey data from an HR attendance and absence scenario.

You’ll learn how to launch Power Query and navigate its intuitive visual interface, including the Query Settings pane and the all-important Applied Steps list, which tracks every transformation you make. We’ll demonstrate how to identify and fix data inconsistencies—such as messy name formats and unwanted spaces—using built-in tools like Trim and Capitalize Each Word.

We also explore how to tidy up datasets by removing unneeded columns using the “Choose Columns” feature and ensure correct data types across the board. Then, to prepare for analysis, we walk through unpivoting the survey response columns—transforming a wide table into a tidy, analysis-friendly format with just two fields: Question and Response.

By the end of this lecture, you’ll have a clean, structured dataset and a solid grasp of the transformation process in Power BI. It’s all part of building HR reports that are not just professional-looking—but accurate and insightful too.

Keywords: Power Query, data cleaning, HR survey, unpivot columns, applied steps, Power BI transformation, attendance reporting.

In this essential lecture, we take our first step into the core of Power BI’s data modelling capabilities—moving beyond Power Query and into the main Power BI interface. You’ll gain a clear understanding of the three foundational views within Power BI: Report View, Table View, and Model View—each serving a different purpose in your report-building workflow.

We begin by demystifying Table View, explaining how it helps you explore your loaded data without altering it—ideal for verifying column contents, checking data types, and filtering rows as a quick data inspection tool. Next, we delve into Model View, where you learn what makes a collection of tables a true data model. We explore how to identify shared columns, how to create a relationship between tables, and what conditions must be met—matching data types, column uniqueness, and logical lookup roles.

You'll also learn how to clean and transform mismatched columns using Power Query, such as removing unwanted characters and converting data types to enable relationships. Finally, we demonstrate both automatic and manual creation of table relationships and explain the concept of cardinality in practical terms.

Whether you're an HR professional building attendance dashboards or a Power BI user exploring data modelling for the first time, this lecture lays a critical foundation for combining tables and enabling seamless, reliable data analysis in your reports.

In this hands-on lecture, we introduce a crucial but often overlooked step in Power BI report design: applying basic branding to create a polished and professional visual identity. Whether you're building HR reports or dashboards for another department, consistent branding ensures your content aligns with your organisation’s tone and style.

You’ll learn how to use Power BI themes to apply your corporate colour palette, fonts, and layout preferences. Themes are sets of visual rules that help standardise the look of your report—covering everything from primary and accent colours to typography and background tints. We’ll show you how to customise an existing theme (like the built-in ‘Storm’ template), match it to a brand colour using hexadecimal codes, and save your changes for reuse in other reports.

You’ll also learn how to incorporate your organisation’s logo into the report in a clean, visually aligned way. From sizing and positioning to alignment with your corporate style guide, we guide you through each step. These easy-to-follow techniques give your HR attendance and absence report a consistent, professional finish—something stakeholders and execs will notice.

By the end of the lecture, you’ll have laid the visual foundation for your report, ready to begin adding real content in the next section. This lesson is ideal for HR professionals, analysts, and Power BI users who want to elevate their reporting with strong design fundamentals.

In this hands-on lecture, we introduce one of the most essential and frequently used visuals in Power BI—the Card visual. Whether you’re building dashboards for HR, Finance, or any other department, card visuals are indispensable for displaying clear, high-level KPIs at a glance. In the context of HR attendance and absence reporting, we demonstrate how to use the Card visual to show key metrics like the total number of survey responses and the average response score.

You’ll learn the three ways to populate a card visual, and why it’s best practice to drag fields directly into the Fields area of the visualisation pane. We also show how to control the aggregation—changing defaults like “Earliest” or “Sum” to “Count” or “Average”—to better reflect your intended metric. Additionally, you’ll learn how to customise the category label on your card so that viewers understand exactly what the figure represents.

Beyond the technical steps, this lecture emphasises time-saving practices and user-friendly design—making your reports more intuitive and professional. By the end, you’ll be confident in setting up multiple card visuals, copying and reusing them efficiently, and adapting them to display your most important headline figures.

This foundational visual sets the tone for the rest of your Power BI report, so it’s worth getting right.

In this hands-on tutorial, we introduce one of Power BI's most versatile visuals: the Matrix Visual—a powerful tool that closely resembles pivot tables in Excel. This lecture is part of the course Power BI in the Workplace Part 1a: HR – Attendance & Absence, and is perfect for HR professionals and Power BI learners looking to display data with more depth and structure.

You’ll learn how to build a matrix that breaks down survey responses by location and question, giving you insights at a much more detailed level than the card visual. We start by carefully placing the matrix on the report canvas, then show the best method for assigning fields to rows, columns, and values. Along the way, you’ll discover why dragging fields into the Fields area (rather than directly onto the visual) ensures cleaner results and fewer surprises.

Next, we explore formatting options that bring clarity to your matrix, including aligning numbers, resizing wrapped column headers, and replacing misleading subtotals with accurate labels like “Average”. These adjustments are especially important when working with HR survey data, where clear communication of metrics matters.

Whether you’re transitioning from Excel or just starting to explore Power BI’s rich visual options, this lecture will help you feel confident working with matrix layouts to present data in a way that’s both structured and visually appealing.

In this practical Power BI lecture from the course Power BI in the Workplace Part 1a: HR – Attendance & Absence, we introduce one of the most interactive and user-friendly elements in Power BI reporting—the slicer visual.

Slicers act as dynamic filters, allowing users to narrow down the data on a report page using intuitive, click-based selections. Whether you're filtering by department or by date range, slicers help make your HR dashboards more interactive, more accessible, and more relevant to the end user.

You’ll learn best practices for adding a slicer to your HR report, including how to populate it with the Department field and how to properly assign fields within the visualizations pane—an essential habit for building robust and maintainable reports. We also explore mobile-friendly formatting options by switching from checkboxes to button-style layouts, ensuring your report is touch-friendly and easy to use on tablets and phones.

Next, we cover how date slicers work differently from categorical fields, introducing the sliding range and calendar pickers to filter by submission date—key for any time-based HR insights.

To round things off, we finalise the design, tidy up the layout, and give the report page a meaningful name. This lecture marks the completion of your first HR report in Power BI—a foundational milestone on your journey to more advanced reporting.

Perfect for those starting out with business intelligence in HR, this session bridges functionality with user experience.

In this lecture, you'll learn how to publish your first Power BI HR report to the Power BI Service, transitioning from local design mode to a fully interactive, cloud-hosted report that your colleagues can explore. We’ll walk through the publishing process step by step—from saving your report in Power BI Desktop to selecting the appropriate workspace in the Power BI Service.

You’ll gain a clear understanding of the differences between "My Workspace" (ideal for learning and personal use) and shared workspaces (suitable for team distribution with a Pro license). You'll also discover how workspaces act as containers for reports, dashboards, and semantic models (formerly datasets), and how administrators and report developers can control access and visibility.

This session is especially relevant for HR professionals and analysts preparing internal attendance or absence reports, and want to ensure their reports are available and secure within their Power BI environment. You’ll also learn how to customise your workspace with a description and icon, helping your team quickly identify and access HR content.

By the end of this session, you’ll know exactly how to take your HR report out of Power BI Desktop and into the real world—making it accessible, secure, and interactive for others in your organisation.

Learn how to share your Power BI reports with colleagues using the built-in Share button in this quick, practical lecture. Part of the "Power BI in the Workplace Part 1a: HR - Attendance & Absence" course, this lesson introduces the simplest and most direct method for sharing an individual Power BI report from within the Power BI Service.

You'll be guided through the process of accessing your workspace, locating your published report, and using the Share functionality to grant view access to other users or groups. Whether you're sharing with an individual colleague like "Peter Parker" or a whole team such as "IT Department," you'll see how to send a message with the link and control what others can see.

This hands-on demonstration is perfect for HR professionals and business users new to Power BI who want to start sharing real, working reports—without needing to configure advanced permissions or create dashboards and apps just yet. You'll also see what the recipient experiences when they receive your shared report, and understand the difference between sharing a report and granting access to a full workspace.

Mastering this foundational skill helps you demonstrate value early, collaborate more effectively, and build confidence in using Power BI across your organisation.

In this short and focused video, we walk through the essential first step in building professional HR reports with Power BI—applying basic branding. As part of our course, Power BI in the Workplace Part 1a: HR - Attendance & Absence, this lecture introduces the importance of creating a reusable report template that reflects your organisation’s brand identity and ensures consistency across all reports.

You’ll learn how to apply a custom Power BI theme, including background images and branded colour schemes, using the “Browse for themes” feature. We also cover practical visual elements that matter in real-world reporting—like correct logo placement, visual alignment, and incorporating department-specific icons (in this case, HR) into your layout. With straightforward guidance, you’ll see how to control spacing, adjust image proportions, and follow common corporate style guide conventions to give your report a polished and professional appearance from the start.

Whether you're creating HR dashboards, internal KPIs, or organisational reports, this foundation ensures that your visual identity is baked in from the beginning. Ideal for HR professionals and Power BI users alike, this lecture is a key part of understanding real-world business reporting in Power BI.

In this practical and highly visual lecture, you'll learn how to create a sleek and reusable navigation bar in Power BI — a vital element for improving report usability and reinforcing brand consistency across your HR dashboards. Navigation bars help guide your users through multi-page reports with a polished, app-like experience. Whether you're producing attendance dashboards or absence trend summaries, a well-structured navigation panel ensures users always know where they are and how to explore further.

We'll begin by inserting Power BI’s built-in page navigator and reconfiguring it to suit an HR report layout with five pages. You’ll see how to adapt the layout to run vertically, align with a side menu style, and apply a consistent shape and colour scheme to match your organisation’s branding. We’ll also hide all non-start pages to encourage structured navigation.

You'll then explore how to customise each visual interaction state — default, hover, press, and selected — giving users clear visual feedback and a professional user experience. We'll style the buttons using your theme colours, add a background panel for clarity, and use Power BI’s precise alignment tools to ensure visual balance. Finally, we’ll copy the completed navigation to all pages and test its dynamic behaviour.

By the end of this lecture, you’ll be confident creating and reusing navigation panels that elevate the user experience of any Power BI report.

Learn how to create a professional, branded Start Page in Power BI that sets the tone for your internal HR reports. In this hands-on lecture from Power BI in the Workplace Part 1a: HR – Attendance & Absence, you'll design a polished welcome screen that reinforces corporate identity, ensures legal clarity, and guides users seamlessly into your report.

This Start Page isn't just for show—it serves a key purpose in communicating that the report is for internal use only and copyrighted by your organisation. You'll learn how to duplicate your existing branded layout, exclude the page from the navigation bar, and replace it with a prominent “Start” button that takes users to the main report.

We walk you through best practices for formatting the page and styling the button using Power BI’s visual formatting tools. You’ll discover how to apply consistent theme colours, use Format Painter to save time, and configure page navigation actions. By the end, your Start Page will look polished and behave exactly as expected—serving as a clear, one-time gateway into your HR attendance report.

Whether you're preparing for stakeholder review or rolling out reports company-wide, this step helps establish credibility and ensures a professional user experience from the very first click.

Learn how to create a dedicated DAX Measures Table in Power BI to keep your HR attendance and absence reports clean, organised, and scalable. In this practical, beginner-friendly tutorial, you'll discover why storing your DAX measures in their own table is considered a best practice in professional Power BI report development.

We begin by introducing DAX — Power BI’s powerful formula language used to calculate metrics that answer real business questions. Whether you're measuring total absence days or calculating absence rates, you’ll soon see that DAX measures are essential to delivering meaningful insight in your HR dashboards.

Using Power BI Desktop, we walk through the process of creating a blank table for your measures, including how to name it correctly to avoid conflicts with reserved keywords. You’ll also learn how this approach sets the foundation for more advanced features like dynamic metadata and last refresh indicators.

By the end of this lecture, you’ll have a reusable structure that promotes tidy data models and makes your reports easier to navigate — especially important when dealing with more complex HR datasets. This lesson is perfect for HR professionals and analysts looking to move beyond basic visuals and embrace professional Power BI practices that scale with your organisation.

This is a core building block in our structured Power BI HR reporting journey — setting the stage for cleaner, more intelligent dashboards.

In this hands-on Power BI tutorial, we take your reporting one step further by creating a dynamic report title using a DAX measure—an essential skill for building professional, reusable templates. Instead of relying on static text boxes, you’ll learn how to use a basic shape with conditional formatting to display a title that updates automatically across every report page.

This approach is ideal for HR professionals, analysts, and Power BI users who want consistent, editable report metadata without touching multiple pages. You’ll see how to write a simple DAX measure for the report title, apply it using the Format pane, and reuse it throughout your report by copying the styled shape. We’ll also cover how to clean up the placeholder column in the measures table and turn it into a dedicated space for all your report formulas.

Whether you're building an HR attendance dashboard, a recruitment pipeline report, or any workplace-focused Power BI solution, this lesson equips you with practical techniques to make your reports more dynamic and user-friendly. By the end, you’ll have a professional report title setup that makes updates quick, consistent, and foolproof.

Keywords: Power BI dynamic titles, DAX measures, Power BI HR reporting, reusable templates, metadata, conditional formatting, Power BI shapes, HR dashboards.

In this hands-on Power BI lecture, you'll learn how to embed dynamic metadata directly into your HR report template—perfect for teams building reusable, professional dashboards. Part of the Power BI in the Workplace Part 1a: HR – Attendance & Absence course, this video shows you how to use DAX measures and shape visuals to create fields like “Created By”, “Data Owner”, and “Intended Audience”—all dynamically populated and centrally managed.

Rather than typing static text on every page, you’ll discover a smarter approach that improves efficiency, consistency, and maintainability. You’ll follow step-by-step as we insert text boxes for labels and use rectangle shapes linked to DAX formulas for dynamic field values. We’ll also walk through formatting techniques—such as aligning text, adjusting padding, disabling backgrounds and borders, and using FX-based text formatting—to ensure your metadata looks seamless within your Power BI navigation bar.

By the end of this video, you’ll have a fully branded, metadata-rich template that saves time and enforces consistency across your HR reports. This technique is ideal for corporate Power BI teams, HR analysts, and anyone looking to build high-quality, scalable reports.

This is an essential step in building reports that not only look good—but are easy to maintain and share with others in your organization.

Keep your reports professional and reliable with dynamic metadata. In this Power BI lecture, you'll learn how to display the last refreshed date and time in your HR attendance and absence report. Knowing when data was last updated is vital for decision-makers, and this technique ensures your report viewers always see the most current information at a glance.

We start in Power Query by using a blank query to generate the current local date and time using the M function DateTime.LocalNow(). This query is automatically updated each time your dataset is refreshed. Once the value is brought into the data model, we walk through how to hide it from the report view to keep things clean and professional.

Back in Power BI Desktop, you’ll create a DAX measure that formats this date/time value into a readable string using the FORMAT function. You’ll then apply this dynamic value to a textbox using conditional formatting to show the timestamp on your report page. Finally, we’ll tidy up our template by organizing all metadata measures into a dedicated folder—ensuring your templates remain clear and easy to maintain.

Perfect for HR analysts and Power BI users focused on real-world reporting needs, this lecture reinforces good design practices that boost report credibility and usability.

In this lecture, we wrap up our report template by adding a professional copyright footer, then export the entire file as a reusable Power BI template. You’ll learn how to format and position the copyright notice, apply it across all report pages, and understand the difference between your master file (PBIX) and the exported template (PBIT). We’ll walk through the full export process and explain how to use the template going forward—so your HR reports are always consistent, polished, and efficient to build. Whether you’re new to templating or looking to save time on future HR reporting projects, this step is essential.

In this video, we kick off the Absence Report build. You’ll learn how to create a fully interactive Power BI report based on staff attendance data, using a well-structured data model and our branded report template. We begin by reviewing the core tables—attendance, staff, status, and date—and then move through each report page step by step. The executive summary includes synced slicers, headline KPIs, and breakdowns by department, location, and month. We then introduce field parameters to let users toggle between metrics in smart matrix visuals, saving time while boosting interactivity. You’ll also explore advanced tools like drill-down hierarchies in tree maps and cost analysis visuals using pie, line, and stacked charts. Throughout, you'll create useful DAX measures like Absence Rate, Average Hours, and Absence Cost—each added to a reusable measures table. Whether you're building for HR, operations, or finance, this walkthrough shows how to blend data modeling, DAX, and clean design into one professional-grade report.

In this lecture from Power BI in the Workplace Part 1a: HR – Attendance & Absence, we begin building our attendance and absence report by connecting to a locally stored Excel workbook — one of the most common data sources used in workplace reporting. You’ll learn how to connect to Excel in Power BI using both the Get Data option and the dedicated Excel workbook button, and we’ll walk through how Power BI detects and presents your data, distinguishing between sheets, named ranges, and formal Excel tables.

We explain why using structured Excel tables provides a cleaner, more consistent experience when transforming data in Power Query, and how Power BI automatically interprets the structure of your workbook by creating a metadata table behind the scenes. You’ll see how to drill down into that metadata to access specific sheets and tables, and how to control and override Power BI’s automatic data type changes.

This video also introduces some helpful concepts around the source and navigation steps in Power Query, preparing you for more advanced Excel integration. If your data is hosted in SharePoint rather than locally, stay tuned — the next lecture demonstrates how to connect to Excel files stored in a SharePoint document library.

Learn how to connect Power BI to Excel workbooks stored in SharePoint libraries—a must-know skill for modern HR and Microsoft 365 environments. This step-by-step guide shows you exactly how to obtain the correct web link, avoid common errors, and authenticate successfully, so your data stays secure and connected in real time.

In this lecture, you'll learn how to connect Power BI to an Excel file stored in a SharePoint library—an essential skill for any team working within a Microsoft 365 environment. While connecting to local files is straightforward, linking to a cloud-based Excel workbook is a little different—and if you use the wrong method, Power BI will throw an error.

We’ll walk through the process step by step. First, you’ll see how to upload a file to a SharePoint document library and locate the correct URL using the “Copy direct link” option—not the standard “Copy link” designed for Teams sharing. Then, you’ll learn why Power BI’s standard Excel connector doesn’t work with web-based files, and how to use the “Web” connector instead.

You’ll also see how to authenticate with your Microsoft 365 organizational account and how to spot whether you’re truly connected to SharePoint (look for Web.Contents in your query). This video clears up one of the most common connection pitfalls in Power BI—and gets you ready to bring cloud-based HR data directly into your reports.

Learn how to clean and transform your HR data in Power Query to prepare it for use in a professional Power BI report.

In this hands-on Power BI lecture, you’ll learn how to transform raw HR data using Power Query, a critical step in preparing clean, structured data for reporting. As part of the Power BI in the Workplace Part 1a: HR - Attendance & Absence course, this video focuses on checking and adjusting three key tables—Attendance, Date, and Staff—after importing them from Excel.

We begin by fixing data types in the Attendance table, converting time-related columns from generic DateTime to the more appropriate Time format. You'll also see how to use Power Query’s Shift+Click and right-click options to update multiple columns at once.

Next, we improve the Date table by auto-detecting correct data types across all fields in one go, ensuring everything is optimized for the data model.

For the Staff table, we’ll switch text and number formats into the correct types—especially for cost columns where accuracy is essential—and merge first and last names into a full name column that looks cleaner in report visuals.

Whether you're new to Power BI or brushing up your data shaping skills, this lecture gives you a solid foundation in transforming HR datasets, improving both report performance and readability. It’s a practical guide to using Power Query effectively in a real-world HR reporting scenario.

Keywords: Power BI HR, Power Query, Attendance data, data cleaning, transform Excel tables, HR report preparation.

In this hands-on video, you'll learn how to connect to hidden sheets in an Excel workbook using Power BI and Power Query—a valuable skill when working with reference data stored discreetly in HR reports. Hidden sheets are often used for tidy workbooks or sensitive information, but by default, Power BI ignores them in the navigation pane. This video walks you through a smart workaround using Power Query to access both hidden and very hidden sheets, without needing to unhide them in Excel first.

You’ll start by duplicating an existing query to maintain the workbook connection, then strip it back to the Source step to reveal the workbook’s full metadata. From there, you'll identify hidden sheets using the metadata fields, access the desired one, and clean up its structure by promoting headers and correcting data types.

Along the way, we’ll explain how Excel's Developer tab lets you mark a sheet as very hidden—meaning it won’t even appear in the Unhide menu—and how Power Query can still surface it for reporting.

Whether you're managing HR attendance codes, reference tables, or internal lookup lists, this technique will help you keep reports clean while preserving the data model’s integrity.

Ideal for HR analysts, Power BI developers, or anyone working with structured Excel files in corporate environments.

In this lecture, you'll complete your Power BI data model for HR attendance and absence reporting. Learn how to structure tables into a clean star schema, verify relationships, and connect key dimensions like Staff, Date, and Attendance Status. We’ll walk through relationship types such as one-to-many, show you how to manage inactive relationships, and guide you through manually linking tables when automatic detection falls short. This setup is the foundation for accurate reporting and effective DAX measures.

This lecture focuses on completing your HR attendance data model in Power BI by creating a clean, scalable structure using a star schema. Starting in Model View, we’ll reorganize our tables, placing the central Attendance fact table at the core and arranging supporting dimension tables like Staff, Date, and Attendance Status around it.

You'll learn how Power BI’s automatic relationship detection works and when manual intervention is needed—especially for date columns, which often require a manual link. We’ll also explain the importance of relationship direction and cardinality, with clear visuals and hands-on steps for verifying or editing connections using the Relationship Properties pane.

A key part of this lesson covers how to identify active versus inactive relationships—an essential skill in complex models. You’ll see how to toggle relationships on or off and understand how these affect your report visuals.

By the end of the lecture, your data model will be fully connected and ready for DAX calculations. This structured approach ensures your HR report can analyse staff attendance, absence, and holidays with clarity and precision—critical for any professional HR dashboard.

Learn how to create essential DAX base measures for HR attendance reports in Power BI. This lecture sets up key metrics like total attendance days, distinct staff count, and average working times.

In this Power BI for HR lecture, we take our first steps into DAX by building a foundational set of base measures to support our Attendance & Absence report. These aren’t just any formulas—these are core calculations like Total Attendance Days, Total Staff, Average Start Time, and Average Leaving Time, which form the backbone of more advanced analytics later in the report.

You’ll learn how to use key DAX functions such as COUNTROWS, DISTINCTCOUNT, and AVERAGE, understanding when and why to use each. We also touch on how time values are stored in Power BI and why it's important to interpret them correctly before formatting. Alongside practical formula writing tips—like using line breaks for better readability—we’ll also reinforce best practices such as grouping measures into folders to keep your workspace organised.

Plus, we update the metadata built earlier in the report template, ensuring every published report includes clearly defined ownership and purpose. Whether you're new to DAX or reinforcing good habits, this lecture is a crucial step in developing clear, reliable Power BI HR dashboards.

By the end of this session, you'll have a clean, organised base from which to build insightful attendance summaries, KPIs, and time-based analyses. Ideal for HR professionals and Power BI learners focused on real workplace data scenarios.

In this lecture, we dive into two powerful DAX iterator functions—AVERAGEX and SUMX—and explore how they enable precise row-by-row calculations in Power BI. These functions are essential when simple aggregations fall short, allowing you to create virtual columns in memory without bloating your data model. First, you'll learn how to calculate the average lunch break duration using AVERAGEX and the DATEDIFF function, avoiding unnecessary calculated columns for optimal performance.

Then, we tackle a more complex example: calculating the total cost of staff sickness absence using SUMX and the RELATED function to pull data across tables efficiently. Both examples showcase the concept of row context, a fundamental idea in DAX that lets you iterate through each row of a table while applying custom logic. You'll also see how virtual columns created by iterator functions keep your model lean and responsive, even when working with large HR datasets.

By the end of the video, you'll have two highly reusable base measures and a strong grasp of how iterator functions fit into your broader DAX strategy. This lecture is a crucial step in building dynamic and efficient HR attendance reports in Power BI. Perfect for anyone aiming to take their DAX skills beyond basic aggregations.

Learn how to create rate-based DAX measures in Power BI to enhance your HR attendance and absence reporting. This video guides you step by step through building key percentage-based insights—absence rate, attendance rate, late arrival, and early leaving percentages—using the powerful DIVIDE function. These measures turn raw attendance data into meaningful KPIs for HR and leadership teams, ready for use in cards, matrix visuals, and executive dashboards.

In this hands-on video from Power BI in the Workplace Part 1a: HR – Attendance & Absence, we focus on building rate-based DAX measures—essential calculations that translate raw attendance data into percentages suitable for professional HR dashboards.

You'll learn how to construct:

Late Arrival % using Late Arrival Count / Total Attendance Days

Early Leaving % after creating a new Early Leaving Count measure

Absence Rate % calculated from total absence days

Attendance Rate % based on working days vs attendance records

We explore the DIVIDE function in depth, explaining its benefits for clean error handling and tidy visuals. You’ll also see how to format all your percentage measures at once using the Properties pane in Model View, improving consistency across your report.

This lecture is ideal for HR analysts and Power BI learners looking to deepen their DAX skills and create clear, executive-ready metrics from attendance data. These measures form the final layer before we shift focus to building interactive visuals in the next section.

Learn how to create a visually appealing, synchronized date slicer in Power BI that enhances user interaction across your HR attendance report. In this video, we’ll build a custom month slicer using the button slicer visual—allowing for clear, clickable buttons that stay in sync across all report pages.

You'll discover how to format your slicer to reflect proper month order, avoiding common issues with alphabetical sorting by using a numeric column from your date table. Then, we dive into styling the slicer to match your corporate theme, using Power BI’s format pane to adjust button states like hover, press, and selected. We walk through two methods of slicer synchronization—quick copy-paste and the more flexible Sync Slicers pane—ensuring consistent filtering no matter which page the user navigates to. Whether you're building an executive dashboard or a detailed absence breakdown, this technique ensures your filters are intuitive and persistent. Perfect for HR professionals and Power BI users looking to add polish, professionalism, and practical functionality to their reports.

In this hands-on Power BI tutorial, you’ll learn how to create and format synchronized dropdown slicers for an HR attendance and absence report. We focus on adding four slicers—Location, Department, Staff Level, and Staff Name—arranged neatly below the main Date slicer for maximum usability and visual alignment. You’ll see how dropdown slicers are ideal when working with long lists, helping save valuable screen space without sacrificing functionality.

We'll walk through the full setup, including how to adjust slicer formatting, set a custom title bar, apply your theme’s colors, and ensure proper alignment using Power BI’s format and distribute tools. Then, we’ll demonstrate how to quickly copy and modify these slicers to cover different staff attributes. Crucially, you’ll also learn how to synchronize these slicers across all pages in your report using an efficient copy-and-paste method—ensuring a consistent filter experience throughout.

By the end of this video, you’ll have a sleek, professional slicer panel that works across your report, laying the foundation for clear and interactive HR dashboards. This is a vital skill for anyone building multi-page reports in Power BI—especially when users need to slice by role, department, or location.

Ideal for HR professionals, data analysts, or anyone working with employee data in Power BI.

In this focused Power BI tutorial, we build an eight-card layout using the new card visual, designed specifically for summarising key HR attendance and absence figures. Instead of using eight separate visuals, you’ll discover how to use grid mode to create a compact, visually appealing dashboard section with just one object—keeping your report tidy and performance-friendly.

We begin by inserting important measures such as total working days, absence days, absence rate, and absence cost, followed by additional staff-related insights like average hours worked, lunch break duration, late arrivals, and early departures. You’ll be guided step-by-step through setting up the grid layout (2 rows x 4 columns), adjusting text size and alignment, and styling the cards with corporate colours for consistency with the report theme.

Along the way, you’ll learn how to efficiently apply formatting across all cards using series-level settings, streamline spacing, and remove unnecessary backgrounds for a cleaner presentation. This technique is not only powerful but also a major timesaver when updating visuals in future reports.

By the end of the video, you’ll have a polished summary section that communicates key metrics clearly and fits seamlessly within your overall Power BI HR dashboard. Ideal for any HR analyst or Power BI user looking to impress with well-structured, space-saving visuals.

Learn how to create polished and insightful stacked bar and column charts in Power BI to visualise HR absence data by location, department, and month. Ideal for HR analysts and report builders.

In this hands-on video from Power BI in the Workplace Part 1a: HR – Attendance & Absence, we walk through the creation of three key visuals that complete the Executive Summary page: two stacked bar charts and one stacked column chart. These charts break down staff absence data into vacation and sickness categories, with one bar chart grouped by location and the other by department.

You'll learn how to use the stacked bar chart visual in Power BI Desktop, customise your axis fields, and apply meaningful formatting such as colour-coding (green for vacation, red for sickness) and legend optimisation. We also demonstrate how to fine-tune label alignment, title formatting, and axis width to avoid text truncation—essential skills for building clear, professional dashboards.

The video then shifts to creating a vertical stacked column chart that compares absence types against total working days across months. This visual provides an easy-to-read time-based comparison of attendance patterns, with detailed guidance on how to adjust axis sizes and text formatting to maximise readability.

By the end of this session, you’ll be confident in creating HR-focused visuals that not only convey key metrics at a glance but also match the visual standards expected in real workplace reporting.

Perfect for HR analysts, Power BI learners, and business users aiming to improve their data storytelling through well-structured visuals.

In this video, you'll learn how to fine-tune visual interactions in Power BI to create a more intuitive and user-friendly report experience. As we wrap up the Executive Summary page in our Attendance & Absence dashboard, we turn our attention to how different visuals respond when users interact with slicers and charts—such as selecting a specific month, location, or department. This session introduces you to cross filtering and cross highlighting, and shows how to use the Edit Interactions mode to control or disable these effects when appropriate.

For example, we'll demonstrate why it’s better to decouple the month slicer from the column chart, so users see the selected month in context, not in isolation. You'll see how to apply 'none', 'filter', or 'highlight' interactions between visuals, depending on the user experience you're aiming for. We also cover typical use cases where filtering is helpful—such as for staff name or staff level—and when it's better to leave all categories visible for comparison.

By the end of this lecture, you’ll be confident in managing visual interactions to ensure your Power BI reports behave exactly as intended, improving clarity, usability, and decision-making value for report users.

Keywords: Power BI visual interactions, cross filtering, edit interactions, slicer behavior, report usability, attendance reporting.

In this lecture, we build a powerful and flexible Staff Absence page in Power BI using Field Parameters—a dynamic feature that allows users to switch between multiple absence-related metrics within a single matrix visual. You'll learn how to let users choose between Total Absence Days, Absence Rate, Total Absence Cost, and Total Vacation Days, all controlled by a user-friendly button slicer.

We begin by setting up a clean matrix layout with staff names as rows and short months as columns. Then, we walk through creating a Field Parameter using the Modeling tab, selecting the key measures we want to offer users. You'll see how Power BI builds a calculated table behind the scenes and uses this to drive user selections.

To polish the experience, we turn our slicer into a button slicer, apply consistent formatting, and ensure users can only select one metric at a time for clarity. This approach saves valuable space, avoids cluttering the page with multiple visuals, and gives end users an intuitive way to explore staff absence from different angles.

Whether you're new to Field Parameters or looking to enhance interactivity in your reports, this video will help you master this game-changing Power BI feature.

Learn how to complete the staff attendance page in Power BI by reusing visuals and setting up attendance-specific field parameters. Master visual adjustments, slicer setup, and formatting tweaks for a clean, interactive matrix.

In this hands-on lecture from Power BI in the Workplace Part 1a: HR – Attendance & Absence, you'll complete the staff attendance page by leveraging efficient Power BI techniques. Since this page mirrors the structure of the staff absence page, you'll learn how to copy and reuse visuals without duplication of effort.

The focus is on building an attendance-specific field parameter to allow users to switch between key attendance metrics like total working days, attendance rate, late arrival %, and early leaving %. You'll walk through how to carefully curate these fields, reorder them for usability, and refine the visual display so the matrix renders clearly at month-level granularity.

We'll also make important adjustments to the slicer—replacing the absence metric with our newly created attendance metric—and ensure that formatting and layout issues (like font size and scrolling) are resolved for a polished user experience. This video reinforces how field parameters, slicers, and matrix visuals work together to create flexible, data-rich pages your HR team will appreciate.

By the end, you’ll have a fully functional staff attendance page that empowers users to toggle between insights with ease—without clutter or confusion. Perfect for HR analysts looking to deepen their Power BI skills with reusable techniques and clean design logic.

Unlock powerful data exploration in Power BI with drill-down hierarchies! In this hands-on lecture, you’ll learn how to create a multi-level hierarchy from HR absence data, enabling interactive exploration of complex categories like Authorization, Absence Group, Absence Type, and Absence Reason. Using a Tree Map visual, we walk through how to build a hierarchy, format it for clarity, and activate drill-down features that let users explore data one level at a time. Ideal for HR analysts, this session shows how to simplify nested data for intuitive reporting.

In this lecture, we bring together everything we've learned to complete the "Absence Cost" page of our Power BI HR report. You'll learn how to visualize total absence cost using three key visuals: a pie chart by location, a tree map by staff role, and a line chart to track cost trends over time. We demonstrate how to configure Power BI's default behavior to use cross filtering instead of the standard cross highlighting, ensuring your visuals work together more clearly and consistently.

You'll discover how interactive visuals enhance user experience, enabling quick drill-downs into absence cost by time, role, or geography. We guide you step by step through formatting best practices—replacing legends with detailed data labels, managing layout space efficiently, and fine-tuning chart titles for clarity.

This video also covers a subtle but important technique: setting your report’s default landing page before saving, ensuring users always start on the right screen. Whether you're building HR dashboards or managing reporting for other departments, these techniques will help you build more intuitive and user-friendly Power BI reports.

Perfect for learners aiming to master visual interactions, data storytelling, and report finishing touches, this lecture is a must-watch in your Power BI HR reporting journey.

In this lecture, you’ll learn how to publish your HR Attendance and Absence report from Power BI Desktop into the Power BI Service and build interactive dashboards that highlight key absence metrics. We begin by explaining the concept of a dashboard in Power BI: a single-page, high-level view that provides quick insights without the interactivity of a full report. You'll see how to create dashboards by pinning individual visuals—such as matrices, charts, and hierarchical visuals—directly from your report, as well as how to create a fully interactive dashboard using the Pin Live Page feature.

We explore the differences between dashboards and reports, including interactivity, slicers, cross-filtering, and drill-down capabilities. You’ll also learn to add visual variety using tiles like videos and images, and we showcase the Q&A feature that allows users to ask natural-language questions about their data.

Finally, you'll watch a full walkthrough of assembling a functional dashboard, including layout adjustments and adding your organisation’s logo for professional branding. This lecture is perfect for HR professionals and Power BI users who want to enhance their reporting impact with executive-friendly dashboards.

Discover how to streamline report sharing in Power BI by creating a fully customizable HR app. In this video, we guide you step-by-step through publishing a Power BI app from your Human Resources workspace. Learn how to bundle key reports and dashboards into a polished, read-only app that mimics a mini-website—complete with navigation and access controls. You’ll explore the setup, content, and audience tabs to fine-tune the app’s look, feel, and availability. See how to configure distinct audiences—like Managers and Directors—with tailored visibility over specific reports or dashboards. Ideal for HR professionals and Power BI users managing internal reporting, this lecture will help you move beyond manual report sharing and give stakeholders a consistent, secure experience. Whether you're managing employee surveys, attendance reports, or executive dashboards, mastering apps will simplify access and enhance adoption across your organisation.