Data Analysis & AI Application in Excel & Power BI Diploma

Home / Course / Data Analysis & AI Application in Excel & Power BI Diploma

Choose from the following available dates to enroll in the Data Analysis using Excel and PowerBI online course

Start DateDaysTimeAvailable Seats
11-DEC-2023Monday – ThursdayFrom 7:00 to 10:00 PMJoin now
23-DEC-2023SaturdayFrom 5:00 to 9:00 PMJoin now
27-DEC-2023Sunday – WednesdayFrom 6:00 to 9:00 PMJoin now

48 hours of training
3 months of practical training
Interactive online lectures
Courses are offered in Arabic

Why you have to enroll in Data Analysis using Excel and Power BI course from IMP

  • Data flourish for informed decisions, it allows organizations to measure performance in all aspects, monitor, evaluate and take corrective action. Accordingly, data analysis can be seen as the main means for business excellence and acceleration.
  • Our Diploma included with a practical training on a variety  of chosen Ai tools, making it an ideal choice for anyone looking for to leverage the latest techniques on the data analysis efforts.
  • This Diploma is the ideal practical to Enhance your Data Analysis Skills and jumpstarting for data Science Track.
  • This Diploma is a combination of The Concept Of Data Visualizations and Technical Skills to build a career future in one of the most important fields worldwide; where the most of global and innovative companies are utilizing data analysis to help making data-driven decisions using Business Intelligent Solutions
  • Our Ai-Driven data analysis course will equip you with the latest techniques to extract valuable insights from your data and informed business decisions

Training Methodology

1) Training setting: to ensure maximum flexibility possible that enable our trainees to pursue their career and personal objectives we offer trainings in: on-primes setting as well as virtual interactive sessions

2) Learning experience: This course will be highly interactive, with a mix of theory, including practical sessions. You will have the opportunity to learn by doing and share your experience, and you will develop your skills through a series of assignments and Projects. 

  • Differentiate analytics techniques.
  • Compute measures of central tendency for various data sets and interpret results
  • Compute and interpret measure of dispersion for various data sets
  • Select proper visual for the message and data
  • Enhance data visuals

3) Up-to-date content: that is precisely chosen by a team of technical experts and is continuously revised for enhancement and coping with technology trends.

4) Hands–on training:  form industry experts, you’ll learn how to harness the power of Ai to automate data analysis tasks, build predictive models, and unlock new opportunities for your business 

Why Study Data Analysis?

  • Increase the Awareness of data analysis techniques using excel & Business Intelligent Solution [Power BI]
  • Perform Data Transformation to explain how findings from data can and should be visualized, to enable stakeholders to make sound business decisions
  • Develop data modeling and DAX to manipulate relevant data and deeply analyzes it by applying appropriate techniques to appropriately answer business questions
  • Advance Data Visualizations techniques in Excel & Power BI to enhance stakeholder Involvement in Decision Making.
  • Build the confidence in influencing business decisions through Data Driven decisions.
  • Build a career in one of the most in-demand fields.
  • Excel your knowledge and expertise and get ready for career development in one diploma.
  • Get prepared for obtaining international data analyst certification.
  • Business owners/ executives/ CEO will be able to read and request the right reports that help them with multifunction decision making.
  • Get acquainted with the data literacy concepts as well as the statistical analysis terms and their application with Excel and Power BI
  • Walking you through storytelling with data journey to become an efficient storyteller, and its application to two of the most frequently used tools.
  • Building the capacity to differentiate corporate data according to type, dynamism, structure, and storage, which puts you on track with building organization data strategy.
  • Providing you with the ability to discuss different analysis and analytics techniques and which best suits your goal/ research question as well as perfectly utilize existing data.

Who Should Attend?

This diploma is designed for:

  • Professionals who seek to build a career in one of the most in-demand fields.
  • Professionals who wish to gain an understanding of the benefits and uses of data analysis and the techniques applied using Excel, Power BI and the latest innovation Ai Driven techniques  when analyzing business data, in order to improve their analytical skills and understanding of data.
  • Professionals who seek to enhance their analysis capabilities and pursue an analyst or data visualization developer career.
  • Data analysts who want to expand their skillset and learn how to use Ai-driven techniques to extract insights from data
  • Business Professionals, business analysts, data analysts, finance professionals, marketing and sales professionals, HR professionals, IT professionals, administrative staff, supervisors, general business professionals, and staff from any function who need to learn and apply data analysis techniques to their daily business reporting and decision making.

This Diploma Prepares Trainees to Pursue Their Careers As:

  • Data analyst.
  • Business intelligence specialist.
  • Performance and reporting analyst.
  • Data visualization specialist.
  • Marketing analyst.
  • Reporting specialist.
  • Program analyst.

