English

English

Data Analysis with Excel and Power BI

Want to turn raw data into powerful insights that drive smart decisions?
Our Data Analysis with Excel and Power BI course is designed to equip you with the practical skills used by professionals to organize, analyze, and visualize data with confidence.In just 48 hours, you’ll master essential tools that make you stand out in any data-driven role.

Start your journey into the world of Data Analysis—professionally and practically!

Course Overivew

Unlock the power of data with two of the most in-demand tools in the business world—Excel and Power BI. This course is designed for professionals, students, and career changers who want to master data analysis and build a strong foundation in business intelligence.

Whether you’re new to data or looking to sharpen your analytics skills, this hands-on course will guide you step-by-step through the entire data workflow—from data collection and cleaning to advanced visualizations and dashboards.

What You Will Learn:

Excel for Data Analysis

Data cleaning, sorting, and filtering
PivotTables and PivotCharts
Advanced formulas & functions (LOOKUPs, IFs, etc.)
Data validation and conditional formatting
Descriptive statistics and basic trend analysis

Power BI for Business Intelligence

Data import and transformation with Power Query
Creating data models and relationships
DAX functions for calculations and KPIs
Building interactive dashboards
Publishing and sharing reports in Power BI Service

Career Prospects:

Upon completion of this course, you’ll be ready to step into roles such as:

Data Analyst
Business Analyst
Reporting Analyst
BI Developer
Operations Analyst

Excel and Power BI are widely used across industries—finance, marketing, logistics, healthcare, and more. This course gives you practical experience to stand out in job interviews or deliver stronger insights in your current role.

Start now and turn data into action. Your career in analytics begins here!

Course Benefits

Course Certification

This certification showcases key skills, hands-on experience, and industry expertise, recognized globally by professionals and employers.

Book Your Seat Now !

Course Outline

Data Analysis in Excel

Classic Data Analysis with Excel
Excel Pivot Tables
Limitations of Classic Data Analysis
Describe classic data analysis with Excel
Describe Excel pivot tables
Describe the limitations of classic data analysis with Excel

The Excel Data Model

Using an Excel Data Model
DAX
Describe an Excel data model
View data within an Excel data table
Describe DAX

Importing Data from Files

Importing Data from Databases

Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Loading Data
Identify available data sources.
Preview, shape, and transform data.
Explain table relationships and hierarchies.
Load data from various sources.

Importing Data from Excel Reports

Importing Data from Excel Reports
Transforming Excel report Data
Import data from Excel reports.
Transform Excel report data.

Creating and Formatting Measures

DAX
Measures
Advanced DAX Functions
Explain what DAX is and when to use it.
Describe a measure.
Use some of the advanced functions within DAX.

Visualizing Data in Excel

Pivot Charts
Cube Functions
Charts for Cube Functions
Create and refine a pivot chart.
Describe cube functions and when to use them.
Describe a number of charts for use with cube functions.

Using Excel with Power BI

Power BI
Uploading Excel Data to Power BI
Power BI Mobile App
Describe Power Bi and the various versions available.
Upload Excel data to Power BI.
Describe the Power BI App.

Discover Data Analytics

Overview of data analysis
Roles in data
Tasks of a data analyst

Get started building with power bi

Use Power BI
Building blocks of Power BI
Tour and use the Power BI service

Get data in power bi

Clean, transform, and load data in power bi

Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code

Design a data model in power bi

Add measures to power bi desktop models

Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures

Add calculated tables and columns to power bi desktop models

Create calculated columns
Learn about row context
Choose a technique to add a column

Use DAX time intelligence functions in power bi desktop models

Use DAX time intelligence functions
Additional time intelligence calculations

Optimize a model for performance in power bi

Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize Direct Query models with table level storage
Create and manage aggregations

Design power bi reports

Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators

Configure power bi report filters

Apply filters to the report structure
Apply filters with slicers
Design reports with advanced filtering techniques
Consumption-time filtering
Select report filter techniques
Case study – Configure report filters based on feedback

Enhance power bi report designs for the user experience

Perform analytics in power bi

Create and manage workspaces in power bi

Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection

Manage datasets in power bi

Use a Power BI gateway to connect to on-premises data sources
Configure a dataset scheduled refresh
Configure incremental refresh settings
Manage and promote datasets
Troubleshoot service connectivity
Boost performance with query caching (Premium)

