PowerBI Engineer

Course List\Content Hours SL Total

Introduction to Data Analysis & Data Driven Decisions (S1-S6) 18 0 18
Brief Introduction to Microsoft Azure (S7) 3 3 6
Introduction to Power BI (S8-S9) 6 3 9
Extract Data from Different Sources in Power BI (S10) 3 0 3
Data Cleaning using PowerQuery (S11-S14) 12 6 18
Introduction to DAX (S15-S17) 9 6 15
Data Analysis and Visualization using Power BI (S18) 3 0 3
Dashboard and Report Development in Power BI (S19-S22) 9 3 15
Data Modeling and Integration in Power BI (S23-S25) 12 0 9
Publishing & Sharing Power BI Report (S26) 3 3 6
Data Refresh Mechanisms in Power BI (S27) 3 0 3
Visualization using Tableau (S28-S32) 15 0 15

Prompt Engineering (S33-S35) 9 3 12

Data Governance (S36) 3 0 3

Capstone Project (S37-S40) 12 15 27

Total 120 42 162

1
 C O U R S E O U T L I N E

Introduction to Data Analysis & Data Driven Decisions

Course Title Introduction to Data Analysis & Data Driven Decisions
18 Hrs. Total
Course Language Hours
Arabic / English

Description
 key concepts involved in data analytics, including data, data analysis, and data ecosystem,
analytical thinking self-assessment giving specific examples of the application of analytical
thinking, spreadsheets, query languages, and data visualization tools in data analytics.
Benefits of Enrolling in a Course:
• Introduction to Data Analytics
• Introduction to Statistics
• Introduction to Visualization Types
• Introduction to Excel Functions
• Introduction to Chart Types on Excel
• Solve Visualization Problems in Excel
• Data Driven Decisions

2
Introduction to Data Analytics
 Understand what data analytics involves and its importance in decision
making across various industries (Overview of data analytics and its
applications).
 Recognize the key steps in the data analytics process, from data collection to
data interpretation.
 Types of data (quantitative vs. qualitative)
 Learn about the roles and skills required for a career in data analytics.
 Introduction to the data analytics lifecycle (question formulation, data
collection, cleaning, analysis, interpretation). 3 Hrs.
 Methods for collecting and storing data

Explain the Problem-Solving Road Map (week 3)

 Discuss the step-by-step approach to problem-solving in data
analysis.
 Introduce frameworks and methodologies like the DMAIC (Define,
Measure, Analyze, Improve, Control) or similar structured problem-
solving processes.
Discuss the Use of Data in Decision-Making
 Explore how data-driven decision making enhances business strategy
and operations.
 Analyze case studies where data significantly impacted
decision-making processes.
Data Collection Methods
 Methods for collecting and storing data.
 Data sources and data collection ethics.
Data Manipulation Techniques 3 Hrs.
 Using spreadsheets for advanced data manipulation.
 Introduction to SQL queries for data manipulation.

Introduction to Statistics
 Grasp basic statistical concepts and terminology, such as mean, median,
mode, variance, and standard deviation.
 Definitions and examples of basic statistical measures. 6 Hrs.
 Understand the difference between descriptive and inferential statistics.
 Overview of descriptive statistics to summarize data characteristics.
 Learn how to apply basic statistical methods to analyze real-world datasets.
 Introduction to inferential statistics to make predictions or inferences about
a larger population from a sample.

Introduction Excel Functions

 Understand the purpose and application of basic Excel functions in data
analysis.
 Overview of the Excel interface focusing on function input and formula bar
usage.
 Gain proficiency in using common functions like SUM, AVERAGE, COUNT,
MIN, MAX, and IF.
 Detailed instructions on how to use basic arithmetic and statistical functions.
 Learn how to combine functions for more complex calculations.
 Introduction to using functions across multiple cells and combining them
(e.g., SUMIF, COUNTIF).
3
Introduction to Chart Types on Excel 3 Hrs.

 Identify when and how to use different types of charts available in Excel.
 Hands-on mini-project or examples demonstrating the creation of basic
charts and interpreting them.
 Develop the ability to create, format, and interpret common chart types like
bar charts, line charts, pie charts, and scatter plots.
 Step-by-step guidance on creating and customizing charts, including selecting
data, choosing the chart type, and adjusting chart elements like titles, axes,
and legends.
 Practical examples to create each type of chart, focusing on common
