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
9:00 AM - 12:00 PM
12:00 PM - 1:00 PM
1:00 PM - 4:30 PM