Establish daily sales reporting


Re-engineering BI tools following the implementation of a new SAP ERP system

Target User Population

Finance / Sales Force / Financial Controller

Description and value added

Making reports that allow to:

  • Track goals and sales of the sales force
  • Analyze sales and goals of the sales force
  • Analyze return rates
  • Establish KPI’s
  • Track a distribution sample
  • Create an application to track the profitability and loss of the company/products/customers on site
  • Establish a budget year simulation tool
  • Establish reporting that generates analysis of financial KPIs
  • Create a consolidated application for different companies

Process and Sourcing

  • SAP data that transforms with an ETL (informatica) and then goes into an internal data warehouse
  • Reporting Microstrategy
  • Data Entry ESSBASE