Struggling to find a way to present data.

HI Excel Team,

I am hoping you able to help me.

We have a Date base which tracks key fields for a particular record on a particular table.

I am trying to provide some analysis to present what the changes mean.

For example;

1) For company x have we have made a total of 21 updates since (08/03/2011 -Created Date ) till last edit edit.
2) The most common field updated is "Information Sharing Risk Rating" & "Information Sharing Risk Rating Region" been edited 4 times in x time frame.

Therefore since the company has been created therefore the % of change is low.

I am open to listen to ideas, as struggling to think of a concept.

Hoping you can help , looking forward to your response

Regards
D

Is this an internal or external report? If internal you can deliver the following: I would group by Field / Event and show the percent of changes. The top 2 have 4, the rest have 1. I would also show the time between the changes. This can identify creation errors vs changes needed. The values flip from 1 to 2 back to 1 for Information Sharing Risk Rating at the onset. I would have a change count by year to show changes have been abnormally high for 2017. Can you tie back cost of changes to the changes (resources needed)? Where the changes came from?

For external reporting, the changes right after implementation may want to be avoided. I know this is sample data but there isn't much to work with. Who is the report for and how often will this be requested? Those are things to keep in mind.

I hope this helps.

Hi,

This is a one of report and is for internal purposes. The analysis is to aid a discussion on Monday. The aim of the discussion is to talk about whether we need to build a data sync strategy for the fields listed in the attached. I'm hoping with the data that I have (excluding example attached) that we can agree that the fields rarely change.

Given your scenario above are you able to mock something up?

Any help would be much appreciated.



.

I would only be able to work on this Monday. I'm busy right now. Sorry!