This is a comprehensive and in-depth learning experience to help you get the skills of Power BI, such as data management, modeling analysis, chart making, and dashboard report making.

这是一次全面、深入的学习体验，旨在帮助您掌握Power BI的数据管理、建模分析、图表制作和仪表板报告制作等核心技能。

This course begins with an introduction to data acquisition and the core Power BI technologies, including data cleaning, merging, and comparison. Participants will then delve into DAX modeling and analysis, exploring the powerful capabilities of Power BI for data modeling. In the charting section, you'll learn to create and optimize both basic and advanced charts, adjust chart styles, and implement interactive effects. Finally, the course concludes with hands-on training on building interactive dashboards and reports, empowering you to transform data into dynamic, visually engaging, and impactful presentations.

课程将从数据获取技巧开始，通过实战案例，让您深入理解数据的本质，掌握数据清洗、合并、对比等关键技术。我们还将深入探讨Power BI的DAX建模分析，让您掌握事半功倍的建模技巧。在图表制作与美化部分，我们将带您深入理解各种图表的特性和适用场景，教您如何制作和优化基础和高级图表，以及如何调整图表样式和设置交互效果。最后，我们将教您如何制作交互式仪表板和报告，让数据动起来，让报告更加生动和吸引人。

Looking forward to your participation. Let's explore the powerful functions of Power BI together and improve the data analysis capabilities!

期待您的参与，一起探索Power BI的强大功能，提升您的数据分析能力！

The course will be conducted in a teaching and practice mode. Each participant is required to bring a laptop with a Windows 10 or Windows 11 and download the Power BI Desktop software in advance. | 本课程将采用一边教学一边练习的方式进行。每位学员需要带一台已经安装了Windows 10 或者Windows 11的笔记本电脑。同时，请提前下载Power BI Desktop 软件。

1、Data analysis methodology and Power BI data analysis process | 数据分析思维与Power BI数据分析流程

• Data management strategies | 掌握有效的工作数据管理策略
• Five-steps method for business data analysis | 商业数据分析五步法
• Understand the entire process of Power BI data analysis | 理解Power BI数据分析全流程
• Plan and design data sources | 如何规划和设计数据源
• Standardization and automation of data analysis | 数据分析的流程化与自动化

 2、Power BI data cleaning and collation | Power BI数据清洗整理

• From Excel to Power BI: Techniques for quickly acquiring data | 从Excel到Power BI：快速获取数据的技巧
• Power Query: Powerful data cleaning and preprocessing tools | Power Query：强大的数据清洗和预处理工具
• Automatic data merging | 自动化合并数据：多个工作簿文件批量合并
• Data cleaning: Splitting and collation irregular data | 数据清洗：不规范数据的拆分与整理
• Data type understanding: In-depth understanding of the essence of data | 数据类型理解：深入理解数据的本质
• Data comparison: Techniques for comparing the difference between two tables | 数据对比：比较两表差异数据的技巧
• Data reverse perspective: Processing of two-dimensional data | 数据逆透视：二维数据的处理
• Data transposition and filling: Make data more complete | 数据转置与填充：让数据更加完整

3、Power BI modeling analysis | Power BI建模分析全面掌握

Calculation Differences between Power BI and Excel | Power BI与Excel的计算差异：理解两者的核心差异

Data modeling principles | 数据建模原理：事半功倍的建模技巧

Establishing a relational model | 关系模型建立：理解事实表和维度表

Understanding the core of modeling | 建模核心理解：深入理解度量值

Multidimensional data calculation: deeper data analysis | 多维数据计算：更深层次的数据分析

Data exploration: insight into business rules and problems through data | 数据探索：洞察数据中隐藏的业务规律与问题

Excel BI: using powerful BI functions in Excel | Excel BI：在Excel中使用强大的BI功能

4、Power BI data visualization and report | Power BI数据可视化与报告制作

1)   Understanding of chart types | 图表类型理解：深入理解Power BI各种图表的特性和适用场景

2)   Advanced chart production: dynamic bubble charts, tree charts, decomposition trees, etc. | 高级图表制作：动态气泡图、树状图、分解树等的制作和优化

3)   Chart dynamic effects: how to add dynamic effects to charts, such as dynamic bar charts, dynamic line charts, etc. | 图表动态效果：如何添加图表的动态效果，如动态条形图、动态折线图等

4)   How to use charts to explore data rules and business problems | 图表钻取：如何用图表探索数据规律和业务问题

5)   Chart linkage: setting linkage effects between charts | 图表联动：设置图表之间的联动效果

6)   Visualization: how to design professional charts | 图表美化：如何设计出专业的图表

7)   Interactive dashboards: making data analysis reports dynamic | 制作交互式仪表板：让数据分析报告动起来

5、Recap and Q&A | 课程总结与Q&A