Power BI Data Analyst
Course Overview:
This course empowers professionals to turn data into actionable insights using Power BI. Designed for data analysts and business users, it covers the full data analysis lifecycle—from data preparation and modeling to report design, publishing, and advanced analytics. Participants will gain hands-on experience with Power BI, DAX, Copilot, and Microsoft Fabric, preparing them for real-world projects and the Microsoft PL-300 certification.
Course Objectives:
By the end of this course, learners will be able to:
- Prepare and transform data from diverse sources
- Model data using star-schema design and DAX
- Build and share interactive dashboards and reports
- Apply advanced analytics including AI visuals and clustering
- Manage, secure, and automate content in Power BI Service
- Leverage Copilot and Microsoft Fabric for end-to-end analytics
- Demonstrate skills through a hands-on capstone project
Introduction to Data Analytics & Power BI
- Discover data analysis and analyst roles
- Tasks of a data analyst
- Power BI services and applications
- Creating visuals and reports
- Business efficiency with Power BI
Data Preparation & Transformation
- Connecting to data sources
- Storage modes and performance
- Data import error resolution
- Cleaning and transforming data
- Naming conventions and shaping data
Data Modeling with DAX
- Star schema design and relationships
- DAX syntax and calculated columns
- Filter context and time intelligence
- Visual calculations and parameters
- Performance optimization with variables
Designing Interactive Reports
- Report structure and visual types
- Formatting and configuring visuals
- Navigation, bookmarks, and drill-through
- Paginated reports and user experience
- Advanced analytics: clustering, trends
Managing & Publishing Reports
- Workspace creation and permissions
- Sharing and distributing reports
- Semantic model management
- Scheduled and incremental refresh
- Dashboard creation and mobile view
- Row-level security (static and dynamic)
Power BI Copilot & Microsoft Fabric Overview
- Copilot for report creation and summaries
- Semantic model requirements
- End-to-end analytics with Microsoft Fabric
- Data team roles and Fabric enablement
Capstone Project
- Data preparation and modeling
- Report design and publishing
- Use of DAX and advanced analytics
- Dashboard creation and security setup
Curriculum
- 1 Section
- 10 Lessons
- 10 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
- Interactive quizzes to reinforce key concepts
- Capstone project with instructor feedback
- PL-300-style labs and exam preparation
- Certification upon successful completion
- Data analysts and BI professionals working with on-prem or cloud data
- Business users transitioning into data-focused roles
- Individuals preparing for the Microsoft PL-300 (Power BI Data Analyst Associate) exam
- Basic understanding of Excel or data analysis concepts
- Familiarity with business intelligence tools (Optional)
- Access to a laptop or desktop with internet connection
- Power BI Desktop installed (Optional)
- Willingness to engage in hands-on labs and project work
Round 1
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
-
Intermediate
-
Active
-
16 Students
-
16 lessons
Login with your site account
Not a member yet? Register now
Register a new account
Are you a member? Login now