Data Analysis Professional Diploma
Course Overview
Turn data into insight using Excel, Power BI, and Microsoft Fabric. Prepare, model, visualize, and analyze data with hands-on labs and a capstone project.
This course is designed for those who perform data analysis tasks and want to enhance their skills using Power BI.
Course Objectives
By the end of this course, you will be able to:
1.Prepare & transform data from diverse sources.
2.Model data with star‑schema design and robust DAX.
3.Build and share interactive dashboards, reports.
4.Apply advanced analytics (AI visuals, clustering, insights).
5.Manage, secure & automate content in the Power BIService.
6.Leverage Copilot & Microsoft Fabric for end‑to‑endanalytics.
Capstone Project
Participants will work in groups to create and present a full digital marketing campaign tailored to product or service. Projects will include strategy, platform selection, content samples, KPIs, and media budgeting.
Data Analysis in Excel
- Introduction to Data Analysis
- Data types, metrics, KPIs
- Power Query: Connect to CSV, SQL, web sources
- Handle nulls, duplicates, errors
- Parameterized queries and combining data
- Power Pivot: Relationships and star schema
- PivotTables and DAX essentials
- Time intelligence and scenario analysis
- Macros for automation
- Dashboard design with Pivot Charts and Slicers
Power BI Analytics (Model migration, core & advanced visuals, accessibility)
- Compare Power Query in Excel vs. Power BI
- Migrate Excel models to Power BI
- Basic visualizations: bar, line, tables, matrices
- Formatting and interactivity
- Advanced visuals: Sankey, heatmap, drill-through
- Accessibility checks
- Deployment and publishing to Power BI Service
- Row-Level Security (RLS)
- Sharing via Microsoft Teams
AI & Microsoft Fabric
- AI-powered analytics tools and use cases
- Microsoft Fabric overview and integration
- Data team roles and enabling Fabric
Capstone Project
- Data preparation
- Model development
- Dashboard design
- Presentation and peer review
Curriculum
- 1 Section
- 16 Lessons
- 8 Weeks
Mohamed Yahia
Professional Summary
Mohamed Yahia is a Certified Management Accountant (CMA) and Microsoft/IBM-certified Data Analyst with 15+ years of corporate expertise in financial analysis, budgeting, and data-driven decision-making. As a Budget & Financial Analysis Manager at Telecom Egypt, he oversees multi-million-dollar budgets, designs executive dashboards, and transforms raw data into strategic insights using Power BI, Excel, and SQL.
A dedicated educator, Mohamed has 5+ years of training experience, teaching professionals to master financial modeling, Power BI visualization, and advanced Excel techniques. His unique blend of CMA expertise (Master’s in Accounting) and cutting-edge data certifications (Nanodegree, IBM, Microsoft) bridges the gap between finance and analytics.
Key Qualifications
• Power BI & Excel: 15+ years building dynamic reports, KPIs, and forecasting models.
• Certifications: Microsoft Certified: Power BI Data Analyst Associate | IBM Data Analyst Professional Certificate | Udacity Nanodegree.
• Taught 100+ professionals to pass CMA exams and deploy Power BI/Excel solutions.
• Winner of Telecom Egypt’s Leadership Award for data-driven presentations.
Education & Certifications
• Certified Management Accountant (CMA)
• Master’s in Accounting (Damanhour University)
• Microsoft Certified: Power BI Data Analyst Associate
• IBM Data Analyst Professional Certificate | Udacity Data Analyst Nanodegree
• IBM Data Analyst Professional Certificate
• Data Analyst Nano Degree.
- Hands‑on labs and real‑world datasets after every module
- Capstone project reviewed with instructor feedback
- Interactive quizzes reinforce key concepts
- Certificate of Completion
- Data analysts & BI professionals
- Business users moving into data roles
- Working Professionals
- Students & Recent Graduates
- Career Switchers
- Basic Excel skills
- Interest in data analytics
- English proficiency is helpful, as the course is likely delivered in English.
Round 3
You might be interested in
-
Expert
-
Coming Soon
-
0 Students
-
12 lessons
-
Intermediate
-
Active
-
139 Students
-
15 lessons
-
Expert
-
Coming Soon
-
0 Students
-
12 lessons
-
Expert
-
Coming Soon
-
0 Students
-
15 lessons
Login with your site account
Not a member yet? Register now
Register a new account
Are you a member? Login now