Home

During this course we will cover how to:

  • Grasp the two data models in work;
  • Improve the efficiency of sorting out non-standard data;
  • Improve the ability of data analysis, respond to the data demand of the superior quickly;
  • Chart making and beautification, making professional business charts and dynamic board of key indicators.


课程收益：

  • 理解工作中的两大数据模型；
  • 数据的快速整理，极大提高整理不规范数据的效率；
  • 快速提高数据分析的能力，快速响应上级提出的数据需求；
  • 图表制作与美化，快速制作专业美观的商务图表，制作关键指标动态看板。


Session Outline

August 12

思维篇 - 怎样才能有效管理工作中的数据？


  • 搞懂两大数据模型是数据分析的关键
  • 分清4种数据类型才能避免手忙脚乱
  • 文件类型决定了效率
  •  清楚分析流程才能胸有成竹


整理篇 - 快速整理工作中的不规范数据



  • 如何快速合并多个表格的数据？
  • 如何快速转换不可计算的数字？
  • 如何从文本中快速提取数字？
  • 如何避免收集到错误数据？
  • 如何用Excel处理大量数据？

How to manage the data effectively

  • Grasp the two key models in data analysis
  • Distinguish four data types to avoid confusion
  • Key to efficiency：The type of file
  • Key to success：Clear analysis process


Sort nonstandard data quickly

  • How to merge data from multiple tables quickly?
  • How to convert uncountable numbers quickly?
  • How to extract numbers from text quickly?
  • How to avoid collecting wrong data?
  • How to process large amounts of data with excel?
August 13

分析篇 - 如何做到数据的敏捷分析？


  • 让透视表动态更新数据源
  • 快速搞定各种分析
  • 切片器关联多个透视表
  • 什么是数据模型？
  • 建立关系与度量
  • Excel大数据分析不卡慢


图表篇 - 怎样让图表直观表达目的？


  • 如何选择合适的图表表达观点？
  • 如何制作专业的图表？
  • 如何制作双坐标图表？
  • 如何做出动态图表？
  • 如何让多个图表进行关联？
  • 如何做出交互式仪表板？

How to make agile analysis of data?

  • Let PivotTable update data source dynamically
  • Quick analysis
  • Use slicers to associate multiple PivotTables
  • What is a data model?
  • Building relationships and measuring
  • Excel big data analysis


How to make the chart to express the purpose directly?

  • How to choose the right chart to express opinions?
  • How to make professional charts?
  • How to make a double coordinate chart?
  • How to make dynamic charts?
  • How to make multiple charts related?
  • How to make an interactive dashboard?

Agenda

时间：8月12日、13日 13:30-16:30


Time：13:30-16:30 on August 12 and 13

Speakers

  • Yongqian Bai白永乾

    Yongqian Bai白永乾

    微软国际认证专家，金山Office认证委员会专家；
    9年企业内训经验，为数百家企业提供过办公技能培训；
    曾长期担任知名世界五百强公司业务分析师，理解业务实际需求；


    Microsoft international certification experts, Office Certification Committee experts;
    Nine years of in-house training experience, providing office skills training for hundreds of enterprises;
    Working experience of business analyst in the world's top 500 companies，understand the actual business needs

    view more

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. 

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


Half-day session training vouchers cannot be used for full-day training programs.

全天会员培训无法使用"半天会员培训免费"券。

Member Ticket
Member Price RMB 998
Member Company Employee Ticket
Standard Price RMB 998
Non-Member Ticket
Standard Price RMB 998

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 Ivette Corominas at (86 21) 6169 3010 or email ivette.corominas@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.