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
