DATA MODELING & VISUALIZATION
with POWERBI
NY School Performance Dashboard
This interactive Power BI dashboard provides users with academic data about how individual NYS schools performed on state exams (Regents).I created it by combining several publicly available datasets and modeling the data into a star schema. I used DAX code to create a couple of the attributes.
POWER BI DASHBOARD
NONPROFIT ORG ANALYSIS
This dashboard is interactive, but it's designed to be easily transmitted as a pdf as well. Underlying data pertains to several key aspects of a nonprofit's viability.
INTERACTIVE EXCEL DASHBOARD
CALL CENTER DATA ANALYSIS
I designed this interactive Excel dashboard with some modern flare. The underlying data represents a company's customer service call center information. Download full file below.
(After downloading, press 'enable contents' -- it takes a couple seconds to settle.)
DATA ANALYSIS + VISUALIZATION
WITH PYTHON
2022 SAT SCORES BY STATE
Visual analysis of states' SAT scores with interactive choropleth graphs. Gleaned data from SAT official reports and analyzed/visualized using Python, Pandas, and Folium.Check out the analysis button below. The full interactive features can be accessed in the Jupyter notebook link.
DATA ENGINEERING + VISUALIZATION WITH PYTHON
NONPROFIT INDUSTRY ANALYSIS
Data for this project came from the BMFF, a public tax database with millions of rows. It's too big for Excel, so I wrote a Python script to query the data and visualize it. I used Canva for the final brochure design. Download and skim at your leisure!
