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
MORE CASE STUDIES
BI FOR HEALTHCARE INDUSTRY
Our Client has a hospital at his own town and wanted to analyze their 5 years of Health care data to know more about their business flow for following metrics,
View
BI FOR MIGRATE APPLICATION FROM SISENSE TO TABLEAU FOR TELECOM INDUSTRY
Our client running a business on Telecom Industry and all his BI application were placed in Sisense software. He wanted to migrate the application from Sisense to Tableau Software due to following reasons
View
BI FOR FLIGHT DATA ANALYSIS
Our Client has Airline Operating company which was specializes in airline crew and flight schedule management solutions. They have a multiple carrier operating regions where they have multiple airlines. Due to some issues, they wanted to switch over their business into new location so they wanted business intelligence solutions to found out the most requested feature such as existing and potential customers along with some metrics.
View
BI for Paper Manufacturing Company
One of our client has a Paper Manufacturing Firm which manufacture wrapping papers for retails stores.
View
BI for Supermarket Store
Our Client has a well recognized Super market store has multiple products at multiple location and they wanted to predict their sales and market statistics which would allow their business to move on next level based on the analysis
View