All projects

Production company · 2026

Production data and asset management

A dashboard that tracks the progress of every project, fed automatically by the team's files.

The dashboard, on fictitious data.

The need

Tracking information was scattered across many files. Knowing where a project stood took time and manual checks.

What I built

Tools that automatically gather and check the team's files and assets, and a Power BI dashboard updated every day.

What it changes

Progress is clear at a glance, gaps are flagged, and the client receives a clear status report.

Tools

  • Python
  • Power BI
  • DAX
  • Power Query
  • Excel