Skip to Content
Business Intelligence and AI-Powered Reporting

Power BI Professional Course

Build professional dashboards, connect data sources, automate reporting, and turn business data into decisions using Power BI, analytics, and AI-powered insights.

Dashboards Power Query DAX Measures AI Visuals Online Sharing
PAFM
Power BI
BI
From scattered data to executive dashboards and smart decisions.
Excel · CSV · SQL · MySQL · Online Databases
Reports · KPIs · Mobile · Scheduled Refresh
6 Professional Levels
40% Final Project Weight
BI Business Intelligence
AI Advanced Visuals
Why This Course Matters

The Power BI course for people who want decisions based on facts, not guessing

This course is designed for professionals who want to build a business intelligence system, organize data, extract useful insights, share secure reports, and monitor performance from anywhere.

01

Build Executive Dashboards

Create impressive dashboards using charts, tables, maps, KPIs, slicers, filters, themes, and professional layouts.

02

Connect All Data Sources

Prepare data from Excel, CSV, TXT, folders, SQL Server, MySQL, websites, and online databases.

03

Use AI and Analytics

Generate advanced visuals, explore trends, build predictive dashboards, and use AI to support business decisions.

Power BI Course
Who Needs Power BI?

For managers, accountants, analysts, business owners, and future data professionals

Power BI helps you move from manual reporting to smart dashboards that update automatically, connect departments, and give management a clear view of performance.

Build dashboards that attract attention and support decisions.
Combine different systems and applications into one reporting model.
Share reports securely with teams, managers, and stakeholders.
Forecast future results based on data, trends, and analytics.
What You Become Professional In

From raw data to interactive business intelligence

The course takes you through the full BI workflow: collecting data, cleaning it, modeling relationships, building visuals, publishing online, setting permissions, and refreshing reports automatically.

DB

Data Preparation

Prepare and organize data from Excel, CSV, TXT, folders, SQL databases, online systems, and business applications.

VIS

Visual Reporting

Design charts, maps, KPIs, tables, slicers, filters, buttons, pages, themes, legends, and tooltips.

SQL

Online Databases

Connect to MySQL and SQL databases, understand IP addresses, firewalls, Cpanel access, and connectivity modes.

WEB

Power BI Online

Publish reports, build workspaces, manage users and privileges, refresh data, use alerts, and design mobile reports.

REL

Relationships

Merge, append, normalize, connect tables, define relationship types, sync filters, and solve merging issues.

PQ

Power Query and Measures

Transform data, add columns, remove duplicates, group data, clone tables, create functions, and build measures.

Complete Course Journey

Six professional levels from data preparation to Power Query and AI dashboards

The course follows the official outline: Building and Preparing Data, Visualizations, Online Databases, Power BI Online, Relationships Between Data, and Power Query with Measures.

01

Level 1 – Building and Preparing Data

Learn how to prepare data correctly, whether by building data in Excel or importing it from different sources.

  • Understand what Power BI is and why it matters for business decisions.
  • Work with files, folders, Excel, CSV, and multiple data sources.
  • Understand how data is used in reports and how to select useful data.
  • Generate practical data to use in reports and business scenarios.
Building Data
02

Level 2 – Visualizations

Transform prepared data into reports that help business owners understand results clearly and quickly.

  • Install Power BI Desktop and explore the interface.
  • Understand data types and learn to use visuals from data.
  • Use time visuals, maps, pages, buttons, shapes, slicers, and filters.
  • Generate visuals using AI, add internet visuals, apply themes, legends, tooltips, and KPI visuals.
Visualizations
03

Level 3 – Online Databases

Learn how to connect to online databases and how to meet the technical requirements for data access.

  • Understand online databases and common database types.
  • Connect to MySQL and SQL databases and download required connectors.
  • Understand IP addresses, database requirements, firewalls, and Cpanel access.
  • Use Direct Query and Import Mode and compare different connectivity methods.
Online Databases
04

Level 4 – Power BI Online

Publish reports securely, manage access, schedule refresh, and make reports available on web and mobile.

  • Create Power BI accounts and official emails.
  • Understand Free, Pro, and Premium users and how to publish projects.
  • Create workspaces, share reports, manage users, privileges, and scheduled refresh.
  • Use Power BI Mobile, dashboards, alerts, automatic reports, and shared accounts safely.
