Building a Portal for Secure Data Collection and Reporting Across Municipalities

Stay in the loop


Building a Portal for Secure Data Collection and Reporting Across Municipalities

January 31, 2023

12 - 1 PM EST

Register Now

Municipal Benchmarking Network Canada, or MBNCanada, is a not-for-profit association funded by 13 partner municipalities. It collects 700 performance measures across 36 service areas on an annual basis, and provides reports and data back to the municipalities, its board, and the general public. In 2022 MBNCanada launched a project to modernize their portal, previously hosted by the City of Kitchener and dating back to 2004. Microsoft 365 (SharePoint, Teams, and Power BI) and Azure were selected to host the new portal. Azure AD B2B was used to invite in 1,000 guests across the partner municipalities for data entry, reporting, and committee and panel management.

This session focuses on the secure implementation of external sharing in Microsoft 365 at scale, optimization of Azure AD security controls in place both in MBNCanada's Microsoft tenant and the partner municipalities, and the zero-trust security design of the MBNCanada portal itself, which is hosted in Microsoft Azure App Services.

Key takeaways of the session are:

  • Leveraging Azure AD B2B and Microsoft 365 to share and collaborate across many organizations and people
  • How to configure your Azure AD tenant optimally for both security and usability, including conditional access policies, sensitivity labelling, and trust settings for external organizations
  • Improving your Microsoft Secure Score
  • Open-source dashboard for seeing users, groups, sign-in activity, failures, and guest user issues from your own Azure AD tenant


Peter Carson headshot

Peter Carson

Peter Carson, President of Extranet User Manager and a Microsoft MVP, is a recognized expert in Microsoft 365, SharePoint, and Extranet strategies. Read Peter's full bio and check out some of EUM's recent articles on all things Microsoft and Extranet related.

Meighan Finlay headshot

Meighan Finlay

Meighan Finlay, Executive Director of MBNCanada, works closely with the MBN Canada Board, Municipal Leads, and service area experts in supporting excellence in municipal service delivery.