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

Optimizing data processes to support a nonprofit's mission

By Kit Germeroth

A large, international nonprofit with a mission to improve quality of life through job and education support needed to standardize data collection and reporting. The nonprofit provides community-based programs and employment placement services and has over 160 member organizations across the nation. Each member has the same general business model but makes minor tweaks to better suit its local community. 

The headquarters at this organization identified an initiative to collect data from each of its member organizations in a more streamlined and scalable manner. 

When we began our engagement, there was no standardized reporting across these independent member organizations. Existing reporting was manually produced and released after the extensive data cleaning processes, delaying valuable insights. Team members were unable to effectively share insights across the member network, and data collection, submission, and validation was tedious and manual. 

Keyrus first performed a discovery exercise with the client that included business, informational, and architectural elements. This allowed us to create a project plan with a phased approach. 

Member Data Ingestion Solution

Members needed to be able to choose from automatic or manual data submission options. The automatic method involved building an API to which members could automatically send their data programmatically. 

To build this solution, Keyrus performed the following tasks:

  • Configured and uploaded a web server

  • Developed and configured file processing routines including data validation checks and alerting features for failures

  • Provided ability to save the data and developed documentation for end users and technical resources

  • Developed and implemented security procedures to protect data from authorized access

  • Developed and tested the API ingestion capability

  • Developed standardized connectors and connector frameworks to/from commonly used member systems to accelerate and de-risk adoption

  • Conducted a trial with pilot members

Both the automatic and manual methods required immediate feedback on whether the data was accepted or rejected. If it was rejected, the system also provided the reason. This meant that Keyrus needed to develop submission templates in various formats (XML, CSV, etc.) with relevant documentation for six different datasets that the members were eligible or required to submit. 

Upon successful data validation, the data is properly structured and inserted into a data warehouse to automatically feed into downstream reporting processes. 

Member Data Transformation & Management

Once a member’s data submission is successfully uploaded, it’s combined with other members’ submissions into a consolidated format while still maintaining both the standard and custom attributes of that member. This allows the members to view the data from two perspectives - both the standardized organization view and the custom view of the specific member. 

Throughout this process, we monitor data quality issues automatically using quilliup to ensure that the data we expose passes data quality checks. In addition, Keyrus deployed a master data management component to harmonize nomenclature and create a common ground for analysis across members. For example, one member might use the terminology “t-shirt” while another used “short sleeve shirt.” The MDM component categorizes these two options as “textile,” thus enabling grouping and comparisons. 

Member Reporting & Analytics Solution

The client’s business goals were to track growth for each member and compare the members to one another on a variety of metrics spanning multiple business units. They requested to see how the members’ performance stacks up for various categories and departments over time so that each member could identify areas of improvement and act on them. This is a challenge because many members track their data differently, meaning data is collected at different levels of granularity and with different nomenclature.

After building the relevant DWH and MDM solutions, Keyrus created five Tableau dashboards for thousands of end users. A common theme through all of the dashboards is to present national and regional benchmarks so that members can spot actionable gaps in performance.

  • The first dashboard gives an overview of a single member’s sales and donations for high level executives.

  • The member could then move to an analysis dashboard where they compare all of its locations to one another. They are also able to select a subset of their locations to compare in this dashboard, which would be useful for a regional manager.

  • The third dashboard drills down to a single location’s data. This gives a store manager a deep dive into how that location is doing in all aspects of business.

  • The final two dashboards allow the member to compare itself to other members and locations. There is a characteristics dashboard where the member selects the characteristics they want to compare against. This is valuable in cases where they only want to compare against similar members (for example in size, geography, and local demographic). It’s also valuable in cases where the member is considering modifying their operating model and want to compare themselves to members who already operate differently. Using this dashboard as a filter, the member then moves to a comparative dashboard that does a side by side comparison of the selected members.

  • Lastly, Keyrus provided help pages to explain each dashboard as well as a data dictionary to clarify any calculations that are on these dashboards. 

Change Management

We began the change management process by building a change management plan with the client. We started with a controlled roll-out plan to a pilot audience before continuing to a wider rollout, including communication, training, and support.  

  • Communication: A cascading communication line from management to the members of the initiative, including user group meetings and feedback surveys, to educate members on the initiative’s purpose and benefits and to promote buy-in.

  • Training: Created role-specific walkthroughs to utilize each Tableau dashboard for common analysis scenarios. Utilized these in Train-the-Trainer content to enable the client to scale their rollout. Train-the-Trainer sessions were recorded and documented.

  • Support: We have created a support methodology based on “office hours” each week, a common Sharepoint feedback portal, specific shared email lists, and even commentary on the actual Tableau dashboards. We also have a proactive support function which monitors actual usage of the dashboards and alerts us to members who are or are not using the system.

A foundation for data-driven growth

As a result of the data and analytics initiative, the organization has a web-friendly user interface for data submission. They can also rely on a new data warehouse as a single source of truth for reporting, including a full data quality alerting framework. Member organizations can also build comparison analytics dashboards to improve their performance.

Prior to the engagement, the Annual Statistical Report (ASR) would not be released to members until July after intensive manual evaluation of missing data, data ranges, and then running the statistical analysis and generating the report.

The ASR can now be generated the day after their data collection is complete, and with the automation of reporting and data integrity, the data collection period is much shorter as well. The ASR is ready to be released in February instead of July, greatly shortening the delivery window.

Overall, members are now able to make better business decisions by comparing against similar member organizations.

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