Project Objectives:

• Replace existing SharePoint database
• Introduce automated reporting
• Automate key business notifications

Technologies Used:

• Power Apps
• Power Bi
• Power Automate

Approach:

Understand and model new relational Dataverse tables based on existing SharePoint lists. Migrate data to Dataverse using Dataflows and Power Query. Surface data and enable user inputs via a Model-driven Power App. Leverage JavaScript to apply business specific logic to enforce certain key processes

Key Benefits:

• Unified data capture process
• Automated report generation
• Reduction in data capturing errors
• Enhanced oversight of class allocation
• Improved monitoring of problem students with early intervention capabilities