Name: Microsoft Power BI: From Data to Interactive Dashboards
Price: 396 SAR
Availability: InStock

Microsoft Power BI: From Data to Interactive Dashboards

A comprehensive, hands-on training program in Microsoft Power BI designed for professionals, analysts, and decision-makers across all domains. This course covers data extraction, cleaning with Power Query, data modeling, DAX fundamentals, and creating interactive, visually compelling business dashboards that transform raw data into actionable insights for the workplace.

Certificate Included

Expert-Led Training

Practical Learning

Enrollment Support

days

5 Days

Language

English / Arabic

Learners joined us

Course Summary

Total Tuition

396 SAR

VAT included

Start Date

2026-10-11

Session hours

6:00–10:00 PM (Riyadh time)

Delivery

Online

Certificate

Attendance Certificate

days

5 Days (Monthly)

Ask on WhatsApp

By continuing you agree to the Refund Policy

Course Details

Overview

The "Microsoft Power BI: From Data to Interactive Dashboards" course is an intensive, hands-on training program designed to equip professionals, team leaders, and analysts across all business functions with the skills required to leverage Microsoft Power BI for end-to-end business intelligence and data storytelling. In today’s data-driven organizational landscape, transforming raw operational numbers into clear, actionable executive insights is essential for proactive decision-making.

The program walks participants through the full Power BI analytics workflow: connecting to heterogeneous data sources (Excel, CSV, relational databases, and cloud services), performing advanced data transformation and cleaning via Power Query, building scalable relational data models, and implementing foundational to intermediate DAX measures. Participants learn best practices in UI/UX dashboard design to craft dynamic, visually engaging reports and dashboards highlighting key performance indicators (KPIs), trend analyses, and multi-dimensional drill-downs.

The course features an applied 80% practical format structured over approximately 4 training days, packed with real-world business scenarios, guided exercises, and a capstone project delivering an end-to-end interactive dashboard ready for organizational deployment.

Objectives

Program Objectives

By the end of this course, participants will be able to:

Master the End-to-End Business Intelligence Lifecycle: Understand how to ingest, transform, model, and visualize data across diverse business domains.
Transform and Clean Data with Power Query: Ingest multi-source datasets (Excel, CSV, databases, cloud feeds) and automate automated ETL workflows.
Build Scalable Relational Data Models: Design effective data schemas (Star Schema), establish relationships, and optimize model performance.
Implement Analytical Calculations Using DAX: Craft essential and advanced DAX measures (CALCULATE, Time Intelligence, aggregation formulas) to track organizational KPIs.
Design High-Impact Interactive Dashboards: Apply visual storytelling and UX design principles using dynamic slicers, tooltips, bookmarks, and cross-filtering.
Publish and Automate Reports on Power BI Service: Deploy workspace reports, manage access permissions, and schedule automated dataset refreshes for stakeholders.

Target Audience

This training program is designed for the following target audiences:

Data and Business Intelligence Analysts: Professionals looking to develop end-to-end interactive dashboards and scalable analytical models.
Managers, Department Heads, and Team Leads: Decision-makers who need real-time visualization of key performance indicators (KPIs) to drive strategy.
Operations, Finance, and Business Professionals: Individuals aiming to automate periodic reporting workflows and streamline cross-departmental data analysis.
Sales, Marketing, and Supply Chain Specialists: Teams seeking to monitor performance, analyze market trends, and evaluate operational pipelines dynamically.
Entrepreneurs and Business Owners: Founders who want unified executive dashboards to track core organizational metrics efficiently.
Fresh Graduates and Job Seekers: Individuals aspiring to build high-demand business intelligence and Power BI skills for the modern job market.

Competencies

Core Competencies

Data Extraction and Transformation with Power Query

Connect to diverse data sources, clean and transform raw datasets, handle missing values, eliminate duplicates, and structure structured tables for analytical modeling.

Relational Data Modeling and Architecture

Design robust Star Schemas, establish relationships between fact and dimension tables, manage primary/foreign keys, and optimize dataset performance.