Diploma Objectives:

  • Data Literacy.
    • Define data, and illustrate different data types
    • Introduce data analysis and analytics techniques, along with their usage and prerequisites.
    • enable you to participate in organization data strategy formulation.
    • Introduce Powerful Ai techniques that can be applied using Excel and power Ai
  • Descriptive Statistics
    • •Understanding descriptive statistics and its underneath approaches.
    • •Illustrate calculation techniques
    • •Explain how to read and interpret descriptive statistics for any data set
    • •Examine data for any issues (outlier, skewness, ..etc.) 
  • Story Telling with Data.
    • define a data story, How does it differ from data visual?
    • How to formulate a professional data story?
    • What are the best practices with data visuals?
    • How to evaluate your data visual with the help of a checklist?
    • How to enhance your data visual?
    • What are the best dashboard layouts?
  • Data Analysis Using Excel
    • Apply newly acquired skills to datasets using Excel to create professional dashboard, for that end you will learn:
    • Connect, Transform, and Load Data Using Power Query
    • Enhance Data Modeling
    • Build Data Analysis Expression [DAX] in Excel
    • Mastering Data Visualization in Excel & Creating Dynamic
  • Data Analysis Using Power BI:
  • Leverage acquired skills that you have already applied in Excel to one of the most demanded tools, for that end you will:
    • Understand The Concept Of Business Intelligent Solutions
    • Connect, Transform, and Load Data Using Power BI
    • Working With DAX and Advanced DAX Measures

Capstone Project Details

  • This project is designed to give you the chance to implement and practice all the skills, knowledge and expertise you have gained throughout this diploma.
  • You will have the full opportunity to work on real-world business problems, research questions, and leverage your knowledge as well as instructors guidance to put these in practice.
  • From the problem statement, data preparation, processing, connection, transformation to reporting business insights with the proper visuals. The resulting interactive dashboard will have the chance to be evaluated with a unified checklist that gives learners equal opportunity to be recognized on our leaders board.
  • Learners shall be invited on demonstration day to present and showcase their newly gained skills put into practice with informed decisions being proposed after successfully preparing data for creating insightful and efficient dashboard.

Learn how to analyze data faster, and extract smarter business insights, and present your work better. All while making it look so easy!

دورات تدريبية كورسات اونلاين
An example of what you can do through the data analysis course using Excel and PowerBi

IMP is one of the most important companies specializing in data analysis training for several years. We trained many companies, banks and institutions in the field of data analysis in Saudi Arabia, Kuwait, United Arab Emirates and several Arab countries.

What you will learn in the Data Analysis with Excel and Power BI course:

  • Introduction to pivot tables and charts.
  • Summarize and analyze data using pivot tables.
  • Introduction to Power Query.
  • Connect to Workbook Excel files.
  • Connect to CSV and TXT files and folders.
  • Connect to Access files.
  • Manipulate and improve data with Power Query.
  • Download and build the data model.
  • Work and link between multiple data sources.
  • Customize columns using M.
  • Introduction to Power Pivot.
  • Understanding how to build a Data Model.
  • Create relationships in the Data Model.
  • Use and master DAX equations.
  • Using and mastering Calculated Column equations.
  • Using and mastering Measures equations.
  • Use and master Row Context equations.
  • Using and mastering Filter Context equations.
  • Build schedules for dates and time periods.
  • Use DAX equations to manipulate history.
  • Create interactive reports using Excel.
  • Create interactive visualization.
  • Introduction to business intelligence solutions.
  • Introduction Power Bi.
  • Create an interactive report and dashboard.
  • Load the data for the BI run.
  • Download and update PBIX reports.
  • Transform data with Power Query in Power Bi.
  • Use the data model.
  • Create relationships.
  • Create hierarchies.
  • Using and mastering Calculated Column equations.
  • Using and mastering Measures equations.
  • Build schedules for dates and time periods.
  • Use DAX equations to manipulate history.
  • Create reports and a dashboard.
  • Customize and filter reports.
  • Drill-down & Drill-Through Use the Drill-down & Drill-Through feature.
  • Axis graphic format.
  • Apply conditional formatting.
  • Slicers and Advance Card Visuals use the property.
  • Use the Bookmarks & Buttons feature.
  • What is data science?
  • The difference between a data scientist and a data analyst.
  • Data analysis competencies vs. data science competencies.
  • Understand the importance of context and audience.
  • Determine the appropriate type of chart for your situation.
  • Direct your audience’s attention to the most important parts of your data.
  • Harness the power of storytelling to help your message resonate with your audience.
  • Pulling data using Python.
  • Data cleaning with Python.
  • Transform data using Python.
دورات تدريبية كورسات اونلاين

Money-back guarantee!

To remove the dread that you join the Data Analysis with Excel and Power Bi online course, We will offer a money back guarantee to anyone who joins the program and is not satisfied with what they have learned for 15 days.

You must be there live during class time and practice the video lessons given to you between classes to be eligible for a refund.

A sample of data analysis course lectures using Excel and PowerBI application

