Success story

Leverage Workiva and Anaplan to automate dozens of FP&A and demand planning reports

By Sergio Escobar & Andrew Onufrychuk

Background

When a front-line service provider was experiencing hyper growth during the pandemic, they encountered several challenges when deciding on:

  1. How, when, and where they should invest and grow their business operations?

  2. What impact will their decisions have across multiple business lines?

  3. How should they manage their business and align resources around that impact and other uncertainties?

The business directors knew that the organization needed to leverage data and technology to overcome these challenges.

Challenge

We helped our client identify three specific needs for leveraging data to optimize their decision-making:

  1. First, they needed to connect all levels of data across all departments in real time to enable enhanced planning.

  2. Second, they needed to automate all reports to include the financial impact of changes on critical value drivers.

  3. Third, they would need to enhance data integrity and security across all systems. Approach

We worked closely with this organization to truly understand their current state and define their target state. Our unique approach of leading with enablement and building together allowed us to optimize the best fit cloud-based solutions for their desired target state.

Keyrus collaborated with this organization to build and deploy customized Anaplan models for FP&A and Demand planning. These models integrated data from multiple sources and provided a central platform for calculating and visualizing all changes to critical value drivers.

There was still one major manual labor requirement. Multiple resources were still required to manually export data from Anaplan and update each narrative and exhibit within their management reports. This is where we leveraged Workiva for automated end-to-end integration and reporting.

Results

  • Empowered the organization to rapidly expand operations by opening dozens of new locations in 2021.

  • Automated the importing, exporting, and building of over 40 management reports.

  • What previously required 3 analysts a total of 15 days per month is now completed by 1 analyst in 1 day with Workiva!

Benefits

The client now benefits from end-to-end automation from planning to reporting to ensure real-time data integrity and security across the entire data ecosystem. This included data from sources like ERP, HRM, CRMs, and other systems, enhancing accuracy in data and reducing collaborative friction and risk of human error.

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

Blog post

5 Insights Your Organization Can Gain from an ESG Solution

April 22, 2022

Environmental, Social, and Corporate Governance (ESG) disclosures have become increasingly sought after in the last 5 years, with heavy forecasted growth expected in the coming two to three.

Success story

Modernizing a data platform at a global trade organization

March 28, 2022

A large global trade organization (GTO) has a mission to promote the sciences in order to improve the quality of life for all. The organization focuses on publications and membership, with a membership exceeding 150,000 in more than 140 countries. They publish over 70 peer-reviewed journals that are considered cutting edge in research within their domain. Additionally, they organize national and regional conferences to promote the sciences.

Event

Keyrus & Anaplan Sponsor Life Sciences Accounting & Reporting Congress 2022

March 11, 2022

Keyrus & Anaplan Sponsor Life Sciences Accounting & Reporting Congress

Podcast

How to craft effective data quality and MDM strategies

March 1, 2022

In this podcast episode, we'll define data quality and MDM as part of data governance. We’ll explore how to create effective data quality and MDM strategies.

Success story

Improving sales reporting to maximize deals at a fintech company

February 23, 2022

A global financial technology company sought to streamline, automate, and optimize how they collect and report on data to keep a steady pulse on the health of their business. Specifically, their sales team was looking for innovative ways to utilize data to enable their sales reps to maximize deal volumes. 

Blog post

Facing the transit industry's challenges head on with data

January 7, 2022

Welcome to another installment of our Evolving Industries series. Join us as we take a deep dive into changing markets, technologies, and consumer expectations, and learn how leading companies are surviving and thriving in some of the world’s most unpredictable industries. In this edition, we sit down with Jeff Hiott, Vice President of Imagination, Research, and Industry Benchmarking for the Capital Metropolitan Transit Authority (Capital Metro).

Press release

Keyrus wins recognition from Clutch as a Leading 2021 Global Provider of Data Analytics

December 16, 2021

We’re excited to share with you that we’ve been named among the top data analytics service providers globally. According to Clutch’s B2B research findings, we’re one of the global leaders for 2021!

Blog post

Keyrus (officially) recognized as a Great Place to Work

November 30, 2021

Keyrus is proud to announce that we are now a certified Great Place to Work! We already knew that we love working at Keyrus, but as a data and digital consulting firm, we like our assumptions to be backed by data. That’s why we brought in the experts at Great Place to Work to survey our team to see how we’re doing and where we can improve.

Blog post

10 can’t-miss episodes from Tableau Conference 2021

November 15, 2021

The Tableau Conference wrapped up on November 12th and, for the second year in a row, it was a fully virtual event. With 308 episodes and five concurrent channels of content, it’d be impossible to watch all of the sessions quickly. To help you navigate, we’ve compiled a list of the ten most essential sessions that provide excellent range and an overview of the entirety of the three-day event.

Event

Pharma/Biotech GTN Summit 2021

November 5, 2021

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