arrow_back Retour aux freelances
F

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

Freelancer

Partager:
placeIN home_workTélétravail assignmentCDD publicOffre agrégée · IN

eventPubliée le 22 nov. 2026 · verifiedNous avons confirmé le 22 nov. 2026 qu'elle est toujours active

Cette entreprise est la vôtre ?

₹ 1.500 – ₹ 12.500 par projet

À propos de l'offre

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.

Continuez à lire gratuitement

Créez un compte gratuit pour voir l'offre complète et postuler.

  • badgePortfolio visible par les entreprises
  • notificationsAlerte de nouvelle offre par e-mail
  • favoriteAbonnement gratuit, résiliable à tout moment