Daily analysis of a store’s activity


Agency managers need to analyse the daily activity of their store (CA, stock, budget, objectives…) and their sales representatives (number of customer visits, number of accounts created…). They must receive each morning this dashboard in PDF format by e-mail, on the activity of the day before

Targer User Population

Agency managers

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

Creation of the dashboard with Microstrategy:

  • Collection of customer needs
  • drafting technical specifications
  • development of reports + dashboard
  • revenue + improvements
  • delivery + creation of a subscription for sending by e-mail to a specific group of users (agency managers)

Process and Sourcing

  • Sourcer data are stored in the company’s ERP (x3). They are integrated every night in a relational database (Sybase) via the Oracle Data Integrator (ODI) ETL.
  • Mircrostrategy Sybase source to power the dashboard