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

    Mastering AWS Key Management Service (KMS) for Secure Data Management: Protect, Encrypt, Comply

    AWS Key Management Service (KMS) is a versatile and valuable tool for businesses of all sizes aiming to protect
    Beinex Related Blogs

    Snowflake and GenAI: Revolutionizing Data Analytics

    As a leader in cloud data platforms, Snowflake is at the forefront of integrating AI capabilities. Staying in sync
    Beinex Related Blogs

    Master Data Visualization with Tableau Public: A Guide to Success

    Tableau Public is a free and versatile platform that empowers users to create, explore, and share data visualizations with
    Beinex Related Blogs

    AWS and GRC Framework: A Comprehensive Approach to Secure and Compliant Data Management

    Organizations increasingly turn to cloud computing solutions like Amazon Web Services (AWS) to enhance operational efficiency, scalability, and cost-effectiveness. However,
    Beinex Related Blogs

    Alteryx and Generative AI: The Alteryx Approach

    Generative AI (GenAI), the most groundbreaking technological advancement in recent years, offers transformative possibilities in data analytics. Alteryx, a