Analytical Calculations Using DAX

Create dynamic measures and calculated columns using fundamental and advanced DAX functions, including CALCULATE, FILTER, RELATED, and Time Intelligence.

Interactive Dashboard and Report Design

Build intuitive, visually compelling dashboards utilizing visual hierarchy, UI/UX best practices, cross-filtering, slicers, drill-throughs, and bookmarks.

Business Performance and Trend Analysis

Transform data into actionable organizational insights, monitor key performance indicators (KPIs), analyze variances, and evaluate performance trends.

Report Automation and Cloud Publishing via Power BI Service

Publish interactive reports to the cloud, configure workspace access permissions, set up automated scheduled refreshes, and facilitate cross-team collaboration.

Learning Journey

Program Outline

Day 1: Foundations of Business Intelligence & Data Transformation (Power Query)

Introduction to Power BI Ecosystem & Business Intelligence

Explore the Power BI platform components (Desktop, Service, Mobile), understand the data storytelling lifecycle, and configure the development workspace and options.

Data Ingestion from Diverse Sources

Connect to disparate data sources including Excel workbooks, CSV files, SQL databases, and web feeds; differentiate between Import and DirectQuery storage modes.

Data Cleansing & Profiling in Power Query

Eliminate null values and duplicates, correct data types, profile data quality, split/merge columns, and standardize text, numerical, and date formats.

Advanced Data Reshaping & Transformations

Perform unpivoting operations to convert wide flat tables into normalized datasets; apply aggregation and grouping operations and build conditional columns.

Append & Merge Query Workflows

Combine multi-period operational datasets using Append queries, and implement relational joins using various Merge join types efficiently.

Day 1 Applied Workshop

Hands-on lab: Import a multi-file folder of uncleaned organizational performance data, perform automated ETL cleanup, and load a clean tabular model.

Day 2: Relational Data Modeling & Architecture

Principles of Data Modeling & Star Schema

Understand relational data architecture, differentiate fact tables from dimension tables, and implement industry-standard Star Schemas for optimal query performance.

Managing Relationships & Cross-Filter Context

Create and configure One-to-Many and Many-to-Many relationships, define active/inactive relationship paths, and manage cross-filter directions effectively.

Building a Standardized Date / Calendar Dimension

Generate dynamic Date tables using M code and DAX calendar generators (CALENDAR/CALENDARAUTO), linking time attributes across operational data tables.

Model Optimization & Schema Organization

Organize model schemas using Display Folders, configure data category tags, hide technical surrogate keys, and format fields for intuitive self-service reporting.

Day 2 Applied Workshop: Building a Enterprise Data Model

Hands-on lab: Build and test a complete multi-table data model connecting customer, product, regional, and transaction data, verifying correct filter flow.

Day 3: Analytical Calculations Using DAX

DAX Architecture: Measures vs. Calculated Columns

Master DAX calculation logic, understand the fundamental differences between computed columns and measures, and optimize memory consumption.

Essential Aggregation & Statistical Measures

Author foundational DAX formulas utilizing aggregation functions (SUM, AVERAGE, MIN, MAX) and distinct counters, established within dedicated measure tables.

Evaluation Context & The CALCULATE Function

Master Row Context and Filter Context transitions, utilizing the CALCULATE function in combination with FILTER, ALL, and ALLEXCEPT expressions.

Time Intelligence DAX Functions

Implement dynamic time calculations for cumulative metrics (YTD, QTD, MTD) and period-over-period variance metrics (SAMEPERIODLASTYEAR, DATEADD, % growth).

Day 3 Applied Workshop: Authoring a Core KPI Suite

Hands-on lab: Construct a robust DAX calculation suite tracking key organizational KPIs, target achievements, operational ratios, and growth percentages.

Day 4: Visual Storytelling & Interactive Dashboard Design

Visual Selection & Data Storytelling Principles

Select appropriate charts for varied analytical intents (Clustered bars, Line trends, KPI Cards, Treemaps, Matrix views, and Waterfall breakdowns).

UI/UX Formatting & Conditional Indicators

