Customer Story

Association Modernizes Data Practices with End-to-End Analytics Solution

Analytics8 is incredibly knowledgeable about the data industry. They assisted us in developing an overarching data strategy, implementing the right cloud infrastructure and data models, selecting the appropriate BI Tool and re-designing our overall analytics reporting solution

Problem

Membership Outgrows Manual Data Analysis Practices

A prominent association with more than 95,000 members and continued year-over-year growth was dealing with unmanageable data about its members. Manual analysis practices were becoming too complex and time intensive for leaders to quickly understand membership sentiment and association financials.

This association partnered with Analytics8 to overcome tedious reporting processes and institute a more mature, long-term data and analytics solution that expertly informs critical decision-making and matches their prominence in the market.

Solution

A Long-term Data Strategy and End-to-end Association Analytics Solution

Work began with a Data Strategy Assessment where we interviewed stakeholders across departments to understand their pain points, tool usage, and reporting needs. The assessment concluded with our recommended action plan which outlines an end-to-end data analytics solution.

We executed the recommendations from their roadmap, each phase of the solution providing more ease and insight for decision makers:

  • Data Warehouse in the Cloud: A data warehouse on Azure replaces the manual process of sourcing data from Aptify, MS Dynamics, MS Excel, and elsewhere to build reports. The new data warehouse provides a single point of access to their data and automates the data cleansing process, which alleviates data quality issues and speeds up reporting.
  • Data Visualization and Enterprising Reporting Tool: Built on Power BI, this analytics solution clearly communicates complex data that was once spread out in various systems. Visualizations and reporting in this platform are used to analyze:
    • Membership Trends: Users have a holistic view of member demographics and year-over-year membership trends, such as retention rates and the shared attributes of who left.
    • Survey Results: Cutting survey analysis down from weeks to under one hour, they can quickly analyze member feedback and easily publish results for members to view.
    • Event Feedback: Previously tracked in large flat files, attendance data from their annual convention is now seamlessly added to the application so they can perform demographic analysis and derive insights from attendee feedback.
    • Membership Dues: Instead of waiting on the monthly reconciliation process, users can now access a daily snapshot of paid vs. outstanding status.
    • Finances: Reports contain up-to-date financial metrics, including company assets and liabilities and revenue and expenses, with the ability to drill down by department.

Results

Focus On The Questions That Impact Their Bottom Line

A ground-up approach to fixing data problems resulted in an association analytics solution that will grow along with their membership count. They unified siloed data and broke down departmental decision making. Instead of worrying about data accuracy or completeness, leaders now focus on answering critical questions about their operations:

  • Which types of members are being retained?
  • What are the demographics of new members?
  • Why are members leaving the association and then being reinstated later? What kind of members are leaving and what attributes do they share?
  • Which offerings are most likely to retain members?
  • Are we losing members to local associations?
  • Is there a way to simplify billing at the company level if there are multiple members from the same company?