Philippines only school where startup Leaders teach AI skills.
HomeWorkshopsPowerBI Fundamentals
Data & Analytics WORKSHOP

PowerBI Fundamentals

Turn raw corporate data into real-time interactive executive dashboards. Master Power BI Desktop, Power Query data transformation, DAX metric formulas, data modeling schemas, and automated report publishing for business intelligence decision-making.

Duration: 10 hrsLevel: Beginners – AdvanceFormat: Interactive BI Workshop

QUICK SPECIFICATIONS

4.9/5 Rating
Hands-on Ratio90% Practical
Projects Built4+ Projects
Total Graduates2,500+ Alumni
Official CertificateYes (LinkedIn Verifiable)
Instructors: Active Tech Startup Leaders
90% Practical Hands-on Coding/Labs
Verifiable Digital LinkedIn Certificate
TOOLKIT

Tools & Platforms You Will Master

Hands-on practice using actual commercial tools and open platforms for PowerBI Fundamentals.

BI Tool

Power BI Desktop

Core dashboard design & report environment

ETL

Power Query Editor

Data extraction, transformation & loading

Calculations

DAX Formula Engine

Data Analysis Expressions metric engine

Spreadsheets

Excel Data Models

Importing multi-sheet financial data

Publishing

Power BI Service Cloud

Sharing interactive dashboards online

AI BI

Copilot in Power BI

AI natural-language visual generation

CURRICULUM

Module-by-Module Breakdown

MODULE 01SECTION 1 OF 4

Connecting Data & Power Query ETL Transformation

Connect to Excel, CSV, SQL, and Web data sources; clean and shape messy datasets.

Learning Outcomes:
Connect Power BI Desktop to multi-source datasets
Clean missing values, unpivot columns, and split text using Power Query
Automate weekly data refresh pipelines without manual copying
MODULE 02SECTION 2 OF 4

Data Modeling & Star Schema Architecture

Build robust relational data models connecting fact tables and dimension tables.

Learning Outcomes:
Design clean Star Schema relationships (1-to-many, 1-to-1)
Manage active vs inactive relationships and filter direction
Create dedicated Date/Calendar tables for time intelligence
MODULE 03SECTION 3 OF 4

DAX Measures & Time-Intelligence Functions

Write DAX (Data Analysis Expressions) formulas to calculate KPIs, YTD growth, and running totals.

Learning Outcomes:
Write essential DAX measures (SUM, CALCULATE, FILTER, ALL)
Perform Time Intelligence calculations (YTD, YoY Growth, Rolling 30-Day)
Optimize DAX measure performance for large datasets
MODULE 04SECTION 4 OF 4

Interactive Dashboard Layouts & Cloud Publishing

Design executive dashboards with drill-throughs, slicers, corporate branding, and mobile views.

Learning Outcomes:
Choose optimal chart types (KPI cards, bar charts, treemaps, decomposition trees)
Add interactive slicers, cross-filtering, and drill-through pages
Publish reports to Power BI Service and schedule automated cloud refreshes
AUDIENCE

Who Should Enroll

01

Business & Financial Analysts

Upgrade Excel spreadsheets into automated, real-time Power BI dashboards.

02

Reporting Specialists & Managers

Provide executives with interactive KPIs and drill-down insights.

03

Operations & Sales Teams

Track regional revenue, inventory levels, and sales targets visually.

04

Data Enthusiasts & Career Changers

Gain standard Business Intelligence (BI) skills demanded by corporate employers.

THE AI SCHOOL PH

VERIFIED CREDENTIAL #PH-266209

OFFICIAL CERTIFICATE

This certifies that

[ Your Full Name ]

has successfully completed all requirements, practical lab projects, and assessment modules for

Certified Power BI Business Intelligence Specialist

Power Query ETLStar Schema ModelingDAX CalculationsDashboard Design
Verifiable on LinkedIn
The AI School Philippines
CAREER CREDENTIAL

Stand Out to Employers with Verified Proof

Credential validating Power BI report authoring, DAX metric design, and cloud dashboard deployment.

Direct LinkedIn Integration

1-click addition to your LinkedIn licenses & certifications section with cryptographic verification.

Portfolio-Backed Projects

Includes direct links to your hands-on code repositories and deployed workshop projects.

Endorsed by Tech Startup Leaders

Issued by active startup founders, CTOs, and AI leaders across the Philippines tech ecosystem.

FREQUENTLY ASKED QUESTIONS

PowerBI Fundamentals Q&A

Specific answers regarding prerequisites, schedule, and certification for this course.

Yes, Power BI Desktop is 100% free to download and use on Windows computers.
COHORT
LIMITED COHORT SEATS

Register for Philippines Cohort

Fill in your details below and our academic counseling team will get back to you within 24 hours.

100% ConfidentialResponse within 24 HoursDirect Counselor Guidance

Ready to Master PowerBI Fundamentals?

Join the next live cohort in the Philippines and learn directly from tech startup leaders.