Apply corporate UI themes, contrast hierarchies, and dynamic conditional formatting rules (color gradients, icons, data bars) to highlight key deviations.

Interactivity: Slicers, Tooltips & Drill-Downs

Incorporate multi-select slicers, custom report page tooltips for granular previews, and cross-report drill-through pathways for in-depth data exploration.

Navigation Architecture with Bookmarks & Buttons

Build professional navigation ribbons, toggleable side menus, and dynamic visual switches using Power BI buttons, actions, and bookmark states.

Power Query

Participants examine Power Query as part of Excel and Power BI for Accountants. The session includes guided explanation, examples, practical exercises, discussion of common errors and risks, and preparation of a usable output such as a calculation, checklist, reconciliation, report, dashboard, compliance file, or decision recommendation.

Day 4 Applied Workshop: Designing an Executive Dashboard

Hands-on lab: Build an end-to-end executive performance dashboard featuring modern aesthetics, interactive slicers, and seamless page navigation.

Day 5: Deployment, Security, Automation & Capstone Project

Publishing & Collaboration in Power BI Service

Deploy desktop .pbix reports to cloud workspaces, configure app workspaces, create unified dashboard views, and manage cross-department sharing.

Data Governance & Row-Level Security (RLS)

Configure and test dynamic and static Row-Level Security roles, restricting confidential data viewing based on organizational roles or territories.

Automated Scheduled Refresh & Data Gateways

Install and configure On-Premises Data Gateways, set up automated dataset refresh schedules, and configure alert triggers for threshold breaches.

Comprehensive Capstone Project & Evaluation

Final practical project: Ingest raw business data, engineer clean ETL processes, build relational models, code DAX KPIs, and deliver a publish-ready dashboard.

Next Available Date

Global Schedule

Date

2026-10-11

Delivery

Online

Session hours

6:00–10:00 PM (Riyadh time)

396 SAR

VAT included

Microsoft Power BI: From Data to Interactive Dashboards

Certificate Included

Expert-Led Training

Practical Learning

Enrollment Support

days

5 Days

Language

English / Arabic

Learners joined us

Overview

Program Objectives

By the end of this course, participants will be able to:

Master the End-to-End Business Intelligence Lifecycle: Understand how to ingest, transform, model, and visualize data across diverse business domains.
Transform and Clean Data with Power Query: Ingest multi-source datasets (Excel, CSV, databases, cloud feeds) and automate automated ETL workflows.
Build Scalable Relational Data Models: Design effective data schemas (Star Schema), establish relationships, and optimize model performance.
Implement Analytical Calculations Using DAX: Craft essential and advanced DAX measures (CALCULATE, Time Intelligence, aggregation formulas) to track organizational KPIs.
Design High-Impact Interactive Dashboards: Apply visual storytelling and UX design principles using dynamic slicers, tooltips, bookmarks, and cross-filtering.
Publish and Automate Reports on Power BI Service: Deploy workspace reports, manage access permissions, and schedule automated dataset refreshes for stakeholders.

Target Audience

This training program is designed for the following target audiences:

Data and Business Intelligence Analysts: Professionals looking to develop end-to-end interactive dashboards and scalable analytical models.
Managers, Department Heads, and Team Leads: Decision-makers who need real-time visualization of key performance indicators (KPIs) to drive strategy.
Operations, Finance, and Business Professionals: Individuals aiming to automate periodic reporting workflows and streamline cross-departmental data analysis.
Sales, Marketing, and Supply Chain Specialists: Teams seeking to monitor performance, analyze market trends, and evaluate operational pipelines dynamically.
Entrepreneurs and Business Owners: Founders who want unified executive dashboards to track core organizational metrics efficiently.
Fresh Graduates and Job Seekers: Individuals aspiring to build high-demand business intelligence and Power BI skills for the modern job market.

Core Competencies

Data Extraction and Transformation with Power Query

Connect to diverse data sources, clean and transform raw datasets, handle missing values, eliminate duplicates, and structure structured tables for analytical modeling.