Power BI in Practice

Introduction

The objective of this course is to introduce participants to automated data analysis from multiple sources, enabling them to transform, clean, and validate data, generate reports and dashboards, and explore advanced tools such as DAX measures, hierarchies, and AI-powered visualizations. We will work with both Power BI Desktop and Power BI Service to understand the full lifecycle of a practical Power BI project.

Objectives

• Upon completion of this course, participants will be able to:
  • • Understand the general functions of Power BI.
    • Perform ETL operations.
    • Create relevant visualizations with Power BI.
    • Manage the lifecycle of a report in Power BI.
    • Use DAX to create simple measures and columns.
    • Publish reports in Power BI Service and manage workspaces.
    • Carry out a hands-on work on a specific situation, working with resources similar to those they currently have.

Participant Profile

Participants with no prior experience in Power BI.

Prerequisites

No prerequisites.

Faculty

Our team of highly qualified instructors combines training with their professional development as experts in the field of ICT. They are professionals certified by the sector’s leading manufacturers who can convey even the most abstract technical concepts in an engaging and understandable way.

Course Materials

Participants will receive references to digital resources that will complement the classroom learning.

Methodology

Guided demonstrations will use different data sources and practical consolidation activities.

Datasets will increase the level of difficulty to facilitate the understanding of how Power BI Desktop and Power BI Service work, from generating reports to data modeling and sharing results.

Content

1. Power BI
   • Features
   • Desktop vs. service
   • Data flow
   • First steps
2. Loading Data into Power BI
   • Available data sources
   • Excel (one or more tables)
   • SQL Server
3. Data Transformation
   • Power Query basics
   • Review of applied steps
   • Joining tables
   • Data cleansing
4. Data Presentation
   • Basic visual elements
   • Tables and matrices
   • Interaction between visuals
   • Filters and bookmarks
5. Data Modeling
   • Relational data model
   • Types of relationships and filters
   • Operations between tables
6. DAX
   • Calculated columns vs. measures
   • Date table
   • Time intelligence
   • DAX fundamentals
7. Power BI Service
   • Dashboards
   • Workspace management
   • Power BI Service features
   • Sharing and security
8. Hands-On
   • Creation of a comprehensive report
   • Power BI lifecycle
   • Advanced visualizations and AI
   • Conclusions

JDB203