Create dashboards in power bi

Implement row-level security

Configure row-level security with the static method
Configure row-level security with the dynamic method

What you will learn

By the end of this course, you will be able to:

Apply advanced Excel functions to analyze and manipulate data efficiently.
Utilize PivotTables and PivotCharts for dynamic data summarization and reporting.
Leverage Power Query to clean, transform, and integrate data from multiple sources.
Create professional dashboards and visualizations for data-driven decision-making.
Automate repetitive tasks using macros and advanced Excel tools.
Enhance productivity by integrating Excel with other Microsoft applications like Power BI.
Import and Transform Data – Use Power Query to clean, filter, and shape data from various sources for analysis.
Design Data Models – Create effective data models and define relationships between tables for accurate analysis.
Master DAX (Data Analysis Expressions) – Use DAX to create custom measures, calculated columns, and aggregations.
Create Interactive Dashboards – Build visually appealing, interactive reports and dashboards to present business insights.
Implement Power BI Best Practices – Ensure data models and reports are optimized for performance and scalability.
Share and Collaborate with Stakeholders – Publish reports to the Power BI Service and collaborate with team members and executives for data-driven decision-making.
Visualize Key Metrics – Utilize Power BI’s advanced visualization tools to highlight trends, KPIs, and actionable insights.

Audience profile

This course is ideal for anyone looking to enhance their data analysis and business intelligence skills using Excel and Power BI. Whether you’re just starting out or looking to level up, this program is tailored to fit a wide range of professional needs:

Business Professionals & Managers: Who need to analyze performance, generate reports, and make data-driven decisions quickly and effectively.
University Students & Fresh Graduates: Looking to boost their CVs with practical, job-ready data skills that are highly valued across industries.
IT & Technical Professionals: Seeking to transition into data-focused roles or complement their existing skills with powerful reporting and visualization tools.
Aspiring Data Analysts: Wanting a solid foundation in tools used daily in real-world analytics and reporting environments.
Career Shifters: From finance, HR, sales, or any field—interested in exploring a career in analytics or business intelligence.
Entrepreneurs & Freelancers: Who want to track business metrics, create dashboards, and understand their data without relying on external support.

No prior experience in data analysis is required—just basic computer skills and a curiosity for working with data!

Download Course Brochure

Top-Rated Experts in the industry

Learn from top-notch instructors who bring industry expertise, passion, and years of experience to guide you toward mastery.

Industry-Relevant Curriculum

Learn practical tools and techniques tailored to solve real-world business challenges.

Hands-on Learning and Projects

Put your skills into action with real-world projects that mimic actual industry scenarios. Build a portfolio that showcases your expertise and prepares you for success in freelancing or company roles

Certification with Credibility

Showcase your skills with a accregated certificate to enhance your professional profile

Career Mentorship and Coaching

Learn from experienced instructors who not only teach data analytics but also mentor you on securing your dream job whether as a freelancer or with top companies

Prerequisites

What Learners Are Saying

Abdelrahman Ahmed

I am excited to announce the completion of a 160-hour intensive training course with CLS Learning Solutions in Microsoft Certified Solutions Associate (MCSA), this was a key step in strengthening my expertise in Windows Server environments as I advance my career in cybersecurity.

Ahmed ElGhobashy

I am excited to share that I have successfully completed the Power BI Data Analyst certification, covering 'Analyzing Data with Excel and Analyzing Data with Power BI', provided by CLS Learning Solutions.

Ahmed Elkomy

Excited to apply these advanced skills to transform data into meaningful insights. Looking forward to the next step in my journey! Thanks ❤️ CLS Learning Solutions.

Ahmed Mostafa Mahmoud

I’m happy to share that I’ve obtained a new certification: Data Analysis with Power BI from CLS Learning Solutions!

Ahmed Nehro

I’m happy to share that I’ve obtained a new certification: Querying Data with Transact-SQL from CLS Learning Solutions & Microsoft!

Alyaa Gaber

I am thrilled to announce that I got my certificate for a preparation course for Certified Business Analysis Professional (CBAP). Thanks, CLS Learning Solutions.

Amr Azab

I'm Happy to share that I've obtained a new course: PMP Preparation Exam from CLS Learning Solutions, many thanks Mr. Ahmed Elshahat.

