Data Analysis course by Karishma Nikhil Kochar

Introduction to Data Analysis

• What is Data Analysis?

• Data Analyst vs Data Scientist vs BI Analyst

• Data Analysis Lifecycle

• Types of Data

• Real-world Use Cases

• Statistics & Math for Data Analysis

  • Descriptive Statistics

    • Mean, Median, Mode

    • Variance & Standard Deviation

  • Probability Basics

  • Data Distributions

  • Correlation & Covariance

  • Sampling Techniques

  • Hypothesis Testing (t-test, chi-square – basics)

  • Excel for Data Analysis

    • Excel Interface & Shortcuts

    • Data Cleaning

    • Formulas & Functions

      • VLOOKUP / XLOOKUP

      • IF, COUNT, SUM, AVERAGE

    • Pivot Tables & Charts

    • Conditional Formatting

    • Data Validation

    • Dashboard Creation

    • SQL for Data Analysis

      • SQL Basics

      • SELECT, WHERE, ORDER BY

      • Aggregate Functions

      • GROUP BY & HAVING

      • Joins (INNER, LEFT, RIGHT)

      • Subqueries

      • Window Functions

      • SQL Optimization Basics

      • Python for Data Analysis

        • Python Basics

        • NumPy (Arrays & Operations)

        • Pandas (DataFrames, Series)

        • Data Cleaning & Transformation

        • Data Aggregation

        • Data Visualization

        • Visualization Libraries

          • Matplotlib

          • Seaborn

          ---

          🧹 6. Data Cleaning & Preprocessing

          • Handling Missing Values

          • Outlier Detection

          • Data Formatting

          • Feature Engineering

          • Data Quality Checks

          • Exploratory Data Analysis (EDA)

            • Univariate Analysis

            • Bivariate & Multivariate Analysis

            • Identifying Patterns & Trends

            • Correlation Analysis

            • Business Insights Generation

            • Data Visualization & BI Tools

              • Data Visualization Principles

              • Chart Selection

              • Power BI / Tableau

                • Data Import

                • Data Modeling

                • DAX Basics

                • Interactive Dashboards

                • Business & Domain Knowledge

                  • KPI & Metrics

                  • Business Problem Solving

                  • Storytelling with Data

                  • Stakeholder Communication

                  • Writing Data Reports

                  • Real-World Projects