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
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