Power BI for End Users


Course Duration:

2 days (16 hours)

Delivery Mode:

Virtual Class via Zoom

Course Fee:

Php 8,300.00 | USD 250.00*

Course Information

This course equips developers with the skills to develop comprehensive solutions on the Microsoft Azure platform. Participants will gain expertise in implementing Azure compute solutions, building Azure Functions, managing web apps, leveraging Azure storage, integrating authentication and authorization mechanisms, and fortifying solutions with KeyVault and Managed Identities. Additionally, learners will explore techniques to connect to Azure services and external third-party services, while incorporating event- and message-based models into their solutions. The curriculum also addresses crucial aspects such as monitoring, troubleshooting, and optimizing Azure solutions for peak performance.

Participants enrolled in this course are individuals with a keen interest in Azure development, aspiring to deepen their understanding of Microsoft Azure technologies and expand their proficiency in cloud-based application development. Additionally, many students are pursuing certification as Microsoft Azure Developer Associates and seek to acquire the requisite knowledge and skills to excel in the certification examination.

Module 1: Introduction to Power BI

  • Understanding Business Intelligence
  • Overview of Power BI
  • Introduction to Power BI Tools and Services
  • Case Studies and Data Stories
  • Support and Resources

Module 2: Requirements Gathering and Project Setup

  • Welcome to House Rules Board Games
  • Initiating a Power BI Project
  • Defining Grain Statements
  • Data Discovery and Refinement
  • Data Modeling and Report Building
  • Creating Dashboards
  • Workspace Selection and Management
  • Creating and Sharing Reports

Module 3: Extract, Transform, and Load (ETL) Data

  • Creating Projects with Power BI Desktop
  • Understanding PBIX Files
  • Connecting to Data Sources
  • Managing Data Connections
  • Refining Data with Query Editor
  • M Code Language and Applied Steps
  • Query Designing and Column Operations
  • Handling Star Schemas and Custom Columns

Module 4: Data Modeling

  • Understanding Relationships and Cardinality
  • Cross-Filter Direction
  • Table and Column Management
  • Introduction to DAX (Data Analysis Expressions)
  • Creating Calculated Columns and Measures
  • Incorporating Lookup Tables
  • Structuring Data with Hierarchies
  • Roles and Row-Level Security

Module 5: Report Design

  • Adding Pages and Navigation Controls
  • Utilizing Shapes, Text, and Images
  • Theme Creation
  • Visualizations and Charts
  • Filters and Slicers Implementation
  • Incorporating Drill-Throughs
  • Custom Visualizations and Phone Layouts
  • Report Optimization Tips

Module 6: Workspaces and Dashboards Management

  • Understanding Power BI Licensing
  • My Workspaces and App Workspaces
  • Premium Capacity Workspaces
  • Publishing Projects and Parallels with Excel
  • Managing Publishers and Viewers
  • Data Source Reconnection and Refresh Scheduling
  • On-Premises Data Gateway
  • Security Role Assignment
  • Dashboard Creation and Customization
  • Utilizing Q&A and Quick Insights for Tile Creation
  • Mobile Dashboard Design
  • Sharing Reports, Dashboards, and Publishing Apps
  • Content Publishing to Websites

* Inclusive of courseware and lab environment (Access to Azure Portal and Cloud Services covered in the course)

Courses that others have also registered for: