Tracking maturity trends - DevOps dashboard

[prepo]

Hello,

We'd like to build a dashboard to showcase the improvement in maturity level in our DevOps approach. The data is hosted on OneDrive which is linked to the PowerBI service. I have attached sample data in this post, which is updated once a month with a unique level of maturity for each parameter. For example the levels of maturity for 

QA automation are:

Automated tests	L0. No Automation
	L1. Simple Automation
	L2. Framework Driven Automation
	L3. Scheduled Automation
	L4. Continuous Integration
	L5. Managed Automation
	Blocked
	Vendor Managed
	N/A

and for Performance testing are

Performance tests
	L0. No Performance
	L1. Single user Performance
	L2. Baseline Performance
	L3. Continuous Performance
	L4. Integrated Performance
	L5. Managed Performance
	Blocked
	Vendor Managed
	N/A

Has anyone encountered a similar usecase, any suggestion to model the data or represent them in a report are appreciated. 

Data:

Apr 2018

App	Priority	Version Control	Continuous Integration	Automated tests - Functional	Automated tests - Performance	Security - scans	Code Analysis	Production scans	Pre-Production scans
App 1	1	L2. Enterprise Git	Done	L2. Framework Driven Automation	L2. Baseline Performance	Backlog	N/A	Level 2 - Teams: Review and fix	Level 2 - Teams: Review and fix
App 2	3	L1. Public Git	Done	L0. No Automation	L3. Continuous Performance	N/A	Blocked	Blocked	N/A
App 3	3	L1. Public Git	Done	L1. Simple Automation	L5. Managed Performance	Blocked	Blocked	Blocked	N/A
App 4	2	L1. Public Git	In Progress	L3. Scheduled Automation	L1. Single user Performance	In Progress	In Progress	L3. Scans are automated via Continous Integration	L1. Onboarding & Scanning
App 5	3	L0. No Version Control	Done	L0. No Automation	L0. No Performance	Blocked	Done	Level 2 - Teams: Review and fix	L4. Security embedded with SDLC

Mar 2018

App	Priority	Version Control	Continuous Integration	Automated tests - Functional	Automated tests - Performance	Security - scans	Code Analysis	Production scans	Pre-Production scans
App 1	1	L1. Public Git	Blocked	L2. Framework Driven Automation	L1. Single user Performance	Backlog	N/A	Level 2 - Teams: Review and fix	L1. Onboarding & Scanning
App 2	3	L1. Public Git	Done	L0. No Automation	L2. Baseline Performance	N/A	Blocked	Blocked	N/A
App 3	3	L1. Public Git	Backlog	L0. No Automation	L3. Continuous Performance	Blocked	Backlog	Blocked	N/A
App 4	2	L0. No Version Control	In Progress	L2. Framework Driven Automation	L0. No Performance	In Progress	In Progress	L3. Scans are automated via Continous Integration	Blocked
App 5	3	L0. No Version Control	In Progress	L0. No Automation	L0. No Performance	Blocked	Backlog	Level 2 - Teams: Review and fix	L3. Scans are automated via Continous Integration

Feb 2018

App	Priority	Version Control	Continuous Integration	Automated tests - Functional	Automated tests - Performance	Security - scans	Code Analysis	Production scans	Pre-Production scans
App 1	1	L0. No Version Control	Blocked	L2. Framework Driven Automation	L1. Single user Performance	Backlog	N/A	Level 2 - Teams: Review and fix	L1. Onboarding & Scanning
App 2	3	L0. No Version Control	In Progress	L0. No Automation	L2. Baseline Performance	N/A	Blocked	Blocked	N/A
App 3	3	L1. Public Git	Blocked	L1. Simple Automation	L1. Single user Performance	Blocked	Backlog	Blocked	N/A
App 4	2	L0. No Version Control	Backlog	L0. No Automation	L0. No Performance	Backlog	In Progress	L1. Onboarding & Scanning	Blocked
App 5	3	L0. No Version Control	In Progress	L0. No Automation	L0. No Performance	In Progress	Backlog	L1. Onboarding & Scanning	L2. Teams: Review and fix

-Prepo

[v-yulgu-msft · Accepted solution]

Hi @prepo,

As a workaround, maybe you can use numeric values to represent the level of maturity. 

For these two tables, you could add a conditional column which lists unique numbers for each level type. Then, in data table, refer to numerical column via LOOKUPVALUE so that text values are converted to numbers. Add numerical column to chart visual.

Regards,

Yuliana Gu

[v-yulgu-msft]

Hi @prepo,

Then, what is your desired output with above sample tables? Please provide more description about your requirement.

Regards,

Yuliana Gu

[prepo]

The output would be to visually represent the level of maturity on a monthly basis for each area per app. Since some of the apps take several months to move from one level to another, it is imperative to showcase the current status. I have represented a sample of how the data could be represented, any advice is welcome. Let me know if you have any questions.

Thank you!

[v-yulgu-msft]

Hi @prepo,

In Power BI desktop, it is not possible to display text values on Y-axis in a chart visual. Y-axis only supports aggregated numerical fields. I'm afraid your requirement might not be achievable right now.

Regards,

Yuliana Gu

[prepo]

do you have any recommendations to convert such matrices to calculate a weighted average and represent the text into numbers.Thanks!

[v-yulgu-msft · Accepted solution]

Hi @prepo,

As a workaround, maybe you can use numeric values to represent the level of maturity. 

For these two tables, you could add a conditional column which lists unique numbers for each level type. Then, in data table, refer to numerical column via LOOKUPVALUE so that text values are converted to numbers. Add numerical column to chart visual.

Regards,

Yuliana Gu

[prepo · Accepted solution]

That helped, thank you for your suggestion. For some reason I am unable to mark your comment as the solution. Noting it here

As a workaround, maybe you can use numeric values to represent the level of maturity. 

For these two tables, you could add a conditional column which lists unique numbers for each level type. Then, in data table, refer to numerical column via LOOKUPVALUE so that text values are converted to numbers. Add numerical column to chart visual.