Power BI Course for Analysts – no certified

Course overview
Prerequisistes
Syllabus

Module 1 – Introduction to Business Intelligence

  1. Introduction to Business Intelligence
  2. Business Intelligence scenarios
  3. Business Intelligence teams
  4. Self-Service BI

Module 2 – Introduction to the Microsoft Power BI suite of tools

  1. Business Intelligence Tools
  2. What is Power BI?
  3. What is the Power BI Portal?
  4. What is Power BI Mobile?
  5. What is the Power BI Report Server?
  6. Installing Power BI
  7. Understanding the Power BI environment
  8. Understanding Power BI Terminology
  9. Lab – Installing Power BI Desktop
  10. Lab – Creating your first report

Module 3 – Connecting to Data Sources

  1. Choosing the right connector for your source
  2. Connecting to an SQL Server
  3. Connecting to an Excel File
  4. Connecting to a CSV File
  5. Data Connectivity Mode
  6. Advanced Options
  7. What is a Dataset?
  8. Best Practices
  9. Lab – Connecting to an Excel file
  10. Lab – Connecting to an SQL Server in Azure

Module 4 – Modeling Data

  1. Data Warehouses
  2. Data Warehouse Examples
  3. Relationships
  4. How Relationships are used in Reports
  5. Lab – Creating Relationships

Module 5 – Power BI Visuals

  1. Reports
  2. Power BI Visual Types
  3. Charts
  4. Maps
  5. Tables/Matrix
  6. Custom Visuals
  7. Interactive Data Visualizations
  8. Lab – Creating Charts and Maps
  9. Lab – Importing and using Custom Visuals

Module 6 – Power BI Transformations

  1. What are transformations?
  2. Shaping Data
  3. Combining Data
  4. Calculated Columns
  5. Measures
  6. Transformation Best Practices
  7. Lab – Shaping and Combining Data
  8. Lab – Creating Calculated columns
  9. Lab – Creating Measures

Module 7 – Power BI Languages

  1. Data Analysis Expressions (DAX)
  2. Transact-SQL
  3. Multidimensional Expressions (MDX)
  4. The R Programming Language
  5. Python
  6. Power Query Formula “M” Language
  7. Lab – Using DAX
  8. Lab – Using T-SQL

Module 8 – Power BI Portal and Collaboration

  1. The Power BI Environment and Menus
  2. Why Workspaces?
  3. What Are Dashboards?
  4. What Are Apps?
  5. Lab – Sharing Your Reports
Duration : 1,5 Days
Regular Rate : 495.00 $
Note :
Upcoming Dates :
qty