Keeping track of compliance tasks for new hires with Power BI 

Ensuring all of your compliance tasks are completed on time and by the right people can be complicated. Additional complexity arises when new people join the organization, or move within it. However, as with a lot of things, a little control and planning can minimize your exposure to non-compliance. 

In this post we are going to show how you can use PowerBI to find out which documents have been assigned to a specific audience using DocRead. This will allow you to ensure that all documents (policies/ compliance requests etc.) have been assigned to the correct audience. It will also help you spot any items that have been assigned in error. 

With its own dedicated reporting engine (VertiPaq - “Brains & Muscles” behind Power BI), Power BI has no problem working with large data sets. When combined with the rich data created by DocRead, it allows you to create beautiful and powerful reports giving insights about how your SharePoint content is being targeted, read and acknowledged by your users. These reports can also be used to demonstrate to regulators how you are communicating, targeting and tracking your Policies, Procedures (and any other important content) and thus ensuring that your employees remain compliant with them.

The “Documents assigned to an Audience“ report that we are going to build in this post will look like this:

The report above uses the standard data view called "Readership.vwTaskInfo" available in the DocRead database (find more information here). It contains three slicers at the top of the page that allows you to select a specific audience, document and site. The table then shows a list of all documents that have been assigned to the selected audience. 

The remainder of this post will explain how to create this dashboard in Power BI. 

Slicers

1) Select the Slicer visualization as shown below. This will add a slicer onto your report canvas. Resize it and move it to the top left corner of your report canvas.

2) From the 'Readership vwTaskInfo' table, select 'DocumentName', or click and drag it into the Slicer Field.

3) Click on the down arrow for this field and select 'Rename for this visual'.

4) Add a space into the field name so it displays as 'Document Name'.

5) On the report canvas, click the down arrow in the top right corner of the slicer and select 'Dropdown'.

6) Your slicer is now ready.

7) Add two more slicers to your canvas and position them along the top of your report.

8) Repeat steps 2-5 to create slicers for the 'AudienceName' (found in the 'Readership Audience' table) and 'SiteURL' (found in the 'Readership Document' table) fields.

Notice how the data in the table changes as you select different combinations of audiences, documents and sites.

Add a report background

To make your report look more appealing or fit in with a corporate color scheme, you may like to add a background layout. This post explains how to do this.

You may also like: