The D&I team at the organization was tasked with a significant responsibility: handling the data of over 65,000 employees to cascade gender and ethnicity goals derived from market data compression and current representation. This massive data management process was part of their year-end agenda, aiming to streamline the representation analysis across various managerial levels. The initiative intended to create a more inclusive workspace, aligning the organization closer to their D&I aspirations.
Achieving Successful Outcomes
To fulfill these objectives, we proposed a robust solution involving the creation of over eight flows for different calculations and the cascading of these details to more than 5,000 managers. The highlights of our solution included:
Role-Based Access: The app incorporated role-based access, facilitating proxy management for senior leaders, thus offering a tiered access structure for different user categories.
Admin Panel: A comprehensive admin panel was set up to control the flow sequences, add members to AAD, and manage other administrative responsibilities, all from within the app.
Utilizing Microsoft Technologies: Our solution leveraged several Microsoft technologies, including PowerApps, Power Automate, SharePoint Document Library, SharePoint Lists, and Azure Active Directory.