Areej Sofy

I'm thrilled to announce that I have successfully completed a comprehensive Data Science and Machine Learning course! with CLS Learning Solutions This journey has been a rewarding experience, providing me with a solid foundation in key concepts such as data analysis, predictive modeling, machine learning algorithms, and more.

Aziza Moatz

I’m grateful to my company ضمان - CGC for giving me the opportunity to take an Excel course, and to CLS Learning Solutions for delivering it professionally. Excited to keep learning in a supportive work environment!

Hisham Ibrahim

I am happy to announce that I have successfully completed the Power BI and Excel Data Analysis course from Microsoft! I am grateful for the support and resources from CLS Learning Solutions that helped me reach this goal and look forward to applying these skills to solve challenges.

Inaam Badawi

It was a real pleasure having the MCV - Manufacturing Commercial Vehicles HR team in my AI for HR workshop. I enjoyed teaching them how AI could improve their HR strategies and operations to drive innovation. Thank you, CLS Learning Solutions to make this happen and for the opportunity!

Mahmoud Ibrahim

I am thrilled to announce that I have successfully completed the Diploma in Data Science & Machine Learning (AI) offered by CLS Learning Solutions.

Mai Ahmed

I am pleased to have successfully completed the Agile Fundamentals Training under the guidance of Ziad Algamal , delivered by the Egyptian Banking Institute in collaboration with CLS Learning Solutions. This training has provided valuable insights into Agile methodologies and best practices that will enhance my approach to software testing and development in the banking sector.

Michael Fahmy

Excited to share that I’ve successfully completed the CCNA course with CLS Learning Solutions! This course has been a great opportunity to deepen my knowledge in networking concepts and technologies, and it’s a significant step towards advancing my career in IT and networking.

Mohamed Abdel aziz

I’m happy to share that I’ve attended and completed: Certified Information Systems Security Professional (CISSP) from CLS Learning Solutions!

Mohamed Aldremly

Special appreciation to Yasser A. Rahman and CLS Learning Solutions for their dedication and impactful guidance!

Mohamed Hassan

A special thanks to CLS Learning Solutions for providing us with this valuable opportunity to achieve this certification. Your support in empowering learners is truly appreciated!

Mohamed Mekkawy

I am thrilled to announce that I have completed my CCNA certification through the Cisco Networking Academy, under the guidance of Eng. Tarek El Gendy at CLS Learning Solutions! Over the past months, I have gained valuable knowledge and hands-on experience.

Mohamed Saeed

I’m happy to share that I’ve obtained a new certification: ISO 31000 Lead Risk Manager from CLS Learning Solutions!

Mohamed Samir

