This is a past event. Registration is closed. View other AmCham China events.
Save the date
Save the dateMay 11, 20229 AM - 4:30 PM (GMT+8)
Organizer
Organizer
Organizer:
Contact Person: Melody Song
Home
Home

Please note that this course will be conducted in Chinese.


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.


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.


Software version

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


Others

PowerBi material resource


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

Agenda
Agenda
  • 9 AM - 12 PM

    Morning Session

    Morning Session

    12 PM - 1 PM

    Lunch Break

    Lunch Break

    1 PM - 4:30 PM

    Afternoon Session

    Afternoon Session

Speakers
Speakers
  • Grace Yan (Chief Trainer/Microsoft Office Chinese-English Bilingual Trainer at Eddic)

    Grace Yan

    Chief Trainer/Microsoft Office Chinese-English Bilingual Trainer at Eddic

Tickets
Tickets

AmCham Cardholder

Member Price RMB 1,200

Employee of Member Company

RMB 1,200

Non-member

RMB 1,400