The Power BI - Skills report

Overview and purpose

The Skills Report provides a comprehensive analysis of organizational skill development, focusing on granted, expiring, and revoked skills. The report details associated skill sets and levels, explores the connection between courses and skills, and delivers comprehensive data on individual users' skill development. Structured across multiple pages—Splash Page, Skills Overview, Skills and Skill Sets, Courses with Skills, and User Skills—this report is designed to support in-depth exploration of skill trends and progress.

The purpose of the Skills Report is to deliver actionable insights into organizational skill progression. By tracking skill statuses, course relationships, and user-specific skill data, stakeholders can identify gaps, monitor development trends, and make informed decisions to enhance training programs. The report allows for targeted interventions and strategic planning, optimizing skill management across the organization.

 

Report structure

Overview

The report consists of several interactive visualizations, including charts, graphs, and data tables. Key components such as filters and slicers are available on each page, enabling users to customize data displays based on various parameters like user, department, skill set, and date range.

 

Instructions for use

This report includes various charts and graphs that help you understand the data through visual representations. You can interact with visuals in a couple of different ways.

• Viewing Details: Hover over charts or graphs to view detailed information, including numbers and percentages.
• Drilling Down: Click on specific sections of charts (e.g., bars in a bar graph or slices in a pie chart) to drill down and display more detailed data. This interaction dynamically updates the entire page based on the selected section.

 

Skills Report Splash Page

 

Overview

The Splash Page introduces the Skills Report and provides essential instructions on navigating the report. This page is crucial for setting the context and ensuring users understand the report’s capabilities and best practices before diving into detailed data analysis.

 

Navigating to Report Sections

Click on any of the buttons to navigate to the specific pages within the report. Each button is clearly labeled according to the section it leads to, making it easy to move through the report seamlessly.

 

 

Skills Overview. Displays a high-level summary of skill statuses, including granted, expiring, and revoked skills.

Skills and Skill Sets. Offers detailed information on individual skills, associated skill sets, and proficiency levels.

Courses with Skills. Shows the connection between courses and the skills they support.

User Skills. Provides a breakdown of skills earned by each user, including proficiency levels and expiry dates.

 

Skills Overview Page

 

Overview

The Skills Overview Page serves as a comprehensive dashboard that offers a high-level snapshot of the organization’s skill landscape. It categorizes skills into three main groups:

• Granted, representing the skills currently held by learners;
• Expiring, which highlights skills that are nearing their expiration and may require renewal or refresher training; and
• Revoked, showcasing skills that have been removed or lost, potentially pointing to areas that need additional focus or retraining.

The data is segmented by key factors such as learner, department, and course, providing stakeholders with a well-rounded understanding of skill distribution and progression across the organization. By visualizing these categories in an accessible format, the page enables decision-makers to quickly assess workforce competencies, recognize trends, and develop strategic training initiatives aimed at addressing gaps and sustaining organizational growth.

 

How it works

Users can refine their view using interactive filters for learners, departments, and courses. These filters dynamically update all visualizations, enabling tailored analysis based on specific needs. This dynamic exploration supports decision-makers in identifying priority areas for development and planning interventions accordingly.

 

Visualizations and insights

Visualizations

The Skills Overview Page includes a variety of visualizations designed to provide in-depth insights into skill distribution and status.

Summary Tiles. Numeric indicators, at the top of the page, that display total counts for Granted Skills, Expiring Skills, Revoked Skills, and Users with Granted, Expiring, and Revoked Skills. These at-a-glance figures give stakeholders a quick overview of organizational skills health.

Granted Skills by Learner. A horizontal bar chart that highlights learners with the highest number of granted skills. By default, you can view all learners with granted skills from most granted to least granted skills. Recognizing these top skill holders allows organizations to leverage their expertise for mentorship opportunities, leadership roles, or critical projects.

Granted Skills by Department. A vertical bar chart that shows how skills are distributed across different departments. This visual helps identify departments with the strongest skill sets, enabling organizations to allocate resources more effectively or replicate best practices across teams.

