Data Analysis with Excel and Power BI

Bestseller

Total Duration 48 Hours

Level Beginner / Intermediate

Delivery Mode

Virtual Learning Public Classroom

Available Schedules

Skills you'll learn

10 skills

Excel data analysis

Data cleaning

sorting and filtering

Data validation

Power BI

Data import and transformation

Power Query

Creating data models

DAX functions

Publishing and sharing reports

Prerequisites

Basic computer literacy

Familiarity with Microsoft Excel

Course Outline

This isn't just a course. It's a structured path designed to turn you into a specialist ready for the global job market.

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

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

Importing Data into Excel
Shaping and Transforming Data
Loading Data
Import data into excel.
Shape and transform data.
Load data.

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
Transforming Excel report Data
Import data from Excel reports.
Transform Excel report data.

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.

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.

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.

Target Audience

Designed to meet the needs of learners at different career stages, empowering them to build user-centered digital experiences

Freelancers: want to monitor business metrics and build dashboards and Understanding data

Data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.

Students & fresh Graduates: looking to enhance their CVs with industry-relevant and sought-after data skills

Business Professionals & Managers: Those who require analysing performance and making data-based decisions quickly and efficiently.

Learning outcomes

What you'll learn

Explore and extend a classic Excel dashboard and Excel data model

Create measures using advanced DAX functions

Create a Power BI dashboard with Excel

Using Pivot Tables and charts for dynamic data analysis.

Using Power Query that allows to load, clean and transform data

Data Importing and Transformation – Load, clean, filter and prepare data for further analysis through Power Query

Acquiring DAX Skills – Using DAX to create custom measures, aggregations and calculated columns

Data Reports Collaboration and Sharing – Publication of reports on Power BI Service and collaboration with team members and executives

About this course

Data Analysis with Excel and Power BI course is designed to equip you with the practical skills used by professionals to organize, analyse, and visualize data with confidence

Unlock the power of data with two of the most in-demand tools in the business world—Excel and Power BI.

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.

Data Analysis with Excel and Power BI FAQs

What will I learn in the Data Analysis with Excel and Power BI course?

You will use Pivot Tables and charts, load, clean and transform data with Power Query, build an Excel data model and dashboards, create measures and calculated columns with DAX, and build and publish Power BI dashboards and reports on Power BI Service.

How long is the Excel and Power BI course and how is it delivered?

The course runs for 48 hours at a beginner to intermediate level, through virtual learning or in a public classroom.

What do I need before joining?

Basic computer literacy and familiarity with Microsoft Excel.

Who is this course for?

It suits freelancers who build dashboards, data and business intelligence professionals who want to analyse data in Power BI, students and fresh graduates building data skills, and managers who need to analyse performance and make data-based decisions.

Will I get a certificate after the course?

Yes. Learners receive an Attendance Certificate from CLS Learning Solutions.

Accredited Credentials

Attendance Certificate from CLS Learning Solutions

Potential Career Paths

Data Analyst

Business Analyst

BI Developer

Financial Data Analyst

Operations Analyst

Freelance Data Analyst

Frequently Asked Questions

Find answers to common questions about the course, schedules, and learning process.

Data Analysis with Excel and Power BI is a practical training course at CLS designed to build job-relevant skills in data analysis. It combines expert-led instruction, guided practice and applied learning so participants can understand the core concepts, use the relevant tools and prepare for real professional tasks. The detailed syllabus, duration, delivery options, learning outcomes and prerequisites are listed on this course page.