Skip to content
For Learners Subjects ComputerLanguageBusinessProfessional
DEGLECY
Subjects Nursery Primary UCE UACE University
Deglecy Professional · Data & Analytics

Professional Data Analytics with Excel, SQL & Power BI

Learn to collect, clean, analyze, visualize, and interpret business data using Excel, SQL, and Power BI. Hands‑on exercises with realistic financial, sales, and HR datasets prepare you for real‑world analytics tasks and…

Enroll for free
30lessons
Beginnerlevel
12 hoursto complete
0already enrolled

About Professional Data Analytics with Excel, SQL & Power BI

Learn to collect, clean, analyze, visualize, and interpret business data using Excel, SQL, and Power BI. Hands‑on exercises with realistic financial, sales, and HR datasets prepare you for real‑world analytics tasks and entry‑level BI roles.

What you’ll learn

  • Foundations of Data Analytics
  • Excel for Data Preparation
  • Excel Analysis & Visualization
  • SQL Fundamentals for Analytics
  • Power BI Essentials
  • Capstone Project: End‑to‑End Business Insight

What’s included

Free · included in Deglecy PlusEnroll free. The first 3 lessons are open; Deglecy Plus unlocks the rest.
Final examFinish all lessons, then take the exam.
CertificatePass the exam to earn your certificate.

Professional Data Analytics with Excel, SQL & Power BI course content

Module 1: Foundations of Data Analytics5 lessons
What is Data Analytics?12 min
Business Data Types & Sources14 min
Navigating the Excel Interface10 min
Basic Statistics for BusinessPlus · 15 min
Data Analytics Project WorkflowPlus · 13 min
Module 2: Excel for Data Preparation5 lessons
Importing CSV & Excel FilesPlus · 14 min
Cleaning Data with FunctionsPlus · 16 min
Text Functions for StandardisationPlus · 13 min
Removing Duplicates & ErrorsPlus · 12 min
Creating Structured Data TablesPlus · 15 min
Module 3: Excel Analysis & Visualization5 lessons
Core Formulas & Logical FunctionsPlus · 15 min
Pivot Tables BasicsPlus · 16 min
Pivot Charts for Quick VisualsPlus · 14 min
Conditional Formatting RulesPlus · 13 min
Building an Interactive DashboardPlus · 18 min
Module 4: SQL Fundamentals for Analytics5 lessons
Relational Database ConceptsPlus · 13 min
Setting Up a Local SQL EnvironmentPlus · 15 min
SELECT, WHERE & ORDER BYPlus · 14 min
JOINs and AggregationsPlus · 16 min
Saving Queries for ReusePlus · 12 min
Module 5: Power BI Essentials5 lessons
Power BI Desktop OverviewPlus · 13 min
Connecting to Excel & SQL Data SourcesPlus · 15 min
Data Modeling & Intro to DAXPlus · 16 min
Designing Visuals & FiltersPlus · 14 min
Publishing & Sharing ReportsPlus · 12 min
Module 6: Capstone Project: End‑to‑End Business Insight5 lessons
Project Brief & Dataset OverviewPlus · 12 min
Data Cleaning in ExcelPlus · 15 min
SQL Data Extraction for AnalysisPlus · 14 min
Building a Power BI DashboardPlus · 18 min
Presenting Findings & RecommendationsPlus · 16 min

Frequently asked questions

What will I learn in Professional Data Analytics with Excel, SQL & Power BI?

The course has 6 modules: Foundations of Data Analytics; Excel for Data Preparation; Excel Analysis & Visualization; SQL Fundamentals for Analytics; Power BI Essentials; Capstone Project: End‑to‑End Business Insight.

How long does Professional Data Analytics with Excel, SQL & Power BI take?

It has 30 lessons and takes about 12 hours to complete. You learn at your own pace and can continue where you stopped.

Do I get a certificate?

Yes. Finish all the lessons, pass the final exam, and you can view and share your Deglecy certificate.

How much does Professional Data Analytics with Excel, SQL & Power BI cost?

Enrolling is free and the first 3 lessons are open. Deglecy Plus unlocks the remaining lessons.

Who is this course for?

It is pitched at Beginner level in Data & Analytics. Check the module list above to see if the topics match what you want to learn.