Seed Training Group 携手
AFMA澳洲财务模型师协会
共同举办全澳网络同步培训
『商务智能首创培训课程』
Power BI Esential
在2016年底课程推出，已有
超过100位学员
参加此项培训。
学员来自各种专业领域：
Accounting / Finance /
Business Analysis / IT /
Marketing Research /
Big Data Management
课程将围绕微软商务智能工具
✅ Power Query
✅ Power Pivot
✅ Power View
✅ Power Map
4大组件展开
讲师 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
