Home

课程说明


本课程旨在改善工作方式及提高工作效率，通过理论讲解加实际操作的授课教学方法，综合运用Power BI进行数据获取和整理，数据建模，以及了解并掌握常用DAX函数，并选择适合数据的图表进行最终的可视化展示。


Background

  • You will master how to use power Bi to obtain and sort out data, model data, understand and master common DAX functions, and select charts suitable for data for visual display through theoretical explanation and practical operation.


课程福利：PowerBi 图表实用素材


Others: PowerBi material resource



软件版本


本课程支持Power BI Desktop中文和英文版本。可提供安装包及说明。


Software version



Both Chinese and English versions of Power Bi desktop will be workable. We will provide installation package and instructions.

Session Outline

培训大纲


1       为什么要用Power BI?


2       数据获取与整理


2.1      连接数据源

2.2      填充合并单元格

2.3      合并查询和追加查询

2.4      工作簿和文件夹合并

2.5      二维数据一键转一维表（逆透视）


3       数据建模


3.1      星形模型和雪花模型

3.2      模型关系和方向

3.3      处理虚拟关系：UserRelationship和TreatAs

3.4      自动创建时间维度表

3.5      计算列、计算表和度量值

3.6      数据分组


4       DAX函数


4.1      DAX简介

4.2      DAX运算符和语法规范

4.3      关系函数：Related, RelatedTable和LookupValue

4.4      常用函数：Calculate, Filter,Divide, Earlier, Max, Min, Var/Return等

4.5      日期智能函数：TotalYTD/TotalQTD/TotalMTD, DateAdd等


5       数据可视化


5.1      报表设计原则

5.2      报表颜色搭配

5.3      图表动态配色

5.4      编辑交互效果

5.5      动态显示度量值


6       Q&A环节

Outline


1       Why we need Power BI?


2       Data acquisition and sorting


2.1      Connect the data source

2.2      Fill the merge cells

2.3      Consolidated query and additional query

2.4      Merge the workbooks and folders

2.5      Inverse perspective


3       Data modeling


3.1      Star model and snowflake model

3.2      Model relationship and direction

3.3      Virtual relationships：UserRelationship和TreatAs

3.4      Create time dimension table

3.5      Calculation columns, tables and measures

3.6      Data grouping


4       DAX Function


4.1      DAX introduction

4.2      DAX operator and syntax specification

4.3      Relation functions：Related, RelatedTable, LookupValue

4.4      General functions：Calculate, Filter,Divide, Earlier, Max, Min, Var/Return

4.5      Data functions：TotalYTD/TotalQTD/TotalMTD, DateAdd


5       Data visualization


5.1      Report design principles

5.2      Color matching skills

5.3      Dynamic color matching

5.4      Editing interaction effect

5.5      Dynamic display of measures


6       Q&A

Speakers

  • 晏艳 Grace Yan

    晏艳 Grace Yan

    易迪思金牌讲师
    微软 Office 中英文双语讲师
    微软 Office2013 认证大师 Microsoft Certified Office Master

     多家 500 强企业 Office 培训授课经验
     长期为客户和学员解决 Office 问题
     多个自媒体公众号微课讲师
     受众学员 10000 人以上


     Rich office training in many global 500 companies
     Solove office problem for clients and trainees
     Micro-class trainer for many Wechat Office Accounts
     More than 10,000 trainees



    多年 500 强外企工作经验，能准确挖掘企业培训需求，快速帮助学员提高 Office 技能；课程结构条例清晰，课程案例吻合工作需要；授课风格生动有趣，善于调动学员积极性，深受学员喜欢和好评。

    Having many working experiences in G500 companies, being able to meet corporate’s training requirements, can help students’ office skills quickly, the training is designed in good logic, having a humor teaching style in class and being well acclaimed by trainees



    Office 办公系统课程
     《Excel 商务数据处理与分析》
     《Excel 数据透视表与图表美颜》
     《Excel 高级商务图表制作》
     《Excel 在 HR 中的高效应用》
     《大数据时代——用 PPT 讲话》
     《Office365 该这样玩儿》

    Office Series Courses

     Business Data Processing and Analysis by Excel
     Excel PivotTable and Charts Beautify
     How to Make Business Charts by Excel
     Excel Makes HR Work More Efficient
     PPT Talks in Age of Big Data
     Office 365 Is More Than Office



    曾经服务客户
    雪佛龙中国能源公司
    中国石油西南天然气研究院沃尔沃汽车制造有限公司 西南美商会
    新电科技有限公司澳新银行
    保利地产
    当纳利印刷有限公司四川机场集团
    中国核动力研究设计院电子科大成都研究院 西安印钞有限公司
    中粮大悦城
    上海国际医学园区中国中铁西南院

    Clients

     Chevron China Energy Company
     Petrol China
     Volvo Cars Co., Ltd
     Southwest AmCham
     NCSI
     ANZ Bank
     Poly Real Estate
     RR Donnelley Publishing and Printing Company
     Sichuan Airport Group
     Nuclear Power Institute of China
     Chengdu Institute of UESTC
     Xi’an Banknote Printing Co., Ltd
     Joy City of COFCO
     Shanghai International Medical Zone
     Southwest Institute of CRECG

    view more

Who Should Attend?

适用对象


本培训课程适用于企事业单位市场销售、行政文秘、人力资源、财务会计、仓储物流等与数据接触较多的相关岗位工作人员。

有一定的 Excel 数据分析基础，需要进一步提升数据处理、数据建模分析、数据可视化能力和使用效率的人员。


Who Should Attend



This course will be useful to the employees who have more contact with data, such as marketing, administrate, human resources, financial accounting, logistics.

The participants should have a certain foundation of Excel data analysis.

Tickets

Please use your own name and email when registering for a training session. Additional fees may apply if you fail to register under your own identity. 


A prepayment is required for all full-day training sessions. 

全天培训课程需要提前付款。

Member Ticket
Member Price RMB 1,200
Member Company Employee Ticket
Standard Price RMB 1,200
Non-member Ticket
Standard Price RMB 1,400

Registration

  • All registrations shall be made online before the session. Payment also shall be made before the session.
  • AmCham Shanghai members are eligible to attend at "Member Rate"; Employees who work at AmCham Shanghai member companies are eligible to attend at "Employee Rate"; Non-members are eligible to attend at "Non-Member Rate".
Cancellation Policy
  • Cancellation: If you need to cancel your registration, please notify Ray Cheng at (86 21) 6169 3015 or email ray.cheng@amcham-shanghai.org at least two weeks prior to the session for a full refund. Cancellation made within two weeks before the session will not be refundable.