In this article, we'll explore the Accreditation analysis report. This report is available to all customers with Power BI. We'll summarise what the report includes, and how it might be used, along with the filter and drill-through options available.
How this report can be used
- See a breakdown of completion progress for continuous and fixed accreditations
- See the ‘big picture’ of accreditations that will expire each month for the coming year
- Follow a ‘one-click’ route to see Users with a status of complete, expired, not started or suspended
Important things to know about this report
The report is dashboard-driven with interactive metrics designed to let you focus on the data that matters most. The report is pre-filtered to include only enabled accreditations, and enabled users, by default. This filter can be changed to show optional learning if required. Use the 'Is group member?' filter to only show users that are currently assigned to an accreditation via a group. The report has a data export limit of 150,000 rows.
Filters
As with all fixed reports, the Accreditation analysis report is supplied with a selection of filters to help you find the detail you're looking for. Watch the below video to see the filters configured for this report:
We've added the ability to filter by "is group member?", which allows you to work out whether the accreditation was assigned by a group or not.
Data drill-through
Data drill-through takes you from summary-level information, right through to the granular detail you need. Watch the below video to see examples with the Accreditation analysis report:
How often does the reports database refresh?
- The report database refreshes twice every 24 hours
- A time stamp showing the most recent database refresh is shown in every fixed report
- The 'database refresh' time stamp can also be added to a user-created report
- The 'database refresh' time stamp displays in GMT/BST time
- Each Dataset is refreshed individually, so the time stamp may differ between reports using different Datasets
- When a fixed report and a user-created report are built using the same dataset, the time stamp will be the same
Discover more about the Fixed reports
Want to get the most out of Fixed Reports? Our step-by-step guides cover the top queries on compliance and Event management, helping you use Fixed Reports effectively while learning key techniques along the way.
When you're ready to explore further, view Key techniques for using the Fixed reports in which Gary walks through real-world use cases.
Need quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources. You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.