Data Analytics

Course Overview

Advanced Excel
Introduction to MS Excel
Uses and Importance of Excel
Exploring Excel Interface
Basic Excel Operations
Formatting
Format Painter
Number & Symbols
Inserting in Excel
Transforming Data
Working with Formulas
Functions in Excel
Logical Functions
Math Functions
Lookup Functions
Formula Auditing
Data Sorting and Filtering
Slicer & Timeline
Flash Fill
Consolidation
Data Validation
Conditional Formatting
Chart and Graphs
Pivot Table
Pivot Charts
Table and Table Styles
Link
Page Setup & Arrangement in Excel
Macro
Protection of Worsksheet

PowerBI
Introduction to Power BI
Role of Power BI in Data Analytics
Power BI Desktop vs Power BI Service
Installing and Setting up Power BI Desktop
Exploring Power BI Interface
Understanding Reports, Dashboards, and Datasets
Connecting to Data Sources
Import vs DirectQuery Mode
Previewing and Loading Data
Launching Power Query Editor
Cleaning and Transforming Data
Removing Duplicates and Unnecessary Columns
Replacing Values and Filling Blanks
Splitting and Merging Columns
Unpivoting and Pivoting Columns
Merging Queries
Appending Queries
Changing Data Types
Creating Data Models
Creating Relationships Between Tables
Understanding Cardinality and Cross Filtering
Creating and Marking a Date Table
Introduction to DAX
Creating Calculated Columns and Measures
Using Variables in DAX
Basic DAX Functions
Logical Functions in DAX
Math and Statistical Functions in DAX
Lookup Functions in DAX
Time Intelligence Functions in DAX
Creating Visualizations in Power BI
Using Bar, Column, Line, and Pie Charts
Working with Table and Matrix Visuals
Using Cards, KPIs, and Gauges
Creating Map and Geographical Visuals
Using Funnel, Waterfall, and Treemaps
Formatting and Customizing Visuals
Using Tooltips and Labels
Using Filters (Visual, Page, Report Level)
Working with Slicers
Creating Drill Down and Drill Up Reports
Using Bookmarks and Buttons
Designing Report Navigation
Creating Interactive Dashboards
Publishing Reports to Power BI Service
Creating Dashboards in Power BI Web
Pinning Visuals to Dashboard
Sharing Reports and Dashboards
Setting up Scheduled Data Refresh
Using Power BI Gateway
Creating Roles and Row-Level Security (RLS)
Testing and Managing RLS in Service
Using Q&A Visual for Natural Language Queries
Using Smart Narratives
Using Key Influencer Visual
Using Decomposition Tree Visual
Using Performance Analyzer
Best Practices for Data Model Optimization
Exporting Reports to PDF or PowerPoint
Following Dashboard Design Guidelines
Final Report Review and Publishing

Tableau
Introduction to Tableau
Installing Tableau Desktop or Public
Understanding Tableau Interface
Connecting to Excel, CSV, and Databases
Live vs Extract Connections
Understanding Dimensions and Measures
Data Types and Field Properties
Preparing and Cleaning Data in Tableau
Sorting, Filtering, and Grouping Data
Creating Calculated Fields
Using Parameters
Using Sets and Groups
Creating Hierarchies
Working with Aggregations and Granularity
Creating Bar, Line, Pie, Map, and Scatter Charts
Using Dual Axis and Combo Charts
Using Tree Maps and Bubble Charts
Customizing Visual Elements
Working with Date and Time Fields
Creating Time Series and Trends
Using Table Calculations
Working with Percent of Total and Running Total
Introduction to LOD Expressions
Building Interactive Dashboards
Adding Actions to Dashboards
Using Filters and Parameters in Dashboards
Creating Data Stories with Story Points
Publishing Dashboards to Tableau Public or Server
Exporting Reports and Dashboards
Real-World Projects and Case Studies
Best Practices in Data Visualization and Dashboard Design

SQL
Understanding Database
Types Of Databases
RDBMS vs NoSQL
Introduction to Relational Databases
What is SQL ?
SQL Syntax Basics
Setting up SQL Environment
Creating a Database
Viewing Existing Database
Dropping a Database
Using a Database
Creating Table
Viewing and Modifying Table
What is a Datatype ?
Types pf Datatypes in SQL
Inserting and Retrieving Data
Working and Updating Data
Functions in SQL
JOINS in SQL
Grouping and Filtering Data
Subqueries
Set Operations
Constraints in SQL
Procedures in SQL

Advanced Python
Introduction to python
Exploring Anaconda and other IDEs
Identifiers
Comments
What are Keywords ?
Datatype and its types
Strings and its Operations
Lists and its Operations
Tuples and its Operations
Sets and its Operations
Dictionaries and its Operations
Operators
Types of Operators
Dealing with Binary Numbers
Decision Control Statement
Nested If
Loop Statement
Nested Loop
Jump Control Statement
Introduction to Functions
Types of Functions
Arguments and its types
Ways to define a Function
Built-In Functions
Recursion
Lambda function
Introduction to Modules
Types of Modules
Creating and Importing of a module
Introduction to Exception Handling
Error vs Exception
Raising an exception
Handling an exception
Components of Exception Handling
Types of Exception
Nested Try
What is a File ?
Types of Files
Introduction to File Handling
Steps of File Handling
Working with File Paths
Modes in File Handling
Methods in File Handling
Introduction to OS module
OS module functions and methods
Introduction to OOPS
Class & Object
Methods
Principles of OOPS
Inheritance
Types of Inheritance
Encapsulation
Polymorphism
Abstraction
Getters
Setters
Deleters
Multithreading
Introduction to Numpy
Understanding Arrays
Dimensions in Arrays
Datatypes in Numpy
Functions and Methods used in Numpy
Introduction to Pandas
Series & Dataframes in Pandas
Reading CSV & JSON using pandas
Cleaning Data using Pandas
Introduction to Tkinter
Creating GUI using Tkinter
Introduction to Matplotlib
Plotting & Marking in Matplotlib
Graphs & Charts in Matplotlib
Multiple Python Based Projects