Part of one of the lectures from the Power BI Data Analysis Diploma
Part of one of the lectures from the Excel Online Live Data Analysis Diploma

This course prepares you to take the Microsoft Data Analysis Exam

Besides the training courses that are conducted in the head office of the IMP in Egypt; IMP courses are also offered live through fully interactive lectures that allow interaction, asking questions, and having the best online learning experience ever.

IMP certificate template

دورات تدريبية كورسات اونلاين


دورات تدريبية كورسات اونلاين

The full course costs $240 instead of $400 for a limited time

Choose the date that suits you and pay through the electronic payment card.


  •  Being data literate means having the necessary competencies to work with data, this part will enable trainees to:
  •  Understand different types of data with their organization
  •  Get acquainted with different analytics techniques and the business/ research questions they answer.
  •  What techniques suit the data type you own Will enable you to leverage your newly acquitted skills to participate in organization data strategy formulation.


  •  Understanding of descriptive statistics covering measures of central tendency & measures of spread. 
  •  You will build on skills and knowledge from data literacy section where you were introduced to different types of data, now it is time to use appropriate measures of central tendency and measure of spread for your data set(s) to understand & describe the data at hand
  •  You will be introduced to the formulas for calculation as well as lead through the interpretation of these measures.
  •  You will also get to know how to combine these messages and comment on the data at hand.


  • You will get introduced to the concept of data story and be able to differentiate it from data visual, then you will build on you earlier gained skill to walk through storytelling journey where:
  • Understand the context, to whom you are presenting your story, what message you are delivering and how to use data to best convey the message.
  • Then you would be guided on visual selection to choose the one the perfectly suit your message as well as the type of data at hand
  • You will walk through different milestones to enhance your visual, to direct audience attention.
  • You will get presented to dashboard layout best practices.
  • Will wrap up with What makes a good visual? Best practices for data visualization and charting


Putting the earlier illustrated concepts into action you will start with Excel dashboard, to make this happen your journey will continue with the following milestones:

Classic Excel Dashboard

  • Introducing Pivot Tables & PivotChart
  • Analyzing Data with PivotChart

Connect, Transform, and Load Data Using Power Query

  • Introducing to Power Query
  •  Connecting to Excel Workbook Files
  •  Connecting to CSV & TEXT Files & Folders
  •  Connecting to Access Files
  •  Transforming Data Using Power Query
  •  Loading Data to the Excel Data Model
  •  Working with Multiple Queries
  •  Custom Columns with M Calculations

Working with Data Model in Power Pivot

  • Power Pivot Capabilities
  •  Understand Data Model Concept
  •  Create Relationships in Data Model

Working with DAX

  • Understand Data Analysis Expression – DAX
  •  Create Calculated Column
  •  Create Measure
  •  Row Context
  •  Filter Context

Working with Advanced DAX Measures

  • Building a Calendar table
  •  Time Intelligence in DAX

Visualizing Data in Excel

  • Create Dynamics Excel Reports
  •  Create interactive Excel Dashboard


Get Started with Power BI Desktop

  • Introduction Power BI
  •  Create Report & Dashboard

Clean, Transform, and Load Data in Power BI

  • Loading Data to Power BI
  •  Uploading & Updating PBIX Reports
  •  Transforming Data Using Power Query in Power BI

Create Data Model in Power BI

  • Manage Data Model in Power BI
  • Create Relationships & Hierarchies

Working with DAX in Power BI

  • Create Calculated Column
  •  Create Measure 

Perform Advanced DAX in Power BI

  • Time Intelligence in DAX
  • Building a Calendar table

Data Visualizations in Power BI

  • Creating Reports & Dashboard
  •  Report Filtering
  •  Drill-down & Drill-Through
  •  Formatting Visualizations
  •  Apply conditional formatting
  •  Bookmarks & Buttons & Q & A

Bonus Module: Introduction to Data Science ( Live Interactive )

At the final stage for that long journey, you will be introduced to the data science concept and differentiate it from data analysis as well as what are the competencies that constitute a good data


  • What is Data Science


  • Difference Between Data Scientist & Data Analyst


  • Data Analysis Competences VS Data Science Competences

Model 6 : Applied Artificial Intelligence

What is AI?

  • Understanding the definition of AI , machine learning , Deep Learning and Artificial Intelligence.
  • Why should we use AI in Power BI?
  • What are our options for AI in Power BI?

AI Features and Bot in Excel AI Features in Power BI

  • Forecasting Time-Series Data
  • Detecting Anomalies in Your Data Using Power BI
  •  Using Natural Language to Explore Data with the Q&A Visual.
  • Using Cognitive Services  Integrating
  • Natural Language Understanding with Power BI
  • Integrating an Interactive Question and Answering App into Power B
  • Getting Insights from Images with Computer Vision
Level: Beginner & Advanced
48 Hours
Course Type: Online Interactive
Language: Arabic
money back