Granted Skills by Course. A clustered bar chart displaying the courses that have contributed most significantly to skill development. This visualization allows stakeholders to determine which courses are most impactful for building essential skills.

Expiring Skills (90 Days) by Learner. A bar chart that displays the number of skills set to expire within the next 90 days for each learner. This visual supports proactive skill management by enabling organizations to plan refresher training or re-certification programs to prevent competency gaps.

Expiring Skills (90 Days) by Department. Similar to the learner-focused chart, this visualization breaks down expiring skills by department. It assists organizations in understanding which departments are at risk of losing critical skills.

Expiring Skills (90 Days) by Course. A visualization that connects upcoming skill expirations with specific courses. It helps in evaluating whether these courses should be prioritized in training schedules.

Revoked Skills by Learner. A bar chart indicating which learners have the most revoked skills. This allows organizations to plan refresher training or re-certification programs to prevent competency gaps.

Revoked Skills by Department. This visual highlights departments with the most revoked skills. Identifying these departments can help organizations target training programs where they are needed most.

Revoked Skills by Course. A chart showing the courses associated with revoked skills. This visualization provides insight into whether certain courses may need content revisions or enhanced support materials to improve long-term skill retention.

 

Insights

The insights derived from the Skills Overview Page are pivotal for strategic workforce planning and skill management.

Recognize Top Performers. By identifying learners with the most granted skills, organizations can leverage these individuals as internal experts, mentors, or candidates for leadership roles. Highlighting top performers not only maximizes internal talent but also contributes to a culture of learning and excellence.

Plan Timely Refresher Training. Monitoring expiring skills allows organizations to implement timely refresher courses, ensuring that essential competencies remain current. This proactive approach reduces the risk of skill gaps and ensures continuous operational effectiveness.

Address Skill Revocation Trends. Analyzing trends in skill revocation helps organizations uncover underlying issues, such as training program inefficiencies or gaps in knowledge application. Addressing these issues through targeted interventions improves long-term skill retention and workforce stability.

 

Skills and Skill Sets Page

 

Overview

The Skills and Skill Sets Page provides a detailed and structured view of all available skills within the organization, categorizing them into relevant skill sets and associated proficiency levels. This comprehensive view supports alignment between skill development initiatives and broader organizational objectives. By understanding how individual skills contribute to overarching skill sets, stakeholders can ensure that training programs are focused, efficient, and aligned with operational demands. This page plays a crucial role in strategic workforce planning by offering a complete inventory of the skills needed to support current and future business goals.

 

How it works

This page is designed with user-friendly filters that enable precise data exploration. Users can filter the available skills by specific skill sets, allowing for a focused analysis that highlights only the most relevant skills and proficiency levels. These filters ensure that users can examine the exact information needed for strategic planning, such as determining which skill sets are lacking within certain departments or identifying areas where proficiency levels need improvement. The dynamic structure of this page means that all visualizations are updated automatically when filters are applied, ensuring real-time, relevant insights tailored to user needs.

 

Visualizations and insights

Visualizations

The Skills and Skill Sets Page includes detailed visualizations, each designed to provide a clear understanding of the organization’s skill landscape.

Metrics Summary. This section displays key performance indicators, including the total number of skills, skill sets, and proficiency levels present within the organization.

Skills with Skill Level Set. This comprehensive table lists every available skill alongside its corresponding skill set and proficiency levels.

All Skills. A visualization that shows a list of all skills across all catalogs.

 

Insights

The Skills and Skill Sets Page equips stakeholders with the insights necessary to align workforce capabilities with strategic business goals.

 

Courses With Skills Page

 

Overview

The Courses with Skills Page provides a list of Courses with their associated skills in one table. This page plays a vital role in understanding the relationship between training programs and the skills they support. By mapping courses to specific skills, stakeholders gain valuable insights into how the organization’s learning and development efforts align with skill requirements. This understanding enables the optimization of training strategies, addressing existing skill gaps, and ensuring that course offerings are effectively supporting organizational competencies.

 

