Business Intelligence With Power BI Desktop

Power BI Desktop is part of Microsoft Business Intelligence Service. It consists of feature-rich data mashup and report authoring tool. With it, users can import and combine data from disparate files, databases, and web services, tweak and visualize the data. The final reports can be published to the web and shared with other people anywhere

The course will teach the features used in different stages from importing, analyzing, visualizing and publishing data and reports. This is an ideal course for managers, analysts or people who want to create stunning dashboard reports that convey the messages effectively.

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

Managing External Data

  • Overview of external source types
  • Importing heterogeneous data sources
  • Linking or adding Excel Tables

Merging and combining data

  • Merge Queries
  • Append Queries
  • Combine Files

Shaping and transforming data

  • Splitting and merging columns
  • Removing columns and rows
  • Replacing data

Data model and tables relationship

  • Working with multiple tables
  • Tables relationship and linking
  • Using Query Editor to import data
  • Creating connections to data sources
  • Creating relationships (auto detect and manual)

Introduction to Data Analysis Expression Language (DAX)

  • Calculation in DAX
  • DAX Data Types and DAX Operators
  • Custom columns and measures
  • Working with DAX functions

Working with reports

  • Query Editor Introduction
  • Adding Column
  • Text Transformations
  • Grouping data
  • Number Column Calculations
  • Date and Time Calculations

Designing and generating dashboards

  • Power BI Desktop Visualizations
  • Guidelines to format Visuals in Power BI Desktop
  • KPI, Built-in Charts and Graphs in Power BI
  • Custom sorting, Filtering, and categorization
  • Working with matrix and table
  • Visual level filters
  • Page level filters
  • Report level filters

PBI3023 - 廣東話 23 Feb enrol
PBI3031 - 廣東話 16 Mar enrol
PBI3032 - 廣東話 16 Mar enrol
PBI3033 - 廣東話 22 Mar enrol
PBI3051 - 廣東話 03 May enrol
  Excel Dashboards and Reports
  Excel VBA
  Mastering Excel PivotTables and PivotCharts
  Power BI Dashboards
  Python for Data Analysis
  Python Programming
  SQL for Data Analysis