Build Interactive Excel BI Academic Data Dashboard

I am looking for an Excel expert to build a fully interactive Excel dashboard that functions like a BI-style reporting tool for student performance data.

Each week, I will paste the same type of student-level export into a `Raw_Data` tab. The workbook should refresh and automatically update the dashboard, slicers, charts, summary metrics, aggregation tables, and filtered student-level records.

The final dashboard should visually resemble the attached mockup/example provided.

Core Requirements

1. Build the dashboard from one raw data source.

* Use a single `Raw_Data` tab as the source for the entire workbook.
* The raw data headers will remain consistent each week.
* No manual formula dragging, chart rebuilding, or PivotTable rebuilding should be required after the weekly data is pasted.
* The dashboard should update after the workbook is refreshed.

2. Create a polished dashboard tab.

* The dashboard should visually match the attached example.
* It should include summary metrics, charts, slicers, aggregation tables, and a filtered student table.
* Backend calculations or PivotTables should be organized separately or hidden.
* The dashboard should be easy for school leaders to use.

3. Include native Excel slicers with multi-select capability.

* Slicers must allow multi-select filtering.
* Users should be able to select multiple grade levels, teachers, courses, subjects, and ranges at the same time.
* Slicers should filter the full dashboard, including charts, tables, counts, and student-level results.

4. Include slicers for:

* Grade Band
* Grade Level
* Teacher
* Course
* Subject
* Pass/Fail
* Grade Distribution Range
* Attendance Range
* No Login Range

5. Include summary metrics similar to the visual example.

* Total Students
* Students Passing
* Students Failing
* Overall Passing %
* Average Grade %
* Average Attendance %
* Students 10+ Days Since Last Login
* At-Risk Student Count, if this can be calculated from the available data

6. Include grade distribution reporting.

* Show how many students fall into each performance range.
* Suggested ranges:

* 0–59%
* 60–69%
* 70–79%
* 80–89%
* 90–100%
* Display this visually, such as through a bar chart.
* This visual should update based on slicer selections.

7. Include aggregation tables or visuals for:

* Teacher performance
* Course performance
* Grade-level performance
* Subject performance

Where available from the raw data, these should include:

* Total students
* Average grade
* Passing %
* Failing %
* Attendance average
* No-login risk counts
* At-risk counts

8. Include days since last login
* Days since last login should be grouped into ranges if login data is available.
* Suggested no-login ranges:

* 0–4 Days
* 5–9 Days
* 10–14 Days
* 15–29 Days
* 30+ Days

9. Include a filtered student table underneath the dashboard.

* The bottom of the dashboard should include student-level records.
* The table should automatically filter based on slicer selections.
* For example, if I select 0–59% and 10–14 Days Since Last Login, the table should only show students who match those selections.
* This table should help leaders move from aggregate trends to exact students who need follow-up.

10. Use only fields available in the raw data or fields that can be reliably calculated from the raw data.

* Appropriate aggregations include grade level, subject, teacher, course, grade percentage, attendance, days since last login, passing/failing status, and grade distribution ranges.
* Do not build visuals that rely on fields unavailable in the export unless they can be calculated accurately.

* Tabs should be clearly named.
* Backend tabs should be organized or hidden.
* Include brief instructions in the workbook for weekly use.

Sample of raw data: https://docs.google.com/spreadsheets/d/1Nhx59XvJOp5PhjuTQREyGZ0k76lax_6a3CWfX9GdZ5g/edit?usp=drivesdk