Power BI Essential




本课程教你如何用Power BI从不同来源获取和分析数据,并利用Power BI工具进行数据可视化,从而更有效地洞悉商业数据中的信息。



  • 什么是Power BI

Power Query 数据获取
  • 介绍POWER BI界面
  • 导入Excel数据生成报表
  • 从多类数据源获取数据 (Excel, Text, CSV, Website etc.)
  • 自动清理整合数据
  • 清理不规则数据 (Empty cell, Space in text, headers that span multiple columns etc.)

Power Pivot 数据建模

  • 数据建模
  • 如何管理数据关联How to manage your data relationships
  • 生成计算列 (calculated column)
  • 优化数据模型
  • 创建度量列 (calculated measure)-DAX语言介绍
  • 创建计算表(calculated table)
  • 处理时间关联数据 (time-based data)

Power BI 数据视觉化


  • Bar chart
  • Pie chart
  • Table visualisations with drag and drop
  • Treemap
  • Combination charts
  • Slicers
  • Map visualisations (demo)
  • Matrixes and tables
  • Gauge visualisation

Power BI 可视化数据报表优化


  • 颜色
  • 图形形状,文字和图片
  • 页面设计
  • 组合
  • 复制页面
  • 类别汇总
  • Z-order of visualisations
  • Visual hierarchies and drill-down

Power BI生成仪表盘(Dashboard)

  • 介绍Power BI service
  • 创建及配置仪表盘
  • 企业内部分享
  • 优化仪表盘

Power BI 公布和分享

  • 公布报表
  • 打印到出报表
  • 刷新报表数据
  • 镶嵌Power BI 报表


Who ShouldAttend

This course is intended for accountant, analysts, and IT professionals that will be involved with the design, development, and maintenance of data employing the features of Power BI or anyone is interested in, orresponsible for presenting data to business decisions makers.

Your Instructor

Byron Tan
Byron Tan

大型国际贸易公司Financial Controller

7年大型公司Financial Controller经验


精通Excel建模、Power BI


Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!