1. Getting Started
This customisable Microsoft Power BI App published by Camms will connect to our Camms.Risk product and let you view information related to your existing risk types (e.g. strategic, operational, project, corporate) and its drilldown of information, for your convenience.
View more details on Microsoft's Power BI and its features here.
- To use this out-of-the-box dashboard offered by Camms through Power BI, you should have already purchased Power BI Desktop from Microsoft and hold a Pro License.
- To point the dashboard to your own Camms database you should also have purchased Camms.Risk [more] and Camms.Connect [more] products offered by Camms.
Note: You are welcome to customise this dashboard to better suit your needs or request Camms to do so on your behalf. For assistance with modifying this dashboard or to make a request for a bespoke dashboard, please contact ReportingHub@cammsgroup.com.
- STEP 1:Click on the link provided to you by Camms and click 'Install' to start the installation process.
Figure 2.1: Install Power BI App
- STEP 2: If an update is available to the Power BI Desktop app or the Camms Power BI App, this additional popup will display to update your software. Select the suitable option as below, and click 'Install'.
- Update the workspace and the app – Select this option to update both the published online Workspaces and Camms Power BI App.
- Update only workspace content without updating the app – Select this option to update only the published online Workspace content.
- Install another copy of the app into a new workspace – Select this option to install a different copy of the Camms Power BI App into a new online Workspace.
Figure 2.2: Update software
- STEP 3: Once the installation is completed, click on the 'Go to app' button in the popup, or click on the new link created in your Power BI Dashboard under the 'Apps' tab.
Figure 2.3: Click on the 'Go to app' button to open Camms Power BI App
Figure 2.4: Click on the link to open Camms Power BI App
- STEP 3: Once clicked on the installed Camms Power BI App link, a dashboard with sample data will be displayed. You will require to then connect the dashboard with your organization's data. To do so, click on the link at the top 'Connect your data'.
- STEP 4: Once clicked on the 'Connect your data' link at the top of the page, a popup window will open to fill in the following details and click 'Next':
- Camms-Token: Add the non-expiring Camms Power BI token provided to you by our Integration Team
- Azure-Subscription-key: Add your Azure subscription key details
- Host: Select between Demo or Live to view your dashboard details
- STEP 5: Once your credentials are validated, select the 'authentication method' (anonymous or basic [for basic enter your username and password]), 'privacy level', and click 'Sign in and continue' to proceed.
- Once connected successfully, your organization's information will be populated in the Camms Power BI App dashboard.
3. Using the Dashboard
The Overview page in the dashboard will display overview details of all risk types of your organization. The following summary details will be available to be viewed:
- Overview – Displays a set of overview widgets to have an overall view of your organization's risk related standings.
- Number of: high residual risks, ineffective controls, overdue controls, overdue actions, overdue risk reviews, total reviewed risks, not reviewed risks.
- Donut charts to display: risks by inherent rating, risk by residual rating, risk by target rating, risk by risk appetite.
- Heatmap to display risk by business grouping.
- Risk code and risk type table.
- Chart to display risk by residual rating and control effectiveness.
The following additional features will be available within all of the dashboard pages:
- View more details – Hover over each chart segment or a rating type to view more details in a tooltip box.
- Filter details – Click on a chart segment, rating type, or any record to visually highlight only that part and filter all dashboard details based on the selection for further investigation.
Figure 3.1.1: Dashboard – Overview
The Actions page in the dashboard will display a chart of actions by owner and overdue status for each responsible person and the actions grid with details of the actions.
|Note: The same additional features will apply to the Actions page too.|
Figure 3.3: Dashboard – Actions
The Controls page in the dashboard will display a chart of controls by owner and overdue status for each responsible person, controls by type and effectiveness, and the controls grid with details of the controls.
|Note: The same additional features will apply to the Controls page too.|
Figure 3.4 Dashboard – Controls
Query your information by selecting from a list of pre-added questions (e.g. What are my highest residual risks?). To query and filter results from information displayed on your dashboards, click on one of the pre-added queries. This will then retrieve and filter the information you require.
Figure 3.6.1 Dashboard – Q&A
Figure 3.6.2 Dashboard – Q&A
|View our website for more details on our product offerings here. |