Reporting & Analytics

As Smart devices collaborate with each other, the amount of data generated is slated to grow exponentially. The rich flow of monitoring data from smart devices enables service providers and their customers to monetize product performance in numerous ways. This ability to unlock the full value of data is essential in order to compete effectively in the usage economy.

Most companies spend a significant amount of time curating the data and not enough time for actual analysis. This in turn means that they are leaving possible revenue on the table. A challenge is that the data from connected products and related business data are often unstructured. Conventional approaches to data aggregation and analysis, such as spreadsheets and database tables, are ill-suited to managing a wide variety of data formats.

The EngageIP Platform addresses these issues through multiple mechanisms including a powerful and flexible reporting framework. The EngageIP Reporting framework has the ability to report on customer activity over the course of the relationship. These include the products they have had, usage history, changes they have made and so on. EngageIP ships out of the box with precanned reports.

ReportsDescription
Sales ReportsMeasure product performance, what’s been sold, when, and by whom.
Revenue ReportsDetail revenue recognition by accounting period to provide a meaningful measurement of business performance
UsageProvides a breakdown of usage per service type definition.
AccountsAccount level insights such as transaction summary data, payments and transactions
InvoicesInvoice summary data including package details, adjustments and balances

Data Sources

EngageIP stores persistent data in SQL tables. EngageIP provides facilities to report on this data through Data Sources. Data Sources can be created from one or more related SQL tables as depicted in the Figure below.

Diagram

Reports are created from data sources. A data source is a superset of data organized by functional relationships. EngageIP ships with a default set of data sources covering categories like owners, accounts and subscriptions, usage and buckets, etc. These built in data sources which can be found in the data management section in the operations tab. Each data source lists the data columns in the report.

Screen Shot

Report Builider

One or more reports can be created from each data source. EngageIP provides a user interface for report creation that provide facilities for the user to select the data source and data source columns that are part of the report. Additional layout properties can be established such as titles, and layout options such as page sizes, formatting, margins. Reports can also be previewed prior to being generated.

Screen Shot