datasets that might be encountered in a business or educational setting.
 Tips for making visually appealing and informative charts.

Introduction to Visualization Types

 Overview of common visualization types (bar charts, histograms, scatter
plots, line graphs, pie charts, heat maps).
 Identify different types of data visualizations and when to use them. 3 Hrs.
 Discussion on the use of color, shape, and size in visualizations to convey
information effectively.
 Understand the principles of effective visual design for clarity and impact.

Solve Visualization Problems in Excel

• Setup Practice Data

• Exercise 1: Comparing Sales Data Across Multiple Regions
- Task: Use a bar or column chart to compare quarterly sales data across
different regions.
- Challenge: Customize the chart to highlight the top-performing region in a
different color.
• Exercise 2: Analyzing Customer Trends Over Time
- Task: Create a line chart to visualize how customer preferences have
changed over the past year.
- Challenge: Add a trendline to the chart to indicate overall trends and make
predictions.
• Exercise 3: Displaying Distribution of Customer Age Groups
- Task: Use a histogram to show the distribution of customer ages.
- Challenge: Adjust bin sizes to optimize clarity and interpretability.

4
 COURSE OUTLINE

Brief Introduction to Microsoft Azure

Course Title Brief Introduction to Microsoft Azure
3 Hrs. Total
Course Language Hours 3 Hours Physical / Online
Arabic / English
0 Hours Self-Study

Description
 This course is a brief introduction for Data Analysts and PowerBI Engineers seeking to harness the potential of
Microsoft Azure for broadening their analytics capabilities and seamlessly integrating cloud solutions into their data
visualization endeavors. The course offers a brief introductory exploration of Microsoft Azure, with a specific
emphasis on its data services, analytics functionalities, and seamless integration with PowerBI, alongside the
fundamental underpinnings of cloud computing.
Benefits of Enrolling in a Course:
• Brief Introduction to Azure cloud services specifically for data analytics and PowerBI
integration.
• Learn to navigate the Azure portal with a focus on data services.

Introduction to Azure for Data

 Understand the basics of cloud computing and its advantages for data
analytics.
 Identify Azure services that support data analytics, including Azure SQL 3 Hrs.
Database, Azure Data Lake, and Azure Synapse Analytics.
 Learn to navigate the Azure portal with a focus on data services.

1
 Basics of PowerBI and its components
 Understand the components of the PowerBI ecosystem.
 Download and Install PowerBI Desktop
 Familiarize with the PowerBI Desktop interface.
C O U R S E O U T L I N E
3 Hrs.
Navigating the PowerBI interface
Introduction
 Navigate the PowerBI interface efficiently. to PowerBI
 Use interface elements to manage and organize data visualizations.
Course Title Introduction to PowerBI
Data Management and Visualization Fundamentals 9 Hrs. Total
Connect PowerBI
CourseLanguage to data sources such as Excel files &
HoursCSV 3 Self-Learning
Arabic / English
 Practice importing data into PowerBI, understanding how to troubleshoot
common issues.
 Learn to create basic visualizations including bar charts, line charts, and pie
charts. 3 Hrs.
 Understand best practices for choosing and configuring visualizations to
clearly represent data.

Self-Study
Advanced Exploration and Community Engagement
Exploring PowerBI Community and Additional Resources:
3 Hrs.
• Engage with the PowerBI Community to learn from shared knowledge
and experiences.
• Explore additional resources such as forums, webinars, and tutorials to
enhance understanding and skill.
Advanced Visualization Techniques:
• Self-study on advanced visualization options available in PowerBI such
as heat maps, waterfall charts, and custom visuals from the
marketplace.
• Apply these techniques to improve the analytical capabilities of reports.
Description
 Get started with PowerBI to create powerful data visualizations and business intelligence
reports.

Benefits of Enrolling in a Course:

 Basics of PowerBI and its components.

 Navigating the PowerBI interface.
 Simple data imports and basic visualization creation.
 Exploring PowerBI community and additional resources.

2
 C O U R S E O U T L I N E
Methods for connecting PowerBI to different databases and APIs
Extract
 Learn how to establish Data from
connections Different
to various data sources,Sources
including
databases and APIs.
Course Title Extract Data from Different Sources
 Basic SQL SELECT Queries to Extract data from SQL Database
