Back to Case Studies

Chicago Bulls

Chicago Bulls

ABOUT THE COMPANY

The Chicago Bulls are a legendary NBA franchise. With 41 regular-season games at the United Center, the staff behind the scenes has a huge number of logistical challenges to handle on a daily basis. www.bulls.com

THE CHALLENGE

The marketing team is responsible for event marketing, partnerships, and public relations outreach. Tracking the tasks within these areas of responsibility, and analyzing their results is a full-time job unto itself. Frustrated by these tedious chores, the members of this group reached out to Knack Training to find solutions to their headaches. Major factors that were identified included:

  • Use of ACID principles in tracking and managing client data, translating to successful spreadsheet design
  • Leveraging Excel functions for linking data, including VLOOKUP, INDEX and MATCH, and others
  • Color-coding stages in processes, as well as status levels and other indicators
  • Using new Office 365 features to build a useful data model in an Excel spreadsheet

STEPS TAKEN

Knack Training moved quickly to resolve these issues so the Bulls marketing team could get back to work. We went to work scheduling a workshop to illustrate the power of relevant Excel tools and features. Through live, hands-on exercises, the daily users of this spreadsheet became experts in Tables, VLOOKUP, and the Excel Data Model. Additionally, Knack Training consultants coordinated with the team to build a new set of spreadsheets from the ground up. Together, we created fast-loading, easy-to-use tools for the team’s daily work.

THE RESULTS

Today, corporate partnerships and event marketing are tracked quickly and effectively, using nothing more than the power of Microsoft Excel. The team has been given the tools to expand upon their existing documents and tackle new problems.

Client’s Feedback

Thank you for the wonderful workshop! We all learned a lot and found it very helpful. Thank you so much for everything that you have done for us this season!

Lindsay Flasch

Manager, Partnership Marketing - Chicago Bulls

View moreCase Studies

San Diego Zoo Global

San Diego Zoo Global

San Diego Zoo Global is a not-for-profit conservation organization committed to saving species around the world. For more than a century, international tourists have flocked to the San Diego Zoo, making it the most visited zoo in the United States.

Dunwoody, Georgia

Dunwoody, Georgia

The City of Dunwoody, Georgia, is a suburb of Atlanta. Every year, they host the Dunwoody Accounting Conference, a week-long educational event for accounting professionals.