A Cloud Computing Business Intelligence Organization

The following are the ideal steps for migrating  a  in-premise  data warehouse  system to a cloud platform, for the sake of case study , Microsoft  Windows Azure platform is chosen  as the target platform.

Integration provides common  Biztalk  Server integration capabilities on Windows Azure, using out-of-box integration patterns to accelerate and simplify development. It as well delivers higher level business user enablement capabilities just as Business Activity Monitoring and Rules, as then as self-service trading partner community portal and provisioning of business-to-business pipelines.  The following diagram courtesy of the vendor shows how the  Windows Azure Appfabric Integration can be used as a ETL platform.

ROLAP :   Relational OLAP is a research that provides sophisticated multidimensional analysis in other words performed on open relational databases.  ROLAP can scale to  large data sets in the terabyte range.

The features

SQL Azure Database does not support all of the features and data types found in SQL Server. Analysis Services, Replication, and Service Broker are not currently provided as services on the Windows Azure platform.

At this time  there is no direct support for OLAP and CUBE processing on SQL Azure,  now with the HPC attributes  using multiple Worker roles,  manually  aggregation of the data can be achieved.

4. Generate ReportsReporting consists of  analyzing the data  stored in the data warehouse in multiple dimensions and  generate standard reports for business intelligence and as well generate ad-hoc reports.  These reports present data in graphical/tabular form and as well provide statistical analysis features.  These reports should be rendered as Excel, PDF and other formats.