Data Analysis course by Karishma Nikhil Kochar

DurationDuration:3 months

Batch TypeBatch Type:Weekend and Weekdays

LanguagesLanguages:English, Hindi, Marathi

Class TypeClass Type:Online

Class Type Course Fee:

₹45,000.00Full Course

Course Content

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

Skills

Eda, Data Analysis, Data Visualization, Data Cleaning

Tutor

Karishma Nikhil kochar Profile Pic
Karishma Nikhil kochar

Karishma Nikhil Kochhar is an experienced Full Stack Java, Data Science, Python, and AWS trainer with 8 years of teaching and industry-focused training experience....

0.0 Average Ratings

0 Reviews

3 Years Experience

Wakad

Students Rating

0.0

Course Rating

Blogs

Explore All
arrow
arrow