Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Overview of the Microsoft Power Platform
- Examination of core components: Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Interoperability between Microsoft 365 and the Power Platform
- Assessment of the operational value associated with low-code development for government agencies
Initiating Work with Power BI
- Installation and configuration of Power BI Desktop
- Establishing connections to diverse data sources, including Excel files, relational databases, and cloud services
- Execution of data cleaning and transformation procedures using Power Query
Data Modeling and Relational Structures in Power BI
- Comprehension of data model architecture and relationship mapping
- Utilization of DAX (Data Analysis Expressions) for complex calculations
- Development of hierarchical structures and calculated measures
Data Visualization and Dashboard Development
- Design principles for effective and interactive data dashboards
- Deployment of visual components: charts, maps, slicers, and tabular views
- Implementation of filtering mechanisms, drill-through capabilities, and conditional formatting
Fundamentals of Power Apps
- Familiarization with the Power Apps development environment
- Development of canvas apps and model-driven applications
- Designing user interfaces and responsive layouts for government systems
Linking Power Apps to Data Sources
- Integration with Dataverse, SharePoint lists, and Excel workbooks as data backends
- Construction of data entry forms, gallery views, and data cards
- Implementation of business logic through formulas and automated actions
Workflow Automation and System Integration
- Leveraging Power Automate to enhance functionality within Power Apps and Power BI environments
- Configuration of triggers and automated workflow sequences
- Application scenarios: approval processes, system notifications, and data updates relevant for government operations
Deployment, Distribution, and Security Protocols
- Publishing dashboards and applications across organizational networks
- Administration of user permissions, development environments, and data governance standards
- Adherence to best practices for the maintenance and lifecycle management of solutions
Conclusion and Future Directions
Requirements
- Competency in data management and analytical reporting procedures
- Foundational proficiency with Microsoft Excel or comparable spreadsheet applications
Target Audience
- Business analysts
- Data specialists
- Executive managers and policy decision-makers
- Automation implementation experts
21 Hours
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
The basic structure of Power BI, its main functions, as well as some advanced functions