Rishi Shah

Data Analyst

Drawing on my experience as a former senior leader at one of London’s highest-performing schools, I now specialize in data analytics to deliver impactful, data-driven solutions. My expertise in leadership and strategy enables me to tackle complex problems with precision and insight.

Explore my portfolio below for examples of my work. I’m proficient in Python, SQL and Excel, with additional experience in Power BI, and Tableau.

My Portfolio

  • This report uses advanced Excel and data visualization techniques to analyze teacher recruitment trends in England, challenging the prevailing “crisis” narrative by demonstrating that the recent decline is a temporary effect of the Covid-19 pandemic, with early signs of recovery already evident.

    Link to report

    Link to Excel spreadsheet

  • This report analyzes attendance trends for the 2024/25 Autumn term using Python with the latest Department for Education data to derive key insights.

    Link to report

    Link to Github code

  • This behaviour dashboard, currently in use in a school, provides real time insights into behaviour trends at the year group level. Sample data has been input to demonstrate its functionality.

    Link to behaviour dashboard

  • Practical training project using example sales data, showcasing Python coding for data analysis and ability to derive insights from data.

    Link to presentation

    Link to Github code

    Link to raw data

  • This academic dissertation uses regression modelling in Stata to determine the effect grammar schools have on the destinations of their students and the state school students in the local area.

    Link to dissertation