How Alghanim standardized collaborative workflow creation by implementing the “Alteryx Sandbox Server” platform on AWS that paved the way for 20% better business predictions - Beinex
Tableau Free Trial Alteryx Free Trial Aurex Free Trial

How Alghanim standardized collaborative workflow creation by implementing the “Alteryx Sandbox Server” platform on AWS that paved the way for 20% better business predictions

About Alteryx Sandbox Server

Alteryx Sandbox Server gives organizations the ability to access, manipulate, analyze, and output data. The Alteryx Designer product allows people to build workflows that step through complex processes logically. Some workflows are performed once to answer a question; some are performed many times to automate processes like reconciliations. Other workflows are built to refresh complex dashboards built with Alteryx, Power BI, or other platforms
7 Jul 2023
admin

    Interested in the article or the service offering? Get in touch with us:


    Challenge

    1. The IT infrastructure of Alghanim where the Alteryx Sandbox Server platform was hosted was in an on-premise datacenter which was designed to be scalable and robust with multi node physical clusters including the server, storage and network components. However, most of the physical hardware was quite old and not equipped with the latest generation of physical servers.
    2. Frequent hardware crashes and portal downtime kept troubling the availability of the Alteryx Sandbox Server application. Assigning a touch hand support person to power on the hardware that was down seemed quite impossible due the restrictions during covid period. Hence, Alghanim wanted to look for another viable solution.
    3. Though the hardware setup at Alghanim was well equipped to meet the occasional spikes in the traffic, it was observed that over a course of 6-month time, most of the IT infra was underutilized than predicted. It was realized that spending huge amount of money on an old hardware plus software maintenance, license costs, internet bandwidth, datacenter cooling and maintenance, touch support personnel and electricity costs – were keeping the business operations challenging.
    4. There was an attempt by Alghanim to select a cost-effective solution that can host Alteryx Sandbox Server application servers, web servers and archival data. This way IT infra can be re-provisioned to host sensitive data on-premise and the rest on the cloud, thereby reducing the overall physical hardware costs spent on a yearly basis.

    Why AWS

    1. Alghanim decided to migrate Alteryx Sandbox Server, database servers and archival data to AWS.
    2. The Alteryx Sandbox Server’s AWS architecture includes Amazon Elastic Compute Cloud (Amazon EC2), that provides complete control of its computing resources, updates to tables in Amazon Relational Database Service (Amazon RDS) and AWS Elastic Load Balancer was used to distribute the traffic to the underlying EC2 instances based on the load.

    Benefits

    1. Alghanim uses AWS services to provision infrastructure and deploy the Alteryx Sandbox Server platform to other departments within it. In addition, the Alteryx Sandbox Server resources that are no longer required to be run all the time are made to auto shutdown thus saving cost. Alghanim reported a 30% cost reduction after implementation of AWS for the Alteryx Sandbox Server platform.
    2. The implementation of Alteryx Sandbox Server on AWS made Alghanim confident in the security of its data, and its accreditation team is enthusiastic about the monitoring and auditing capabilities provided by AWS tools. With the implementation of IAM roles, Alghanim IT team was able to isolate systems and tightly control user accesses. These capabilities were harder to achieve within the existing infra but were available out of the box with AWS
    3. By adopting AWS to host the Alteryx Sandbox Server platform, Alghanim has been able to innovate and experiment to a degree previously impossible. For example, Alghanim compared the performance and cost-effectiveness of three different cloud solutions. Without moving to the AWS, the costs associated with running an outdated on-premise hardware would have creeped up and the alternative way of upgrading the existing on-prem infrastructure to the latest hardware models and then hosting the Alteryx Sandbox Server application on top of it would have taken months.

    Tags:

    Related Links

    Beinex Related Blogs

    RUNNING THE MIGHTY SMALL LANGUAGE MODEL PHI 3 ON SNOWFLAKE

    In Artificial Intelligence, the advent of Large Language Models (LLMs) has ushered in a wave of innovation, empowering users
    Beinex Related Blogs

    10 Tableau Data Dashboard Design Hacks for Clear Insights & Faster Decisions

    A dashboard can speak volumes! When the need of the hour demands businesses to rely heavily upon data, dashboards
    Beinex Related Blogs

    The Strategic AI Deployment: Integrating Llama 3 in the Snowflake Ecosystem

    It is 2024, and there will only be a few enterprises which have not yet invested in Generative AI.
    Beinex Related Blogs

    Snowflake’s Evolution: A Look at the New Features in 2024

    Snowflake's journey since its 2014 release as a "cloud data warehouse" has been nothing short of remarkable. It has
    Beinex Related Blogs

    Alteryx Data Preparation: A Key to Successful Data Analytics

    In today's data-driven world, the quality of your data directly impacts the quality of your decisions. Raw data, however,