Power BI Online
05

Level 5 – Relationships Between Data

Learn how to link tables from multiple systems so reports can answer deeper business questions.

  • Merge data, append data, normalize data, and understand relationship types.
  • Generate relations between tables and use synchronized filtering.
  • Understand merging issues and relationship properties.
  • Connect performance data, HR data, sales data, and operational data in one model.
Relationships
06

Level 6 – Power Query and Measures

Modify imported data so it becomes cleaner, faster, and more suitable for dashboards and reporting.

  • Calculate, transform data types, and create functions.
  • Clone tables, control data paths, add columns, and remove duplicates.
  • Group data, clean data, and prepare dynamic tables.
  • Create measures and advanced calculations for professional reporting.
Power Query
Advanced Professional Skills

Everything needed to build real business intelligence systems

KPI

Performance Monitoring

Track company performance using KPIs, alerts, dashboards, and real-time or scheduled report updates.

SEC

Secure Sharing

Share reports with users and teams while protecting data privacy and controlling privileges.

MOB

Mobile Reporting

Design dashboards that managers can view on phones, tablets, and computers from anywhere.

AUTO

Automatic Refresh

Schedule automatic updates from databases without manual intervention, keeping reports current and reliable.

AI

AI Visuals

Use artificial intelligence to create advanced visuals and predictive dashboards for future performance insights.

DAX

Measures and Calculations

Build advanced measures and calculations that convert raw numbers into useful business indicators.

Final Power BI Project

Build a complete dashboard project from data collection to online publishing

The final project requires each student to apply what they learned by preparing data, building relationships, designing dashboards, publishing reports, setting permissions, and presenting business insights.

Data Collection and Cleaning
Power Query Transformations
Relationships and Data Model
Dashboard Design and KPIs
Power BI Online Publishing
Insights, Recommendations and Presentation
Activities and Evaluation

Practical learning with assignments, cases, and final project

Students are evaluated through assignments, practical cases, and a final project that confirms their ability to apply Power BI in real business environments.

Assignments – 20%

Regular assignments are given to ensure students apply the material correctly and consistently.

Practical Cases – 40%

Each student applies practical cases for every level to build confidence and real execution ability.

Final Project – 40%

A complete final project is submitted at the end of the course according to what the student learned.

Career Outcomes

Turn data skills into a professional advantage

Power BI Analyst

Prepare dashboards, analyze data, and support management with accurate reporting.

Business Intelligence Specialist

Build BI systems that combine data from multiple departments and business applications.

Financial Reporting Analyst

Use dashboards to analyze financial performance, ratios, trends, and business results.

Operations Dashboard Developer

Track operational KPIs, productivity, attendance, sales, inventory, and service performance.

Management Reporting Officer

Prepare professional reports for executives and decision makers across the organization.

Data-Driven Manager

Use data, dashboards, and predictive analytics to lead teams and improve performance.

Course Requirements

Simple requirements for professional Power BI practice

PC

Laptop

Windows laptop is required, preferably Windows 10 or above, for Power BI Desktop training and practical work.

MOB

Mobile Phone

Any fast phone can be used to test Power BI Mobile reports and dashboard viewing while moving.

COM

Commitment

Attendance, assignment submission, practical work, and academy policies are essential to get full benefit.

Branch Locations

Ramallah · Nablus · Hebron

Power BI training is available through PAFM branches with direct contact options for registration and inquiries.

Ramallah Branch

Ramallah

Al-Ersal Street, Nabali and Faris Building, 7th Floor. Contact: 022976747.

Nablus Branch

Nablus

City Center, Main Square, Main Commercial Building, 8th Floor. Contact: 092331918.

Hebron Branch

Hebron

Ain Sarah Street, Jawwal Building, 5th Floor, near Bravo and KFC.

Start Your Data and AI Reporting Journey

Join Power BI today and transform your work using business intelligence and AI

Stop guessing. Build dashboards, organize data, connect systems, automate reports, and make confident decisions using Power BI.

info@pafm.ps www.pafm.ps www.pafm1994.com 022976747 092331918 +972569355940