How it works

The Courses with Skills Page is designed for user-friendly navigation and dynamic data interaction. Users can apply filters to narrow down data by specific courses or skills, enabling focused analysis.

 

Visualizations and insights

Visualizations

The Courses with Skills Page features several key visualizations designed to highlight the connection between courses and skills.

Metrics Summary. Displays the total number of courses with skills, providing an at-a-glance understanding of the organization’s overall training coverage.

Course-Skill Data Table. This central visualization lists all available courses alongside the skills they support. The table provides details such as course titles, corresponding skills, and skill categories. This detailed overview helps stakeholders understand which courses are essential for developing specific skills, making it easier to design learning pathways that align with strategic goals.

 

Insights

The Courses with Skills Page provides essential insights that inform training strategy and course development.

Determine High-Impact Courses. By analyzing which courses support the most critical skills, organizations can prioritize these offerings in their training programs. High-impact courses that develop multiple essential skills can be promoted for broader adoption.

Optimize Training Strategies. Understanding the skills supported by each course allows training managers to design efficient learning. Multi-skill courses can be leveraged to accelerate development, while specialized courses can be used to target specific skill gaps.

Align Training with Organizational Competencies. The ability to see how courses align with organizational competencies ensures that training investments are directly supporting strategic goals. By focusing on courses that develop high-priority skills, organizations can ensure that their workforce remains competitive and capable.

 

Users Skills Page

 

Overview

The User Skills Page provides a comprehensive and detailed analysis of skill achievements for individual users within the organization. This page plays a crucial role in tracking user-specific skill development, monitoring proficiency levels, and understanding how skill statuses evolve over time. It highlights the current state of each user's skills by categorizing them into granted, expiring, and revoked statuses. Additionally, it tracks expiry dates to ensure that skills remain relevant and up to date. By offering a granular view of user-level data, this page supports targeted development initiatives, personalized learning paths, and strategic workforce planning aimed at enhancing overall organizational performance.

 

How it works

The User Skills Page is designed with flexible filters that allow users to customize their view according to specific analysis needs. Available filters include user, manager, department, skill, status, and grant date. When these parameters are adjusted, all visualizations on the page update instantly, providing real-time, tailored insights.

 

Visualizations and insights

Visualizations

The User Skills Page includes several critical visualizations, each designed to provide meaningful insights into user-level skill data.

Granted, Expiring, and Revoked Skills Summary. A set of summary tiles or cards that display the total number of granted, expiring, and revoked skills. These figures provide a high-level understanding of the current skill landscape, allowing stakeholders to quickly assess the organization’s and User’s overall skill health.

Status by Course. A bar chart or matrix visualization that shows skill statues by course, including granted, expiring, and revoked.

Granted Skills Over Time. A line chart that tracks the number of skills granted to users over a specified time period. This visualization highlights engagement trends and provides insights into how skill acquisition aligns with organizational goals and events. By analyzing these trends, stakeholders can assess the impact of training initiatives and adjust strategies to sustain continuous development.

Data Table. A comprehensive, user-specific data table that lists all relevant details for each skill. The table includes columns for user name, skill title, proficiency level, status (granted, expiring, revoked), grant date, and expiry date. This detailed view allows stakeholders to conduct in-depth analyses, identify development opportunities, and track progress against individual and organizational goals.

 

Insights

The User Skills Page delivers valuable insights that inform targeted learning strategies and workforce development initiatives.

Monitor Individual and Team Development. By providing detailed information on user-level skill achievements, the page allows stakeholders to track progress, identify high performers, and tailor development plans to individual needs.

Assess Course Effectiveness. The Status by Course visualization provides insights into how training programs contribute to skill development. Stakeholders can use this information to optimize course offerings, ensuring that training investments deliver the desired outcomes.