IDS Case Study: Create a Model to Allocate Performance Bonuses

By Keiter Technologies

IDS Case Study: Create a Model to Allocate Performance Bonuses

Challenge and Opportunity

A Keiter Technologies client was seeking a way to better allocate performance bonuses to its employees that considered areas of high and low volume, percentage of increased sales, and location profitability.

 

Our Approach

  • The customer had an outdated structure for measuring sales and performance data of its employees. They struggled to balance overall region volume with improvements the sales force had made in historically lower volume or less profitable regions.
  • Using Microsoft Power BI, we were able to clean up and integrate information for all of the customer’s employees into one central database.
  • The database provided the customer with essential information about each employee such as volume of sales made, customer acquisition, etc.

Results

The newly created database database provided the customer with the information needed to create a more equitable and performance-based bonus structure.

 

View All IDS Case Studies >

 

Learn More about our Innovative Data Solutions Services

 

Share this Insight:

About the Author


Keiter Technologies

Keiter Technologies

Keiter Technologies focuses on serving businesses with their strategic technology needs through data science, cybersecurity, and IT audit and consulting.

More Insights from Keiter Technologies

The information contained within this article is provided for informational purposes only and is current as of the date published. Online readers are advised not to act upon this information without seeking the service of a professional accountant, as this article is not a substitute for obtaining accounting, tax, or financial advice from a professional accountant.

Categories

Contact Us