Program Overview

Program Overview

The Power BI Course is a comprehensive program designed to equip students with the skills and knowledge necessary to effectively utilize Microsoft Power BI for data visualization and business intelligence. The course covers the entire Power BI ecosystem, including Power BI Desktop, Power Query, Power Pivot, and Power View.

Course Introduction

The course introduction provides an overview of the Power BI platform, its core features, and application architecture. Students will learn how to import, split, integrate, and clean data using Power Query, establish relationships using Power Pivot, and create interactive reports using Power View.

Course Objectives

The course objectives include:

• Understanding the Power BI ecosystem and its components
• Learning how to use Power Query to import and clean data
• Establishing relationships using Power Pivot
• Creating interactive reports using Power View
• Understanding DAX functions and how to use them to generate calculated columns and measures

Course Outline

The course outline includes:

• Power BI overview
• Power BI Desktop and Excel differences
• Power BI Desktop execution flow
• Power BI Desktop modules
• Downloading and installing Power BI Desktop
• Recognizing Power BI Desktop work environment
• Using Power Query to get data
• Using Power Query to clean data
• Recognizing Power Pivot work environment
• Establishing relationships
• DAX functions overview
• Recognizing Power View work environment
• Power View quick chart creation
• Cross-report settings and operations
• Focus mode
• Cross-filtering
• Buttons and navigators
• Editing interactions

Target Audience

The target audience for this course includes:

• Individuals who want to learn data visualization tools
• Users with Microsoft Excel basic operation experience who want to improve their data integration, analysis, and visualization efficiency

Course Schedule

The course schedule includes:

• Two-day course (12 hours total)
• Four sessions:
  • First session: 2026/01/24, 01/31 (Saturday) 9:30-16:30 (with a one-hour lunch break)
  • Second session: 2026/04/18, 04/25 (Saturday) 9:30-16:30 (with a one-hour lunch break)
  • Third session: 2026/06/27, 07/04 (Saturday) 9:30-16:30 (with a one-hour lunch break)
  • Fourth session: 2026/09/12, 09/19 (Saturday) 9:30-16:30 (with a one-hour lunch break)

Course Fee

The course fee is:

• NT$6,500 (student discount price: NT$5,500)
• Early bird discount (before 04/07): NT$500
• Additional discount for signing up for the Power BI Advanced Course: NT$500

Related Courses

Related courses include:

• AIūExcel Course
• AIūExcel Business Analysis Course
• AIūPower BI Business Analysis Course
• Streamlit Interactive Data Course
• Tableau Course
• Google Ads Course
• Python Advanced Course
• AIūExcel VBA Course
• Power Automate Course
• Power BI Advanced Course
• AIūPython Business Analysis Course
• Carbon Footprint Verification Course
• Python Course
• Meta Ads Course
• SQL Course

Refund Policy

The refund policy states that:

• A full refund will be given if the course is cancelled or if the student requests a refund 30 days before the course starts
• A 90% refund will be given if the student requests a refund between 29 days and 1 day before the course starts
• A 50% refund will be given if the student requests a refund after the course has started but before one-third of the course has been completed
• No refund will be given if the student requests a refund after one-third of the course has been completed