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

Different Data Sources

  • Overview of external source types, e.g., relational databases, text files, Analysis Services
  • Importing heterogeneous data sources
  • Linking or adding Excel Tables

What is a data model?

  • Normalization
  • Knowing different kinds of joins ( 1 to many, many-to-many etc)
  • Using Power Query to import data

Creating data models

  • Creating connections to data sources
  • Editing table properties
  • Defining data Tables
  • Knowing data types
  • Creating relationships (auto detect and manual)
  • Diagram View vs. Data View
  • Defining hierarchies

Introduction to Data Analysis Expression Language (DAX)

  • Calculation in DAX
  • DAX Data Types and DAX Operators
  • Evaluation context
  • Calculated columns and measures
  • Working with DAX functions
  • Time Intelligence Functions
  • Information functions
  • Logical and text functions

PBI8052 - 廣東話 31 May enrol
PBI8063 - 廣東話 05 Jun enrol
PBI8062 - 廣東話 15 Jun enrol
PBI8061 - 廣東話 28 Jun enrol
  Mastering Excel PivotTables and PivotCharts
  Excel Dashboards and Reports
  Excel VBA
  SQL for Data Analysis

Working with Power Query

  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations

Data Visualization

  • Power BI Desktop Visualization ( Power View )
  • Formatting Visuals in Power BI Desktop
  • Waterfall Chart
  • Built-in Charts and Graphs in Power BI
  • Sorting, Filtering, and categorization
  • KPIs
  • Maps and Geo-Spatial Visualization ( Power Map)
  • Working with Matrix ( Power Pivot )
  • Rows / Columns / Values
  • Visual level filters
  • Page level filters
  • Report level filters