Microsoft Power BI



  • The newest generation of Data Analytics technology with integration of all modern Data Technologies
  • Powered with Clouding, Data Visualization, Geometric Reporting, Data Warehouse, Business Intelligence, Big Data, AI and Machine Learning
  • The most efficient tool for customizing data analysis for business needs in the easiest way to share your data, reports, visualizations, and dashboards
  • All leading industries progressing their next generation of reporting technology with Power BI, including banking, insurance, manufacture, retail, government
Totally 20 hours, 7 classes/weeks.
Every Sunday 9:30am – 12:30pm.


Class 1. Power BI Overview (2.5 hrs)

  •  What is Power BI
  •  Power BI Infrastructure
  •  How Power BI Works
  •  Power BI Components
  •  Power Query, Power Pivot, and Power View
  •  Course Environment Setup
  •  Download and Install Power BI Desktop
  •  Build the First Report in a Few Steps

Class 2. Data Modeling in Power BI Desktop (3 hrs)

  •  Power BI Data Sources
  •  What is a Table in Power BI
  •  Using Excel as Dataset
  •  Working with Access
  •  Talking to Database – MS SQL Server
  •  Relationship
  •  Data Model
  •  Big Data, R and Python in Power BI

Class 3. Creating Reports in Power BI Desktop (3 hrs)

  •  Data Connection
  •  DirectQuery and Import
  •  Calculation in Power BI
  •  Creating Reports
  •  Shaping and Customizing
  •  Filtering Data in Reports

Class 4. More Works in Power BI Desktop – M Language, DAX, and SQL (3 hrs)

  •  Design the Flow – the M Language
  •  More Details of Data Analysis in Power BI – The DAX
  •  Sending Requests to Database – SQL Queries
  •  Executing more – Running Procedures in MS SQL Server
  •  Fetching Data from SSAS
  •  Integrating Power BI Reports with SQL Server BI with ETL/SSIS

Class 5. Balancing Performance – Power BI Desktop and Power BI Service (3 hrs)

    •  Determining Data Processing Modes
    •  Performance Consideration
    •  On Premise or On Cloud
    •  Preparing for Sharing your Power BI Reports
    •  Power BI on Cloud –
    •  Viewing Reports on the Web

Class 6. Sharing Power BI to the World (3 hrs)

    •  Sending Power BI Reports to Cloud
    •  Building and Sharing Dashboards
    •  Packing your Power BI Applications
    •  Maintaining Power BI Reports – Scheduling Data Refresh
    •  Administering Power BI Reports – Reporting Usage Metrics
    •  Who can do What – Authentications and Permissions

Class 7. Managing Data Security (2.5 hrs)

    •  Subscriptions – In-house Repository, Personal, On Premise, On Cloud
    •  Bridging to you Data Sources – What is Power BI Gateway
    •  Types of Gateway – In-house Repository, Personal, On Premise, On Cloud
    •  Downloading, Installing and Configuring Data Gateway
    •  Creating Roles and Applying Role-Based Security
    •  Licensing and Governance
    •  Row-Level Data Security Control
    •  Wrapping the Work up

负责人:Charlene Ding
联系方式:416-665-1888 Ext:1
微信号:vicxbk2 vicxbk2