You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

Leveraging AWS to automate reporting at Atlas Machine & Supply

By Amanda Glavocich

Background

Atlas Machine & Supply (“Atlas”) is a heavy-capacity industrial machinery manufacturing company specializing in areas such as compressed air and machining and repair. Their work has been delivered across virtually all industries that produce physical processes via machinery. Since 1907, Atlas has expanded its reach throughout the United States and positioned itself as a leading provider of manufacturing and repair needs, contributing to high job volumes across their eight facilities. 

Challenge

In order to schedule and monitor the high volume of manufacturing jobs, Atlas utilizes scheduling software called Just Plan It. This software houses job and task data such as planned and actual start and end times, statuses, resources, and capacity that all add to an increased understanding of organizational productivity. While valuable data was collected in Just Plan It, retrieving that data was a manual and time-consuming process, making internal reporting a difficult task. 

Without a direct pipeline, Atlas would have to continue to access this data via manual pulls, delaying access to critical organizational productivity and scheduling data. Atlas approached Keyrus as they looked for a solution to pull their data from Just Plan It on an automated schedule and land it in Amazon Redshift to facilitate internal reporting in Tableau. 

Solution

Through conversations with the Atlas team, Keyrus learned about the availability of Just Plan It’s production scheduling API, and explored potential integration options. Keyrus recommended developing a pipeline that would effectively connect Tableau to the scheduling data via a multi-tool solution.

In order to facilitate automation, Keyrus utilized Amazon Sagemaker as an intuitive and cost-effective tool to run a Jupyter notebook on a daily schedule. Within the Jupyter notebooks were blocks of code utilizing Python’s boto3 library that enabled data ingestion, data structuring, and creation of tables and views in Redshift.

Lambda functions were first used to ingest data from the REST API, which was loaded into S3 buckets in parquet file format. AWS Glue Data Catalog and AWS Glue Crawler were then used to define the table schema of the parquet files. Once table definition is defined in AWS Glue Catalog, the notebook utilizes Redshift Spectrum to create external schema in Amazon Redshift to which tables and views are created that may be used as data sources in Tableau.

Results

Today Atlas no longer needs to spend hours per month manually pulling and organizing the high volume of manufacturing jobs data. Atlas managers can spot status, resource, and capacity issues, drill into root causes, and communicate results with the time that they used to spend just collecting the data. This is critical because continuously improving organizational productivity directly affects Atlas’ bottom line.

Keyrus & AWS Keyrus is a global consultancy specializing in building modern analytics platforms in the cloud.  We are an Advanced Tier AWS Consulting partner with over 20 certifications, 3 accredited service delivery programs (EC2 for Windows Server, Service Catalog, and Redshift) and are part of 2 partner programs (Solution Provider and Public Sector Partner).

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Press release

Keyrus named amongst Top B2B Companies on Clutch

December 12, 2022

The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader. 

Webinar

PDF Parsing with Alteryx Intelligence Suite

December 1, 2022

In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.

Webinar

Modern Cloud Analytics in Action: Keyrus and Red Ventures

November 11, 2022

The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.

Event

Pharma/Biotech GTN Summit 2022

October 27, 2022

Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit

Press release

Keyrus Achieves AWS Data and Analytics Competency Status

October 6, 2022

Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.

Webinar

Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)

October 19, 2022

Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)

Webinar

Tableau Embedded Analytics: Optimizing insights from Salesforce data

September 20, 2022

Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.

Success story

How C&S Wholesale Grocers maximized ROI with an analytics center of excellence

September 7, 2022

C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.

Success story

Implementing a cloud security automation tool at a global consulting firm

September 2, 2022

Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.

Success story

Leveraging Salesforce to improve operations at Pajama Program

July 25, 2022

Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.

Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection