Achva - A&I - analytics and insights
👩‍🏫

Achva - A&I - analytics and insights

🏳️‍🌈 LGBTQ+ Organization
votes number
Technical requirements
BI
Automation
Database
projectManager
tagline
Actionable insights
Voters
Team stack
Tech level ( 1- low)
2
Mentor
amélie
Priority 1- low
2
Status
Approved

Context

The organization has two full-time employees and the rest of the staff are volunteers. Which creates a high turnover of personnel, almost renewed every year and there is no consistency from year to year, according to the managers. ¾ arrive for one year only.

What is the problem and its effects?

There are a lot of files and no one focused place to manage and understand the content. No understanding of trends, no data-driven high level visibility and decision making.
 

Current state

Volunteers fill in forms and sheets, no analytics or statistics to understand trends and insights

Proposal for solution

Centralized Dashboard with analytics. The ability to connect to google sheets, excels and generally drive and to present trends, insights etc. ex: which campus was more active? do I need to budget more next year? Do I need to close a certain campus etc.
Assumptions
  • Centralized BI Dashboard
  • Since there are processes and activities repetitive annually/monthly, to make templates
Constraints
  • If its doable without organizing the whole drive, who choose which files to connect?
 
OUT OF SCOPE
  • connection to whole volunteers management system

Metrics for success

  • The ability to understand at least 3 trends (defined by the organization) for each campus
  • The ability to see the big picture about all campuses (comparison?)
 

Technical requirements

Choosing processes and tables/ sheets to analyze
Creating logics and queries - PivotTables, Power Query, Macros etc
Connecting to user-friendly interface for non-technical staff - (canva?)
Defining the process to add new table/process