Data Analyst

9 Courses · 269 Lessons
🔍

C1 Introduction to Data Analytics 25 lessons

M1 What is Data Analytics 5
1Data Analytics Defined▸ 2Data Analytics in Action▸ 3Module 1 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M2 The Data Analyst Ecosystem 5
1Types of Data▸ 2Data Analytics Tools aur Languages▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M3 Gathering and Wrangling Data 5
1Data Gathering▸ 2Data Wrangling Fundamentals▸ 3Module 3 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M4 Mining and Visualizing Data 5
1Statistical Analysis aur Data Mining▸ 2Data Visualization Principles▸ 3Module 4 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M5 Career Opportunities 5
1Data Analytics Career Paths▸ 2Building Your Data Analytics Portfolio▸ 3Module 5 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

C2 Excel Basics for Data Analysis 25 lessons

M1 Introduction to Spreadsheets 5
1Spreadsheet Basics▸ 2Basic Formulas aur Functions▸ 3Module 1 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M2 Data Entry and Formatting 5
1Data Entry aur Import▸ 2Formatting aur Conditional Formatting▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M3 Data Quality and Cleaning 5
1Data Quality Issues▸ 2Cleaning Data in Excel▸ 3Module 3 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M4 Analyzing Data with Pivot Tables 5
1Pivot Table Fundamentals▸ 2Advanced Pivot Table Features▸ 3Module 4 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M5 Final Assignment 5
1Final Assignment Brief▸ 2Handson Execution▸ 3Peer Review aur Submission▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

C3 Data Visualization Dashboards Excel Cognos 26 lessons

M1 Visualizing Data Using Spreadsheets 5
1Data Visualization Fundamentals▸ 2Creating Basic Charts in Excel▸ 3Module 1 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M2 Creating Charts Using Spreadsheets 5
1Advanced Chart Types▸ 2Chart Customization aur Best Practices▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M3 Creating Dashboards Using Spreadsheets 5
1Dashboard Design Principles▸ 2Building Excel Dashboard▸ 3Module 3 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M4 Cognos Analytics 6
1Cognos Analytics Introduction▸ 2Creating Visualizations in Cognos▸ 3Interactive Dashboards aur Stories▸ 4Module 4 Review▸ 5T Final Module Assessment▸ 6T1 Mid Module Quiz▸
M5 Final Assignment 5
1Assignment Requirements▸ 2Building Both Dashboards▸ 3Peer Review aur Submission▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

C4 Python for Data Science AI and Development 28 lessons

M1 Python Basics 5
1Python Overview aur Setup▸ 2Variables aur Data Types▸ 3Module 1 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M2 Python Data Structures 5
1Lists aur Tuples▸ 2Dictionaries aur Sets▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M3 Python Programming Fundamentals 7
1Conditions aur Branching▸ 2Loops▸ 3Functions▸ 4Classes aur Objects Basics▸ 5Module 3 Review▸ 6T Final Module Assessment▸ 7T1 Mid Module Quiz▸
M4 Working with Data in Python 6
1File Handling▸ 2NumPy Fundamentals▸ 3pandas for Data Analysis▸ 4Module 4 Review▸ 5T Final Module Assessment▸ 6T1 Mid Module Quiz▸
M5 APIs and Data Collection 5
1REST APIs aur HTTP▸ 2Web Scraping with BeautifulSoup▸ 3Module 5 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

C5 Python Project for Data Science 8 lessons

M1 Extracting Stock Data 3
1Stock Data Extraction with yfinance▸ 2Module 1 Review▸ 3T Final Module Assessment▸
M2 Web Scraping and Data Analysis 5
1Web Scraping Revenue Data▸ 2Data Analysis aur Visualization Dashboard▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

C6 Databases and SQL for Data Science 30 lessons

M1 Getting Started with SQL 5
1Introduction to Databases aur SQL▸ 2SELECT WHERE aur Sorting▸ 3Module 1 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M2 Relational Databases and Tables 5
1Creating aur Managing Tables▸ 2Data Manipulation INSERT UPDATE DELETE▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M3 Intermediate SQL 5
1Builtin Functions aur Aggregation▸ 2Subqueries aur JOINs▸ 3Module 3 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M4 Accessing Databases using Python 5
1Python Database Connectivity▸ 2pandas SQL Integration▸ 3Module 4 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M5 Working with Real World Datasets 5
1Real Dataset Analysis with SQL▸ 2Advanced Query Patterns▸ 3Module 5 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M6 Advanced SQL 5
1Stored Procedures aur Functions▸ 2Transactions aur ACID▸ 3Module 6 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

C7 Data Analysis with Python 25 lessons

M1 Importing Data Sets 5
1Data Analysis Overview▸ 2Importing Data with pandas▸ 3Module 1 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M2 Data Wrangling 5
1Handling Missing Values▸ 2Data Formatting aur Transformation▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M3 Exploratory Data Analysis 5
1Descriptive Statistics▸ 2Visual EDA Techniques▸ 3Module 3 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M4 Model Development 5
1Linear Regression▸ 2Polynomial Regression aur Pipelines▸ 3Module 4 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M5 Model Evaluation and Refinement 5
1Model Evaluation Techniques▸ 2Model Refinement▸ 3Module 5 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

C8 Data Visualization with Python 20 lessons

M1 Introduction to Data Visualization 5
1Why Data Visualization▸ 2matplotlib Fundamentals▸ 3Module 1 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M2 Basic and Specialized Visualization Tools 5
1Basic Visualization Tools▸ 2Specialized Visualization Tools▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M3 Advanced Visualizations and Geospatial Data 5
1Advanced Visualization Techniques▸ 2Geospatial Visualization with Folium▸ 3Module 3 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M4 Creating Dashboards with Plotly and Dash 5
1Plotly Interactive Visualizations▸ 2Dash Dashboard Framework▸ 3Module 4 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

C9 Data Analyst Capstone Project 30 lessons

M1 Data Collection 5
1Project Overview aur Data Sources▸ 2Collecting Data via APIs▸ 3Collecting Data via Web Scraping▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M2 Data Wrangling 5
1Finding aur Handling Missing Values▸ 2Handling Duplicates aur Data Normalization▸ 3Module 2 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M3 Exploratory Data Analysis 5
1Distribution Analysis▸ 2Relationship aur Trend Analysis▸ 3Module 3 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M4 Data Visualization 5
1Static Visualizations▸ 2Interactive Visualizations▸ 3Module 4 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M5 Building Dashboards 5
1Dashboard Design aur Planning▸ 2Building the Dash Dashboard▸ 3Module 5 Review▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸
M6 Final Presentation 5
1Presentation Structure aur Storytelling▸ 2Creating the Presentation▸ 3Module 6 Review Final Submission▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