MOC 20778




15 horas lectivas.
5 Horas / Día




Requisitos previos:

Before attending this course, students must have:

  • Excellent knowledge of relational databases and reporting.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel




  • Presencial en Madrid y Barcelona
  • En oficina de cliente
  • Online Direct



El objetivo de este curso es proporcionar a los estudiantes una buena comprensión del análisis de datos con Power BI, incluyendo visualizaciones, servicio y Mobile App.


Module 1: Introduction to Self-Service BI Solutions

  • Introduction to business intelligence
  • Introduction to data analysis & data visualization
  • Overview of self-service BI
  • Considerations & Microsoft Tools for self-service BI

Lab : Exploring an Enterprise BI solution

Module 2: Introducing Power BI

  • Power BI
  • The Power BI service

Lab : Creating a Power BI dashboard

Module 3: Power BI

  • Using Excel as a data source for Power BI
  • The Power BI data model
  • Using databases as a data source for Power BI
  • The Power BI service

Lab : Importing data into Power BI

Module 4: Shaping and Combining Data

  • Power BI desktop queries
  • Shaping data
  • Combining data

Lab : Shaping and combining data

Module 5: Modeling data

  • Relationships
  • DAX queries
  • Calculations and measures

Lab : Modeling Data

Module 6: Interactive Data Visualizations

  • Creating Power BI reports
  • Managing a Power BI solution

Lab : Creating a Power BI report

Module 7: Direct Connectivity

  • Cloud data
  • Connecting to analysis services

Lab : Direct Connectivity

Module 8: The Developer API

  • The developer API
  • Custom visuals

Lab : Using the developer API

Module 9: Power BI mobile app

  • Power BI mobile apps
  • Using the Power BI mobile app
  • Power BI embedded


Dónde Estamos

Gadesoft Madrid
C/ Clara del Rey, 14
28002 Madrid, Spain
Tfn: (+34) 91 510 23 90

Gadesoft Barcelona
Carrers del Madrazo, 27 - 2º 4ª
Barcelona, 08006
Tfn: (+34) 93 368 00 87