Market Share Analysis: For a large partner organization with a wide national network, a Fellow used Power BI and Excel to analyze nationwide and program-specific membership trends over a 10-year time period to understand whether competition by new competitive centers is negatively impacting membership.

Impact Measurement Tool: For a large nation-wide non-profit, a Fellow conducted a meta-analysis on the impact of after school programs on Power BI and is currently building a tool, an app, which would estimate the impact each member organization has on their community.

Salary Benchmark Analysis: Taking a sample of 30 schools, and around 3,500 teachers, a Fellow conducted an analysis of teacher salaries in charter schools using R. This primarily involved descriptive statistics of the distribution of charter salaries by school level (elementary/high school), years of experience, highest degree earned and subject matter. Our Fellow also produced a policy analysis of how non-unionized charter school salaries compare to the Chicago Teachers Union contracts and the contracts of unionized charter schools.

Visualization of Processes: A Fellow used GIS and Python to create data story maps to show the effects of under- investment in different regions of Cook County. Our Fellow’s interventions helped the department cohere their data, visually lay it out to understand gaps between investments and needs, and refocus their investment strategy.

Mapping Trends and Gap Analysis: A Fellow used publicly available data from Chicago Public Schools to create visualizations to characterize trends in graduation and college enrollment rates. Through this they demonstrated that while high school graduation rates have plateaued in recent years citywide, there remains significant variation at the school and community level. Another important finding is that some schools do well in graduation rates but do not increase college enrollment and these schools cluster spatially.