Course Outline
Overview of the Microsoft Power Platform
- Introduction to Power BI, Power Apps, Power Automate, and Power Virtual Agents
- Grasping the strategic business benefits of low-code development
Initial Steps with Power BI
- Setup and configuration of Power BI Desktop
- Linking diverse data sources such as Excel, databases, and cloud services
- Executing data cleansing and transformation via Power Query
Constructing Data Models and Relationships in Power BI
- Conceptualizing data models and defining relationships
- Employing DAX (Data Analysis Expressions) for complex calculations
- Establishing hierarchies and creating measures
Visualizing Data and Building Dashboards
- Crafting effective, interactive dashboards
- Implementing filters, drill-through capabilities, and conditional formatting
Getting to Know Power Apps
- Navigating the Power Apps development environment
- Developing both canvas-based and model-driven applications
- Structuring user interfaces and layouts for optimal usability
Integrating Power Apps with Data Sources
- Utilizing Dataverse, SharePoint, and Excel as backend data sources
- Building forms, galleries, and data cards
- Implementing business logic through formulas and actions
Workflow Automation and System Integration
- Leveraging Power Automate alongside Power Apps and Power BI
- Configuring triggers and setting up automated workflows
- Practical automation scenarios including approvals, alerts, and data updates
Deployment, Collaboration, and Security Protocols
- Distributing dashboards and applications across the organization
- Overseeing permissions, environments, and data governance standards
- Adhering to best practices for solution maintenance and updates
Recap and Future Roadmap
Requirements
- Fundamental knowledge of data management and reporting methodologies
- Basic proficiency with Microsoft Excel or comparable spreadsheet applications
Target Audience
- Business analysts
- Data specialists
- Managers and key decision-makers
- Experts in process automation
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