3 Hrs. Total
Understand the settings and configurations needed
CourseLanguage for successful data
Hours
Arabic / English 3 Hrs.
extraction.
 Apply learned connection techniques to extract data from a new source.

Description
 Focus on leveraging PowerBI to extract data from various sources, ensuring compatibility and
efficiency.
Benefits of Enrolling in a Course:
 Methods for connecting PowerBI to different databases and APIs.
 Techniques for data extraction using PowerBI connectors.
 Handling data extraction issues and troubleshooting.

3
 C O U R S E O U T L I N E

Data Cleaning using PowerQuery

Course Title Data Cleaning using PowerQuery
18 Hrs. Total
Course Language Hours 6 Self-Learning
Arabic / English

Description
 Deep dive into using PowerQuery for cleaning and transforming data to prepare it for analysis.

Benefits of Enrolling in a Course:

 Introduction to PowerQuery interface and capabilities.
 Advanced data transformation techniques.
 Handling missing data, duplicates, and errors.
 Automating data cleaning processes using PowerQuery.

4
Introduction to PowerQuery interface and capabilities
 Navigate the PowerQuery interface.
 Perform basic data transformations such as filtering and sorting.
Advanced data transformation techniques
 Utilize advanced PowerQuery functions to manipulate and prepare data sets
for analysis. 6 Hrs.
 Practice cleaning a complex dataset.
Handling missing data, duplicates, and errors
 Develop strategies for addressing common data issues like missing values
and duplicates.
 Implement best practices to ensure data quality.
Deep dive into PowerQuery's M language
 Understand the fundamentals of the M language used in PowerQuery.
 Write custom functions to handle specific data cleaning tasks. 3 Hrs.

Real-world data cleaning project

 Apply all learned techniques in PowerQuery to clean a real-world data set. 3 Hrs.
 Prepare a report summarizing the data cleaning process and outcomes.

Self-Study
Hands-on: Self Implement Real-world data cleaning project
• Apply all learned techniques in PowerQuery to clean a real-world data
6 Hrs.
set.
• Prepare a report summarizing the data cleaning process and
outcomes.

5
 C O U R S E O U T L I N E

Introduction to DAX
Course Title Introduction to DAX
15 Hrs. Total
Course Language Hours 6 Self-Learning
Arabic / English

Description
 Learn the fundamentals of Data Analysis Expressions (DAX) to perform complex data
calculations in PowerBI.
Benefits of Enrolling in a Course:
 Basics of DAX and its syntax.
 Common DAX functions and their applications.
 Creating calculated columns and measures.
 Advanced DAX scenarios and performance optimization.

1
Basics of DAX and its syntax
 Understand the basic structure and syntax of DAX.
 Create simple calculated columns using basic DAX functions.
Common DAX functions and their applications 3 Hrs.
 Utilize common DAX functions for data analysis.
 Solve typical data manipulation problems using DAX.
Creating calculated columns and measures using DAX
 Design and implement calculated columns and measures to enhance data
models.
 Know the difference between calculated columns and measures 6 Hrs.
 Understand the impact of these calculations on data analysis.
Advanced DAX scenarios and performance optimization
 Tackle advanced data scenarios with complex DAX formulas.
 Learn techniques to optimize the performance of DAX calculations.
Self-Study
DAX in practice - solving business problems
• Apply DAX to solve a specific business problem.
6 Hrs.
• Document the process and results in a case study format.

2
 C O U R S E O U T L I N E

Data Analysis and Visualization using PowerBI

Course Title Data Analysis and Visualization using PowerBI
3 Hrs. Total
Course Language Hours
Arabic / English

Description
 Enhance skills in analyzing data and creating informative visualizations that convey clear
narratives.
Benefits of Enrolling in a Course:

 Advanced chart and graph options in PowerBI.

 Techniques for effective data presentation.
 Exploring new visualization trends and tools.

3
Advanced chart and graph options in PowerBI
 Explore advanced visualization options in PowerBI.
 Create complex visualizations that convey deeper insights.
3 Hrs.
Techniques for effective data presentation
 Learn best practices for presenting data visually.
 Develop skills to tell stories effectively through data.

4
 C O U R S E O U T L I N E

Dashboard and Report Development in Power BI

Course Title Dashboard and Report development in Power BI
12 Hrs. Total
Course Language Hours 3 Self-Learning
Arabic / English

Description
 Learn to design and develop interactive dashboards and comprehensive reports in PowerBI.

