DW/BI and Cloud
Computing
As we all
know, Data Warehousing and Business Intelligence has been the key to making
informed strategic decisions for an organization’s success. DW/BI are generally
hosted on servers within the organization so as be accessible to a network of
decision making executives. In order to
meet the increasing demand in data analysis, the varied functionalities
expected from the DW/BI tools, and the enormous data the BI tools handle, DW/BI
has started to move from servers and local machines to the cloud.
Cloud
Computing is big advancement in technology is the cloud. Cloud provides the
biggest advantage of flexibility to organizations to meet with their
fluctuating demands. Organizations are moving to cloud in order to meet with
their requirements in scalability, computing resources, speed, balancing
workloads, storage and reliability. In addition to providing these benefits, it
provides an effective cost-saving option as it meets the need of the house with
flexibility in resources being used depending on the requirement.
With this
introduction on DW/BI on cloud, let’s get into some of the latest advancements that
combines DW/BI with cloud computing.
1. Hautelook with Amazon RedShift:
RedShift is a cloud based, petabyte-scaled data
warehouse service that is available with Amazon AWS. Unlike a relational database,
it holds a column oriented DBMS that is capable of handling large scale
data-sets with parallel processing. Using the Attunity Replicate and Attunity
CloudBeam combines well together which accounts for the flexibility to change
the configurations based on the data needs and thereby achieve high speed
performance. Since the Redshift runs on Amazon AWS, it provides additional
advantage of no hardware/maintenance cost.
HauteLook, a Nordstorm acquired company, uses
Amazon RedShift for its cloud BI solution. It is reported that the company was
able to improve its speed of processing and at the same time maintain the cost
of the data warehousing by moving to Amazon Redshift.
2. P&G with Teradata Enterprise
Analytics on Cloud:
Teradata offers Enterprise Analytics on Cloud. It
offers different variations in the cloud services as seen in the architecture: Private
Cloud, Public Cloud and a Hybrid.
Teradata provides a Unified Data warehouse
architecture using Discovery as a service and Data Management as a service on
cloud. The Discovery platform uses MapReduce functions drives the sophisticated
path and graph analysis on multi structured data to enable rapid exploration and
discovery of data. Data Management module capitalizes Hadoop for large-scale
dataset management which enables better analysis and management of data of any
size.
P&G, a world-class leader in consumer product
industry, uses Teradata Enterprise Analytics on Cloud for their global
marketing. P&G has incorporated Teradata Customer Interaction Manager, Teradata
Master Data Management and Teradata Warehouse miner. Using these the company
was able to drill down and analyze their global marketing campaigns to find out
their effectiveness. The company also talks about the speed of deployment and
low capital costs incurred to set up this analytics tool. The company achieved
creating conversations in cloud with about 4.8 billion consumers and was able
to maintain all this data in one fresh location available for use by all
P&G around the globe.
3. Coach with MicroStrategy Cloud Business Intelligence
Platform:
Microstrategy provides a powerful cloud analytical
BI platform provides self-service analytics, big data analytics and mobile
analytics. The main advantage is that it allows for combining of information
from different systems without the need for any scripting language. It provides
powerful predictive, data integration capabilities, mobile support and advanced
analytical tools to help customers get the best results. The most
differentiating factor for microstrategy is that unlike others, they host their
software in their own data center and also allow customers to keep their data
on their own premise to alleviate security concerns.
Coach is a leading designer accessories company. Using Microstrategy
BI, the company achieved quick BI insights and decision making capabilities.
Some of the main features appreciated by Coach are the re-usable report
templates, timely visibility to key metrics on dashboard, visibility to
granular level of details on the reports and interactive mobile applications.
Resources:
No comments:
Post a Comment