COURSE CONTENT
What you will learn 📊:
1️⃣ Advanced Excel data handling and analysis (IF – VLOOKUP – SUMIFS..)
2️⃣ Data analysis using PivotTables
3️⃣ Data analysis using PivotCharts
4️⃣ Creating professional dashboards
5️⃣ Cleaning and manipulating data using Power Query
6️⃣ Building data relationships (Star Schema)
7️⃣ Using DAX in Power BI and creating measures
8️⃣ Data storytelling and communicating results with stakeholders
The course will be in Arabic. It starts from 6:30pm to 9:30pm (week days only)
This course is designed to help you build strong, practical data-analysis skills using Excel and Power BI. You will learn advanced Excel functions such as IF, VLOOKUP, SUMIFS, and other powerful data-handling techniques. The program covers PivotTables, PivotCharts, and the creation of professional dashboards to help you analyze and present information effectively. You will also work with Power Query to clean and transform data, build Star Schema data models, and apply DAX formulas to create insightful measures in Power BI. The course concludes with techniques for data storytelling—showing you how to communicate insights clearly and professionally to stakeholders.
Trainer
Hamza Radfan Ahmed
An active Data Analyst with more than 3 years corporate experience using Excel & Power BI
Point of Contact: +966536652139.
Copyright © 2025 - PSTI - All rights reserved.