Brief

Allows wireless network engineers to see a status of their network aggregated to markets and drillable to an individual cell or even a handset/call. It displays key performance indicators in various dashboards, reports and puts cells shaded by selected KPI on a geographic map. It provides Web UI to access the dashboards/reports/map layers.
User navigation along any axis of interest (such as network hierarchy or time) is handled instantly by displaying the requested data in no longer than 5 seconds.

Architecture

• ETL gathers data from heterogeneous data sources – ASCII or Excel files, database tables of various RDBMS.
• Data transformation routine stores data in Oracle data warehouse in a uniform way
• Aggregations are applied to raw data in order to pre-calculate key performance indicators and store them in the form ready to be presented to end users
• Microsoft SQL Server Analysis Services are used as OLAP engine. Multiple OLAP cubes are built upon data warehouse and used for instant access to any slice of data.
• Microsoft SQL Server Reporting Services are used to present requested data in tabular or chart forms.
• Oracle MapViewer component of Oracle Application Server is used to plot spatial information about wireless or customer-related artifacts on geographic map.