*Training period: Jul 2 to Aug 11; Registration deadline: Jul 8

*This training will be conducted in Chinese and the online training link will be sent to applicants before the course starts

Course Background

This training camp mainly trains the power Bi practical skills of data analysis and data presentation, trains the data analysis and visualization skills that meet the needs of enterprises, and enables students to have good data processing, data modeling and analysis, especially data visualization report presentation capabilities.

Do you face the following difficulties in your work?

• There is a lot of repetitive manual data sorting

Data is captured from the system regularly, and the format needs to be repeatedly modified (change date format, column, deduplication, consolidation, etc.); When the amount of data is large, excel crashes and gets stuck when it processes tens of megabytes of Excel files and millions of lines of data; Use multiple data sources, manually copy and paste to merge, or often use functions such as vlook up / index / match to merge data from multiple tables into one table.

• The demand for periodic reports is changeable

Quarterly requirements change months, product, channel, region and other dimensions, resulting in redoing the report; KPI and dashboard display data need to be prepared regularly by week, month and quarter; The development cycle of the automation data support requirements submitted to the IT department is too long or cannot be met in time; Advanced data applications need to understand VBA statements or SQL query language.

• Need to tell a story with data visualization

The basic graphics provided by Excel cannot meet the needs, such as maps, tree views, waterfall diagrams, Pareto diagrams, etc; Modifying coordinates, colors, data labels and other beautifying charts takes time; Interactive analysis is required for multi angle analysis; Often share reports to others, hoping that others can read them on their mobile phones or tablets.

Course Income

• Master the practical functions of power Bi in the workplace through enterprise practical cases;
• Learn how to organize, clean and combine power query data, which makes it easier to organize data;
• Learn the methods of power pivot data analysis and data modeling, and analyze data efficiently and accurately;
• Master the visual presentation technology of power Bi desktop data, and enjoy the unparalleled visual feast of charts.

Training Mode

Recording and broadcasting class learning tasks + online live tutoring improvement + homework feedback + learning group interaction

Target Audience

Whether you are an industry elite or a newcomer to the workplace, whether you are in finance, human resources, sales, administration or operation, as long as you deal with data, power Bi can help you to free yourself from the cage of big data and bid farewell to digital porters!

Notice: The training invoice will be issued and sent to the registration email within 7 working days after the training. Cancellation policy: If you are unable to attend the training you have registered for and paid, please cancel your registration at least 5 working days in advance. If you fail to notify AmCham China of your cancellation in time, we will charge the actual course fee. Thank you for your cooperation and support.

Contact: Jennifer Xu (jxu@amchamchina.org)