Dear DUSA Members and Friends,

This is the last call of DUSA Training "Power BI Desktop - Advanced Application" which will be held on May 25th, 2021.

Power BI Desktop is a cloud-based data visualization and business intelligence tool from Microsoft. It can complete all processes of data analysis, including data acquisition, data cleaning, modeling and visualizing. It provides nontechnical business users and individuals with tools for data analysis and decision making.

This course will discuss the various methods and best practices that are in line with business requirements for modeling, visualizing, and analyzing data with Power BI, such as Power Query, Power Pivot and Power View.

Sign up to this half-day training course and instantly level up your knowledge of data analysis. 

Power BI Desktop，是微软官方推出的可视化数据探索和交互式报告工具。它能实现数据分析的所有流程，包括对数据的获取、清洗、建模和可视化展示，从而来帮助个人或企业来对数据进行分析，用数据驱动业务，做出正确的决策。

本教程旨在帮助了解和理解Power BI（包括Power Query Power Pivot、Power View）的使用功能和应用技巧，从而掌握基本的数据处理能力、数据建模分析能力、数据可视化呈现能力，助您乘上数据分析之路的快速直通车。

This course is for business intelligence professionals who need to analyze data and present data in marketing and sales, administration, human resources, financial accounting, warehousing, logistics and etc.  Participants should have experience in data analysis in Excel. Familiarity with Pivot Tables is a plus, but is not required.

该课程适用于在日常工作中需要进行数据分析，数据可视化的企事业单位市场销售、行政办公人员、人力资源、财务会计、仓储物流等的相关岗位工作人员。参加培训的学员需要具备一定Excel数据分析经验，如会使用数据透视表则更佳。

• Learn to summarize and edit data quickly among multiple worksheets and multiple workbooks by Power Query; | 掌握通过Power Query 快速对多工作表、多工作簿数据的进行汇总编辑;
• Learn to model and analyze data by Power Pivot and be familiar with the DAX function; | 掌握通过Power Pivot 建立数据模型并进行数据分析的方法，熟悉DAX函数的应用;
• Learn to create eye-catching visualization diagrams by Power View. | 掌握通过Power View 快速制作数据图表技术，学会创建引人注目的可视化图表。

• Brief introduction about the data analysis | 学习准备—认识数据分析;
•  Integrated application of PQ/PP/PV | 系统学习—PQ/PP/PV综合应用；

1. Import data to PQ | 导入数据到PQ
2. Sort data by PQ | 用PQ整理数据
3. Model and link the data | 如何建立模型/关联数据
4. Data classification | 数据分类
5. Data calculation: functions | 数据计算：函数
6. Diagrams selection, using and layout | 图表的选择，使用和布局

•  Case Study - Power BI application in HR management | 实战应用—Power BI在人力资源中的应用.