Below you'll find a short list of some suggested questions to ask the Data Analyst, based on the data available and the types of visualizations and reports we can generate. These are just some ideas to get you started - the possibilities are endless! To see more details on the exact data included in each dataset, click on the header of each section.
Profiles Dataset
- How much in annual dues do members pay by age?
- Which membership level pays the most in dues?
- Which category pays the most in annual dues?
- What is the average age of all members?
- Where are most of my members located?
- How many members joined this year?
- How many members have $0 in Annual Dues?
- How many members dropped after the first year of joining?
- Who has been a member the longest?
- How many members have fewer that 50 FTEs?
- Show me the average number of FTEs in each status
Revenue Dataset
- Show me revenue by month for this year
- Which category brings in the most revenue?
- Which profiles had the most non-dues revenue last year?
- How much in revenue did each membership level bring in in the last 12 months?
- Show me revenue amount by revenue item for this year
- How much have i written off in dues revenue each month in the past 12 months?
Payments Dataset
- Show me payments for each revenue item last month by day
- What is the average days outstanding for dues invoices by payment type?
- Which method of payment is most common?
- Show me a breakdown of payment totals by type for the last 12 months
- What is the rate of pay for last month's dues invoices?
- How many members have made a renewal payment this year?
- Which profiles paid their dues late this year?
Event Registrations Dataset
- Which events brought in the most revenue last year?
- Which type of events are most popular?
- Show me event attendance by membership level
- How far ahead do people register for each event type?
- Show me event revenue by revenue item for the past year
- Show the count of signups each day for XX event