Power BI Dashboards

The course targets those users who want to create reports or dashboards. Power BI desktop is a free application which prebuilds a lot of professional charts and visuals. Users can expand their library by using visuals from third parties which makes the dashboards even more presentable.

In the course, students will learn how to import data from various sources, link and transform all the data , and constructing dashboards using different visuals.

What you’ll learn

Understanding Microsoft Business Intelligence Service

  • What is Microsoft PowerBI service and the related products
  • PowerBI vs Excel's Business Intelligence tools

Creating data models

  • Knowing different kinds of joins
  • Normalization
  • Creating connections to data sources
  • Editing table properties
  • Defining data Tables
  • Knowing data types
  • Creating relationships (auto detect and manual)

Working with Query Editor

  • Importing Excel, csv, text, Access and data from SQL server
  • Creating tables
  • Diagram view vs. data view
  • Transformation GUI
  • Row transformations
  • Column transformations
  • Text Transformations
  • Adding and removing columns or rows

Working with filters

  • Slicer for labels
  • Slicer for Date information
  • Visual level filters
  • Page level filters
  • Report level filters

Power BI Dashboards and Data Visualizations

  • Power BI Desktop visualization
  • Formatting visuals in Power BI Desktop
  • Waterfall chart, donut chart, scatter chart
  • cluster column chart and line and area chart
  • sorting and advanced sorting
  • Funnel, KPIs, card, multi-rows card, guage
  • Working with matrix and report
  • Rows / Columns / Values settings
  • Adding buttons, images and bookmarks to dashboards
  • Adding images

SCHEDULES
 
PBD0021 - 廣東話 17 Feb enrol
 
PBD0024 - Eng 19 Feb enrol
 
PBD0025 - 廣東話 24 Feb enrol
 
PBD0026 - 廣東話 28 Feb enrol
 
PBD0041 - 廣東話 31 Mar enrol