Learn Data Skills
Beta
Bryan Johnson

Bryan Johnson

Associate Data Analyst

AppleTree Institute

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Track

SQL Fundamentals

My New Course

Introduction to Python

Inquisitive analyst, forever asking 'Why?' to uncover the truth in data.

My Work

Take a look at my latest work.

DataLab

Exploring Astronaut Activities in SQL - Solution

DataLab

Course Notes: Data Analyst with R Track

DataLab

Project: Analyzing Students' Mental Health in SQL

DataLab

Exploring Astronaut Activities in SQL - Solution

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to R
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

AppleTree Institute for Education Innovation | Dec 2022 - Present

Associate Data Analyst

• Utilizes MySQL to transform data and create individualized reporting for school leaders • Has written Python scripts to automate processes using cron from reporting as well as automation of platform work, which has saved over 100 hours for the Tech Support team • Tableau Administrator for all of AppleTree’s internal and external dashboards • Worked with an outside contractor to implement an embedding of our Tableau dashboards within the company’s online platform • Determined and implemented an itemized process for updating the platform database, by removing over 25 million records. • Managed projects related to Google Apps Script and insertion of data into databases for reporting purposes • Researched and implemented a solution for automatic delivery of over 200 reports • Built a Weekly Heatmap tool for the Support team to analyze customer service tickets • Created analysis for the Curriculum team that determined the impact of lessons during small-group instruction • Created a predictive tool to determine the yearly charter school score administered by the Public Charter School Board metrics • Member of the EdTech Data Discovery Team, which directs the upgrading and rebranding of the entire online platform • Attended the 2024 Tableau Conference in San Diego, CA
Show More

Art of Problem Solving | Sep 2020 - Aug 2022

Campus Director

• Managed 3 full-time and over 30 part-time employees • Oversaw the logistical operations of the campus, which offers 36 courses in over 75 sections and over 875 enrollments • Created, maintained, and analyzed the Academic and Summer schedules to maximize enrollments • Hired and trained part-time instructors and office staff • Consulted with current and prospective families for student readiness into the academic program • Successfully transitioned the campus back to in-person operations, while adhering to CDC guide- lines • Member of the Academy Budget Committee • Taught Mathematics classes, ranging from Elementary to High School • Organizes and hosts multiple mathematics contests every year

Johns Hopkins Center For Talented Youth (CTY) | Sep 2017 - Sep 2020

K12 Supervisor

• Created 2 courses that generate over $1.3M per year in revenue • Managed 30 part-time employees • Worked with Multimedia department to standardize processes for image creation and course usage • Creates, reviews, and revises both synchronous and asynchronous HonorsAlgebra I courses • Participates in hiring process for potential new full-time and part-time staff • Trained new part-time staff on policies, procedures, and course-specific responsibilities • Approved forward-facing end–of–course documentation • Worked with Operations to update existing automated forward-facing communications • Created a spreadsheet tool to improve efficiency for approval of instructor hours • Member of the Learning Management System (LMS) redesign team, which worked with outside vendors to implement instructional design standards for updated LMS • Continued fulfilling the duties of Course Supervisor (see below)

Johns Hopkins Center For Talented Youth (CTY) | Mar 2015 - Sep 2017

Course Supervisor

• Managed over 20 instructors over various courses ranging from elementary to high school • Created and manages a weekly help room, available to hundreds of middle school students • Worked with managers to help create and organize department-wide training materials • Continued fulfilling the duties of Curriculum Specialist / Instructor (see below)

Johns Hopkins Center For Talented Youth (CTY) | Dec 2014 - Mar 2015

Curriculum Specialist / Instructor

• Instructed students concurrently across the world in various asynchronous online math courses • Created content for courses that range from grade 4 to collegiate • Presented to students at educational forum seminars throughout the year

Six Red Marbles | Mar 2013 - Aug 2014

Mathematics Curriculum Specialist

• Supervised creation of McGraw Hill Common Core Achieve: Mathematics and edited for quality • Wrote curriculum and managed additional teams of writers as needed • Created guidelines, prototypes, and general project specifications • Created high-quality dynamic math materials for a diverse group of clients • Collaborated with the project management team to staff projects • Used Adobe Illustrator to create and edit technical mathematical art pieces

A Pass Educational Group, LLC | Sep 2012 - Feb 2013

Director of Mathematics Development

• Created and managed all project training materials • Trained and managed all Mathematics writers and editors for each Mathematics project • Created and managed all hiring assessment samples for prospective writers and editors • Member of Quality Assurance Team • Made staffing recommendations to project managers for both writer and editor positions • Took on the role of writer, developmental editor, copy editor, and project manager as needed

A Pass Educational Group, LLC | Apr 2012 - Sep 2012

Mathematics Item Writer / Developmental Editor

• Designed and Developed Mathematics questions for various projects • Edited questions from various writers for each project on the basis of the quality of the content & specifications of the client

My Education

Take a look at my formal education

College of Professional Studies Certificate in Data AnalyticsGeorge Washington University | 2024
Master of Science (M.S.) in MathematicsMichigan State University | 2014
Master of Arts in MathematicsBowling Green State University | 2008
Bachelor of Science in Integrated MathematicsBowling Green State University | 2005

About Me

Bryan Johnson

Former gifted educator, curriculum developer, and manager who transitioned to a career in data. SQL started my journey, and I don't plan to stop anytime soon.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free