Ultimate Job Ready AI- Powered Data Analytics Course

About Course

This is a to-the-point, ShamsulX style Data Science course! This all-in-one Job-Ready Data Science Course is designed for beginners and intermediate learners who want to master data science skills and become industry-ready with hands-on experience.

Understand the Complete Data Analytics Workflow from Data Collection to insight Generation
Analyze and Clean real-world datasets using Python, Pandas, and Numpy
Query , Manage and Transform databases with SQL like a professional analyst
Leverage AI-powered tools to automate analysis, generate insights,and boost productivity
Work with excel for Advanced reporting, automation and analysis
Build Dashboards and interactive reports using Power BI

Course Content

Introduction to Data Analytics

Introduction to Data Analytics & Course Overview
What is Data Analytics?
What Data Analysts typically Do
The Data Analytics Workflow
Tools used by a Data Analyst
Mini Project : The Profitable Car Showroom

Basic Excel for Data Analytics

Introduction to Excel
Excel – Visual Walkthrough
Workbook and Sheets
Saving and Opening Workbooks
Adding Data with Headers in Excel
Alignment, colors and font in Excel
Understanding Excel Cell Formats
Performing Calculations in Excel
Absolute references in Excel
Order of Operations in Excel
Functions in Excel
Commonly Used Excel Functions
Mini Project- Build an Expense Tracker
Modifying an Excel Workbook
Formatting data in an Excel Worksheet
Conditional Formatting in Excel
Sorting and Filtering Data in Excel
Generating Random Data in Excel
Images and Shapes in Excel
Images and Shapes in Excel
Charts in Excel
Print preview and Printing in Excel
Creating and Using Templates in Excel
Referencing Data Across Worksheets in Excel

Basic Python(AI powered)

Introduction to AI powered Python
Installing Python & VS Code
Installing Python Packages using pip
Built-in vs External Packages in Python
Variables and Data Types in Python
Comments and Type Conversion in Python
Taking User Input in Python
Operators in Python
Strings and String Methods in Python
f-Strings in Python
List and List Methods in Python
Tuple and Tuple Methods in Python
Sets in Python
Dictionaries in Python
Conditional Statements in Python
Loops in Python
Functions in Python
Local vs Global Variables in Python
File Handling in Python
Error Handling in Python
Mini Project 1: Lets build Snake, Water & Gun
AI Assisted Software Development introduction
ChatGpt Setup and Tips
Installing and Using GitHub Copilot
Mini Project 2: File Organizer in Python
Mini Project 3: Typing Speed Tester
Mini Project 4: Quiz App in Python
Mini Project 5: PDF Merger GUI in Python
Mini Project 6: Water Drinking Reminder with Notifications
Mini Project 7: Build a Password Manager Using Python

SQL for Data Analytics

Introduction to Database and SQL
Relational vs Non Relational Databases
Installing MySQL
Writing Our First SQL Query
MySQL Starter Script
DataTypes & Creating a Table in MySql
Inserting Rows in a Table
Selecting Data from the Orders Table
Updating & Deleting Data in a Table
Altering and Droping in a Table
Transactions in MYSQL
Constraints in MYSQL
Primary Key & AUTO_INCREMENT in MYSQL
Order By and LIMIT in MySQL
Functions in MySQL
Logical Operators in MySQL
Foreign Keys in MySQL
ON DELETE in MySQL
JOINs in SQL
Indexes in MySQL
Views in SQL
Subqueries in SQL
GROUP BY in SQL
UNION in SQL
ROLLUP in SQL
Stored Procedures in MySQL
Triggers in MySQL
MySQL Workbench GUI Tutorial
Using AI to Generate SQL queries
Capstone Project- Database Design for an E-commerce Store

Advanced Python

Iterables & How Python Loops Over Data
List Comprehensions in Python
Generators in Python
Mutability, Copies & Common Data Bugs in Python
NumPy Basics & why NumPy
Pandas Basics & Why Pandas
Selecting , Filtering & Data Cleaning with Pandas
Reading CSV & Excel Files with Pandas
Writing Data to CSV & Excel with Pandas
Matplotlib for Data Analysis
Saving Plots
Data Visualization with Seaborn
Project : Noida Real Estate Market Analysis

AI Tools for Data Analysts- Make Coders Jealous

Advanced Excel for Data Analytics

Advanced Excecl for Data Analytics
VLOOKUP in Excel
HLOOKUP in Excel
XLOOKUP in Excel
Text to Columns in Excel
Removing Duplicates in Excel
Notes and Comments in Excel
Freezing Panes in Excel
Find and Replace in Excel
Advanced Sorting in Excel
Subtotals in Excel
DSUM() List function in Excel
DSUM with OR crietaria
DSUM with AND crietaria
AVERATE,DCOUNT,DMAX,DMIN functions in Excel
The SUBTOTAL function in Excel
Data Validation and Dropdowns in Excel
Input Message and Error Alert in Excel Data Validation
Creating Dynamic Formulas using Data Validation in Excel
Importing Data from Text Files in Excel
Microsoft Excel Export Files Format
Pivot Tables in Excel
Working with Columns and Filters in Pivot Tables
Working with Dates in Pivot Table
Formatting Pivot Table Data
Modifying Pivot Table Calculations
Developer Mode in Excel
Recording Macros in Excel
Understanding VBA codes in Excel
Creating Button in Excel with VBA
Formatting Shapes and Other Tips in Excel Developer Mode
Form Control in Excel
Power Query in Excel
Power Query Workflow- Connect, Transform,Combine,Load
Applying Power Query & Refreshing Data
Custom Columns in Power Query
Conditional Columns in Power Query
Merging and Appending Queries in Power Query
Editing Power Query Steps
Using AI Inside Excel – Copilot Tutorial
Introduction to PowerPivot + setup within Excel
Creating Data Models in PowerPivot
Using RELATED Function in PowerPivot

