Datawarehouse- & BI Solutions
- Core functions: Data warehousing, reporting, analytics, cockpit, data mining, scorecards.
- Main applications: SAP BW, Oracle DWH, Hyperion Interactive Reporting.
With Business Intelligence (BI), Axpo Informatik supports business processes by providing the appropriate KPIs, management information and reports. This enables efficient, prompt management of business operations. Risks and exceptions in day-to-day business are recognised and dealt with early on.
Data Warehousing
Data from a variety of sources are combined in a separate analytical environment; this can be a Data Warehouse (DWH) or multidimensional cubes, e.g. based on SAP/BW, Essbase or Microsoft.
These analytical data storage systems are optimised so they can handle fast, flexible analysis, and discrepancies are eliminated. This important process is called Extract Transfer and Load (ETL).
Reporting and Cockpits
Our solutions are as varied as your requirements. Here are three examples of projects we have completed:
- Finance cockpit for a division
- Report with Meteo-Forecast for the prognosis of short-term usage and regulation of the energy trade
- Automated generation of periodic reports for external authorities
We use products made by leading manufacturers: Oracle BI, SAP BusinessObjects, SAP BW and Microsoft.
Axpo Informatik AG Offer
- Development of a KPI map, e.g. based on a Balanced Scorecard
- Generation of a needs assessment regarding reports
- Joint development of a BI strategy and architecture
- Implementation and operation of the BI landscape
- Implementation of reporting books (highly standardised collection of analyses, with periodic data updating)
- Development of data collection for ad hoc analysis, including training and support of power users
- Design of management cockpits and dashboards
- Specific solutions for trend analyses and simulation