Get in touch 01006613113

Microsoft Power BI

About Course

Course Objectives

  • Understand the role of data analytics and the responsibilities of a data analyst

  • Connect to and retrieve data from multiple data sources

  • Clean, transform, and load data using Power BI

  • Design efficient data models with relationships, hierarchies, and dimensions

  • Create calculations and measures using DAX

  • Optimize data models and improve performance

  • Design interactive reports and dashboards

  • Create and publish paginated reports

Course Outlines

Module 1:

  • Get Started with Microsoft Data Analytics
  • Data Analytics and Microsoft
  • Getting Started with Power BI
  • After completing this module, you will be able to:
  • Explore the different roles in data
  • Identify the tasks that are performed by a data analyst
  • Describe the Power BI landscape of products and services
  • Use the Power BI service

Module 2:

  • Prepare Data in Power BI
  • Get data from various data sources
  • Optimize performance
  • Resolve data errors
  • After completing this module, you will be able to:
  • Identify and retrieve data from different data sources
  • Understand the connection methods and their performance implications
  • Optimize query performance
  • Resolve data import errors

Module 3:

  • Clean, Transform, and Load Data in Power BI
  • Data shaping
  • Enhance the data structure
  • Data Profiling
  • After completing this module, students will be able to:
  • Apply data shape transformations
  • Enhance the structure of the data
  • Profile and examine the data

Module 4:

  • Design a Data Model in Power BI
  • Introduction to data modeling
  • Working with tables
  • Dimensions and hierarchies
  • After completing this module, you will be able to:
  • Understand the basics of data modeling
  • Define relationships and their cardinality
  • Implement dimensions and hierarchies
  • Create histograms and rankings

Module 5:

  • Create Model Calculations using DAX in Power BI
  • Introduction to DAX
  • DAX context
  • Advanced DAX
  • After completing this module, you will be able to:
  • Understand DAX
  • Use DAX for simple formulas and expressions
  • Create calculated tables and measures
  • Build simple measures
  • Work with Time Intelligence and Key Performance Indicators

Module 6:

  • Optimize Model Performance
  • Optimize the model for performance
  • Optimize Direct Query Models
  • Create and manage Aggregations
  • After completing this module, you will be able to:
  • Understand the importance of variables
  • Enhance the data model
  • Optimize the storage model
  • Implement aggregations

Module 7:

  • Create Reports
  • Design a report
  • Enhance the report
  • After completing this module, you will be able to:
  • Design a report page layout
  • Select and add effective visualizations
  • Add basic report functionality
  • Add report navigation and interactions
  • Improve report performance
  • Design for accessibility

Module 8:

  • Create Dashboards
  • Create a Dashboard
  • Real-time Dashboards
  • Enhance a Dashboard
  • After completing this module, students will be able to:
  • Create a Dashboard
  • Understand real-time Dashboards
  • Enhance Dashboard usability

Module 9:

  • Create Paginated Reports in Power BI
  • Paginated report overview
  • Create Paginated reports
  • After completing this module, you will be able to:
  • Explain paginated reports
  • Create a paginated report
  • Create and configure a data source and dataset
  • Work with charts and tables
  • Publish a report
Download Schedule
Enroll Course

World Food Programme (WFP)

Our work with the World Food Programme (WFP) focused on enabling the effective adoption of digital field technologies and essential digital literacy capabilities. Participants utilized mobile-based data collection platforms within operational contexts, enhancing accuracy, consistency, and confidence in digital data handling. The engagement strengthened WFP’s ability to rely on digital tools to support field operations and humanitarian programs.

Raya

For Raya, we delivered technology enablement focused on automation-driven operations and scalable application development. Participants gained hands-on experience with automation technologies and modern front-end development frameworks, supporting more efficient processes and the delivery of flexible, high-performance digital solutions aligned with business growth objectives.

EgyptAir

Our engagement with EgyptAir focused on enabling the effective use of application development technologies alongside the adoption of cybersecurity and secure computing practices within operational environments. Participants worked with Microsoft-based development platforms and programming technologies while gaining practical exposure to secure application usage, access control mechanisms, and threat-aware system interaction. This integrated technology enablement supported more secure digital operations, improved system reliability, and reinforced cyber resilience across aviation technology environments.

Banque Misr

We collaborated with Banque Misr to enable integrated enterprise technology capabilities across multiple domains. The engagement supported effective utilization of IT infrastructure environments, data analytics platforms, and professional capability development frameworks, allowing teams to operate confidently within complex enterprise systems. Our delivery approach focused on practical technology adoption, operational alignment, and building sustainable competencies that support reliable banking services and informed, data-driven decision-making.

Course Booking Form