Power BI Reports

Introducing BPA Reports on Power BI

Power BI Reports

Reporting is the ultimate layer any software must provide for communicating business critical insights to decision makers.

BPA is releasing new prebuilt business intelligence reports – built on Microsoft Power BI – ready to be plugged in our Office 365 modern app for quality and compliance. These reports have been designed to answer quality and compliance managers most pressing challenges, regarding subjects like:

  • Document management and training
  • Audit coverage and performance
  • Customer feedback and satisfaction
  • Job and collaborator competencies
  • Nonconformity management
  • Risk trends and monitoring

State of the art reports are built on the most advanced BI technology and provide meaningful indicators presented in modern graphics, like maps, matrixes and cards. End users can click on interactive dashboard to drill down reports or select values in slicers to filter graphics.

Responsive dashboards are accessible on desktop and mobile devices by frontline workers or collaborators on the move.

>> Contact us to know more

Risk Power BI Report

Risk management dashboard presenting risk scores in heatmap and risk trends.

Pareto

Pareto Analysis as an Effective Quality Improvement Tool

Pareto dashboard example to determine which root causes provoked 80% of nonconformities using BPA Quality on Office 365 and Power BI.

In the quality improvement context, a Pareto chart is a simple tool that helps organizations identify the most frequent defects, complaints, or any other factor that can be counted and categorized. The chart takes its name from Vilfredo Pareto, originator of the “80/20 rule,” which postulates that 80 percent of the problems come from 20 percent of the causes.

You can use a Pareto chart any time you have data that are broken down into categories, and you can count how often each category occurs.

For instance, a Pareto chart can be used

  • to prioritize suppliers to evaluate (e.g. in ABC categories), based on the total cost of the purchased material/services with each supplier;
  • to identify main risks or hazards that caused 80% of incidents
  • to determine major root causes that provoked 80% of the complains or nonconformities.

Knowing major root causes that caused the biggest part of complaints and nonconformities allows an organization to prioritize actions to be taken to become more efficient.

This video presents a Pareto dashboard example to determine which root causes triggered 80% of nonconformities using BPA Quality on Office 365 and Power BI. The entire scenario was configured with no code.

The bar chart represents occurrence for each root cause in decreasing order. The curve represents the cumulated percentage of these root causes. In this case, 7 root causes triggered 80% of nonconformities, which represents a bit more than 6% of all root causes.

In summary, a Pareto analysis can be done easily for any categorized data available in your BPA Quality app. The analysis outcome allows organization to prioritize actions to become more efficient and enable continuous improvement.

Request for a BPA Quality Free Trial Now !

Building an Efficient Skill or Competency Matrix with Office 365 & SharePoint

Innovative way to manage skills, competencies and produce an interactive skill matrix dashboard, using Power Automate for automation, Power BI for reporting and BPA Quality on SharePoint/Office 365.

In ISO 9001:2015, the clause 7.2 specifically requires an organization to determine the necessary competency of collaborators and ensure they are qualified on the basis of appropriate education, training, or experience. All businesses have the requirement for qualified collaborators. The more competent the people, the better potential business results. A skill (or competency) matrix is typically a table that displays people’s proficiency in specified skills and knowledge.

This no-code scenario presents a simple configuration example to build an efficient skill management system with BPA Quality. The needed data for jobs, skills, and collaborators can be easily imported from existing spreadsheets generally used by organizations.

Skills need to be determined for a particular job function. They can be grouped by skill set for the applicable industry, for instance: basic skills, required skills for ISO management systems, or technical skills. The skill level is determined to accomplish a particular job function. This is the “should” level of competence needed to effectively perform a job function. Periodical collaborator assessments allow to determine the “Actual” level of competence. We generally have 4 level categories from basic to specialist. Skill gaps are automatically calculated.

The identified skill gaps will be basis of your organizational training program. In this example, the needed skill training items are automatically created using a simple workflow built with Power Automate. Responsible persons or mentors to plan training are automatically alerted.

The skill matrix dashboard is a powerful business intelligence report created with Power BI. The first matrix displays skill gaps by collaborator. Needed training is highlighted in red, collaborators exceeding skills are in green. Totals sum gaps by collaborator or skill. The second matrix displays skills by jobs. The third line displays the sum of actual skill rating by collaborator, by job and training status by collaborator.

By selecting a collaborator in the matrix, other charts are automatically filtered. For instance, Boris requires training in induction program, ISO 9001 and SAP. His job function is quality. The sum of actual skills is 1.25. Boris has 2 identified training and 1 planned.

In summary, the skill matrix dashboard gives an instant and comprehensive report about the needed skills and training needed for your organization. Using such a tool, you can guarantee your organization has the needed competencies and education to perform efficiently and improve business results.

Request for a BPA App Free Trial Now !