Power BI Sales Dashboard for an FMCG Company (Primary and Secondary Sales)

via Freelancer ·

Budget / Salary₹1,500–12,500
TypeFreelance project
LocationRemote
Posted1 hour ago
Description

We need an experienced Power BI developer to build a sales dashboard for an FMCG business. The goal is one place where management can see sales performance by region, distributor, product and salesperson, refreshed automatically.

Data sources

Primary sales (company to distributor), from ERP or Excel exports (Tally / SAP / other)
Secondary sales (distributor to retailer), from the DMS or Excel
Targets by month, region, distributor and SKU (Excel)
Product master (SKU, brand, category, pack size), distributor master and outlet master
Sample files will be shared with shortlisted freelancers

Dashboard pages

Overview: sales value and volume, target vs actual (%), growth vs last year and last month, top and bottom regions.
Region and territory: state → area → territory drill-down with a map view.
Distributor: primary vs secondary sales, distributor stock and days of inventory, outstanding payments.
Product / SKU: brand and category mix, top and bottom SKUs, new product performance, price per unit.
Outlet coverage: active outlets, numeric distribution, lines per bill, new outlets added.
Salesforce: performance by sales officer / ASM / RSM against target, productive calls.
Schemes and returns: scheme or discount spend as % of sales, returns and damages.

Requirements

Clean data model (star schema) and well-structured DAX
Filters for date, region, channel (GT / MT / e-commerce), brand and category
Automatic refresh (scheduled refresh through a gateway, or SharePoint/OneDrive files)
Role-based access: each regional manager sees only their own region
Fast to load and easy to read on desktop and mobile

Deliverables

Power BI file (.pbix), published to our workspace
Data model and measure list with short documentation
One handover session (recorded) and 2 weeks of bug-fix support

Timeline: 3–4 weeks.

To apply, please share

One or two FMCG / CPG or distribution sales dashboards you have built (screenshots or a public link with dummy data).
How you would handle primary vs secondary sales and targets set at different levels (e.g. region-level targets vs SKU-level sales).
Your fixed price and timeline.
data processing excel microsoft access business analysis business intelligence data visualization power bi data modeling
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.