Michael's Projects

CDC Deaths (CDC | Wonder)
Using CDC data to represent death rates by year, state, sex, race, and age.

• Extract: Deaths by Underlying Cause

• Transform: File Level via XLSX

• Load: Years, States, Races, Sexes, and Age Group

PBIT/X and data available upon request

State of NJ Emergency Response

“Michael has volunteered to participate in our COVID-19 mobilization in support Microsoft’s response to the global coronavirus outbreak.”

I was asked to create a PowerBI using a dataset provided by New Jersey related to COVID-19

Community Outreach: Quick Guides

Handouts designed to be a printed front/back on standard paper to guide a faith-based community how to engage with our street friends.

Slides available upon request

Pierce County Open (PBIT available upon request)

Leveraging the Pierce County Open Budget / Checkbook to bring together Revenue, Expenditures, and Checkbook in a connected manner by normalizing common hierarchical fields and respecting the biennial budget alongside yearly spending.

Reporting Designs/Usage

• Custom visual

• Dynamic fields filtering & totaling based on filtered selection

• Drill-through with 'Modern visual tooltips' (Revenue Only)

• Last updated fields for tracking data freshness

• Ranking

• Sync'd slicers

Primary objective was to model a report similar to Pierce County website, with secondary objective to enhance capabilities based on available data. Some solutions are minimal simply to expose the capability, but expansion is always possible...

Homelessness in America (files available upon request)

Leveraging the Annual Homelessness Assessment Report (AHAR) data from HUD via AHAR Reports | HUD USER I combined the years into a normalized dataset that enables filtering by State and Area with grouping of Overall, Individuals, or People w/ Families.

The Annual Homelessness Assessment Report (AHAR) is a HUD report to the U.S. Congress that provides nationwide estimates of homelessness, including information about the demographic characteristics of homeless persons, service use patterns, and the capacity to house homeless persons. The report is based on Homeless Management Information Systems (HMIS) data about persons who experience homelessness during a 12-month period, point-in-time counts of people experiencing homelessness on one day in January, and data about the inventory of shelter and housing available in a community.

<-- Tableau

PowerBI -->

FBI National Crime Statistics (PowerBI)

Sometimes we hear some 'data' and are curious if it matches what the data says. Although this is not a direct match to the data statement since that was at a city level, this report exposes the trending for crime statistics by state across both property and violent crime.

See for yourself if we/you are safer now than we/you used to be...