Benefits of Enrolling in a Course:

 Dashboard design principles and layout planning.
 Interactive elements and custom visuals.
 Publishing and sharing dashboards.
 User feedback and dashboard iteration techniques.

1
 Dashboard Design Principles
 Understand the fundamentals of effective dashboard design, including
layout, visual hierarchy, and user interactivity.
 Practice designing dashboards that are both aesthetically pleasing and
functional.

6 Hrs.
Interactive Elements and Custom Visuals
 Learn to incorporate interactive elements that enhance user engagement
and data exploration.
 Develop skills in using and customizing visuals within dashboards.

Building Comprehensive Reports

 Gain proficiency in compiling comprehensive and cohesive reports that
effectively communicate data insights.
 Focus on narrative structure and data storytelling within reports. 3 Hrs.
User Experience and Accessibility
 Study best practices for enhancing the user experience and accessibility in
dashboards and reports.
 Apply these practices to improve existing dashboard designs.
Self-Study
Performance Optimization and User Feedback
• Optimize dashboard performance to handle large datasets efficiently.
3 Hrs.
• Implement a feedback loop to refine dashboards based on user
interactions and suggestions.

2
 C O U R S E O U T L I N E

Data Modeling and Integration

Fundamentals of Data Modeling
 Understand the principles of data modeling, including entity-relationship
Course Title Data Modeling and Integration
diagrams and normalization. 12 Hrs. Total
 Practice creating simple data models to support
Course Language analytics.
Hours 0 Self-Study 6 Hrs.
Arabic / English
Building Robust Data Models in Power BI
 Learn to construct and refine data models using Power BI modeling
capabilities.
 Understand the importance of relationships and cardinality in data
modeling.
Data Integration Techniques
 Master techniques for integrating multiple data sources within Power BI.
 Address common challenges associated with data integration, such as data
consistency and conflicts. 6 Hrs.
Ensuring Data Integrity and Security
 Implement measures to ensure data integrity and security during the
modeling and integration processes.
 Understand governance practices related to data handling and usage.
Description
 Focus on creating robust data models and integrating various data sources within Power BI for a
unified view.
Benefits of Enrolling in a Course:
 Principles of data modeling and relationships.
 Techniques for integrating disparate data sources.
 Best practices for maintaining data integrity.

3
 C O U R S E O U T L I N E
Publishing Reports to PowerBI Service
Publishing
 Learn the steps to publish reportsPowerBI
from PowerBIReport
Desktop to&PowerBI
Sharing Service.
 Understand different publishing options and their implications.
Course Title Publishing PowerBI Report & Sharing
 Differentiate between Reports and Datasets 6 Hrs. Total
 Reuse datasets in different reports
Course Language Hours 3 Self-Learning
Arabic / English
3 Hrs.
Configuring Access and Collaboration Settings
 Master the settings for managing access and permissions within PowerBI
reports.
 Practice configuring collaborative features to enhance teamwork.
 Creating and Configuring Workspaces
 Data Compliance and Dataset Labeling

Self-Study
Security Best Practices in Report Sharing
• Study security best practices and policies for sharing PowerBI reports.
3 Hrs.
• Evaluate and apply security settings to protect sensitive data.

Description
 Learn how to publish PowerBI reports and set up effective sharing and collaboration practices.

Benefits of Enrolling in a Course:

 Methods for publishing reports to the PowerBI service.
 Configuring access and permissions.
 Security best practices in report sharing.

4
 C O U R S E O U T L I N E

Data Refresh
Setting Up Data Refreshes in PowerBI Mechanisms in Power BI
 Learn to configure scheduled refreshes and direct query options in PowerBI.
Course Title Data Refresh Mechanisms in Power BI
 Understand the impact of data refresh strategies on report accuracy and
3 Hrs. Total
Course Languageperformance. Hours 3 Hrs.
Arabic / English
 Create Refresh Button in the Dashboard Linked to Power Automate
Troubleshooting Data Refresh Issues
 Develop skills to troubleshoot common issues with data refreshes, including
connectivity and performance problems.
 Implement solutions to ensure reliable data updates.
Description
 Master techniques for refreshing data in PowerBI reports to ensure up-to-date information is
always available.
Benefits of Enrolling in a Course:
 Setting up scheduled refreshes and understanding refresh limitations.
 Troubleshooting refresh issues.
 Using gateway configurations for data refresh.

