Data Analyst

9 Courses | 132 Lessons
🔍
📖 C1 Introduction to Data Analytics 5 Modules | 15 Lessons
▶ M1 What is Data Analytics 3
1L1 Data Analytics Defined→ 2L2 Data Analytics in Action→ 3L3 Module 1 Review→
▶ M2 The Data Analyst Ecosystem 3
1L1 Types of Data→ 2L2 Data Analytics Tools aur Languages→ 3L3 Module 2 Review→
▶ M3 Gathering and Wrangling Data 3
1L1 Data Gathering→ 2L2 Data Wrangling Fundamentals→ 3L3 Module 3 Review→
▶ M4 Mining and Visualizing Data 3
1L1 Statistical Analysis aur Data Mining→ 2L2 Data Visualization Principles→ 3L3 Module 4 Review→
▶ M5 Career Opportunities 3
1L1 Data Analytics Career Paths→ 2L2 Building Your Data Analytics Portfolio→ 3L3 Module 5 Review→
📖 C2 Excel Basics for Data Analysis 5 Modules | 15 Lessons
▶ M1 Introduction to Spreadsheets 3
1L1 Spreadsheet Basics→ 2L2 Basic Formulas aur Functions→ 3L3 Module 1 Review→
▶ M2 Data Entry and Formatting 3
1L1 Data Entry aur Import→ 2L2 Formatting aur Conditional Formatting→ 3L3 Module 2 Review→
▶ M3 Data Quality and Cleaning 3
1L1 Data Quality Issues→ 2L2 Cleaning Data in Excel→ 3L3 Module 3 Review→
▶ M4 Analyzing Data with Pivot Tables 3
1L1 Pivot Table Fundamentals→ 2L2 Advanced Pivot Table Features→ 3L3 Module 4 Review→
▶ M5 Final Assignment 3
1L1 Final Assignment Brief→ 2L2 Handson Execution→ 3L3 Peer Review aur Submission→
📖 C3 Data Visualization Dashboards Excel Cognos 5 Modules | 16 Lessons
▶ M1 Visualizing Data Using Spreadsheets 3
1L1 Data Visualization Fundamentals→ 2L2 Creating Basic Charts in Excel→ 3L3 Module 1 Review→
▶ M2 Creating Charts Using Spreadsheets 3
1L1 Advanced Chart Types→ 2L2 Chart Customization aur Best Practices→ 3L3 Module 2 Review→
▶ M3 Creating Dashboards Using Spreadsheets 3
1L1 Dashboard Design Principles→ 2L2 Building Excel Dashboard→ 3L3 Module 3 Review→
▶ M4 Cognos Analytics 4
1L1 Cognos Analytics Introduction→ 2L2 Creating Visualizations in Cognos→ 3L3 Interactive Dashboards aur Stories→ 4L4 Module 4 Review→
▶ M5 Final Assignment 3
1L1 Assignment Requirements→ 2L2 Building Both Dashboards→ 3L3 Peer Review aur Submission→
📖 C4 Python for Data Science AI and Development 5 Modules | 18 Lessons
▶ M1 Python Basics 3
1L1 Python Overview aur Setup→ 2L2 Variables aur Data Types→ 3L3 Module 1 Review→
▶ M2 Python Data Structures 3
1L1 Lists aur Tuples→ 2L2 Dictionaries aur Sets→ 3L3 Module 2 Review→
▶ M3 Python Programming Fundamentals 5
1L1 Conditions aur Branching→ 2L2 Loops→ 3L3 Functions→ 4L4 Classes aur Objects Basics→ 5L5 Module 3 Review→
▶ M4 Working with Data in Python 4
1L1 File Handling→ 2L2 NumPy Fundamentals→ 3L3 pandas for Data Analysis→ 4L4 Module 4 Review→
▶ M5 APIs and Data Collection 3
1L1 REST APIs aur HTTP→ 2L2 Web Scraping with BeautifulSoup→ 3L3 Module 5 Review→
📖 C5 Python Project for Data Science 2 Modules | 5 Lessons
▶ M1 Extracting Stock Data 2
1L1 Stock Data Extraction with yfinance→ 2L2 Module 1 Review→
▶ M2 Web Scraping and Data Analysis 3
1L1 Web Scraping Revenue Data→ 2L2 Data Analysis aur Visualization Dashboard→ 3L3 Module 2 Review→
📖 C6 Databases and SQL for Data Science 6 Modules | 18 Lessons
▶ M1 Getting Started with SQL 3
1L1 Introduction to Databases aur SQL→ 2L2 SELECT WHERE aur Sorting→ 3L3 Module 1 Review→
▶ M2 Relational Databases and Tables 3
1L1 Creating aur Managing Tables→ 2L2 Data Manipulation INSERT UPDATE DELETE→ 3L3 Module 2 Review→
▶ M3 Intermediate SQL 3
1L1 Builtin Functions aur Aggregation→ 2L2 Subqueries aur JOINs→ 3L3 Module 3 Review→
▶ M4 Accessing Databases using Python 3
1L1 Python Database Connectivity→ 2L2 pandas SQL Integration→ 3L3 Module 4 Review→
▶ M5 Working with Real World Datasets 3
1L1 Real Dataset Analysis with SQL→ 2L2 Advanced Query Patterns→ 3L3 Module 5 Review→
▶ M6 Advanced SQL 3
1L1 Stored Procedures aur Functions→ 2L2 Transactions aur ACID→ 3L3 Module 6 Review→
📖 C7 Data Analysis with Python 5 Modules | 15 Lessons
▶ M1 Importing Data Sets 3
1L1 Data Analysis Overview→ 2L2 Importing Data with pandas→ 3L3 Module 1 Review→
▶ M2 Data Wrangling 3
1L1 Handling Missing Values→ 2L2 Data Formatting aur Transformation→ 3L3 Module 2 Review→
▶ M3 Exploratory Data Analysis 3
1L1 Descriptive Statistics→ 2L2 Visual EDA Techniques→ 3L3 Module 3 Review→
▶ M4 Model Development 3
1L1 Linear Regression→ 2L2 Polynomial Regression aur Pipelines→ 3L3 Module 4 Review→
▶ M5 Model Evaluation and Refinement 3
1L1 Model Evaluation Techniques→ 2L2 Model Refinement→ 3L3 Module 5 Review→
📖 C8 Data Visualization with Python 4 Modules | 12 Lessons
▶ M1 Introduction to Data Visualization 3
1L1 Why Data Visualization→ 2L2 matplotlib Fundamentals→ 3L3 Module 1 Review→
▶ M2 Basic and Specialized Visualization Tools 3
1L1 Basic Visualization Tools→ 2L2 Specialized Visualization Tools→ 3L3 Module 2 Review→
▶ M3 Advanced Visualizations and Geospatial Data 3
1L1 Advanced Visualization Techniques→ 2L2 Geospatial Visualization with Folium→ 3L3 Module 3 Review→
▶ M4 Creating Dashboards with Plotly and Dash 3
1L1 Plotly Interactive Visualizations→ 2L2 Dash Dashboard Framework→ 3L3 Module 4 Review→
📖 C9 Data Analyst Capstone Project 6 Modules | 18 Lessons
▶ M1 Data Collection 3
1L1 Project Overview aur Data Sources→ 2L2 Collecting Data via APIs→ 3L3 Collecting Data via Web Scraping→
▶ M2 Data Wrangling 3
1L1 Finding aur Handling Missing Values→ 2L2 Handling Duplicates aur Data Normalization→ 3L3 Module 2 Review→
▶ M3 Exploratory Data Analysis 3
1L1 Distribution Analysis→ 2L2 Relationship aur Trend Analysis→ 3L3 Module 3 Review→
▶ M4 Data Visualization 3
1L1 Static Visualizations→ 2L2 Interactive Visualizations→ 3L3 Module 4 Review→
▶ M5 Building Dashboards 3
1L1 Dashboard Design aur Planning→ 2L2 Building the Dash Dashboard→ 3L3 Module 5 Review→
▶ M6 Final Presentation 3
1L1 Presentation Structure aur Storytelling→ 2L2 Creating the Presentation→ 3L3 Module 6 Review Final Submission→