Statistics
Introduction to Statistics
Importance and Applications of Statistics
types of Statistics
Qualitative vs Quantitative
Data Collection and Sampling
Population and Sample
Sampling Techniques
Data Organization and Representation
Graphical Representation
Mean
Median
Mode
Measures of Dispersion
Variance
Standard Deviation
What is Skewness?
What is Kurtosis?
Correlation and Regression
Probability and its components
Hypothesis Testing
Null and Alternate Hypothesis
Type I and Type II Errors
Z-test
T-test
Chi-Square test
Analysis of Variance (ANOVA)
F-test
Simple Linear Regression

Machine Learning
Introduction to Machine Learning
What is Machine Learning?
Difference between AI, ML, DL, and Data Science
Types of Machine Learning: Supervised, Unsupervised, Reinforcement
Applications of Machine Learning
Setting up ML Environment
Installing Anaconda and Jupyter Notebook
Introduction to Python Libraries for ML
Working with NumPy and Pandas
Data Visualization with Matplotlib and Seaborn
Data Preprocessing
Understanding Dataset Structure
Handling Missing Data
Encoding Categorical Variables
Feature Scaling (Standardization, Normalization)
Feature Engineering Basics
Exploratory Data Analysis (EDA)
Descriptive Statistics
Visualizing Data Distributions
Correlation Matrix and Heatmaps
Outlier Detection
Insights from Data Patterns
Supervised Learning
Introduction to Supervised Learning
Splitting Dataset: Train-Test Split, Cross Validation
Regression Algorithms:
Linear Regression
Multiple Linear Regression
Polynomial Regression
Classification Algorithms:
Logistic Regression
K-Nearest Neighbors (KNN)
Support Vector Machines (SVM)
Decision Trees
Random Forest
Naive Bayes
Model Evaluation Techniques
Confusion Matrix
Accuracy, Precision, Recall, F1 Score
ROC-AUC Curve
Mean Squared Error (MSE), RMSE, MAE
K-Fold Cross Validation
Unsupervised Learning
Introduction to Unsupervised Learning
Clustering Algorithms:
K-Means Clustering
Hierarchical Clustering
DBSCAN
Dimensionality Reduction:
PCA (Principal Component Analysis)
Feature Selection and Engineering
Feature Importance
Removing Multicollinearity
Recursive Feature Elimination
Using Domain Knowledge for Features
Model Deployment Basics
Saving Models using Pickle or Joblib
Creating a Simple Web App with Streamlit or Flask
Introduction to Model Deployment on Cloud (basic overview)
Advanced Topics (Optional for Analysts)
Ensemble Learning: Bagging, Boosting (AdaBoost, XGBoost)
Hyperparameter Tuning: GridSearchCV, RandomizedSearchCV
Introduction to Time Series Forecasting
Basics of Natural Language Processing (NLP)
Ethics and Bias in ML
Real-World Project Workflow
Defining the Problem
Data Collection & Cleaning
EDA & Preprocessing
Model Building & Evaluation
Interpretation & Communication
Report or Dashboard Creation
Deployment (Optional)

Big Data
What is Big Data?
5Vs of Big Data
Big Data Architecture Overview
Batch vs Stream Processing
Introduction to Hadoop
HDFS and its Components
Working with Hadoop Commands
Introduction to YARN
Introduction to Hive
Creating Tables and Writing Hive Queries
Partitioning and Bucketing in Hive
Introduction to Pig
Writing Pig Scripts using Pig Latin
Pig vs Hive Comparison
Introduction to HBase
Creating and Querying Data in HBase
HBase vs RDBMS
Introduction to Sqoop
Importing and Exporting Data using Sqoop
Introduction to Flume
Using Flume for Data Ingestion
Introduction to Apache Spark
Spark vs Hadoop MapReduce
Working with RDDs and DataFrames
Writing SQL in Spark (Spark SQL)
Basics of PySpark
Introduction to Spark Streaming
Big Data on Cloud (AWS, Azure, GCP)
Big Data Use Cases

Cloud
Introduction to Cloud Computing
Benefits and Features of Cloud Computing
Traditional IT vs Cloud Computing
Cloud Service Models – IaaS, PaaS, SaaS
Cloud Deployment Models – Public, Private, Hybrid,
Community
Introduction to Virtualization and Hypervisors
Introduction to AWS, Azure, and Google Cloud Platform
Creating a Cloud Account (AWS Free Tier Example)
Understanding Regions and Availability Zones
Launching a Virtual Machine (EC2 Basics)
Cloud Storage Basics – S3, Azure Blob, GCP Storage
Introduction to VPC and Networking in Cloud
Introduction to IAM – Users, Roles, and Policies
Billing and Cost Management in Cloud
Monitoring and Alerts (CloudWatch Basics)
Deploying a Simple Web App on Cloud
Introduction to Serverless – AWS Lambda Basics
Basics of Cloud Security and Shared Responsibility Model
Real-World Use Cases of Cloud Computing