- The file was customized for easy access to tools.
- Data was organized by splitting columns into rows.
- Tables were merged using XLOOKUP.
- The data was cleaned.
- A column for average scores was added.
- A filter formula was designed for records post-2020/11/25 with average scores below 60.
- This filter was applied.
- The data was converted to an Excel Table.
- A Pivot Table was created to explore trends.
- Insights were visualized with charts.
- A dashboard was compiled using best practices.