Data Warehouse, ETL, OLAP - making SAP BW end-user friendly
Business Intelligence solutions simply access back-office systems to give a smart view on data, allow to drill down and alert on KPIs (business critical key performance indicators). The industry and size of the company determines whether this shall be done via an additional data storage layer (the data warehouse) or directly on the life data of the production system. There is no general wisdom what is the better. It simply depends on too many factors such as stress on the production system, need for real-time data to decisionmakers.
Especially in SAP environments the additional stress to the production machine becomes a costly exercise if additional hardware is on order. At Smart-View we can connect to both: directly to the back-office data or to a (well-designed) data warehouse.
What Panorama BI can do for SAP customers:
- Direct connectivity to SAP BW without any data extraction
- Complete and integrated solution: Analysis, Reporting, Dashboarding, Scorecarding, Modeling & visualization
- Advanced caching and connection pooling for the best BW performance available
- leverage the BEX pre-built quarries to all information workers and enable intuitive interactivity
- Web based and MS Office front end for all BI activities (Mendocino like)
And additionally to that:
Non SAP and Mixed environments:
- SQL Server based ETL, DW and OLAP
- Complete and integrated solution: Analysis, Reporting, Dashboarding, Scorecarding, Modeling & visualization
- Advanced caching and connection pooling for the most scalable BI solution on Analysis services
- The most integrated BI solution on the MSFT Platform
- Pervasive delivery of BI through SharePoint, Dashboards, SAP Portal, Excel, PowerPoint, Visio and more
