Jj8epzklrz2urygahp9l

Power BI Essential

革命性商业智能分析软件,解决使用Excel的一切痛点!

   视频介绍

微信扫码参加最新线下课程

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

课程内容:

Introduction

  • 什么是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经验

超过10年商务和税务咨询经验

精通Excel建模、Power BI

持有CPA/CTA/MBA证书


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!