课程说明
本课程旨在改善工作方式及提高工作效率,通过理论讲解加实际操作的授课教学方法,综合运用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.
适用对象
本培训课程适用于企事业单位市场销售、行政文秘、人力资源、财务会计、仓储物流等与数据接触较多的相关岗位工作人员。
有一定的 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.
软件版本
本课程支持Power BI Desktop中文和英文版本。可提供安装包及说明。
Software version
Both Chinese and English versions of Power Bi desktop will be workable. We will provide installation package and instructions.
培训时间/Time
2022.5.11 9-12;13-16:30
课程福利:PowerBi 图表实用素材
Others:PowerBi material resource
培训大纲
1 为什么要用Power BI?
2 数据获取与整理
2.1 连接数据源
2.2 填充合并单元格
2.3 合并查询和追加查询
2.4 工作簿和文件夹合并
2.5 二维数据一键转一维表(逆透视)
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.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
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
Payment:
1. Bank transfer:
RMB Bank Account
A/C Name: 中国欧盟商会
A/C No.: 7110210182500027543
China CITIC Bank 中信银行京城大厦支行
Capital Mansion Sub Branch
No. 6, Xinyuan Nan Road
Chaoyang District, 100004 Beijing
北京市朝阳区新源南路6号京城大厦
S.W.I.F.T. Code: CIBKCNBJ100
2. Online pay through Wechat.
Terms & Conditions:
This event has limited seating and requires registration and payment in advance. No walk-ins accepted.
Cancellation Policy:
If you cannot attend this event, please cancel your registration at least 3-working days before. If you fail to notify us of your cancellation in a timely fashion, you will be charged for event costs.
To cancel, please contact Ms. Annie Zhou at azhou@europeanchamber.com.cn.
Disclaimer免责声明:
Participants must maintain proper social distancing norms and abide by the Government ’s Epidemic Prevention and Control Rules. If you do not follow the relevant regulations, the European Union Chamber of Commerce in China accepts no responsibility for any of your physical discomfort caused during and after the event. Thank you for your cooperation.
参与活动时,参会人应与他人保持适当距离(防疫考虑)并遵守政府颁布的疫情预防控制要求(例如佩戴口罩等)。如您违反要求,中国欧盟商会对于您在活动中或者活动后的身体不适,不承担任何责任。 感谢您的理解和配合。