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.
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.
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.
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.
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).
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.
Press release
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
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
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
Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit
Press release
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
Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)
Webinar
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
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
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
Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.