What is the RIW System Microsoft Power BI integration?


Microsoft Power BI easily connects to the RIW System to allow modelling and visualisation of RIW cardholder data. You can create dynamic reports that allows you to analyse, share, and promote insights across your organisation while maintaining data accuracy, consistency, and security.



Report data is refreshed from the RIW System periodically during the day, and includes the following key features:

  • Grid-like matrices that display competencies required by job roles held by cardholders that the organisation has access to. The matrices use coloured icons and text to show competency validity and competency expiry for each job role. 
  • Ability to report on upcoming competency expiry for 30/90/120 days, allowing for improved competency management.
  • Colour coding highlights workers with active blocks, active suspensions or to indicate that the swipe relationship is the only one that is present. 
  • A clickable link for each cardholder, which takes the user into the RIW System to view the cardholder record and perform actions such as awarding a competency. 
  • Metrics show crews and projects with the most invalid job roles.
  • Extensive filtering to quickly zoom in on the required information. Available filters include job role, crew name, project name, competency filters, cardholder filters and more.
  • On site now (open shifts), including data on if a cardholder has been spot checked or access controlled, and the outcome (basically all reporting fields from the swipes custom reports and heat map data).
  • Fatigue management reporting, sites worker swiped onto including current and historic, roles held at the time, travel time etc.
  • Pie chart of direct employees subscription data i.e. current or expired and Operator Job role valid or invalid.
  • Assessor logins – who holds an assessor login and roles they can assess (and is there assessor job role on their profile valid/invalid) (all contact details etc.) the people they have assessed and the job role they assessed and assessment date
  • Competence definition set up (regardless of a job role being selected).
  • Network Operators have greater reporting analytics to deliver more functionality. 


If you are interested in Microsoft Power BI integration, users must have their own Microsoft Power BI licence and complete the E-Learning for Microsoft Power BI course, which costs $25+GST. Once the course has been completed, RIW System Microsoft Power BI integration will granted. You can follow our instructions on Connecting a new user to Microsoft Power BI reporting for more detail.


For more information about the type of data you can access, please refer to Job Role Competency Status Microsoft Power BI report user guide.



RIW Knowledge Centre article link:

https://support.riw.net.au/support/solutions/articles/51000293248



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.