Generate Insights from Data with Power BI

Join Los Angeles Neighborhoods and Health Measures to let Power BI discover insights.

Datasets

Census Tracts by Neighborhood + Health Data

Step 1. Launch Power BI

If you need to download, https://powerbi.microsoft.com/en-us/, it's part of Office 365 subscription.

Step 2. Create the Queries

    1. Other > OData Feed
  1. Rename Queries to something meaningful so it's easy to understand data elements when building charts

Step 3. Transform Data

Add State and County FIPs codes to LA Tracts to join with Health Data
Add Column From Examples

Step 4. Create Data Model

Relate datasets by FIPs Census Tract numbers

Health Measure and Commute Time Insights

Los Angeles Health Measures by Neighborhoods