endorsedOngoing

Power BI Analytics for SALINOR (Salt Producer)

Services Covered:

Big Data Analytics and Business Intelligence

Industry

Engineering & Manufacturing

Duration

63 months

Budget

10K - 49K

Start Date

1 May 2021

Team Size

1-5 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

78/100

Good

Project Capability Score (PCS) estimates how capable BIX Tech is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

SALINOR

Rio de Janeiro, Brazil

Project Summary

A salt production company (SALINOR) engaged BIX Technology to build datasets and Power BI reports to automate Excel-based analyses across business areas. BIX created datasets and reports covering Production, Finished Product Inventory, Human Resources and Supplies. The work identified data inconsistencies and enabled process improvements, including new analyses and faster HR reporting, with an estimated reduction of 80 hours of work per month.

Key Challenges

Build datasets and Power BI reports for business areas
Automate analyses that were previously carried out in Excel
Provide reporting across Production, Finished Product Inventory, Human Resources, and Supplies

Project Deliverables

Datasets for business areas
Power BI reports for key business indicators
Reports for Production, Finished Product Inventory, Human Resources, and Supplies
Automation of analyses previously performed in Excel

Project Solution

BIX built datasets for the client's business areas and developed Power BI reports to surface key business indicators. The vendor's scope included automating analyses previously done in Excel and delivering reports for Production, Finished Product Inventory (loss and return analysis), Human Resources and initial work on Supplies. The engagement started with two resources and continued with a BI consultant responsible for development.

Project Outcome

Errors and data inconsistencies identified across business areas enabling improved collection and analysis.
New analyses created leading to improvements in the production process.
HR indicators improved and delivered faster, with new absenteeism and overtime analyses.
Improved loss and return indicators for finished product inventory.
Estimated reduction of 80 hours of work per month.

Platforms

SaaS

Tech Stack

Power BI

Client Endorsement

Overall Review Rating

4.88

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Thanks to the analysis work carried out by the BIX Technology team, the company was able to identify several data inconsistencies and errors. Because of the team's important contributions, the company can improve their overall processes which will translate into more efficient production.”
Vinicius Lança
Systems Analyst
Date: 09/21/2021