ISMS Dashboard Development in Power BI
Budget: $30 – $250 AUD
Power BI freelancer needed to build an ISMS dashboard (ISO 27001). Create a clean, executive-level dashboard with Red/Yellow/Green status based on ratings. Data includes Controls, Risks, and Tasks. Risk status uses Residual_Risk_Rating, Task status uses Status_Rating, and Control status must roll up using worst-case logic.
Requirements:
* Overview page with KPIs (overall status, counts)
* Control matrix/heatmap with colour coding
* Drilldown from control → risks & tasks
* Tables showing details and reasons for status
* Filters and intuitive navigation
Deliverables:
* .pbix file with data model
* DAX measures for roll-up logic
* Basic documentation
Skills:
* Strong Power BI & DAX
* Data modelling (star schema)
* Dashboard UX design
Nice to have: ISO 27001 or risk/compliance experience.
I will provide two SQL server 2 tables to use as the data source.
Requirements:
* Overview page with KPIs (overall status, counts)
* Control matrix/heatmap with colour coding
* Drilldown from control → risks & tasks
* Tables showing details and reasons for status
* Filters and intuitive navigation
Deliverables:
* .pbix file with data model
* DAX measures for roll-up logic
* Basic documentation
Skills:
* Strong Power BI & DAX
* Data modelling (star schema)
* Dashboard UX design
Nice to have: ISO 27001 or risk/compliance experience.
I will provide two SQL server 2 tables to use as the data source.