The Minnesota Metropolitan Council partnered with Infojini to modernize and automate its internal operations using Microsoft’s Power Platform. The engagement focused on building custom applications, dashboards, and workflow automations that would enhance operational efficiency, minimize manual effort, and improve real-time access to data across departments. Infojini’s team designed, developed, and deployed solutions across Power Apps, Power Automate, Power BI, and Power Portals, fully integrated with the Council’s existing SQL Server infrastructure.

Challenges:

• Low-Code Application Architecture: The Council required low-code solutions tailored to complex business processes, ensuring ease of use and scalability.
• Cross-System Integration with SQL Server Databases: Integration with multiple back-end SQL Server databases was critical to ensure data integrity and seamless access across Power Platform tools.
• 10+ Custom Workflow Automation: Multiple business workflows needed to be automated using Power Automate to reduce delays and repetitive work.
• Optimized UX for Power Platform Tools: UI/UX had to align with both mobile and desktop experiences, especially for field operations and approvals.
• Performance Monitoring & Reporting: Leadership required dynamic, filterable reports built using Power BI for operational insights.

Job Roles:

• Power Platform Developers: Built apps, automated flows, and dashboards using Power Apps, Automate, and BI.
• Data Integration Engineers: Developed connectors and data pipelines between SQL Server and Power Platform.
• UI/UX Designers: Created responsive and accessible interfaces within Power Apps and Portals.
• Business Analysts: Defined business logic, performed data mapping, and created user flow diagrams.
• Project Manager: Led agile sprints, tracked KPIs, and coordinated deployments.

Infojini’s Solution:

• Power Platform Implementation: Delivered a full-stack solution leveraging Canvas Apps, Power Automate Cloud Flows, and Power BI Embedded Dashboards.
• Workflow Automation Using Power Automate: Designed and deployed 10+ logic-based workflows in Power Automate, incorporating triggers, conditions, loops, and approvals to reduce manual intervention by 80%.
• Custom Apps and BI Dashboards: Built 5+ tailored applications including internal field apps, task management tools, and reporting dashboards with role-based views.
• Automated Service Requests Routing with Power Automate: By integrating Microsoft Power Automate with SharePoint and Power Apps, service requests were automatically routed to the appropriate departments. As a result, the Metropolitan Council saw a 50% reduction in service request clearance time.
• Real-Time SQL Server Integration: Used On-Premises Data Gateway and SQL connectors to ensure secure, real-time CRUD operations across workflows and dashboards.
• Interactive Dashboards & Reporting Using Power BI: Implemented Power BI dashboards to provide operational visibility, performance tracking, and analytical insights to stakeholders.
• Scalable Design & Collaboration with Low-Code Solutions: All solutions followed ALM best practices, ensuring future extensibility via environment variables, component libraries, and Power Platform CLI.

Results:

• 10+ workflows automated, delivering 80% reduction in manual task time
• Implemented automated routing system, reducing service request clearance time by 50%
• 5+ apps & dashboards launched across departments
• 3+ SQL Server systems integrated in real time
• Power BI dashboards enhanced executive decision-making with real-time KPIs
• 99.5% uptime across Power Automate flows
• Accelerated digital transformation and boosted interdepartmental collaboration