讲师 Terry Lin 

资深 Financial Controller

同时拥有金融、IT 以及会计

 三大领域的殷实经历

Power BI 澳洲

会计实战应用第一人

Power BI Essential Training Outline

1. Get Data with Power Query

   1) Understand Power BI data sources

   2) Connect to different types of files

   3) Connect to a web data source

   4) Import Excel data models to Power BI

   5) Send data from Power Query to Power Pivot

   6) Append data to a query

   7) Merge and group data

   8) Reduce data with the Query Editor

2. Data Analysis in Power Pivot

  1) Transform data

  2) Add an index column

  3) Clean up data

  4) Create hierarchy / relationships between tables

  5) Use lookup tables in a dataset

  6) Generate insight with DAX calculations

3. Create Business Report in Power View & Power Map

   1) Create and format chart visuals

   2) Use Matrices, Cards and Tiles to visualize Power View Data

   3) Complete the dashboard using slicers and timeline

   4) Create an data map and other useful charts

   5) Creating interactive dashboards

   6) Set drill through features in Power BI report

   7) Publish report to the Power BI

   8) Refresh and remove datasets and reports