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

PBD4082 - 廣東話 17 Aug enrol
PBD4083 - 廣東話 29 Aug enrol
PBD4091 - 廣東話 07 Sep enrol
PBD4092 - 廣東話 24 Sep enrol
PBD4111 - 廣東話 06 Nov enrol
  Access SQL
  Business Intelligence With Power BI Desktop
  Excel Dashboards and Reports
  Excel VBA X ChatGPT/GPT
  Python for Data Analysis
  Python Programming x ChatGPT/GPT
  SQL for Data Analysis