Power BI: Collect and Visualize Training Analytics for Free

Effective dashboards and analytics are often missing from many LMS platforms. That’s because it’s very challenging to implement a training analytics dashboard—and every end-user wants something just a bit different from their peers.

This problem actually extends far beyond LMS platforms. That’s good news because the result is a powerful tool that can empower L&D teams to collect training analytics for free—and easily create clear, attractive data visualizations.

All disciplines, from marketing to sales to logistics, are itching for better ways to visualize their metrics and KPIs. This has sparked creation of a class of business intelligence, or BI software. These tools empower users to load in their own data and create their own dashboards and visualizations.

Popular tools include GoodData, Looker, Tableau, and Domo. However, one tool stands out from all of them: Power BI. This free BI tool from Microsoft allows you to quickly import data files and create interactive dashboards and reports.

At OttoLearn, we use Power BI as part of the analytics suite with our Agile Microlearning platform. This allows our enterprise clients to build their own custom dashboards. Any L&D team can use Power BI in a similar manner.

Let’s explore the steps in building a custom interactive dashboard. We’ll use fictional OttoLearn data.

The default dashboard shows learners’ activities and progress. Individual data are displayed, along with averages.

Figure 1: The default OttoLearn advanced analytics dashboard powered by Power BI, showing an overview of learner mastery

How to use Power BI

The first step to using Power BI is to load in your data files. With OttoLearn, we export a single XLS file that contains all the data. Some platforms may generate or multiple data files, which Power BI also supports.

Once your data files are uploaded, you must establish relationships between the different tables. For instance, if you have a table of your users and a table with their scores (in our example, mastery levels by module), you simply link the common data columns so that Power BI knows how to connect your data.

A list of users is linked to a module that measures progress

Figure 2: An example of linking related data across tables

Once your data points are connected, you’re ready to design your dashboard. Power BI displays all of your data. Simply drag data onto the page, then select a type of visualization. Presto!

Power BI users can select a data visualization type and drag the desired data fields onto it using drop-down menus.

Figure 3: Power BI creates many types of data visualization from your data

For example, you can create a bar chart that shows how many employees have reached the “mastery” level of a particular skill—and display the percentages by region or location.

Figure 4: This short video shows the steps in creating a bar chart visualization of learner mastery by location (videos do not include audio)

It’s easy to change a visualization to a different format, or emphasize different data. Just click on it and select a different visualization type. Let’s change from a bar chart to an interactive map showing learner mastery by location.

Figure 5: This short video shows the steps in converting a bar chart to an interactive map

Power BI offers more features with its AI-powered natural language queries. Explore your data by typing in a question. Power BI dynamically finds and visualizes the answer. Simply drag that visualization onto a page.

Typing a question dynamically creates a visualization with the data that answer the question.

Figures 6 and 7: NLP query support makes it easy to find the data you’re looking for

Additional Power BI features

In addition to the clear dashboard with your learning analytics and the ability to easily create data visualizations, Power BI offers many more features:

  • Add filters that automatically carry over and apply to your other pages. For instance, you may want the user to be able to filter the analytics by department, brand, country, job function, etc.
  • Share dashboards with others in your organization; set row level data permissions to limit who can access what data
  • Set an automatic refresh interval for your data (using the free Personal Gateway)
  • Download your analytics as a ready-to-present PowerPoint

Using a tool such as Power BI to obtain and analyze free training analytics enables you to break free of the pre-packaged reporting from your LMS platform, and start designing your own visualizations. You can give each learner access to the information they need to turn training data into actionable insights.

Power BI resources

Power BI offers guidance, sample data, and other resources to help you become a power user:

Register for the Free Tools for eLearning Spotlight, an online event taking place January 30, to discover more ways to enhance your eLearning without draining the budget.

More Development

You May Also Like