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:

Cable, MSO, Sattelite, Telco IPTV

  • Traffic and Billing
  • Accounts Receivable
  • Audience Analysis
  • Web Sites
  • Proposal
  • CRM
  • Interactive TV
  • Subscriber Billing
  • Equipment Analysis
  • Service Jobs
  • Channel Viewing

Cable Networks

  • Traffic
  • Proposals
  • Audience Analysis
  • CRM
  • Accounts Receivable
  • Program Amortization

Broadcast Television Stations, Radio Stations and Networks

  • Traffic
  • Proposals
  • Audience Analysis
  • CRM
  • Accounts Receivable
  • Program Amortization
  • Radio Affiliates

Print Display & Magazines

  • Traffic
  • Proposals
  • CRM
  • Accounts Receivable

Advertising Agencies

  • Campaign Planning
  • Linear audience data
  • Website bookings and Ad Server tracking
  • Linear Media Bookings
  • Print Bookings
  • GEO mapping
  • Accounts Receivable

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