DATA ANALYST

Excel:

·      Introduction to Excel & Interface

·      Data Entry, Formatting and Shortcuts

·      Formulas and Functions

·      Conditional Formatting & Data Validation

·      Sorting, Filtering and Advanced Filter

·      Data Cleaning in Excel (TRIM, CLEAN, Remove Duplicates)

·      Pivot Table

·      Revision

SQL:

Introduction to SQL Databases

·      Definition and Purpose

Introduction to SQL Server

·      Introduction to Databases

·      DBMS

·      RDBMS

·      Different types of RDBMS

Commands and Data Types

·      SQL Commands

·      Data Types

SQL Queries

·      SELECT Statement

·      WHERE

·      Distinct

·      Logical Operators

·      Comparison Operators

·      Order by

·      Top/Limit

Filtering Data

·      IN and Not IN

·      Between

·      Like and Wild Cards

·      Null Concepts

Aggregate Functions

·      Count

·      Sum

·      Avg

·      Min

·      Max

·      Group By

·      Having

Database Joins

·      Inner

·      Left

·      Right

·      Full Outer

·      Self, Cross

Windows Function

·      Row number

·      Rank, Dense Rank

·      Lead, Lag

SQL Functions

·      String Functions

·      Date Functions

·      Numeric Functions

Data Definition Language

·      Create

·      Drop

·      Alter

·      Rename

·      Truncate

·      Modify

·      Comment

Data Manipulation Language

·      Insert

·      Update

·      Delete

Data Transaction Language

·      Commit

·      Rollback

·      Savepoint

SQL Advanced Topics

·      Case Statement

·      Views

·      Stored Procedures

·      Indexes

·      Unions

·      Transactions/ Functions

·      Sub Queries

·      Exception handling

Case Studies and Projects

Python:

 Introduction to Python & Setup

·      Installing Python / Anaconda

·      Jupyter Notebook basics

·      Virtual environments

·      Git & GitHub basics

Python Fundamentals

·      Variables and data types

·      Operators

·      Conditional statements (if, else, elseif)

·      Loops (for, while)

·      Functions and scope

·      Data structures: List, Tuple, Set, Dictionary

·      List comprehensions

·      Exception handling

Working with Files & Modules

·      Reading and writing files (CSV, JSON, TXT)

·      Importing modules & packages

·      Creating custom modules

·      Logging and docstrings

NumPy for Numerical Computing

·      Creating ndarrays

·      Indexing & slicing

·      Broadcasting

·      Vectorized operations

·      Mathematical & statistical functions

·      Random module and sampling

·      Linear algebra basics

Pandas for Data Manipulation

·      Series and Data Frame creation

·      Reading/writing data (CSV, Excel, SQL)

·      Selection and filtering

·      GroupBy and aggregation

·      Merging and joining datasets

·      Pivot tables and reshaping data

Data Cleaning & Feature Engineering

·      Handling missing values

·      Detecting and treating outliers

·      Data type conversions

·      Encoding categorical variables

·      Feature scaling

·      Creating new features

Data Visualization

·      Matplotlib basics (line, bar, scatter, histogram)

·      Seaborn for statistical plots

·      Customizing plots (labels, titles, legends, colors)

·      Correlation heatmaps

·      Interactive plots with Plotly (optional)

Statistics in Python

·      Descriptive statistics

·      Probability distributions

·      Sampling & Central Limit Theorem

·      Hypothesis testing (t-test, chi-square)

·      Correlation vs causation

Tableau

Introduction to Tableau

·      Overview of Tableau and its components (Tableau Desktop, Tableau Server, Tableau Online, Tableau Public)

·      Installing Tableau and understanding the interface

·      Connecting to different data sources (Excel, CSV, Databases, Cloud)

·      Live vs Extract connections

·      Basic navigation and workspace layout

Data Connection and Preparation

·      Connecting to files, databases, and web connectors

·      Data Interpreter and data cleaning options

·      Renaming, splitting, and pivoting fields

·      Managing metadata (data types, field names, default properties)

·      Data blending vs data joins

Basic Visualizations

·      Creating bar charts, line charts, pie charts, and maps

·      Using ShowMe panel for quick chart creation

·      Working with filters, sorting, and highlighting

·      Formatting charts (colors, fonts, borders, alignment)

·      Adding titles, captions, and tooltips

Intermediate Visualizations

·      Dual-axis charts and synchronized axes

·      Combined axis charts

·      Scatter plots, bubble charts, and treemaps

·      Heat maps and highlight tables

·      Gantt charts and area charts

Advanced Charts and Analytics

·      Waterfall charts, bullet charts, and funnel charts

·      Pareto charts and control charts

·      Reference lines, bands, and distributions

·      Forecasting and trend lines

·      Clustering and analytics pane features

Calculations in Tableau

·      Types of calculations (Basic, Level of Detail, Table Calculations)

·      String, date, and numeric functions

·      Logical functions (IF, CASE)

·      Aggregate vs non-aggregate calculations

·      Parameter usage with calculations

Mapping in Tableau

·      Building basic maps and filled maps

·      Geographic roles and custom geocoding

·      Custom background images

·      Layers and map styles

·      Path maps for showing movement

Dashboards

·      Creating dashboards and layout options

·      Adding and arranging multiple visualizations

·      Using containers (horizontal, vertical, tiled, floating)

·      Dashboard actions (filter, highlight, URL actions)

·      Device-specific dashboard design

 Storytelling in Tableau

·      Creating stories and story points

·      Linking dashboards in a story

·      Using annotations and descriptive text

·      Best practices for narrative flow

Performance Optimization

·      Extracts vs live connections for performance

·      Filtering strategies for large datasets

·      Reducing load time with context filters and aggregation

·      Performance recording and analysis

Tableau Server & Tableau Online

·      Publishing workbooks and dashboards

·      Permissions and user roles

·      Scheduling extracts and refreshes

·      Version control and collaboration

·      Project structure and best practices

Tableau Best Practices & Real-World Scenarios

·      Dashboard design principles

·      Color theory and accessibility in Tableau

·      Handling large datasets efficiently

·      Creating interactive, user-friendly visualizations

·      Real-time case studies and projects