Training course information
Course outline
Training schedule

At the end of this course, the participants should be able to:

  • Get Started with Power BI and gain a fundamental understanding of the capabilities of Power BI.
  • Start out with seeing how you can quickly and easily gather data from a variety of sources, and then cleanse and transform that data with just a few clicks.
  • learn how you can enhance the results by integrating disparate data sources and adding simple calculations. Then, you’ll learn how to explore your data with visualizations and simple dashboards.
  • learn what steps are necessary to keep your data up to date.
  • Have a firm understanding of the basic skills required for using Power BI to acquire and transform data, enhance the data for analysis, and produce reports and dashboards.

Introducing Power BI

  • What is Power BI?
  • What are some benefits of Microsoft Power BI?
  • Getting Acquainted with Power BI
  • Creating Datasets from Data Models and Data Files
  • Using Quick Insights to Explore a Dataset
  • Viewing Reports in Power BI
  • Exploring a Dashboard
  • History of Power BI
  • Choosing a Development Tool: Using Excel -
  • Using Power BI Desktop

Getting Data

  • Databases
  • Getting Data from Databases Using Power BI Desktop
  • Getting Data from Databases (Excel)
  • Getting Data from Files Using Power BI Desktop
  • Getting Data from Files Using Excel
  • Web and Other Sources
  • Getting Data from the Web
  • Azure and Software as a Service
  • Manual Entry
  • Adding Data Manually Using Power BI
  • Adding Data Manually Using Excel

Transforming Data

  • Renaming Queries
  • Combining Queries: Append
  • Appending Queries Using Power BI
  • Appending Queries Using Excel
  • Fixing Metadata Using Power BI
  • Fixing Metadata (Excel)
  • Filtering Rows
  • Eliminating Columns
  • Combining Queries: Merge
  • Merging Queries
  • Adding Columns by Splitting Text
  • Adding Columns by Splitting XML
  • Adding Columns for Sorting

Modeling Data for Analysis

  • Creating Relationships
  • Creating Relationships Using Power BI Desktop
  • Creating Relationships Using Excel
  • Defining New Columns
  • Concatenating Columns
  • Concatenating Columns Using Power BI Desktop
  • Concatenating Columns Using Excel
  • Performing a Look up to a Related Table
  • Using the Related Function
  • Translating a Value
  • Using the If Function
  • Adding a Date Table
  • Adding a Date Table in Power BI Desktop
  • Adding a Date Table in Excel 2019

Enhancing the Data Model

  • Defining Hierarchies in Power BI Desktop
  • Defining Hierarchies in Excel
  • Configuring Properties in Power BI Desktop
  • Configuring Properties in Excel
  • Configuring Properties: Data Categories
  • Configuring Properties: Formatting & Default Summarization
  • Defining New Measures
  • Defining Customer Count & Pct of Total Customers
  • Defining Total Sales & Previous Year Sales

Visualizing Data

  • Adding Visuals
  • Adding a Table, Clustered Column Chart, & Bar Chart
  • Adding a Map, Card, and Matrix
  • Adding a New Page, Column Chart, Filled Map, and KPI
  • Adding Visuals Using Excel
  • Filtering In Power BI Desktop
  • Filtering in Excel Power View
  • Slicer Filtering in Power BI Desktop
  • Slicer Filtering in Excel Power View
  • Highlighting
  • Setting Properties in Power BI Desktop
  • Setting Properties in Excel Power View
  • Drilling Within a hierarchy
  • Drilling in Power BI Desktop
  • Drilling in Excel Power View

Refreshing Data

  • Publishing Datasets
  • Refreshing Imported Data
  • Using Power BI Gateway - Personal
  • Scheduling Data Refresh
  • Understanding Power BI Gateway – Enterprise

Training Courses Schedule for 2026 is now available

Discover our 2026 training programs and design your professional development plan with ALTAWAIL Consulting & Training.
Download the full schedule now to view upcoming course dates and outstanding training opportunities.

We provide consulting and training solutions backed by our accumulated expertise and the latest technologies and methodologies, enhancing the readiness of your employees and organization to deliver exceptional products and services.

-

2025 Training Schedule

Training course language: English

Training course venue: Jeddah

Training course end date: 20 February، 2025

Training course start date: 16 February، 2025

Training course language: Arabic

Training course venue: Jeddah

Training course end date: 26 June، 2025

Training course start date: 22 June، 2025

Training course language: Arabic

Training course venue: Dammam

Training course end date: 4 September، 2025

Training course start date: 31 August، 2025

Training course language: Arabic

Training course venue: Riyadh

Training course end date: 4 December، 2025

Training course start date: 30 November، 2025

Training course fee : 6800 SAR

Data Analysis and Reporting Using Power BI

Find a course that works for you