Get in Touch
 Duration 21 hours

Course Outline

Overview of the Microsoft Power Platform

  • Introduction to Power BI, Power Apps, Power Automate, and Power Virtual Agents
  • How Microsoft 365 integrates with the Power Platform
  • The strategic business benefits of adopting low-code development models

Foundations of Power BI

  • Setup and configuration of Power BI Desktop
  • Establishing connections to diverse data sources such as Excel, databases, and cloud services
  • Applying data cleaning and transformation techniques with Power Query

Building Data Models and Relationships in Power BI

  • Grasping the concepts of data modeling and entity relationships
  • Utilizing DAX (Data Analysis Expressions) for advanced calculations
  • Constructing hierarchical structures and defining key measures

Advanced Data Visualization and Dashboard Design

  • Crafting intuitive and interactive dashboard experiences
  • Leveraging visual components like charts, maps, slicers, and tables
  • Implementing filters, drill-through navigation, and conditional formatting rules

Getting to Know Power Apps

  • Navigating the Power Apps development environment
  • Building both canvas and model-driven applications
  • Designing user-friendly interfaces and structured layouts

Integrating Power Apps with Data Sources

  • Utilizing Dataverse, SharePoint, and Excel as primary data repositories
  • Developing functional forms, galleries, and data cards
  • Establishing application logic through formulas and triggered actions

Workflow Automation and System Integration

  • Coordinating Power Automate with Power Apps and Power BI
  • Configuring triggers and automated business processes
  • Real-world automation scenarios, including approval chains, notifications, and data updates

Deployment, Collaboration, and Security Governance

  • Rolling out dashboards and applications across the organization
  • Administering access rights, environments, and data governance policies
  • Best practices for the ongoing maintenance and evolution of solutions

Recap and Future Learning Paths

Requirements

  • Foundational knowledge of data management and reporting cycles
  • Basic proficiency with Microsoft Excel or comparable spreadsheet applications

Target Audience

  • Business analysts
  • Data specialists
  • Managers and strategic decision-makers
  • Workflow automation experts

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories