Monitor the daily activity of the sales team’s product statements

Context

Willingness of sales representatives to follow their daily activity in terms of product statements.

Targer User Population

Sales force / Market Managers

Succinct description of the implementation of this application and its added value

Realisation of an SSAS cube allowing sales representatives to manage their business independently.

 

  • Creation of a SSRS portal allowing sales representatives to manage their activities thanks to the following modules:
  • Linear tracking: Linear share of linear, linear measured, linear total…
  • Presence monitoring: Rate on presence, number of products surveyed, number of mandatory products…
  • Follow-up Activity: Objectives of visits, number of visits carried out, Date of last visit…
  • Monitoring Budget: Budget used, budget allocated, remaining budget…
  • Commitment monitoring: Monitoring of unit commitments…

Process and Sourcing

  • ETL: Informatica

     

  • Reporting: Cube SSAS + reporting SSRS