New members vs. lapsed members, by month
Joins come from the membership table's join_date; lapses are renewals due that were not paid within the grace window.
Three questions, three numbers
Each answer below is computed live from the filtered data — the same measures a leadership team would see in Power BI.
Chapter roster reporting by region
Chapters that have filed their annual officer/roster report, versus those still outstanding. Select a region to drill to state level.
Where members signed up or renewed on the AirVenture grounds
Memberships opened or renewed in the AirVenture 2026 window (Jul–Aug), placed by the on-grounds location of the transaction on a schematic of the show. Circle size = transactions; always the Jul–Aug window, filtered by region and member type.
Renewal rate by member type
Renewals paid ÷ renewals due in the selected window. Lifetime members have no renewals and are excluded from the rate.
From the membership database to a report Matt owns
No new system. A read-only view on the existing database, a Power BI semantic model with the measures on this page, and a scheduled refresh.
| Measure | Definition |
|---|---|
| Active members | Members with status = Active at period end |
| Renewal rate | Renewals paid ÷ renewals due (excl. Lifetime) |
| Net change | New members − lapsed members |
| Roster filed % | Chapters with a roster report on file ÷ chartered chapters |
