BI for Paper Manufacturing Company

CUSTOMER

One of our client has a Paper Manufacturing Firm which manufacture wrapping papers for retails stores. They had a huge plant who has a plenty of labours and machineries from which they want to predict the current statistics of our Plant Operation

CHALLENGE

Client wanted to predict what was happening in their company regarding labour and machineries. In case of labour and machineries details, we need to get over all data where the data were not in proper format. So he indeed of analyzing tool to perform statistical analysis in depth and came up with these insights,

• Labour - Overall Cost and Worked hours
• Machineries - Overall run-time, efficiency, cost

SOLUTION

To ensure the overall cost, run-time and efficiency of machineries and overall cost and worked hours based on cycle, we modelled the data structure and provided following specific features,

• Structure data processing for modifying the historical data
• Incremental Load Modelling for further incoming data to be in
  correct format

After presenting the specific features for each solutions, we came up with the final version of visualization

RESULTS

At the end of the project, the Client received a top-level visualization that ensured the birds eye view reporting. The report contained cost estimates as well as analysis of result from multiple angles

TECHNOLOGIES AND TOOLS

MySQL Server 2015
EXCEL, CSV Files
ODBC Connectors
Dot net (4.5.4)
QlikView 12