JAVA J2EE 4 U

 

To create Power BI versus Validated Result, first prepare a summary table for each week.

Week	Power BI – Human	Validated – Human	Power BI – Automation	Validated – Automation
W25	12	15	38	35
W26	10	8	40	42
W27	14	16	36	34
W28	9	11	41	39

Recommended visual: Clustered column chart

For a clean management view, create two separate charts.

Chart 1: Automation closures

Use:

• X-axis: Week
• Values: Power BI – Automation and Validated – Automation
• Chart type: Clustered column chart

For every week, two bars will appear side by side:

• Power BI reported automation count
• Your manually validated automation count

This makes differences immediately visible.

Chart 2: Human closures

Use:

• X-axis: Week
• Values: Power BI – Human and Validated – Human
• Chart type: Clustered column chart

In Excel

1. Select the columns:
   • Week
   • Power BI – Automation
   • Validated – Automation
2. Go to Insert → Column or Bar Chart.
3. Select Clustered Column.
4. Set the title as:

Power BI vs Validated Automation Closures – Weekly

5. Enable Data Labels so the count appears above each bar.

Repeat the same process for human closures.

Also add a variance column

This shows how much the Power BI report differs from your validation.

Week	Power BI Automation	Validated Automation	Variance
W25	38	35	3
W26	40	42	-2

Excel formula:

=B2-C2

Interpretation:

• 0: Power BI matches your validation.
• Positive value: Power BI reported more automation closures.
• Negative value: Your validation identified more automation closures.

You can also calculate the absolute mismatch:

=ABS(B2-C2)

Best final presentation

Show:

1. Automation comparison chart
2. Human comparison chart
3. A small variance table underneath

Add one observation below the charts, such as:

Power BI broadly aligns with the validated results; however, differences were identified where service accounts were used after manual intervention or where automatically resolved incidents were manually closed by engineers.