programming

MS Power BI course

  • Requirements: Basic knowledge of data visualization is required.
  • Modality: Online classes with practical sessions and room for doubts.
  • Duration: 10 horas.
  • Price: 250€.
  • Material: We provide all the material to download and reuse (presentations, codes and data).
  • Software: MS Power BI.
  • Valid certificate of completion.
    Contact us

    Module 1: Introduction to MS Power BI

    • Components
    • Workflow

    30min.

    Module 2: Obtaining and transforming data

      • Get data (flat files, file folder, SQL Server)
      • Power Query user interface
      • Data transformations
        • Group data
        • Replace values
        • Query combination
        • Add queries
        • Cancel dynamization of columns

      3hr.

      Module 3: Data Modeling

      • What is a dimensional model?
      • Fact and Dimension Tables
      • Star model
      • Data granularity and cardinality
      • Creating a calendar table

      30min.

      Módulo 4 : Data Analysis Expressions (DAX)

      • Calculated columns and. Measures
      • Aggregation functions (SUM, AVERAGE, COUNTROWS, DISTINCTCOUNT)
      • Iterator functions (SUMX, AVERAGEX, MAXX, RELATED)
      • Logic functions (IF, SWITCH)
      • Evaluation contexts in Power BI (filter context and row context)
      • Filter functions (CALCULATE)
      • Filter and table manipulation functions (ALL and VALUES)
      • Filter and table manipulation functions (CALCULATE + ALL)
      • Table manipulation and filter functions (CALCULATE + ALLSELECTED)
      • Filter functions (REMOVEFILTERS)

      3hr.

      Module 5: Data visualization

      • Page Settings
      • Add charts to the report
      • Custom visuals
      • Axes format
      • Markers
      • Conditional format
      • Data segmenters
      • Segmenter synchronization
      • Filter panel

      2hr.

      Module 6: MS Power BI Service

      • Exploring Power BI Service
      • Workspaces in Power BI Service
      • Roles in work areas
      • Power BI licenses
      • Free registration in PBI Power BI
      • Scheduled update
      • Configuring gateways
      • Data export
      • Row-level security

      1hr.

      Back to Training

      Adrian Manresa

      Instructor

      Adrian is a Business Intelligence consultant and analyst. His passion for transforming raw data into meaningful business strategies and visualizations has driven the growth and efficiency of companies in different sectors.

      View profile

      Available material

      Presentations, codes, data, and all the material available for reuse.

      Practical courses

      Classes focused on the practical aspect, with space to solve doubts.

      All ready to go?

      Talk to us without obligation to clarify all your doubts.

      Contact us