Subscribe to my newsletter EDM News
BI Case Study: Professional Golfers Association

This is the third of four case studies on how associations are using business intelligence, about which I presented at a recent ASAE conference. There are a lot of details to these case studies, but since this is a blog, I’m going to keep this at a high level.

The Professional Golfers Association includes a national association as well as 41 sections (think of them as chapters). PGA’s sections are the primary hosts of most of the golf events that occur in the US each year. Amazingly, both the PGA national headquarters and the 41 sections share a single membership database. (That story alone is worthy of an article or two.)

Because all of this information resides in one system, PGA had an opportunity to develop a simple yet very effective business intelligence system that would allow them to display key performance indicators (KPIs) to the 41 sections and headquarters. As Larry Green of PGA explained to me, “The sections always wanted to know how they were doing compared to the other sections. Now they can see for themselves.”

PGA worked with their sections to identify 12 KPIs that would measure the effectiveness of each of the sections (things like course participation). For each KPI, the sections are ranked 1 through 41, and then the 12 KPIs are totaled to provide an overall ranking. All of this information is pulled from the primary membership database, but stored in a separate online business intelligence database that each of the 41 sections can access. The data is updated on a daily basis, and since all the sections share the same membership database, the data is complete and essentially real-time.

Now the sections can instantly view this information and see how they are doing relative to the other sections. And they can learn where they are doing well and where they need to improve, and adjust their programs and activities accordingly.

About author:

Archives

Sign-up for EDM News

 

 

Testimonials

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

“We came to Wes because we were very frustrated with our existing AMS and we wanted to improve our capabilities as soon as practicable. Wes very quickly helped us through a process of identifying our needs, identifying potential vendors, and selecting a new system that we’ll be able to move into very quickly. I especially appreciated Wes’s candor about our processes as well as the systems we were looking at. He was a great resource to have in a period of high anxiety for our organization. I would highly recommend Wes for any similar project.”

Jack Chiasson, CMP Executive Director
National Association of Life Brokerage Agencies

“Wes was able to come in and offer tangible, relevant advice that made us more productive immediately. I value his understanding of databases but more so, his understanding of how nonprofits work. There was no lost time educating him about how membership organizations are “different.” Wes recommended changes in processes as well as tips and tricks that were easy to implement made an immediate positive impact.”

Mary Pat Paris, Executive Director
International Registration Plan

Mary Pat Paris
International Registration Plan

“This is the second database implementation we’ve done since I have been at Western Arts Alliance (WAA). The first I did on my own. This time we engaged Wes Trochlil as our database planning consultant. Let me tell you, this process is a whole lot easier having Wes on your team! For a small association like WAA, it’s tempting for board and EDs to question the justification and expense of a database planning consultant. But it’s the small associations that need Effective Database Management the most. Wes strengthened our planning process, clarified our needs requirements, helped us steer around solutions that couldn’t meet our objectives, and saved us money in the long haul.”

Tim Wilson, Executive Director
Western Arts Alliance

Tim Wilson
Western Arts Alliance
%d bloggers like this: