Request Information

 
 
 
 
Content
ICDL Traing Classes in Dubai

Power Business Intelligence

About this course:

Analyzing Data with Power BI

This 5 hours instructor-led course provides students with the knowledge and skills analyze data with Power BI

Topics include:

Getting Started

  • Introduction to Power BI
  • Installing Power BI Desktop version
  • With Power BI you can:
    • Get Data
    • Model Data
    • Report Data
    • Save Data
    • Publish Data
  • Power BI Interface elements
  • Power BI Views:
    • Data View
    • Report View
    • Relationship View
  • Power BI Query Editor
  • Getting Data from:
    • Excel
    • Access Database
    • CSV
    • Website
    • XML
    • Facebook
    • Microsoft Azure
    • Google Analytics
  • Shape and Combining Data from multiple source
    • Grouping Rows
    • Creating Pivot Columns
    • Creating Custom Columns
    • Query Formulas
  • Understanding Releationships in Power BI
    • Using Autodetect feature
    • Creating Relationship manually
    • Edit Relationship
    • Configure Advanced Options
      • Cardinality
        • 1 : Many
        • Many : 1
        • One : One
  • What is Data Analysis Expression (DAX)?
    • DAX syntax
    • Tables
    • DAX Operators
  • Functions in DAX
    • Format Function
      • SUMX, AVERAGEX, MINX, MAXX, COUNTAX etc.
    • Related Function
    • RelatedTable Function
    • Logical Function
      • IF condition
      • Switch Function
    • ISBlank Function
    • Contains Function
    • Statistical Function
      • Countrows
      • Distinctcount
    • Text Functions
      • Substitute Function
      • Concatenate Function
    • Data and Time Function
      • ClosingBalanceMonth Function
    • Filter Function
      • All
      • Except
      • Calculate etc.
Trainer : Tauqeer Faiz
IT Instructor, Al Dar University College

Get A Call Back