Smarter ideas worth writing about.

Business Intelligence and Big Data Analytics in the Cloud

Challenges to Traditional Approaches

Implementing and managing on-premise Business Intelligence and Big Data solutions is not new but comes with many challenges. These types of solutions demand: high infrastructure requirements, handle unpredictable load volumes, involve a large upfront investment, high development and maintenance costs, longer provision times, and a high reliance on IT.

The Cloud Advantage

The Cloud addresses many of the challenges encountered by traditional on-premise solutions. The Cloud is quickly developing strong solutions for Business Intelligence and Big Data and offers several advantages such as:

  • Speed: Resources are immediately available. The Cloud allows us to reduce or eliminate the long periods associated with infrastructure procurement and application deployment. Ultimately, we’re getting our Business Intelligence and Big Data solutions in the hands of our customers more quickly.
  • Elasticity: The Cloud allows us to utilize the massive computing power available on the web. Furthermore, it provides the ability quickly scale up or scale down based on the needs of the business.
  • Lower Risk: No hardware or software to install or update. You can cancel your Cloud-based subscription at any time, thus reducing the costs sunk into an initiative.
  • Accessibility: Provides access to data that can be delivered anywhere, anytime and on any device.

Cloud Deployment Options

There are few options available for deploying Business Intelligence and Big Data solutions in the cloud.

  • Platform as a Service (PaaS): The PaaS option provides you with a computing platform (hardware and software). PaaS allows subscribers to deploy solutions without having to buy and manage the underlying hardware and software. The hardware and software is purchased and managed by the Cloud service provider. In the Business Intelligence and Big Data world, PaaS offerings include services like databases and ETL/ELT engines. Some examples of Cloud-based PaaS services include Azure SQL Data Warehouse and Amazon Redshift.
  • Infrastructure as a Service (IaaS): Some think of this as Hardware as a service. This option provides the necessary hardware and networking components to its subscribers over the internet. It’s essentially like having a virtual on-demand server when you need it. In this instance, you’re responsible for installing, managing, patching, etc. the software on the server. This means you’ll acquire a virtual server from a service provider sized (CPUs, RAM, storage, etc.) to meet your needs. You now have a blank slate to start your project. Next, you need to select an operating system, database platform and other components to support your Business Intelligence and Big Data project. Just keep in mind the service provider will ensure the hardware is running to meet your SLAs, but you’re responsible for all aspects regarding the software.

To determine which is better for hosting your data assets, you need to understand some key differences. PaaS is typically used by application developers, while IaaS is used by network or infrastructure architects. In other words, PaaS provides a mechanism to develop applications, whereas IaaS provides only the infrastructure necessary to run the code developed by application developers. Another aspect to consider is administration. PaaS performs many of the administrative tasks (e.g. backups, patches, etc.) for you, while these are things you’ll have to manage with IaaS.

Join our 1-hour webinar presentation to learn more about the components of Microsoft’s cloud-based analytics environment, Cortana Analytics.


About The Author

National Analytics Solution Manager

Greg is Cardinal's National Analytics Solution Manager. With his extensive experience in leading and developing data warehouse and business intelligence solutions, Greg has played an exceptional role in building Cardinal's Data Solutions Practice.