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 (the Foundation) is a nonprofit organization dedicated to advancing the frontiers of mathematics and basic sciences. The Foundation provides grants in four areas: Mathematics and Physical Sciences, Life Sciences, Autism Research, and Outreach & Education. These initiatives pursue potentially ground-breaking projects that demand sophisticated management, financial analysis, and detailed tracking of project milestones and results.
The Foundation's finance department was using Excel spreadsheets to track performance statistics crossing the many domains it supports, including cost centers, events, awards, and ongoing investments. Such limited technology made data quality and governance very difficult. Updates were an expensive and risk-prone manual process.
Keyrus proposed and implemented Semarchy to eliminate these costs and risks. Semarchy is a Master Data Management platform that maintains a golden record as a single source of truth across an organization.
Keyrus used a four-phase methodology to implement Semarchy: Discover, Design, Build, and Deploy.
Discover: During the discovery phase, Keyrus met with finance and technical experts to attribute definitions, review existing procedures for updating data, and review the frequency of those updates.
Design: Keyrus built an Entity-Relationship model to unify the Foundation's domains under Semarchy. This model led to the creation of a Data Catalog that documented required meta-data and necessary data validations and transforms. Keyrus designed a Semarchy UI to meet end-user expectations.
Build: Keyrus created and installed the many pieces required by this project. These included SQL Server database objects and Semarchy components such as data validations, UI prototypes, workflows, automated email notifications, and role-based security. After demonstrating this implementation, Keyrus worked with end-users in a rigorous UAT regimen.
Deploy: As it always does, the UAT process brought forth possible refinements and improvements. With those improvements implemented, Keyrus deployed the solution to the Foundation’s production environment. The solution is used by their finance team and administered by their technical team. Implementing Semarchy has streamlined the finance team's processes, brought data quality to the forefront, and provided an audit trail that tracks attribute-level changes.
An Entity Relationship Diagram (model) that defined all tables, attributes, and data types required by the system;
A Data Catalog used as a reference for all meta-data related to the Semarchy implementation, including data validations and attribute definitions;
An on-premises Semarchy Platform which the finance team uses daily to track all master attributes, replacing far less capable spreadsheet technology.
The solution centralized data quality and data governance functions and streamlined audit trails. These improvements allow the Foundation to reduce hours of work on manual updates, allowing their finance team to work more efficiently on other tasks. High data quality also allows the finance team to create awards and grants quicker, leading to more potentially ground-breaking projects.
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.