Mighty QuinnConsultingMighty Quinn Consulting — home
Workplace

Retail · Controlling

Management Portal

A search-driven SharePoint portal that made more than 15,000 reports findable and manageable across every country organisation.

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

End-of-project survey

Overall satisfaction10/10
Budget10/10
Time10/10
Quality8/10
Collaboration10/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.

You're doing a great job: being nerdy with a sure instinct, but also providing serious, meaningful and forward-looking input. Thank you very much. Great success with you.

Retail

The point

Group controlling produces reports for every country organisation and every department, and the hard part was never producing them — it was getting the right one in front of the right people, and keeping who-may-see-what straight as the catalogue grew past fifteen thousand. This replaced that with a catalogue people search instead of a structure people have to learn.

Processes covered

  • Report distribution to country organisations
  • Report publication and metadata capture
  • Report category management
  • Access and permission management
  • Usage analysis and catalogue clean-up

The brief

  • Distribute different reports to every country organisation, across all departments
  • Easy access to reports, and an easy time finding them
  • Straightforward management of report categories, roles, permissions and uploads

The build

  • Search-driven SharePoint site with a “Google-style” start page
  • Dedicated metadata concept for reports and report definitions
  • Flows to distribute reports, automatically complete report metadata and set appropriate permissions
  • Dedicated app to manage report categories including their distribution, permissions and information logics
Tech stack
  • SharePoint Online
  • PnP Modern Search
  • Power Apps
  • Power Automate
Our part
  • Project Management
  • Design
  • Conception
  • Development

The good

  • Search-based approach enabled efficient and easy management of more than 15,000 reports
  • Usage analysis enabled optimization of report contents and distribution
  • High user and management acceptance

The bad

  • Initial issues with API limits necessitated the redesign of certain flows
  • Slight delay in findability of reports after publishing, due to the search-driven approach
  • First concerns about the “Google-style” start page