Achva - A&I - analytics and insights

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