A leading Canadian nursing service provider streamlines their employee onboarding process and boosts productivity with PreludeSys | PowerApps

About the client

The client is a Canadian-based nursing and rehabilitative services provider that offers retirement suites, assisted, memory care, and long-term care.  The client is a Canadian-based nursing and rehabilitative services provider that offers retirement suites, assisted, memory care, and long-term care.


Client challenges
  • The client faced challenges in optimizing employee onboarding and offboarding processes, streamlining data collection, and monitoring departmental performance.
  • Their former data collection method proved inadequate for robust reporting and analysis, affecting decision-making and process enhancement.
  • High manual intervention in audit and template modifications adversely impacted stakeholders’ productivity, exacerbated by the storage of audit data in multiple formats, leading to data silos and hindering targeted filtration, segmentation, and audit analysis.
Solution
  • Two applications were built for audit management and streamlining employee onboarding and offboarding with power apps.
  • The employee management application automates onboarding and offboarding, enabling comprehensive data management.
  • The application was designed with robust data gathering, filtering, and auditing functionalities. It could seamlessly integrate with Azure Active Directory, enabling the retrieval and secure storage of employee data in the cloud.
  • The newly developed audit app will act as a one-stop platform where auditors and QA teams can schedule, perform, and review audits, add improvement points, establish work plans, and conduct re-audits as necessary.
  • Multiple Power BI dashboards were developed considering critical factors like data sources, tables, and DAX calculations to enable faster decision-making.
  • A Common Data Service (CDS) was designated as the data source for Power BI reporting, and separate workspaces were created for development, testing, and production.
  • Power Automate flows were integrated into the system to send notifications to assigned users once an audit was completed, ensuring timely communication and follow-up.
Results at a glance
Reduced administrative overhead with automated onboarding/off-boarding processes Streamlined audit conduction, review, modification, and progress tracking Improved performance  and trend visualization  with Power BI reports    
Benefits
  • Implementing a dedicated application streamlined the employee onboarding process and improved their data security.
  • Incorporation of advanced multi-select filtering, easy sharing options, and export functionalities, optimized data management, and increased user productivity.
  • Creating actionable work plans based on identified improvement points, enhanced operational efficiency, and streamlined process tracking.
  • The organization experienced significant improvements in critical areas, including increased ROI and reduced operational costs with the advanced Power BI reports.
Technology
  • Power Apps – Model Driven and Canvas Application