arrow_back Volver a las freelances
F

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

Freelancer

Compartir:
placeIN home_workRemoto assignmentPor contrato publicEmpleo agregado · IN

eventPublicado el 22 nov 2026 · verifiedConfirmamos el 22 nov 2026 que sigue activo

¿Esta empresa es tuya?

₹ 1.500 – ₹ 12.500 por proyecto

Sobre el empleo

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.

Sigue leyendo gratis

Crea una cuenta gratis para ver el empleo completo y postularte.

  • badgePortafolio visible para las empresas
  • notificationsAlerta de empleo nuevo por correo
  • favoriteSuscripción gratuita, cancela cuando quieras