Human Resources Sample File - Employee Table

Hi,

I was wondering if there is a sample work or sample dataset to be able to visualize the following:

there are operations which contain a certain number of products and steps to be finalized and I need to see the status of each of these ccomponents and current status of the overall operation? So, to make it clear let say A1 operation has x1,p1,x2,p2: 'x' representing an operation step and 'p' representing a product in that operation and I have a certain time frame from 1st of April until 26 April to deliver it. Now I want to visually see what is the status of overall operation and which step or product is defaulted? I think it makes sense to use colors but what visuals to use and how?

The db is a SAP one and I like to know what is best way to connect and get data frm the db nightly?

2- I also need to se what is my current inventory level to be able to make decision about my processes...

thanks in advance