Business decisions are nowadays data driven and organizations have a lot of data collected and stored in their data warehouses, data stores,etc. These are just raw data and are of no use directly. So Organizations have to use Business Intelligence tools which can help then transform and visualize the data. Visualization plays an important role in understanding the data and finding if the data follows any particular pattern. For this purpose, Tableau is one of the top preferred software tool. It is simple and can be used even by non-technical people. It provides an option to create an interactive dashboard which is very helpful in monitoring and presenting the data. Tableau is very fast and efficient and can handle millions of rows of data. Tableau can do data blending, real time data analysis, and can combine and extract data from multiple sources.
Tableau to cloud:
Tableau is a must have software tool for almost every organization. But using Tableau in an on-premises setting may prove costly. Company has to buy expensive hardware for data storage, their maintenance and scalability becomes an issue. Nowadays organizations use cloud services to store their data and it is totally managed by service provider. It becomes affordable to scale in and out and archive data for long time. So Migrating Tableau to the cloud can prove very beneficial. It can help in providing better accessibility, uptime, and would be reliable as cloud infrastructure is disaster proof, multi-region, and fault tolerant. One method is to move the Tableau setup to Amazon Web Services.
For setting up the cloud infrastructure on AWS, the following steps are to be used:
We have to use a EBS volume of at least 100GB to install Tableau Server.
- Creating a Virtual Private Cloud-
A VPC with EBS of 100GB is sufficient to got up to 10000 IOPS which will help in processing a large number of data. For the first step you have to set up an AWS account and then go to the VPC service section. Then select a region that is closest to the organization’s geographical location. Then create this VPC on amazon. This VPC enables us to launch different AWS services on virtual cloud same as that of on-premises setup which can also be scaled according to the needs.
- Networking and security-
After launching VPC, we have to configure networking and security. We have to go to security in AWS and create a new security group.Here we have to specify the inbound rules which allows traffic to enter the private cloud. We have to give access to HTTP(80),HTTPS(443) and RDP(3389). This will enable access by organization to the VPC.
- Launching Amazon EC2 instance-
We have to create an Elastic Cloud Compute (EC2) service. We have to choose a region that is closest to organization as done during VPC. Then use an Amazon machine Image(AMI). This is a file that has details of the exact setup image that is to be created to fulfill the requirements of Tableau Server. Then configure and add the security group created to the instance and launch the instance.
- Creating an elastic IP for launched VPC- we have to configure VPC and assign an elastic IP address. Elastic IP address is an IP that is fixed and is reserved to a particular organization.
- Installing Tableau Server- Login to EC2 instance and then connect it to remote desktop for access. Then we have to install the Tableau Server on the instance. This will create a Tableau setup on cloud. Then we can redirect and shift the data operations from local Tableau setup to AWS Tableau server.
A Tableau cloud setup is a more efficient and reliable solution. Also the companies can migrate their data storage, compute and processing as well as their Machine learning solution to the cloud which will save lots of expense to companies.