Data Analytics Training Program – Self-Paced Recorded Sessions
Section 1: Orientation & Data Foundations
Lesson 1.1: Strategic Blueprint for Business Insights
Section 2: Microsoft Excel for Data Analytics
What You’ll Learn ?
Lesson 2.1: Introduction to Excel
Lesson 2.2: Data Import & Cleaning
Lesson 2.3: Exploratory Data Analysis (EDA) in Excel
Lesson 2.4: Advanced Excel Features for Data Analysis
Section 3: SQL - Structured Query Language , Databases & Datawarehouse
Lesson 3.1: Introduction to SQL and Database Concepts
Lesson 3.2: Writing Basic SQL Queries
Lesson 3.3: Data Aggregation and Filtering
Lesson 3.4: Working with Joins and Subqueries
Lesson 3.5: SQL Project – Practical Analytical Application
Section 4: Python For Data Analytics
Lesson 4.1: Introduction to Python for Data Analytics
Lesson 4.2: Data Manipulation with Pandas
Lesson 4.3: Data Cleaning and Transformation in Python
Lesson 4.4: Python Project for Data Analytics
Section 5: Data Analytics & Visualization with Power BI
Lesson 5.1: Introduction to Data Visualization and Power BI
Lesson 5.2: Connecting and Preparing Data in Power BI
Lesson 5.3: Creating Basic Visuals in Power BI
Lesson 5.4: Advanced Visualizations and Customization
Lesson 5.5: Building Interactive Dashboards in Power BI
1 of 2
Previous Lesson
Next Lesson
What You’ll Learn ?
Data Analytics Training Program – Self-Paced Recorded Sessions
What You’ll Learn ?
Build a strong foundation in Excel, including basic formulas, functions, and data entry techniques
Import and clean data from various sources like text files, CSVs, and databases
Conduct exploratory data analysis (EDA) using descriptive statistics, data visualization, and PivotTables
Apply advanced Excel functions such as INDEX-MATCH, array formulas, and data validation
Use Excel’s what-if analysis tools, like Scenario Manager and Goal Seek, for data-driven decision making
Visualize data with charts, conditional formatting, and Pivot Charts
Work through real-world case studies and hands-on exercises in data analysis
Progress from beginner to advanced concepts in Excel for data analytics
This Course Includes:
Recorded videos
Hands-on exercises
Articles
Previous Lesson
Back to Course
Next Lesson
Trustpilot
Scroll to Top
WhatsApp us
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?
Register
Don't have an account? Register one!
Register an Account