LAVastro
Excel

Telco Excel Report

Damir B.
#excel#powerpivot#datawarehouse#sap

Client: EU Telco
Year: 2020-2021

The clients’ requirements were to create a single report that would connect data from its data warehouse, custom databases into one single report. The report had several section:

  1. Current performance of ICT portfolio (financial and non-financial) in form of tables and charts
  2. Performance prediction
  3. Simulation via paremeters
  4. Custom database for revenue projections and actuals
  5. Connected filtering cross sheets
  6. Data ingestion via PowerPivot
  7. Security in order to allow only users on company domain to open the file

[Top]

← Back to Projects