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
  • Time Intelligence Functions
  • Information functions
  • Logical and text 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
  • Uploading dashboards to Power BI service
  • Sharing dashboards in Power BI service

SCHEDULES
 
PBI8121 - 廣東話 12 Dec enrol
 
PBI8123 - 廣東話 21 Dec enrol
 
PBI8124 - 廣東話 29 Dec enrol
 
PBI9013 - 廣東話 07 Jan enrol
 
PBI9012 - 廣東話 08 Jan enrol
RELATING COURSES
  Mastering Excel PivotTables and PivotCharts
  Excel-Advanced
  Excel Dashboards and Reports
  Excel VBA
  SQL for Data Analysis