[Online Training] Feb 20 Excel暨Power BI数据整理与建模分析（中文授课）

课程大纲 Course Outline

1. Power Query数据整理与清洗 Power query data sorting and cleaning

l 获取数据 Data acquisition

l 整理数据 Organize data

l 规范数据 Specification data

2. Power Pivot创建数据模型 Power pivot creates data model

l 启用Power Pivot Enable power pivot

l 加载数据到Power Pivot Load data to power pivot

l 创建数据模型 Create data model

3. 双剑合并进行数据整理与建模分析实战 Data sorting and modeling analysis

l 获取数据源与建立模型 Data sorting and modeling analysis

l 使用查询和条件汇总函数 Use query and condition summary functions

l 使用数据透视表多维度分析 Use query and condition summary functions

l 任务业绩和同比环比分析 Task performance and year-on-year analysis

Cancellation of RSVP

In case you need to cancel your attendance to the event, please write an email to: events@sha.swisscham.org at least 24 hours prior to the event. Failure to cancel your RSVP timely will require the payment of a "no show bill" of the full amount stated in this invitation. You can contact Nini Qi by telephone: 021 5368 1237. For third-party events, the event terms and conditions of the event organizer apply.

如果您要取消出席活动,请在活动开始前24小时写邮件给 events@sha.swisscham.org。如未能及时取消,我们视同默认付款. 若非瑞士商会主办的活动，取消规则请参照活动主办发布的条款。

Please notice that Swiss Chinese Chamber of Commerce Shanghai (as the host of the event) will take photographs from the event and might post these on its public webpage and or social media platforms in order to create awareness of its events. By attending this event you consent to the Swiss Chinese Chamber of Commerce Shanghai taking and using photographs of you as described above. Please contact [events@sha.swisscham.org] if you have any inquiries related to this matter.

作为活动主（承）办方中国瑞士商会将在活动现场进行拍照，并可能在公共网页及社交媒体平台上公布照片用于活动后期宣传。参加中国瑞士商会的活动，我们将视同您默认我们有权因上述原因及以上述方式使用您的照片。如有异议，请联系events@sha.swisscham.org。