Legal Aid Alberta
client success story
What we delivered
Developed comprehensive service management and content management solutions on the Microsoft platform.
- Transitioned CRM solution from on-premise to the cloud
- Refreshed and optimized SharePoint, Web Portal and Dynamics
- Developed Power Apps to automate manual processes
- Created KPIs and related Power BI dashboards
The organization
The organization
Legal support for families
Legal Aid Alberta provides affordable legal services in family law, family violence matters, child welfare, immigration, and youth and adult criminal defense.
The challenge
The challenge
Manage client accounts and associated workflows
Legal Aid Alberta (LAA) required a web solution that would be used to manage different types of client accounts within the organization and automate manual business processes. A pre-requisite to building out this desired functionality was the integration of data using a Microsoft Dynamics 365-based CRM. In addition to the core solution of the Dynamics CRM, it requires multiple portals for the day-to-day activities of the organization based on the users and the types of organizational processes and standard operational procedures.
The solution
The solution
A modern workplace based on Microsoft platform
Silver Creek led the customization and configuration of the Dynamics CRM On-Premises, SharePoint, and multiple portals for the day-to-day activities of the organization based on the users and the types of the organizational processes and standard operational procedures.
Data Management
· Developed solution architecture for new reports, portals, and cloud environments
· Designed and developed tabular data models in SSAS to satisfy business requirements and data analysis.
· Migrated Power BI Reports to Tabular data models and reduced storage usage by 90%.
Application Development
· Leveraged PowerApps to automate complex business processes, reducing manual labor, improving data accuracy and reporting through SQL Server and Power BI.
· Developed deep-linking and variable dependencies between different databases in the same PowerApp to ensure seamless data integration.
· Created a waffle menu and linked seven PowerApps, enabling easy navigation across different business processes.
Data Integration
· Created New ETL pipeline for Dynamics CRM (on-premises) migration to Dynamics 365 migration (On-Cloud)
· Used Azure logic apps and on premises gateway to integrate data from dynamics to COTS app called Legal Aid Files
Dynamics Portal Development
· Application Front End Development using React
· Application Back End Development using .NET Core and Entity Framework Core (Code-First approach)
· Web API Development using .NET Core and Integration to the Front-End Application
The benefits
The benefits
Successful impact on the business
Legal Aid Alberta has been very pleased with the successful modernization of its workplace. Their appreciation is evident on the fact that LAA has relied on Silver Creek resources for the fluid delivery of Dynamics and SharePoint Maintenance services since November 2009.
To date all projects have been implemented rapidly and successfully. Silver Creek have managed to provide major changes to the working environment while LAA continued to operate on the live environment supporting the organizational day-to-day activities of the organization.
Looking for a similar solution?
SilverCreek is a premiere IT professional services firm at the forefront of data management, analytics, application development and automation. We have established ourselves as the leading digital innovation partner in western Canada by delivering industry-leading data products with excellence in customer service.
Let us help improve the value of your data and build solutions you can use.
