DATA ANALYTICS & DATA SCIENCE || aictpvtltd

Course Details

Data Science
0.0 Reviews

DATA ANALYTICS & DATA SCIENCE

By Krishna Kumar
26/Feb/2025
0 Students

Course Description

Module 1: Excel for Data Analysis

Data Cleaning & Formatting
Pivot Tables & Charts
Advanced Formulas & Functions
Automation with Macros

Module 2: SQL for Data Handling

Database Concepts & Normalization
SQL Queries (Joins, Subqueries, Aggregations)
Stored Procedures & Views
Performance Optimization

Module 3: Power BI & Tableau (Data Visualization)

Data Import & Transformation
Interactive Dashboards
DAX & Calculations (Power BI)
Storytelling with Data

Module 4: Python for Data Science

Data Handling with Pandas & NumPy
Data Visualization (Matplotlib & Seaborn)
Web Scraping & APIs
Exploratory Data Analysis (EDA)

Module 5: Machine Learning

Supervised & Unsupervised Learning
Feature Engineering & Model Tuning
Regression & Classification Models
Model Deployment

Module 6: Deep Learning

Neural Networks & TensorFlow Basics
Convolutional & Recurrent Neural Networks
Natural Language Processing (NLP)
AI Model Optimization

Module 7: Cloud Computing for Data Science

AWS/GCP/Azure Overview
Cloud-based Data Pipelines
Big Data Tools (Hadoop, Spark)
Scalable AI & Model Deployment

Course Curriculum

Krishna Kumar

Founder, AICT PVT LTD, IoT & Embedded System Academic Trainer, Data Scientist

I am a web developer with a vast array of knowledge in many different front end and back end languages, responsive frameworks, databases, and best code practices

Reviews

0.0

0 Ratings

This Course Fee:

₹28000 ₹35000

Course includes:

Level
Duration 240h
Lessons 0
Quizzes 0
Certifications Yes
Language

Add To Cart

Course Details

DATA ANALYTICS & DATA SCIENCE

Course Description

Course Curriculum

1. Introduction to Python

2. Basic Python Syntax

3. Control Flow & Loops

4. Functions & Modules

5. Data Structures in Python

6. File Handling

7. Object-Oriented Programming (OOPs)

8. Exception Handling

9. Python Libraries for Data Handling

10. Database Connectivity with Python

11. Web Scraping with Python

12. GUI Development in Python

13. Final Project

14. Introduction to Excel

15. Basic Excel Functions & Formulas

16. Data Formatting & Customization

17. Working with Tables & Data Management

18. Advanced Excel Functions

19. Pivot Tables & Pivot Charts

20. Data Visualization with Charts & Graphs

21. Advanced Data Analysis & Power Query

22. Macros & Automation with VBA

23. Working with Large Datasets

24. Collaboration & Security in Excel

25. Final Project

26. Introduction to Databases & SQL

27. SQL Basics & Data Retrieval

28. SQL Functions & Data Aggregation

29. Data Manipulation in SQL (DML)

30. SQL Joins & Relationships

31. Advanced SQL Queries & Subqueries

32. Data Definition Language (DDL) – Managing Database Structure

33. Constraints & Data Integrity

34. Views & Stored Procedures

35. Transactions & Concurrency Control

36. SQL Performance Optimization

37. SQL for Big Data & Cloud Databases

38. Final Project

39. Statistics for Machine Learning

40. Data Collection & Preprocessing

41. Descriptive Statistics

42. Probability & Distributions

43. Hypothesis Testing & Inferential Statistics

44. Correlation & Regression Analysis

45. Introduction to Machine Learning

46. Supervised Learning - Regression Models

47. Supervised Learning - Classification Models

48. Unsupervised Learning

49. Feature Engineering & Model Optimization

50. Ensemble Learning & Advanced ML Models

51. Deep Learning & Neural Networks

52. Machine Learning Deployment & Cloud Integration

53. Final Project

54. Introduction to Power BI

55. Data Loading & Transformation (Power Query)

56. Data Modeling & Relationships

57. Introduction to DAX (Data Analysis Expressions)

58. Advanced DAX Functions

59. Data Visualization in Power BI

60. Creating Interactive Dashboards

61. Power BI Service & Cloud Integration

62. Power Automate & Power Apps Integration

63. Power BI Security & Governance

64. Power BI Performance Optimization

65. Advanced Power BI Features

66. Final Project & Certification

67. Interview Preparation

68. Client Based Project with Internship

69. LOR- Letter of Recommendation

70. Placement

Krishna Kumar

Reviews

₹28000 ₹35000

Course includes:

Share this course: