M. K. W. STUDIOS
Analytics and Programming
Automated Timesheet Dashboard
Tools
Excel // Power BI
Skills
consulting // data integration // automation // dashboard visualization
Objective
Worked with state agency to update employee engagement time-tracking methods to a centralized, automated timesheet dashboard using Power BI.
Craneway Craft Fair
Tools
Airtable // Excel // Tableau
Skills
consulting // data cleaning // dashboard visualization
Objective
Evaluate applicant and logistical data for future location planning, inviting quality emerging artists in specific genres, granting scholarships to students / new applicants.
Photo by Clara Rice Photography
Academic Projects
Triangle Voter Demographics
Tools
Tableau
Skills
data cleaning // dashboard visualization
Objective
Build interactive dashboards that tell the visual story of voting rates by demographics of 2.7 mil voters, across RTP and neighboring cities' municipal, primary, and general elections from 2011-2019. Drill down on active voter rates in 2012 vs 2016 general elections.
Early 2020 Climb of Covid 19
Tools
SAS Studio
Skills
SAS programming // reporting
Objective
Deliver summary of pandemic onset and geographic spread by county, highlighting top 3 counties and monthly trends in a single-page report, with CDC data collected between January - May 2020.
Wikipedia - Scraped Projection of
US Population Growth
Tools
Github // Jupyter Notebook // Pandas // Matplotlib // BeautifulSoup
Skills
Python programming // HTML scraping // data cleaning & transformation
Objective
Depict a trend in US Demographics using data scraped from Wikipedia.
