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
 
PBD9111 - 廣東話 19 Nov enrol
 
PBD9122 - 廣東話 09 Dec enrol
 
PBD9121 - 廣東話 20 Dec enrol
 
PBD0011 - 廣東話 16 Jan enrol
RELATING COURSES
  Access
  Access SQL
  Business Intelligence With Power BI Desktop
  Excel Dashboards and Reports
  Excel VBA
  Python Programming
  SQL for Data Analysis