Mighty QuinnConsultingMighty Quinn Consulting — home
Insights

Retail · Information Security

Macro Signing Dashboard

Adoption and code analysis for a macro signing service, across Excel, Word and PowerPoint.

Duration
< 5 months
Budget
< 10.000 €
Project team
MQC 2 · Client 3

End-of-project survey

Overall satisfaction10/10
Budget9/10
Time8/10
Quality10/10
Collaboration9/10

Every project ends with the same questionnaire: five answers from 0 to 10, in the spirit of a Net Promoter Score. We publish what comes back, including when nothing does.

The brief

  • Show how many macros have been signed, and how adoption of the signing service is developing
  • Go past counting and analyse the VBA inside the files

The build

  • Custom M code against the web service connector to retrieve data from the signing service behind a bearer token
  • Metrics and DAX measures for volume, status and code analysis, with row-level security on top
Tech stack
  • Power BI
  • Power Query
  • DAX
Our part
  • Conception
  • Development

The good

  • More than seven sub-dashboards, detailed enough to understand how the service is actually used rather than only how often

The bad

  • Bearer token authentication was awkward, though it worked out inside Power BI without losing any features