5
 C O U R S E O U T L I N E

Visualization using Tableau

Course Title Visualization using Tableau
15 Hrs. Total
Course Language Hours
Arabic / English

Description
 You’ll gain a comprehensive introduction to data analysis and visual design in Tableau. You'll
build a range of visualizations – from single worksheets to dashboards – and you'll learn
techniques to apply to your own data analysis with Tableau.
Benefits of Enrolling in a Course:
 Introduction to Tableau Desktop
 Connecting to Data
 Customizing a Data source
 Filtering and sorting Data:
 Working with Date fields:
 Working with Multiple measures:
 Mapping geographical data:
 Using crosstabs
 Using Calculations
 Visualizing Data
 Creating dashboards
 Sharing dashboards


6
 Introduction to Tableau Desktop
Connecting to Data
 How Tableau Desktop Connects to Data sources
Customizing a Data Source
 Editing and saving a data connection (data source connections, metadata
changes, etc..)
 Updating a view with new data
Filtering and Sorting Data
 Creating and changing filter options
 Using Date filters
 Using computed and manual sorts
 Sorting by fields inside or outside the view
 Creating Groups and Hierarchies
Working with Date Fields
 Working with discrete and continuous time fields
 Changing Date fields into Discrete or continuous fields
 Creating Custom Dates

Working with Multiple Measures

 Dual axis and combo charts
 Combined axis charts
Mapping Geographical Data
 Visualizing geographical dimensions on a map
Using Crosstabs
 Creating and editing crosstabs
 Creating totals, subtotals and averages in a crosstab
 Creating highlight tables

Using Calculations
 Working with Dates, Strings and type conversion functions
 Working with aggregations
 Working with table calculations such as percent of total, year over year and
running total
Visualizing Data
 Breakdown of a whole chart types.
 Creating different views such as pie & bar charts, heat map, tree map,
geographical map
 Building hierarchy and tree maps
 Creating scatter plots and highlighting data with reference lines

Creating Dashboards
 Creating dashboards from multiple sheets
 Adding actions for interactivity
Sharing dashboards
Different options for sharing a tableau workbook or uploading it to tableau
server.

7
 C O U R S E O U T L I N E
Principles of Data Governance
 Understand the key principles ofData Governance
data governance, including data quality,
lineage, and stewardship.
Course Title Data Governance 3 Hrs.
 Learn about the roles and responsibilities involved in a data governance
3 Hrs. Total
Course Languageframework. Hours
Arabic / English
Data Governance Frameworks and Models
 Learn about different frameworks and models used to implement data
governance.
 Identify how these frameworks can be tailored to fit various organizational
needs.
 Learn about different frameworks and models used to implement data
governance.
 Identify how these frameworks can be tailored to fit various organizational
needs.
Roles and Responsibilities in Data Governance
 Understand the roles of data stewards, data owners, and other key
stakeholders.
 Discuss the responsibilities associated with these roles.
 Case study analysis to identify roles and responsibilities in a given scenario.
Description
 Explore the principles of data governance necessary to manage accessibility, consistency, and
security of data in PowerBI.

Benefits of Enrolling in a Course:

 Overview of data governance in PowerBI.
 Best practices for data

8
 C O U R S E O U T L I N E

Capstone Project
Course Title Capstone Project
27 Hrs. Total
Course Language Hours 12 Hours Physical / Online
Arabic / English
15 Self-Study

Description
 Provide participants with practical, real-world experience through extensive case studies across
various industries. Students will apply their knowledge of data analysis, visualization, and
reporting to solve complex business problems using tools like PowerBI.

Benefits of Enrolling in a Course:

 Engage in hands-on data analysis and visualization projects across different industries.
 Develop, present, and critique real-world solutions using PowerBI and other analytical tools.
 Enhance case study solutions with advanced analytical techniques.
 Prepare detailed reports and presentations to effectively communicate findings.

Implement a Solution with a full dashboard, documentation, and presentation, and tell a story in one of
the following:

 Market Analysis for a Startup

 Healthcare Data Analysis
 Financial Data Forecasting
 Retail Customer Segmentation
 Social Media Sentiment Analysis
 Transportation Efficiency Study
 Countries-Comparison Data Analysis
 Unemployment Statistics Analysis
 Store Sales Analysis
 Long Survey Data Cleaning and Analysis