Power Bi Course Curriculum:

Few of the topics that will be covered in our Power BI Training Classes in Abu Dhabi include the following:

I) Introduction to Power BI

  • What is BI
  • History of Power BI
  • Benefits of Power BI
  • Components
  • Power BI Desktop – Installation
  • Building Blocks
  • Demo – Sample Power BI Reports
  • Creating a Simple Report

II) Get Data & Transform Data with Power Query

  • Get and edit Data – An ETL Tool (Extract, Transform, Load)
  • Get data from Excel File
  • Get data from CSV File
  • Get data from Folder
  • Get data from SQL
  • Get data from Access
  • Get data from Website
  • Understanding Power Query Editor
  • Load vs Direct Query
  • Append Queries
  • Merge Queries
  • Filtering Rows
  • Split Columns based of Delimiter, Merge Columns
  • Eliminating Columns
  • Fixing Metadata issues
  • Creating Custom Column based on the Conditions
  • Refresh Queries
  • Introduction to M Query Language

III) Data Modelling

  • Introduction to Data Modeling
  • Creating Relationship between tables
  • Building a data model
    a. Hiding columns from Reporting View
    b. Sorting and Formatting
    c. Creating Hierarchies
  • Create Calculated columns – M Language
  • Creating a Date Dimension

IV) Power BI Visualizations

  • Introduction to visuals in Power BI
  • Create and customize simple visualizations
  • Recommended Charts for your data set
  • Bar charts and Column Charts
  • Line Charts and funnel charts
  • Pie Charts and Donut Chart
  • Tree Charts and Maps
  • Combination charts
  • KPI and Card Charts
  • Table and Matrix Views
  • Buttons and Bookmarks
  • Adding Text box, Shapes and Images to Reports
  • Creating Stunning Dashboard & Interactive Reports in few clicks

V) Slicing and Dicing

  • Filters
  • Slicers
  • Parameters
  • Manage Interaction between objects
  • Drill down/Roll Up

VI) Introduction to DAX Language

  • Introduction to DAX Functions
  • DAX Syntax
  • DAX Data Types
  • DAX Operators
  • DAX Functions
    a. Logical Functions
    b. Aggregate Functions
    c. Date and Time Functions
  • d. Text Functions
    e. Mathematical Functions
    f. About Calculate Function
    g. Working with Complex DAX Formula

VII) Publishing and Sharing Power BI Reports

  • Publish from Power BI Desktop
  • Working with Power BI Service
    a. On Web
    b. On Mobile/Tab
  • Modify Reports in Power I Service
  • Export Data from a Visualization
  • Create Dashboards based on Multiple Reports
  • Sharing Dashboards and Reports
  • Empower Stakeholders to Dazzle their Data Through Sharing
  • Refreshing Datasets
  • Setup Power BI Gateway to refresh Local Data
  • Manage Roles.