Home
Courses
About Us
Contact
Register
Login
Back
Home
Courses
About Us
Contact
9 Sections
81 Lessons
16 Weeks
Expand all sections
Collapse all sections
Introduction to Data Analytics
8
1.1
What is Data Analytics
1.2
Types of Data Analytics
1.3
Data Analytics vs Data Science
1.4
Data Analytics Life Cycle
1.5
Data Analyst Roles & Responsibilities
1.6
Tools Used in Data Analytics
1.7
Career Opportunities in Data Analytics
1.8
Data Analytics Project Overview
Excel for Data Analytics (Beginner to Advanced)
19
2.1
Introduction to Excel
2.2
Excel Interface
2.3
Rows, Columns, Cells
2.4
Formatting Data
2.5
Sorting & Filtering
2.6
Basic Formulas
2.7
Logical Functions (IF, AND, OR)
2.8
Text Functions
2.9
Date Functions
2.10
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
2.11
Pivot Tables
2.12
Pivot Charts
2.13
Conditional Formatting
2.14
Data Cleaning Techniques
2.15
Data Validation
2.16
Advanced Formulas
2.17
Dashboard Creation
2.18
Excel Charts
2.19
Data Analysis Project
SQL for Data Analytics
15
3.1
Introduction to SQL
3.2
Database Basics
3.3
SQL Installation
3.4
SQL Tables
3.5
SELECT Statement
3.6
WHERE Clause
3.7
ORDER BY
3.8
GROUP BY
3.9
HAVING Clause
3.10
Joins (Inner Join, Left Join, Right Join)
3.11
Subqueries
3.12
Aggregate Functions
3.13
SQL Case Statements
3.14
Window Functions
3.15
SQL Data Analysis Project
Power BI (Beginner to Advanced)
10
4.1
Introduction to Power BI
4.2
Power BI Installation
4.3
Power BI Interface
4.4
Data Import
4.5
Data Cleaning
4.6
Data Transformation
4.7
Power BI Charts
4.8
Dashboard Creation
4.9
Power BI DAX
4.10
Power BI Dashboard Project
Python for Data Analytics
11
5.1
Python Introduction
5.2
Variables
5.3
Data Types
5.4
Lists
5.5
Dictionaries
5.6
NumPy Introduction
5.7
Pandas Introduction
5.8
Data Cleaning using Python
5.9
Data Analysis using Python
5.10
Data Visualization using Python
5.11
Data Analysis Project using Python
Data Visualization
5
6.1
Data Visualization Introduction
6.2
Types of Charts
6.3
Best Practices
6.4
Dashboard Design
6.5
Data Storytelling
Real World Projects
5
7.1
Sales Dashboard Project
7.2
HR Analytics Project
7.3
Marketing Analytics Project
7.4
Finance Analytics Project
7.5
Business Analytics Project
Interview Preparation
4
8.1
Data Analytics Interview Questions
8.2
Resume Building
8.3
Portfolio Building
8.4
Freelancing Guide
Bonus Module
4
9.1
Google Sheets Analytics
9.2
AI Tools for Data Analytics
9.3
ChatGPT for Data Analysts
9.4
Automation Tools
This content is protected, please
login
and
enroll
in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content
