Custom Data Visualizations
LATEST PROJECT

Ohio School Data Consultant

I specialize in working with schools and districts to take what has traditionally been text-based and PDF reports and re-making them into colorful, interactive, and insightful visualizations. The example to the right is a drill-down enrollment analysis using Tableau. The "Breakdown Levels" allow the data to be disaggregated in many different ways. The "Color Disaggregation" changes the color of the bars. The filters (all the way to the right), control what data is analyzed.

Get Started
Ohio School Data Consultant - Graphical Image
Data Analysis
LATEST PROJECT

Data Analysis

Are you curious as to whether your intervention program is working? Are you wondering if any of your subgroups are over- or under-performing? Do you have a mountain of data that you just need help understanding? I can help uncover trends, effectiveness, and areas for investment and divestment.

Get Started
Data Visualizations
LATEST PROJECT

Data Visualizations

Do you have a data set that you need to look at graphically? Are you stuck in an endless Excel Graph-Data-Graph loop? Let me take your data and turn it into a beautiful, engaging, and dynamic web-based visualization. Google Data Studio and Tableau Online are my preferred tools.

Get Started
Technology Consulting
LATEST PROJECT

Technology Consulting

Do you have a particularly difficult school district technology problem to solve? Not sure how to go about integrating your student information system with the vast array of intervention programs your teachers want to start using?

Get Started
previous arrow
next arrow

Ohio School Data Consultant

Ohio School Data Consultant ImageI am an experienced Ohio school data consultant specializing in school data analysis and visualization.  Today, districts have no shortage of data.  Enrollment, Attendance, Discipline, High-Stake Testing, Intervention, and Short-Cycle Assessments are just some of the data elements that schools track each and every day.  But what to do with all of that data?  I help Ohio school districts make sense of their data.  I might work with the district to create an engaging drill-down data visualization for a Board presentation or analyze an intervention program (Data Analytics) to see if it is having an impact on student achievement.

Ohio School Data Consultant - R Studio ImageAlmost all of my projects start with R and R Studio.  These tools allow me to extract data from data sources, load CSV and XLS files, and then clean, combine, normalize, and prepare data for analysis through something called “data wrangling.”  This is generally the most time-consuming part of any analysis project, and it requires the most thought and discussion with my clients.   The best part about using R Studio is that my projects are easily updated and customized for different clients.  Work on NWEA in one school district is easily portable to work in other districts, saving both time and money.

Ohio School Data Consultant R Studio ModelMy initial data analysis for all projects continues in R Studio.  The first step in any analysis is called EDA, or Exploratory Data Analysis.  This step looks for things like missing data, outliers, mismatched formats, and overall data set management.  After EDA is complete, a more in-depth analysis takes place for things like correlation, trends, and statistical significance.  The more in-depth predictive analytics projects use machine learning, regression, and modeling.  All of this work is done in R.  You can see some of my analytic projects on my Blog.

Ohio School Data Consultant Tableau DashboardAfter the data analysis is complete, I then move to visualizations.  This is where all of the hard work in the previous steps comes to life.  Having tools such as Google Data Studio and Tableau give my customers the best of both worlds.  Tableau offers best-in-class data analytic capabilities, including parameter- and filter-driven visualizations, dashboards, and an extremely powerful and flexible calculated field programming language.  However, Tableau is expensive for schools, and it is nearly impossible for most of my customers to afford making their Tableau visualizations public.  Google Data Studio is free for schools to use, and can be an extremely attractive option to make certain visualizations public.  You can see some of my visualization projects on my Blog.

You can see some of my recent work on my Blog.  When you’re ready, Contact Me to get started.