Online Analytical Processing (OLAP) |
| The Task: |
| To create and deploy Cubes that would help to provide filtering, grouping and labeling of data in a data warehouse. Various reports could be generated which could lead to taking decisions for improving the business. |
|
| The Challenges |
| To design a centralized cube that would cater to all kinds of reports required by the client. |
|
| The Solution |
| Binary Spectrum designed the cube which suffices the PMPM reports requirement. It provides for business process improvement wherein the client can identify cost and revenue opportunities using data mining. For example, they can analyze reports like regions where drugs are sold most and make future business decisions based on the analysis. The various reports can be broadly divided into the following categories: |
|
 |
Membership |
|
Provider |
|
Claims |
|
UM – Utility Management / DM – Disease management |
|
|
| The Result |
| The reports created out of cubes helps in business analysis for the client. |
 |
|
|
