Course Outline
Foundations of the Microsoft Power Platform
- An overview of Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Synergy between Microsoft 365 and the Power Platform
- Grasping the business advantages of low-code development
Initial Steps with Power BI
- Setup and configuration of Power BI Desktop
- Establishing connections to diverse data sources including Excel, databases, and cloud services
- Data purification and processing techniques via Power Query
Building Data Models and Defining Relationships in Power BI
- Conceptualizing data structures and inter-table relationships
- Performing calculations using DAX (Data Analysis Expressions)
- Constructing hierarchies and defining measures
Visualizing Data through Dashboards
- Crafting intuitive and interactive dashboard designs
- Utilizing visual components such as charts, maps, slicers, and tables
- Implementing filters, drill-through capabilities, and conditional formatting
Getting Acquainted with Power Apps
- Exploring the Power Apps development environment
- Building both canvas and model-driven applications
- Structuring user interfaces and layout arrangements
Linking Power Apps to External Data
- Utilizing Dataverse, SharePoint, and Excel as underlying data stores
- Constructing forms, galleries, and data cards
- Developing application logic through formulas and actions
Achieving Automation and System Integration
- Combining Power Automate with Power Apps and Power BI
- Configuring triggers and automated process flows
- Real-world automation scenarios including approvals, alerts, and data updates
Deployment, Collaboration, and Security Protocols
- Releasing dashboards and applications within the organizational framework
- Overseeing access rights, environment settings, and data governance
- Best practices for the ongoing maintenance and iteration of solutions
Recap and Future Directions
Requirements
- Fundamental knowledge of data management and reporting procedures
- Basic experience with Microsoft Excel or comparable spreadsheet applications
Target Audience
- Business analysts
- Data specialists
- Executive management and decision-makers
- Workflow automation experts
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
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions