Course Detail

***Please note this training will be conducted in Chinese***


Course Background

This course aims to upgrade Excel data analysis through AI technology to help students master knowledge and skills in data preprocessing, data cleaning, data modelling, data analysis and visual presentation. The course is rich in content and covers all aspects of data analysis, aiming to help students improve their data analysis skills comprehensively.


Course Benefits

  • Knowledge of data preprocessing and data cleansing methods and techniques.
  • Understand the concepts of data modelling and common data models.
  • Learn to use AI techniques for data analysis and visual presentation.
  • Enhance data analysis skills and gain better insight into the information behind the data.


Event Detail：

  • Course Format: Online Training-Microsoft Teams
  • Time & Date: 9:00-16:00, December 12
  • Language: Chinese
  • Contact: Mora Zhang, mzhang@amchamchina.org


Notes:

  • Online registration is required for this training and the training link will be sent to successful registrants the day before the course.
  • E-fapiao will be issued seven days after the event.

Course Outline

1. AI Wisdom for Data Insight: Analyze the mystery of AI-assisted data analysis

2. AI-assisted data pre-processing: avoiding erroneous data generation

  • Setting up drop-down lists
  • Limiting the length of text
  • Prohibition of double entries
  • Associative Entry
  • Dynamic drop-down menus

3. AI Intelligent Data Cleansing: make data quality brand new

  • Disaggregation and fast filling
  • Rapidly highlighting data characteristics
  • Ensure the correctness of the entered data
  • Automated handling of duplicate values
  • Identify and correct outliers
  • Filling and predicting missing values
  • Application of LLM in Data Cleaning
  • Copilot efficient processing

4. Data Cleaning Automation: Power Query

  • Quickly and automatically summarize multiple worksheets and folders
  • Merge queries that are more powerful than Vlookup
  • Faster append queries than copy and paste
  • Columns to rows trick - reverse perspective
  • Knowing right from wrong without IF
  • PQ Data Processing Practical Cases

5. Function AI Partner: Simplifying Complex Formulas

  • Introduction to AI tools
  • Decrypting ID numbers with AI
  • One-to-one queries: Vlookup, Xlookup, Index and Match
  • Cross-table lookup functions: Indirect function
  • M365 functions: Filter, Lamdba, etc.
  • Copilot Sketch Functions

6. Data modelling: new ideas for multi-table analysis

  • What is data modelling?
  • Common data models
  • Automatic creation of date dimension tables
  • Creating Pivot Tables from Data Models

7. AI-enhanced data analysis: strengthening the power of data analysis

  • Comparative analysis
  • Correlation analysis
  • Subgroup analyses
  • Cross-analysis

8. Pivot tables: easy to navigate data insights

  • Value summaries and display modes
  • year-on-year, chain and base ratios
  • Pivot table automatic grouping and manual grouping
  • Data Sorting and Custom Sorting
  • Filtering TopN
  • The Simplest GetPivotData Function
  • Slicer Linkage

9. Visual presentation: AI-enhanced data representation

  • Common errors in chart design
  • The five main characteristics of professional charting
  • AI-assisted chart colour matching
  • Change fonts and colours with one click
  • Interactive Dynamic Kanban Creation

Speaker

  • Yan Yan (Gold Medal Lecturer at Eddic)

    Yan Yan

    Gold Medal Lecturer at Eddic

    MCT (Microsoft Certified Tutor)
    Microsoft Gold Partner Instructor
    Microsoft Office, Power BI bilingual instructor
    Microsoft Office International Master Certification
    Microsoft Office PPT International Certified Professional
    Microsoft Office Excel International Certified Expert
    Microsoft Office Word International Certified Expert (the only full score winner of Word in the world)
    Microsoft Power BI Data Analysis Certification

    view more

Tickets

Members & Employees of Member Companies
Standard Price RMB 1,080
Non Members
Standard Price RMB 1,280
Group Ticket
Standard Price RMB 5,000