Excel数据分析：零基础入门数据图表，制作数据看板
Enroll now →
About this course
很多业务人员的报告主要是文字和数据，缺少直观的数据图表，让报告的说服力弱了一层。为了让业务人员做出生动的数据图表，本节课详细讲解了Excel静态图表、动态图表和数据看板三种图表类型的制作方法，综合提高数据可视化能力，让数据也会说话。课程首先介绍了静态报表的制作方法，常用的柱状图和饼状图等想必大家都已经了然于心，老师重点介绍了难度较高的7种图表，包括3种分布类图表和4种流程类图表，分别是箱线图、散点图、雷达图、瀑布图、甘特图、漏斗图、旭日图。其次介绍了利用数据透视表制作动态图表的方法，让图表具备交互特性，业务分析更自由。接着老师介绍了电商和销售常用的数据指标，基于业务情况选择合适的数据制作图表。最后通过一个销售案例，介绍数据看板的制作方法。
What you'll learn
- create static and dynamic charts in Excel
- construct advanced visualizations such as box plots and waterfall charts
- use pivot tables for interactive data
- design data dashboards based on sales case studies
Course objectives
- improve data visualization skills
- enhance the presentation of business reports
- develop the ability to choose appropriate chart types based on business needs
Skills you'll gain
Related courses
Data Science Foundations
USD 49
Data Analytics in the Public Sector with R
USD 49
Data Science as a Field
USD 99
Geographic Information Systems (GIS)
USD 49
Data Visualization & Analytics in Tableau
USD 49
Programming for Python Data Science: Principles to Practice
USD 49
Enhancing Reproducible Science with GitHub and Docker
USD 49
Statistical Methods and Data Analysis
USD 49
Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.