Certificate Authentication

Module 1: Basics

• Course structure and content
• Download: project files
• Introduction to the course project
• Important information about the course

Module 2: Introduction to Microsoft in Power BI

• Presentation of Power BI Desktop and its components
• Download, Installation and Power BI Desktop settings
• Important: settings and options
• Power BI Service and mobile application

Module 3: Connecting and modeling data in Microsoft Power BI Desktop

• Types of data connectors in Power BI Desktop
• Query Editor (Power Querry)
• Data import from Excel and CSV
• Basic table transformations in Power BI Desktop
• Working with TEXT type tools
• Working with NUMERIC type tools
• Working with DATE and TIME instruments
• Generating conditional and index type columns
• Data grouping and aggregation
• Pivot / Unpivot in Power BI
• Data fusion in Power Query (Merge)
• Pasting data in Power Query (Append)
• Import from a Folder
• Modification of data sources and refresh (Refresh)

Module 4: Creating links between tables and data models in Power BI Desktop

• What is a Data Model?
• DATE type tables and DIMENSION type tables
• Creating Relationships between tables
• Management and editing of relationships between tables
• Cardinality of relationships; Filter Flow
• Connecting several DATA type tables

Module 5: Data analysis with DAX calculations in Power BI

• Introduction to DAX (Data Analysis Expressions) + SYNTAX
• Intro DAX – Calculated Columns
• Intro DAX – Measures
• The filter context of the Measures
• Categories of DAX functions
• Date and Time functions

Module 6: Data visualization in Power BI

• Introduction to the "Report" Mode
• Inserting visuals in Power BI
• Visual formatting options
• Filtering options
• Explore data with the Matrix visual
• Data filtering using Slicers
• Displaying the values using the Card and KPI visuals
• Editing interactions between reports

Module 7: Power BI Service and integration with Teams

• Publishing reports from Power BI Desktop in Power BI Service
• Creating Dashboards from published reports
• Sharing options with team members using Microsoft Teams
• Sharing and collaboration in Power BI Service
• Data export: Excel, PowerPoint, PDF