Certificate Authentication

Power BI Basic Certificate for Furica Ionut Catalin

Add to LinkedIn

Certificate ID: 
767611
Authentication Code: 
76d9d
Certified Person Name: 
Furica Ionut Catalin
Trainer Name: 
Cosmin Marius Ionescu
Duration Days: 
5
Duration Hours: 
35
Course Name: 
Power BI Basic
Course Date: 
2024-06-10 14:00 to 2024-06-14 17:00
Course Outline: 

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