AIC - Build dashboard related to certification

Hello,

We are looking to implement a dashboard in AIC to monitor our certification campaigns and display revelant KPIs such as On-Going \ Completed, Access Revoked or Approved.

Some elements are missing as the capability to built a filter on the campaign name instead of ID. Data model related to those objects isn’t totally clear too.

For example, as a first KPI I created a chart pie to get the result of Access \ Revoked access using the Certification_Item table with Approved data but I’m not sure this is the correct information.

Generally we are building this kind of dashboards with Splunk using Sailpoint API to get data but for this specific use case we would use AIC.

If you have any advices or guidances to implement this kind of dashboard, feed free to contact me.

Thanks

Anyone who can help on this topic ?

Our plan for now is to export all campaing reports using PowerShell and to build dashboards into PowerBI as AIC doesn’t seem to answer easily our need.

PowerBi can definitely process this kind of data. Here are a couple of presentations that you might look at:

Yannick Beot did a great presentation about how to connect up to PowerBI.

BYOB - bring your own BI - Content / Video Library - SailPoint Developer Community

Here are some examples that I did in PowerBI around creating dashboards (start around 41:00)

Unlock the power of data in identity management with SailPoint Identity Security Cloud - Content / Video Library - SailPoint Developer Community