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.
Our client is a regional transmission organization (RTO) that coordinates the movement of wholesale electricity across several states. To comply with federal regulations, our client is required to post real-time and historical data on its public website. The organization sought to enhance its data governance capabilities to provide a better experience for end users and remain compliant with all regulations.
Prior to this initiative, our client had multiple legacy systems and faced data quality challenges, which were impacting the posting time and reliability of data. Because these legacy systems were not centralized, the data postings were inconsistent and there was no standard method of managing reference data.
The client data was vast and provided business-critical information related to various aspects of the RTO’s operations. Each dataset involved different source systems, loading cadences, quality checks, and other requirements.
This initiative required cleaning and processing bid and offer data, load forecasts, settlements, and sensor data from a Plant Information (PI) Management System. The client’s largest dataset showed day-ahead and real-time Locational Marginal Pricing (LMP) across a power grid for each node where electricity could be purchased across the entire territory.
After performing a discovery exercise, Keyrus determined that the goal of the project was to create a system that allowed end users to access and understand current and historical data for 55 datasets from the past thirty years to satisfy all regulatory requirements.
Using Alteryx, the Keyrus team built custom workflows to first extract and transform data. To prove the reliability of these new workflows, each dataset completed an extensive QA process that was conducted automatically and programmatically using Quilliup prior to being published on the client’s website. The tool also logged data and created audit trails to ensure that data remained reliable and accessible to meet federal regulatory requirements. Finally, the verified outputs were loaded into an Azure Data Lake and posted to the public website.
In addition to the technical implementation, the Keyrus team also developed extensive documentation and provided training resources to the client, to ensure that the operational processes worked smoothly.
After the implementation of this process, our client can be confident that the requisite data is being posted to their public website in a timely fashion so that they remain compliant with federal regulations.
The solution created reliable, uninterrupted service, and an easy-to-maintain hub. In just six months, Keyrus delivered over 50 different workflows to help the client serve end users.
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.