endorsedCompleted

Power BI Financial Dashboards for Advertising & Big Data Company

Services Covered:

Big Data Analytics and Business Intelligence

Industry

Advertising & Marketing

Duration

2 months

Budget

10K - 49K

Start Date

1 January 2020

Team Size

1-5 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

76/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

Confidential

Kuala Lumpur, Malaysia

Project Summary

Polestar built a suite of Power BI dashboards and reporting processes for an Asia-Pacific digital advertising and big data services company, replacing manual Excel reporting. The dashboards are in regular use, received positive internal feedback, and the client is planning a Phase 2 expansion. The engagement included data modeling, visualization design, and training for the client's team.

Key Challenges

Transition from Excel-based manual reporting to automated reporting
Reduce reporting time and minimize risk of errors
Provide on-demand, visual reporting that is easy for users to access and use

Project Deliverables

Power BI dashboards for financial analysis (P&L, headcount, revenues, expenses, KPIs)
Data model and reporting processes
Training and handover for internal resources
Power BI implementation guidance and best practices

Project Solution

Polestar defined the client's Power BI journey, modeled and prepared the data, built reporting processes, designed effective visualizations and implemented a suite of Power BI dashboards covering financial metrics. They trained the client's resources to own and update the dashboards and provided a dedicated Power BI developer with senior resource augmentation as needed.

Project Outcome

Dashboards are in regular monthly use with good Phase 1 coverage
Intended user audience adopted the dashboards and the client is planning a Phase 2 expansion
Smooth collaboration enabled meeting targets and deadlines

Platforms

SaaS

Tech Stack

Power BI

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The dashboards are currently in use by the client and have received positive feedback from the internal team. Polestar Solutions & Services collaborates successfully with the client to ensure a smooth workflow. The team is hard-working and professional.”
Prateek Basu
Head of Planning & Enablement
Date: 07/07/2020