Business Intelligence With Power BI Desktop

Our comprehensive Power BI course is specifically for students interested in leveraging the power of data visualization and analysis in the financial domain. In today's data-driven world, proficiency in Power BI has become a must-have skill for aspiring finance professionals and gain a competitive edge in the job market.

Our Power BI course is tailored to meet the specific needs of students seeking to enhance their data analysis capabilities. Throughout the course, you will learn how to transform raw financial data into visually compelling dashboards and reports that facilitate data-driven decision-making. Our experienced instructors will guide you through hands-on exercises, teaching you everything from data modeling to data visualizations. You will also explore advanced topics such as DAX formulas. By the end of the course, you will have acquired the skills and knowledge necessary to extract meaningful insights from data and communicate them effectively to drive business success.

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

SCHEDULES
 
PBI4071 - 廣東話 16 Jul enrol
 
PBI4072 - 廣東話 25 Jul enrol
 
PBI4081 - 廣東話 26 Aug enrol
 
PBI4082 - 廣東話 29 Aug enrol
 
PBI4091 - 廣東話 24 Sep enrol
RELATING COURSES
  Excel Dashboards and Reports
  Excel VBA X ChatGPT/GPT
  Excel-Advanced
  Mastering Excel PivotTables and PivotCharts
  Power BI Dashboards
  Python for Data Analysis
  Python Programming x ChatGPT/GPT
  SQL for Data Analysis