I`m very proud to have CISSP ISC2 Certificate from CLS Learning Solutions. The most wanted certificate in Cybersecurity, this milestone gives me a comprehensive vision of all aspects of cybersecurity.

Mohamed Taha

This learning journey has deepened my skills in data analysis, visualization, and insights generation, bringing me one step closer to mastering data-driven decision making.

Mohand Khaled

Excited to share that I have successfully completed the Cisco Certified Network Associate (CCNA 200-301) course at CLS Learning Solutions. This program was a transformative journey into the world of networking and prepared me with both theoretical knowledge and hands-on skills.

Muhammad Amjad Karara

I'm happy to share this moment with you guys, I got my CLS Learning Solutions certification in Python. I hope this step will be helpful and a good addition to my career ❤ .

Nada Osman

I’m excited to share that I had the privilege of attending the Agile Analysis Certified Professional (AACP) preparation course, accredited by the International Institute for Business Analysis (IIBA). It was an incredible experience. Thanks to CLS Learning Solutions for organizing this transformative program.

Sama Aly

I’m thrilled to announce that I successfully attended and completed 'Power BI Data Analyst' course from CLS Learning Solutions.

Samer Eltawansy

We're thrilled to share a snapshot of our ongoing Power BI training program! And big thanks to the trainer Ahmed Mounir and CLS Learning Solutions team.

Vivian Fayez

We are thrilled to announce our Basic Excel Training round #1 for our valuable employees. At SODIC SPORTS CLUBS, we believe in continuous learning and empowering our team with essential skills to enhance efficiency and productivity. Thanks, CLS Learning Solutions for this training that will equip participants with the fundamental Excel techniques needed for data management, analysis, and reporting.

Discover more in our promo videos!

Play

Training Locations

Our classrooms in provide an in-person learning experience with direct interaction with instructors,These locations are equipped with modern facilities that support collaboration, practical training, and focused attention

Cairo Branch

Giza Branch

We offer two tailored virtual training formats, the Self-Paced Training to Enjoy the freedom to study anytime, anywhere and the Virtual Interactive Instructor-Led Training with flexible sessions that connect you with expert instructors in real time

Virtual Instructor-Led Training

Self-Paced Training

We offer on-site training at your company’s premises. Tailored to your business needs, these sessions allow employees to learn without leaving the workplace.

Our expert instructors will deliver courses designed to enhance skills and drive performance, all in a familiar and comfortable environment.

Why Learn from CLS?

Years of Experience

+ 0

Since 1995, we’ve been a trusted training partner, helping individuals and organizations achieve their goals.

Expert Instructors

+ 0

Learn from with top experts in the industry guranteed and get career assistance and coaching.

Hands-On Learning

% 0

Our courses are designed with real-world projects and practical applications.

Our Graduates' Success Stories

Mohamed Ismail

IT Infrastructure and Service Manager at SANOFI

My experience with CLS Learning Solutions was a very nice experience and I benefited a lot in light of the participation and explanation from the distinguished professors. This is the first time I have participated in ITIL Course these wonderful sessions and I advise everyone to participate and benefit from this wonderful center.

Dr. Hoda Baraka

Advisor to Minister for Technology Talents Development

CLS is one of the Best Performing training centers in DEPI Initiative, they are very organized, they provided their own LMS which helped our team in monitoring and reporting, their instructors were all very professional and above expectations.

Amr Khames

Training and Development Manager at Al Ezz Dekheila Steel

The professional training services provided by this team exceeded our expectations. The courses were highly engaging, expertly delivered, and tailored to our needs. Our team gained valuable skills that have directly impacted our performance. I highly recommend their training programs for anyone looking to upskill their workforce.

Dr. mohamed hafez

Data Analyst

Dr. mohamed hafez Testimonial on Data Analysis Track – He Successfully graduated from Our Data Analysis Track with DEPI Scholarship (MCIT)

DEPI

DEPI Graduates Testimonials

فعاليات يوم الابتكار في الذكاء الاصطناعي والمسارات المهنية واتجاهات السوق بحضور طلبة مبادرة رواد مصر الرقمية في مسار الذكاء الاصطناعي بفندق سفير بالدقي بالقاهرة في حضور نخبة من خبراء الذكاء الاصطناعي في سوق العمل المصري والسعودي

Mona Moamen

Office Manager at International Drug Agency For Pharmaceutical Industry

Testimonial from Mr. Mona Moamen, Office Manager at International Drug Agency For Pharmaceutical Industry and She Successfully graduated from Our Data Analysis Track with DEPI Scholarship ( MCIT )

Mohamed Amro Seleem

Computer Science Student

Mohamed Amro Seleem ( Computer Science Student) Testimonial on Data Analysis Track – He Successfully graduated from Our Data Analysis Track with DEPI Scholarship (MCIT)

Mohamed Amro Seleem 2

( Computer Science Student)

Mohamed Amro Seleem ( Computer Science Student) Testimonial on Data Analysis Track – He Successfully graduated from Our Data Analysis Track with DEPI Scholarship (MCIT)

Our Strategic Clients

The CLS Learning Solution Advantage

Experience

We have been in the market since 1995, and we kept accumulating experience in the training business, and providing training for more than 200,000 trainees ever since, in Egypt, and the MENA region.

Premium Facilities

CLS facilities are well-equipped with strong hardware and software technologies that aid both students and trainers lead very effective smooth training programs.

Customer Support

We provide our clients with the best solutions, customized to their specific needs and goals. Our team is highly qualified to answer whatever questions you have.

Global Accredited

CLS is an authorized and accredited partner by technology leaders. This means that our training programs are of the highest quality source materials.

Up To Date

We keep tabs on every change in the market and the technology field, so our training programs will always be updated up to the World-class latest standards, and adapted to the global shape-shifting job market.

Certified Instructors

We select the best instructors, who are certified from trustworthy international vendors. They share their professional experience with the Trainees, so they can have a clear hands-on experience.