Power BI

Course Overview

Power BI training teaches individuals how to use Microsoft’s business analytics tool to visualize and analyze data. Power BI allows users to create interactive data reports, dashboards, and charts using a variety of data sources. Power BI training covers topics such as creating reports and dashboards, integrating data from multiple sources, and using data visualization techniques to communicate insights. Training may also include how to use Power BI’s advanced features, such as data modeling, DAX (Data Analysis Expression) formulas, and integration with other Microsoft tools.

At the end of the training, participants will be able to:

  1. Appreciate the benefits of using Business Intelligence
  2. Learn to access Power BI Workspace
  3. Connect to Data Sources
  4. Integrate Power Query for Data Transformation
  5. Data Modelling in Power BI
  6. List Visuals and Filters in Power BI

Pre-requisite

  1. Knowledge of relational databases and reporting.
  2. Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
 

Duration

3 days

Course Outline

  1. Evolution of Business Intelligence
  2. Business Intelligence in Modern World
  3. Questions BI can Answer
  4. BI Technologies
  5. BI Tools
  1. Introduction to Power BI
  2. Power BI Products
  3. Power BI Architecture
  4. Integration with Microsoft Flow
  5. Power BI over Excel
  1. Power BI Desktop
  2. Power BI Desktop Functions
  3. Useful terms in Power BI Desktop
  1. Connect to Files
  2. Connect to SQL Server
  3. Connect to Web data
  4. Data Entry in Power BI Desktop
  5. Connect to Direct SQL Query
  1. Power Query Editor
  2. Power Query Editor: Field Specifications
  3. In-depth Functionalities in Power Query Editor
  1. Introduction to Data Model
  2. Building Relationships
  3. What is DAX?
  4. DAX contexts
  5. DAX Syntax
  6. DAX Calculation types
  7. DAX Functions
  8. DAX Operators
  1. Visualizations in Power BI
  2. Creating Visualizations in Power BI
  3. Filters in Power BI
  4. What is Slicer?
  5. Types of Slicer
  6. Changing Visual Settings
  7. Preview features in Power BI
  1. Power BI Services
  2. Power BI Service vs. Report Server
  3. Publish Report on Power BI Services
  4. Workspace in Power BI
  5. Power BI Row Level Security(RLS)
  6. Power BI Dashboard
  7. Power BI Other Functionalities
  8. Power BI Gateway

Reviews