Udemy Certificate 0

Excel数据分析：零基础入门数据图表，制作数据看板

Name: Excel数据分析：零基础入门数据图表，制作数据看板
Price: 19.99 USD
Availability: InStock

About this course

很多业务人员的报告主要是文字和数据，缺少直观的数据图表，让报告的说服力弱了一层。为了让业务人员做出生动的数据图表，本节课详细讲解了Excel静态图表、动态图表和数据看板三种图表类型的制作方法，综合提高数据可视化能力，让数据也会说话。课程首先介绍了静态报表的制作方法，常用的柱状图和饼状图等想必大家都已经了然于心，老师重点介绍了难度较高的7种图表，包括3种分布类图表和4种流程类图表，分别是箱线图、散点图、雷达图、瀑布图、甘特图、漏斗图、旭日图。其次介绍了利用数据透视表制作动态图表的方法，让图表具备交互特性，业务分析更自由。接着老师介绍了电商和销售常用的数据指标，基于业务情况选择合适的数据制作图表。最后通过一个销售案例，介绍数据看板的制作方法。

43/100

CourseAsk score

What the provider tells you: 23/45
Who stands behind it: 8/35
How complete the listing is: 12/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

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

Data Analysis #business intelligence #data visualization #excel #data analysis #pivot tables #charts #interactive charts #advanced visualizations #sales data #data dashboards #static charts

$19.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.