Power BI Sales Dashboard for an FMCG Company (Primary and Secondary Sales)
₹1500-12500 INR
Posted 1 minute ago
•
Ends in 6 days
₹1500-12500 INR
Paid on delivery
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.
Project ID: 40830188
About the project
2 proposals
Open for bidding
Remote project
Active 12 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
2 freelancers are bidding on average ₹7,250 INR for this job


Hello, I have built Power BI sales dashboards for FMCG and distribution teams before, with primary and secondary sales sitting side by side. I can share one or two screenshots with dummy data so you can see how the drill-downs and layout feel in practice. For your setup I would use a clean star schema: separate fact tables for primary sales, secondary sales, and targets, all linked to shared dims for date, region or territory, distributor, product or SKU, and salesperson. That keeps company-to-distributor and distributor-to-retailer numbers clear, while Overview still shows value, volume, target vs actual, and growth in one place. On targets at mixed levels, I keep each target at its real grain. If a target is set by region but sales land at SKU, I do not invent fake SKU targets. You compare where the levels honestly line up, so % achievement stays trustworthy and nothing gets double counted when you filter by brand or channel. Pages would match what you listed: map drill-down by state to territory, distributor stock and days of inventory, product mix, outlet coverage, salesforce vs target, schemes and returns. Filters for date, region, GT / MT / e-commerce, brand, and category. Refresh via gateway or SharePoint or OneDrive, plus RLS so each regional manager only sees thei...
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