BI In Cloud -Part 1
What is Cloud Computing?
Cloud in simple words is 'Pay as you use'. Cloud computing is analogous to the way we pay for our utilities like electricity or water based on the consumption. The underlying Infrastructure is owned and managed by some third party and cost is billed to us in form of units consumed
a)Demand: - Massive computing power on demand available immediately
b)Unlimited Elasticity: - Infinitely scalable on demand and resources can be released as well when not required
c)Low cost of ownership/ Affordable: - Pay as you use for minutes , hours or days based on capacity used.
Types of Cloud
a)Public cloud: - This is pure form of cloud where infrastructure, service is provided & managed by third party and we pay as we use.
b)Private cloud: - There is lot of debate around whether private cloud is actually a cloud because all infrastructures is still managed and owned by a company. In real sense this is not a cloud but just a internal shared network which is not satisfying the parameters of cloud computing but still a topic worth for a debate because of different view points from Industry.
c)Hybrid cloud: - Combination of private and public cloud.
Business Intelligence / Data warehouse and Cloud Computing.
Growing data in TBytes, high performance expectations, low cost of ownership, easy to acquire, organize & manage are some of the key expectations for any Data ware house application. BI in cloud is a new approach for business Intelligence which can address all future expectations of data warehouse with following distinct advantages
1.No need to install any hardware or software: - Access through web browser ( depends on kind of cloud service)
2.Unlimited bandwidth and geographical scalability: - System will automatically assign or release computing resources based on requirements
3.Shorten BI implementation cycles and help BI implementations to become more flexible & scalable.
4.Pay as you use - If you use less, pay less: - This is as opposed to current scenario where an organization installs their own infrastructure and always pay for the peak load.
5.Common Data exchange method (Transaction data feed to cloud BI):- Lot of items to be sorted out at time of actual deployment.
6.Availability of best-of- breed infrastructure and services with unlimited computing capacity (based on the type of services purchased)
BI Delivery options
Business Intelligence can be on a private cloud or a public cloud depending on business needs and usage type
1.Delivery options based on service :- BI clouds generally have following service options
a)Infrastructure-as-a-Service (IaaS) :- Here vendors like GoGrid ,Rackspace , Right scale or Amazon etc can provide hardware and system software and then you can deploy own BI/ DW applications . Here you only pay for hardware and system software on usage basis but you still need purchase your BI/ DW applications.
b)Platform-as-a-Service (PaaS) :- BI Players like Good Data, Pivot Link etc which provide the BI/ DW platform but you need to develop and deploy the same as per your business requirements
b)Software-as-a-Service(SaaS): -Here vendors like SAP Business Objects ,salesforce.com are offering 'On Demand BI' or prepackaged end to end BI solution with limited customizations. This is typically suitable for SME category for cost advantages and short cycled BI projects.
All these options are analogous to a transport industry
a)Roads are basic Infrastructure (analogous to IAAS )
b)Cars , Buses are the platforms which runs on roads (analogous to PAAS)
c)GPS can guide as how to reach correct destinations(analogous to SAAS )
2.Delivery options based on Usage Type: - Like staging data in local systems but accessing reports in cloud or using cloud for Protypes as a sandbox or a fully live application in cloud.
BI in cloud: - Issues in debate
BI in cloud enables a variety of new possibilities and it can be future of BI looking at the current trneds in BI industry . However, it's not a silver bullet and one might need to evaluate following parameters as well.
1.Easy migration from one cloud to other cloud
2.Common data exchange mechanism: ¬ Data flow mechanism & strategy between local transaction system and BI cloud.
3.Deciding on what should be done locally and what should be done in cloud: - How much to use from cloud as there is too much offered by cloud
4.Security, Risk and Regulatory concerns: -While managing data outside the enterprise, data security can be a key concern .
5.Measuring long term cost of ownership
6.New era BI technologies like in-memory etc: - Are they being developed keeping cloud into consideration.
One should check and decide between overall cost and business value and take a decision based on following parameters
2.Goals:-This might be other business priorities which are not cost driven
3.Type of organization and regulatory requirements
4.Whether it can meet the objectives of organizations
In subsequent blogs , I will focus on following cloud areas
a) Security concerns : What BI Vendors are doing in this areas.
b) BI trends in cloud : Vendors and solutions with focus on SAP on Demand
c) Is cloud a future or just a hype