Skip to content

Menu

Home
Training Plan
Services
Free Resources
Blog
Contact Us
Register
Login
Cart

Home
Courses

Data Analytics Program

Curriculum

12 Sections
69 Lessons
10 Weeks

Expand all sectionsCollapse all sections

Introduction to Data Analytics
By the end of this module, learners should understand: ✔ What data analytics is ✔ Various types of analytics ✔ The end-to-end data lifecycle ✔ Different roles in a data organization
4
MODULE 2 – Excel Foundations for Data Analytics
Learners can now: ✔ Navigate Excel confidently ✔ Apply essential formulas for calculations ✔ Clean and prepare raw datasets effectively
3
MODULE 3 – Advanced Excel & Dashboards
By the end of Module 3, learners can: ✔ Build PivotTables and PivotCharts ✔ Use slicers to enhance interactivity ✔ Design a complete dashboard in Excel ✔ Apply advanced functions like VLOOKUP and INDEX/MATCH
4
MODULE 4 – SQL Foundations
Learners understand SQL basics, how databases work, and can run fundamental queries using SELECT, WHERE, ORDER BY, DISTINCT, and LIMIT.
3
MODULE 5 – Intermediate SQL
Learners can now combine tables, summarize data, and perform advanced filtering using JOINs, GROUP BY, and HAVING.
12
MODULE 6 – Data Cleaning & Preprocessing
Learners can identify data issues, clean inconsistent datasets, and apply preprocessing techniques.
14
MODULE 7 – Python Foundations for Analytics
Learners understand Python basics and can load datasets using simple scripts.
14
MODULE 8 – Data Analysis with Pandas
Learners can manipulate DataFrames, merge datasets, and perform exploratory analysis.
3
MODULE 9 – Data Visualization
Learners can create meaningful visuals and communicate findings effectively.
3
MODULE 10 – Power BI Foundations
Learners can import, clean, and visualize data in Power BI.
3
MODULE 11 – DAX & Advanced Power BI
Learners can build advanced dashboards and write DAX measures to compute business KPIs.
3
MODULE 12 – Capstone Project
Learners demonstrate their end-to-end analytics capabilities through a practical, real-world project.
3

Lesson 3.3 Building Dashboards in Excel

A dashboard brings together multiple visuals and KPIs to offer a consolidated business view.

Dashboard Elements

KPI Cards (Total Sales, Revenue Growth, Total Orders)
Trend Charts for month-wise performance
Bar/Column Charts for category or region breakdown
Slicers for easy navigation

Dashboard Design Principles

Maintain consistent color themes
Use clean fonts and minimal text
Ensure charts are not cluttered
Align all elements neatly

Use spacing and grouping for better readability

Leave a Reply Cancel reply

Comment

Enter your name or username to comment

Enter your email address to comment

Enter your website URL (optional)

Save my name, email, and website in this browser for the next time I comment.

Lesson 26

Lesson 3.4 Advanced Excel Functions for Analysis

Menu

Home
Services
Training Plan
Free Resources
Contact Us
Privacy Policy
Terms of Use
Register
Login

Facebook Instagram Linkedin

Search this website Type then hit enter to search

×

Cart

Unlock The PDF

Please Fill This Fourm to Download the PDF

Take a load off and enjoy 20% off all Courses storewide. Enter your email below to receive your promo code. Offer valid for a limited time.

NameName

EmailEnter your email address

Phone NumberPhone Number

AddressAddress

I've read and accept the terms & conditions

Unlock The PDF

Please Fill This Fourm to Download the PDF

Take a load off and enjoy 20% off all Courses storewide. Enter your email below to receive your promo code. Offer valid for a limited time.

NameName

EmailEnter your email address

Phone NumberPhone Number

AddressAddress

I've read and accept the terms & conditions

Unlock The PDF

Please Fill This Fourm to Download the PDF

Take a load off and enjoy 20% off all Courses storewide. Enter your email below to receive your promo code. Offer valid for a limited time.

NameName

EmailEnter your email address

Phone NumberPhone Number

AddressAddress

I've read and accept the terms & conditions

Unlock The PDF

Please Fill This Fourm to Download the PDF

Take a load off and enjoy 20% off all Courses storewide. Enter your email below to receive your promo code. Offer valid for a limited time.

NameName

EmailEnter your email address

Phone NumberPhone Number

AddressAddress

I've read and accept the terms & conditions

Unlock The PDF

Please Fill This Fourm to Download the PDF

Take a load off and enjoy 20% off all Courses storewide. Enter your email below to receive your promo code. Offer valid for a limited time.

NameName

EmailEnter your email address

Phone NumberPhone Number

AddressAddress

I've read and accept the terms & conditions

Unlock The PDF

Please Fill This Fourm to Download the PDF

Take a load off and enjoy 20% off all Courses storewide. Enter your email below to receive your promo code. Offer valid for a limited time.

EmailEnter your email address

NameName

Phone NumberPhone Number

AddressAddress

I've read and accept the terms & conditions

Unlock The PDF

Please Fill This Fourm to Download the PDF

Take a load off and enjoy 20% off all Courses storewide. Enter your email below to receive your promo code. Offer valid for a limited time.

NameName

EmailEnter your email address

Phone NumberPhone Number

AddressAddress

Modal title

Main Content