Inspectional Services​

Maven Inspectional Services is a fictitious restaurant health inspection agency that needed to create reports and dashboards easily shareable across the whole company, allowing easy collaboration.

Maven Inspectional Services

The Project

Build scalable reports & dashboards for the Maven Inspectional Services, a fictitious restaurant health inspection agency based in Los Angeles, California.

The Aim

Create reports and dashboards that can be shared across the company for collaboration. This project requires the usage of both Power BI Desktop and Power BI Service.

Data Sources

A folder of CSV files, containing information about health inspection records, along with details about each restaurant, health inspector, and violations.

Data Model Created

The Work

  • Connect and transform the raw data
  • Build a relational data model
  • Create new calculated columns and DAX measures
  • Build reports & dashboards within a company workspace
  • Automate dataflows and schedule updates
  • Share and collaborate with peers and other teams
  •  Create a mobile layout for the report to be consumed on the go

The Output

The final output is a single-page interactive report containing the core business KPIs, a view on violations by region, types of violations, violation trends over time, and a distribution map by zip code.

The Dashboard

The Mobile Layout

For the best experience check the interactive report below using a laptop