The Power BI - Location Metrics report

Overview and purpose

This comprehensive Power BI report offers a detailed analysis of enrollment data across a range of educational or training programs, globally and locally. Utilizing a variety of dynamic visualizations including geographical maps, pie charts, and bar graphs, the report illustrates the distribution and status of enrollments, providing stakeholders with clear and actionable insights.

The report is structured into multiple pages, each focusing on specific aspects of enrollment data. From geographical distribution across cities and countries to detailed breakdowns by completion status and compliance with deadlines, the report encapsulates a broad spectrum of metrics essential for assessing the efficiency and impact of program implementations.

Overall, this report serves as a vital tool for stakeholders to monitor, evaluate, and strategize based on current enrollment trends and progress. It aids in decision-making by providing a thorough understanding of the effectiveness of programs and initiatives across different regions and statuses.

 

Report structure

Overview

The report consists of several visualizations (charts and graphs), which you can interact with to explore specific data sets.

Key features of the report include:

Geographical Analysis. Pinpoints where enrollments are concentrated globally and within specific regions, helping identify key areas of activity and potential markets or targets for expansion.

Status Breakdown. Provides a clear view of the progress of enrollments, categorizing them into Not Started, In Progress, Completed, and Overdue, which is crucial for monitoring progress and identifying bottlenecks.

Compliance Metrics. Assesses the adherence of program rollouts to their planned timelines, highlighting areas of efficiency and those requiring prompt attention to meet deadlines.

Interactive Elements. Allows users to interact with the data, such as selecting specific time frames, which dynamically adjusts the data displayed for more focused analysis.

 

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. Simply move your mouse over any part of a chart or graph. A small box will appear, showing you more specific information, like numbers or percentages, related to the part you are hovering over.
• Drilling Down. If you want to see more detailed data about a particular section of a chart, such as a slice of a pie chart or a bar in a bar graph, just click on it. This action will "drill down," which means it will open more detailed information about that section and change the data displayed on the entire page based on your selection.

 

Location Metrics Report splash page

 

 

Overview

The Splash Page serves as the welcoming interface for the Zensai Location Metrics Report, providing users with an initial overview and essential tips for navigating and utilizing the report effectively. 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 reports. Each button is clearly labeled according to the section it leads to, making it easy to move through the report seamlessly.

 

 

• Overview. Summarize the key learning metrics from a high-level perspective, highlighting overall trends and insights.
• By City. Detail the learning metrics specific to cities, focusing on localized data and comparisons within urban centers.
• By Country. Provide aggregated learning metrics by country, showcasing national trends and cross-country comparisons in learning initiatives.

 

Location Overview page

 

 

Overview

This page of the Power BI report presents a comprehensive geographical overview of enrollments by providing data on the distribution and status of course enrollments across different locations. It utilizes a map visualization to pinpoint hotspots based on enrollments and course passing status.

The map is complemented by bar charts showing detailed enrollments by country and city, focusing on the stages of completion: Completed, In Progress, and Not Started.

 

How it works

The data visualization leverages Microsoft Bing maps to geographically represent enrollment figures, ensuring a clear visual distinction among different cities. The enrollment data is aggregated by country and city, with individual bars representing the proportion of courses in different completion stages.

 

Visualizations and insights

The visualizations provide immediate insights into the distribution and status of enrollments. If a city shows a significantly higher completion rate, this insight might indicate a higher engagement or resource allocation in that city. The 'Enrollments by City' section clearly delineates the progress status across selected cities, identifying potential areas for intervention or support. Overall, the report highlights critical disparities and progress in course enrollments, aiding in strategic decision-making and resource distribution.

 

All By City page

 

 

Overview

This Power BI report page provides a detailed view of Key Performance Indicators (KPIs) related to enrollments, categorized by city and worldwide compliance rates. It highlights totals for enrollments in various statuses: Not Started, In Progress, Completed, and Overdue.

 

How it works

The page utilizes interactive elements like a geographical map and pie charts to display data effectively. The KPI totals are presented in a straightforward numeric breakdown, while the By Status pie chart segments the enrollments into four distinct statuses, offering a visual representation of the completion landscape. Additionally, compliance metrics are illustrated in both numeric and pie chart formats, focusing on overdue and completed tasks against set deadlines, reflecting the efficiency of enrollment management across locations.

 

Visualizations and insights

The map effectively emphasizes potential geographical areas of concern which might need more focused attention to enhance completion rates. This visualization aids stakeholders in pinpointing strategic interventions to improve overall efficiency and compliance.

 

By Country page

 

 

Overview

This page of the Power BI report offers a global perspective on enrollments, detailing the total Key Performance Indicators (KPIs) by country. The map emphasizes the global reach of the enrollments, focusing where significant activities are highlighted. Accompanying the map are key metrics that provide a breakdown of enrollments in different statuses: Not Started, In Progress, Completed, and Overdue.

 

How it works

The visualization utilizes a world map to represent data distribution across continents, highlighting the areas with significant enrollment activities with marked circles. Below the map, there are neatly organized sections that display KPI totals and status distributions through numerical data and a pie chart. This layout helps to quickly assess the proportion of enrollments in different phases of completion. Additional compliance metrics are shown below, which detail the relationship between scheduled due dates and actual completion statuses, offering a clear view of adherence to expected timelines.

 

Visualizations and insights

The map serves as a visual anchor, drawing attention to regions with high enrollment activities, and the accompanying charts provide a deeper understanding of the status and compliance of these enrollments. These visualizations not only offer insights into current operations but also help in identifying trends and areas needing attention to optimize global educational or training efforts.

 

Troubleshooting map errors

“To display Azure Map visuals, sign in.”

 

 

The error message suggests that the Azure Maps visual requires user authentication to access and display the map data.

Here’s how you can address this issue:

1. Sign In. Ensure you are signed into Power BI with an account that has the appropriate permissions to access Azure Maps. This usually means using a work or school account linked to your organization’s Power BI and Azure services.

2. Verify that your account has permission to access Azure Maps services. This might require coordination with your IT department or the administrator who manages Azure and Power BI services within your organization.

3. Sometimes, simply signing out and signing back in can refresh your session and resolve these access issues.

4. If you are signed in and still encountering issues, there might be additional configuration needed in Azure to ensure that your Power BI account can access Azure Maps. (see next section for troubleshooting steps)

 

"Can't display this visual. Sorry, your tenant admin has not enabled the use of Azure Maps"

 

 

This error indicates that the Azure Maps service is not activated for your organization in Microsoft Power BI. To resolve this issue, you'll need to work with your organization's Power BI administrator or IT department.

1. Contact your IT Department or Administrator. Inform them about the specific error and request that they enable Azure Maps for your organization in the Power BI service.

2. Azure Maps Activation: The administrator needs to go to the Power BI Admin portal.

3. Under Tenant settings, they should look for the Use Azure Maps Visual section.

4. They must enable Azure Maps by adjusting the settings to allow its use for the required groups or the entire organization.

5. Once Azure Maps is enabled by your administrator, go back to your Power BI report and try to reload or refresh the data. This should now allow the Azure Maps visual to display properly.

If your organization decides not to enable Azure Maps this report may not perform as intended.

 

Accessing the Report

Please contact your Customer Success Manager for access to this report.