Contact info: office@maxconsolidation.com

Excel based remote reporting solution

  • Multi-user solution including access right management and Microsoft authentication
  • Data is saved in central database located in Microsoft Azure cloud
  • Data is entered locally using Excel-form and/or tables
  • Defined dimensions enables different viewpoints, like
    • Revenues, profits and profitability by Organization, Customer, Project, Product Group
    • Drilling down to detailed Organization, Customer, Project, Product Group information
  • Targeted email notifications enables management of reporting processes
  • Reports and graphs can be generated with encompassing PivotTable, PowerPivot and/or Power BI tools

Reporting

Remote reporting using one or multiple Excel-forms

Reports

Reporting and DashBoards in Excel, PowerPivot, PowerGraph and/or Power BI

Reporting forms

  • Excel forms and tables are used for reporting
  • Based on user access rights reporting is directed to right organizations and other dimensions
  • Changes made can be followed and cancelled or changed by the users that have authority to do so

Consolidated report

  • Users can generate consolidation and aggregated reports of all data entered that they have right to access
  • You can have different views in your report based on available dimensions, like organization-view, project-view etc.

Calculation fields and meters

  • You can add calculation fields to reports, where you can utilize Excel-functions and database data
  • You can generate Dashboards using Excel, PowerPivot and/or Power BI