Git & GitHub for Data Analysts

Introduction to Git and GitHub
Installing Git and GitHub Desktop
Setting up GitHub Account and First Repository
Understanding Git Workflow
Scenario 1: Working Alone on a project with Git
Pushing and Pulling Changes from GitHub
Accessing and Reverting Commits
Branching and Merging in Git
Creating a pull request on GitHub
Ignoring Files in Git withh .gitigore
Git Best Practices and how to use Git as a Data Analyst

Web Development for Data Analysts(UI, Dashboards && Visualization)

Probability & Statistics for Data Analytics

Introduction to Probability
Types of Experiments in Probability
Probability Practice Set 1
Basic Rules of Probability
Practice Questions on Probability
Conditional Probability
Bayes Theorem
Introduction to Probability Distributions
Uniform Distribution
Binomial Distribution
Normal Distribution
Central Limit Theorem
Introduction to Statistics
Mean, Median and Mode
Variance and Standard Deviation

Data Visualization using Power BI

Introduction to Power BI
Power BI Desktop – Installation and Overview
Connecting to Data Sources in Power BI
Different Types of views in PowerBI
Initial Settings and Customization in Power BI Desktop
Creating Our First Visualization in Power BI
Creating Shapes in Power BI
Stacked Bar Chart and Column Chart in Power BI
Clustered Charts and 100% Clustered Charts in Power BI
Line Charts and Area Charts in Power BI
Creating a Card Visual in Power BI
Viewing Column Quality, Distribution and Profiles in Power BI
Why not to use Pie Charts and Donut Charts in Power BI
Creating Pie Charts and Donut Charts in Power BI
Slicers in Power BI
Filters in Power BI
Tables in Power BI
Matrix visuals in Power BI
Creating Relationships in Power BI
DAX Basics in Power BI
M Language Basics in Power BI
Publishing and Sharing Reports in Power BI
Mini Project: Creating a Power BI Dashboard for ClipKart Sales Data

Tableau for Data Analytics

Introduction to Tableau
Tableau Desktop – Installation and Overview
Connecting Tableau to Data Source
Creating Our First Visualization in Tableau
Filters in Tableau
More Chart Types in Tableau
Creating Symbol Maps and Filled Maps in Tableau
Build a Complete Sales Dashboard using Tableau Public
Publishing the Dashboard to Tableau Public
Conclusion and Wrapping Up the Tableau Section

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Introduction to Data Analytics

Introduction to Data Analytics & Course Overview

What is Data Analytics?

What Data Analysts typically Do

The Data Analytics Workflow

Tools used by a Data Analyst

Mini Project : The Profitable Car Showroom

Basic Excel for Data Analytics

Introduction to Excel

Excel – Visual Walkthrough

Workbook and Sheets

Saving and Opening Workbooks

Adding Data with Headers in Excel

Alignment, colors and font in Excel

Understanding Excel Cell Formats

Performing Calculations in Excel

Absolute references in Excel

Order of Operations in Excel

Functions in Excel

Commonly Used Excel Functions

Mini Project- Build an Expense Tracker

Modifying an Excel Workbook

Formatting data in an Excel Worksheet

Conditional Formatting in Excel

Sorting and Filtering Data in Excel

Generating Random Data in Excel

Images and Shapes in Excel

Images and Shapes in Excel

Charts in Excel

Print preview and Printing in Excel

Creating and Using Templates in Excel

Referencing Data Across Worksheets in Excel

Basic Python(AI powered)

Introduction to AI powered Python

Installing Python & VS Code

Installing Python Packages using pip

Built-in vs External Packages in Python

Variables and Data Types in Python

Comments and Type Conversion in Python

Taking User Input in Python

Operators in Python

Strings and String Methods in Python

f-Strings in Python

List and List Methods in Python

Tuple and Tuple Methods in Python

Sets in Python

Dictionaries in Python

Conditional Statements in Python

Loops in Python

Functions in Python

Local vs Global Variables in Python

File Handling in Python

Error Handling in Python

Mini Project 1: Lets build Snake, Water & Gun

AI Assisted Software Development introduction

ChatGpt Setup and Tips

Installing and Using GitHub Copilot

Mini Project 2: File Organizer in Python

Mini Project 3: Typing Speed Tester

Mini Project 4: Quiz App in Python

Mini Project 5: PDF Merger GUI in Python

Mini Project 6: Water Drinking Reminder with Notifications

Mini Project 7: Build a Password Manager Using Python

SQL for Data Analytics

Introduction to Database and SQL

Relational vs Non Relational Databases

Installing MySQL

Writing Our First SQL Query

MySQL Starter Script

DataTypes & Creating a Table in MySql

Inserting Rows in a Table

Selecting Data from the Orders Table

Updating & Deleting Data in a Table

Altering and Droping in a Table

Transactions in MYSQL

Constraints in MYSQL

Primary Key & AUTO_INCREMENT in MYSQL