Microsoft Power BI

by Elegant Training Center

This is a highly engaging and interactive course designed to help the delegates learn about Power BI application and its uses as an analytical software.

AED 1200

Contact the Institutes

Fill this form
Elegant Training Center Logo

img Duration

20 Hours

Course Details

Power BI is quickly becoming the world’s most powerful self-service business intelligence platform, and an absolutely essential tool for Finance and Business Data professionals.

Microsoft Power BI transforms company data into rich visuals that facilitate new ways of thinking about and organizing data so that users can focus on what's important to achieving business goals.

The user-friendly Power BI reporting application has been designed to help users, of all experiential levels, produce insightful data analysis - hence our interactive and highly engaging BI training course helps candidates across departments communicate performance-related data in a visually understandable manner.

This course will help participants understand the fundamentals and uses of Power BI and to develop business intelligence workflow, and teach you how to connect and transform source data, build complex relational models, Analyze data with powerful DAX functions and design stunning, interactive dashboards from scratch.

Course Outline

Part 1 - Connect & Transform the Raw Data into Power Bi

  • Types of Data Connectors

  • Basic Table Transformations

  • Text, Number & Date transformation tools

  • Index & Conditional Columns

  • Power Query Parameters

  • Invoke Custom Functions

  • Grouping, Aggregating, Pivoting & Unpivoting

  • Modifying, Merging & Appending Queries

  • Connecting to Folders and automate data loading

  • Change the structure of unorganized multiple data files into the proper format and combined the data into one file

  • Connecting to Website with Parameters

  • How to import data from SQL Database to Power BI

  • Defining Hierarchies & Categories

  • Connecting Data from Text files, Excel files, from Folders and Access Data Bases, etc.

  • Automation of data loading procedures

  • How to add custom columns and columns from examples

  • Best Practices in Power Query Data transformation

Part 2 - BUILD a Relational Data Model Power Bi

  • Intro to Database Normalization

  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables

  • Creating Table Relationships

  • "Star" vs. "Snowflake" Schemas

  • Active vs. Inactive Relationships

  • Filter Context & Cardinality

  • Connecting Multiple Data Tables

  • Hiding Fields from Report View

  • Data Modeling Best Practices

Part 3 – Using DAX measures and calculated Columns

  • Intro to Data Analysis Expressions (DAX)

  • Calculated Columns vs. Measures

  • What is Evaluation Context

  • Row Context vs. Filter Context

  • How to create your first measure

  • Implicit Measures Vs Explicit Measures

  • DAX Syntax & Operators

  • Basic Date & Time Intelligence Formulas

  • Logical & Conditional Statements

  • Text, Math & Stats Functions

  • CALCULATE Function

  • Context Transition with CALCULATE

  • How to use Calculate and ALL & FILTER Functions

  • SWITCH / SWITCH (TRUE) Function

  • How to calculate Percentage of Parent with ALL Function

  • ALL SELECTED / TOPN / SELECTEDVALUE

  • DAX Iterators (SUMX, AVERAGEX, MINX)

  • How to use HASONEVALUE to fix total issues

  • Handle Many to Many (MTM) relationships with virtual relationships using TREATS function

  • How to Calculate Moving Average with DAX

  • Time Intelligence Functions SAMEPERIODLASTYEAR, DATEADD, YTD, MTD, QTD, DATESINPERIOD, PARRALLAL PERIOD

  • How to use DAX VARIABLES and simply complex DAX queries

  • DAX Best Practices

Part 4 - Design Interactive Reports

  • Intro to the Power BI Report View

  • Adding Objects & Basic Charts

  • Formatting & Filtering Options

  • Slicers, Timelines, Cards & KPIs

  • Map Visuals (Basic, Fill, ArcGIS)

  • Treemaps, Lines, Areas & Gauges

  • Using Decomposition tree

  • Visual Interactions and Navigation tips

  • Advanced visualization tips and tricks

  • Using Bookmarks and Selection Pane

  • How to use Power BI Custom Visuals

  • Row Level Security and Publishing to Power BI Service

  • Editing Report interactions & Drill through Filters

  • Connect drill through filters to buttons

  • Using the power of Artificial Intelligence (AI) with Power BI

  • Data Visualization best practices as per IBCS standards (International Business Communication Standards)

For Whom?

  • Finance & Accounting Professionals

  • Financial & Business Analysts

  • Market Research Analyst

  • Investment Analysts

  • HR Professionals

  • Sales Professionals

Prerequisites:

  • Students need to bring a Laptop that has Microsoft Power BI installed. Power BI is currently only compatible with PC/Windows (not available for Mac). 
  • There are no prerequisites for this Power BI Course - it is open and accessible to all individuals that wish to enhance their knowledge of Power BI.

Special Message

special offer for this batch

Elegant Professional and Management Development Training stands as a distinguished training center in Al Barsha1, Dubai, UAE setting the standard for excellence in face-to-face training programs. As a KHDA-approved and Autodesk Authorized center, we pride ourselves on offering affordable, effective, and industry-recognized courses across diverse fields, including Engineering & IT, Finance, Sales & Marketing, and HR & Administration.

As a KHDA-approved center, our dedication to quality education is recognized by the regulatory authority, assuring you of our commitment to delivering courses that meet the highest standards.

Moreover, being an Autodesk Authorized center in Dubai underscores our expertise in providing cutting-edge training in engineering and technology.

  • Barsha Branch

    Office Number 620, AL Attar Business Centre, Beside ibis Hotel, Al Barsha 1 Sheikh Zayed Road, Dubai,UAE Near Sharaf DG Metro Station, Barsha, Dubai

Check out more Power BI courses in UAE

G-TEC Education Institute Logo

Power BI Training Course

The Power BI Training Course at G-TEC Education Institute in Dubai is a comprehensive program designed to empower participants with the skills and knowledge to harness the power of data visualization and analysis using Microsoft Power BI. In

by G-TEC Education Institute
Learners Point Academy Logo

Data Science & Big Data Analytics

This training will provide you with an opportunity to learn about designing, developing and deploying Data Science and explore the applications of Big Data in the real world. 

by Learners Point Academy
  • Price
  • Start Date
  • Duration
Aptech Computer Training Logo

Data Visualization using Tableau

The visual representation of your data in a worksheet or dashboard. A collection of one or more worksheets and dashboards. A single view of data. Organizations use Tableau to visualize data and reveal patterns for analysis in business intell

by Aptech Computer Training
  • Price
  • Start Date
  • Duration
Accountants And Auditors Association Logo

Introduction To Data Analytics

This course allows participants to learn how to analyze data and apply to modern business. Accountants and Auditors also provide students with a credible certificate on completion of course alongside 18 CPE hours for continuous development.

by Accountants And Auditors Association
  • Price
  • Start Date
  • Duration
Accountants And Auditors Association Logo

Microsoft Power BI (Business Intelligence)

This training is for individuals interested in developing interactive dashboards through Microsoft's latest Business Intelligence (BI). Accountants and Auditors Association provides participants with a credible certificate on completion of c

by Accountants And Auditors Association
  • Price
  • Start Date
  • Duration

© 2025 www.coursetakers.ae All Rights Reserved. Terms and Conditions of use | Privacy Policy