Computer Academy


Enquire Now

Course Information

  • 6 May 2021 (Thu) 10:00 AM - 5:00 PM
  • 16 Jun 2021 (Wed) 10:00 AM - 5:00 PM
Registration period
9 Mar 2021 (Tue) - 11 Jun 2021 (Fri)
HKD 1,780
Course Level
Study Mode
6 Hour(s)
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong

Course Overview

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

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

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed