Dragonet Data Management - Power BI Dashboard

Challenge Summary

Welcome to everyone in the “Dragonet Data Management - Power BI Dashboard”! The goal of this challenge is to develop the power BI dashboard based on the provided design.

Project Overview

Dragonet is the codename for our client, which is a global company focused on life and non-life insurances. The Information Security Risk & Compliance (ISRC) team prepares a report on a monthly basis. The report, in the form of a PowerPoint file, provides stakeholders and other interested parties with the Key Risk Indicator (KRI) metrics for the past month. There are currently around 80 to 85 KRIs covering various Information Security domains, such as vulnerability management and incident reporting.

 

Security Area: The category of KRI

KRI: metrics to measure the security risk & compliance

Country/Business Unit(BU): each KRI metrics will have its own value for different BU including its own comments

 

In the design challenge, we build the design on how it should look, now we are developing those reports on Power BI

Technology Stack

Power BI, SQL Server

Device/OS Requirements

Chrome, Firefox, Safari, IE 11

Assets

The assets are shared in the forum.

Individual Requirements

Implement the following screens

• Tabular Data for KRI Metrics: 
  • D01_3.png https://marvelapp.com/prototype/6a4dd69/screen/72934758  (similar for all other 17 security areas/groups)
• Searching by KRI name: 
  • D01_7.png https://marvelapp.com/prototype/6a4dd69/screen/72934759 
• Security Area Menu:
  •  D01_11.png https://marvelapp.com/prototype/6a4dd69/screen/72934760 
• Comment/Remarks per BU and KRI Metric: 
  • D01_12.png https://marvelapp.com/prototype/6a4dd69/screen/72934761 
  • Should be able to see historical comments per KRI metrics per BU
• Legend: 
  • D01_14.png https://marvelapp.com/prototype/6a4dd69/screen/72934763
  • Legends per KRI should also be added before the KRI name 

Out of Scope:

• Overall Summary
• Notifications (remove the icon as well)

General Requirements

• The elegant looks similar [The developer is free to introduce changes to make it more elegant ] to the design is the major requirement i.e. if the looks and feel don’t match the submission will be failed. 
• Performance and accuracy should be taken care
• Data should be connected from SQL Server
• The report should be easy to maintain and extend

Winner Responsibility

• The winner has to fix the issues identified by the reviewer as a final fix within 24hr.

Final Submission Guidelines

Submit the zip containing

• PBIX report that can be deployed on cloud power BI
• Deployment Guide including data source connection and Verification guide.