Gyromitra Inc.

Public sector / Open data programs

Public Data Portal — Usage & Adoption Analytics

Track adoption of a public-facing data catalog — usage, growth, top assets, departmental engagement, and ministry-level dashboards

Public Data Portal — Usage & Adoption Analytics — hero
Year
2024–2025
Role
Lead Power BI Developer
Audience
Program leadership, contributing departments, individual data stewards
Pages
27

Challenge

A public-facing data portal published thousands of datasets contributed by dozens of departments. Program leadership knew page-view totals were growing, but couldn't answer the harder questions contributing departments actually cared about: which of our datasets are being used, how does engagement compare to peer ministries, and is the work my team is doing moving the needle.

Approach

I designed a layered analytics suite. A program-level overview tracks usage, growth, and the top 25 assets. Below that, a per-ministry dashboard gives each contributing department the same metrics scoped to just their content, plus a team-activity view so managers can see whether publishing effort correlates with engagement. The dashboard went through three iterations (2.0 → 4.0) as we learned which views were actually used and which were noise.

Outcome

Contributing departments now have their own dashboard they pull themselves, instead of asking the program team for a one-off slide. Program leadership uses the top-25 and growth views to direct promotional effort. The iterative redesign (4.0 is meaningfully simpler than 2.0) is itself a case study in how dashboards earn trust by shedding features.

Tools
  • Power BI
  • DAX
  • Power Query (M)
  • Web analytics integration
Data sources
  • Catalog metadata
  • Web analytics platform
  • Download logs
  • Page-view logs
Techniques
  • Cohort analysis (records vs. resources)
  • Top-N rankings
  • Departmental scorecards
  • Multi-version dashboards (2.0, 3.0, 4.0) with iterative redesign
  • Team-activity attribution