endorsedCompleted

Power BI Implementation and Dashboards for Consumer Goods Organization

Services Covered:

Big Data Analytics and Business Intelligence

Industry

Consumer Goods

Duration

4 months

Budget

10K - 49K

Start Date

1 January 2021

Team Size

1-5 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

73/100

Good

Project Capability Score (PCS) estimates how capable Polestar Analytics 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

J L Morison (India) Ltd

Mumbai, India

Project Summary

A consumer-goods organization partnered with Polestar Solutions & Services to implement a PowerBI-based BI analytics system that consolidated ERP and other system data. The system went live and users are pleased with daily morning reports; the team's project management and responsiveness were highlighted as effective.

Key Challenges

Implement PowerBI-based analytics for the organisation.
Consolidate ERP and other system data into an easy-to-use, maintainable BI system.
Create automated data upload processes that do not require technical monitoring.

Project Deliverables

Sales and marketing dashboards
Data model
Automated data upload processes
Daily morning email reports

Project Solution

Polestar conducted a discovery phase to map user requirements and defined the technology architecture. They created the data model, developed ETL/data upload processes, and built Power BI dashboards for sales and marketing that pulled data from the ERP and other systems. The vendor maintained daily operations via MS Teams, implemented automated data uploads that required no technical monitoring, and staffed the project with a part-time project manager, two ETL developers, and one Power BI developer.

Project Outcome

System went live and users are pleased with daily morning reports that show business state as of previous day end.
Effective, responsive workflow with fast issue resolution and occasional after-hours support.

Platforms

SaaS

Tech Stack

Power BI

Client Endorsement

Overall Review Rating

4.63

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Thanks to the expertise provided by the Polestar Solutions & Services team the system just went live and the company is quite pleased with how it is performing. The team's project management style was quite effective and responsive for the project.”
Satish Pai
Head-IT
Date: 06/15/2021