CloudMBI™ Data Warehouse

CloudMBI™ is BIAnalytix in the Cloud. CloudMBI™ has all of the components necessary for successful execution of an enterprise media data warehouse in the cloud, including:

Simple Extraction

A simple and well defined data extraction process for any operational system to well defined, purpose built staging schemas.

Working ETL

A predefined and working ETL process to ingest the periodic granular data into a rich, global Media star schema that can accept diverse data sources.

Media Star Schema

A pre-designed, Media-specific star schema that assembles all the complex relationships correctly as they are delivered by the ETL.

Media OLAP Cubes

A rich set of OLAP cubes that provide the millions of totals necessary for comprehensive analysis and reporting across all data sources.

Media Port

A portal and reporting layer that includes pre-designed industry analyses and KPIs.

This solution is implemented using the Microsoft BI Stack on the Windows Azure Cloud Architecture.

CloudMBI ™ does not displace any existing, in-house BI toolsets that other vendors provide or solutions that may already be in place in the corporation. This is because the CloudMBI™ solution is designed to support access to cubes and reporting using third party presentation tools from multiple vendors. Consequently existing BI toolsets could be used for the presentation layer, though not for the ETL, Star Schema or Cube implementation.

As with BIAnalytix, CloudMBI supports a rich set of Modules covering the spectrum of media, advertising, entertainment and Telecommunications. These are outlined in more detail under Solutions, however in summary they address all traditional and emerging media and advertising models. In summary they include the following:

The architecture to execute these various module in the cloud is outlined in CloudMBI™ Architecture.