Tutors

Innomatics Research Labs

PROGRAM OVERVIEW

CURRICULUM

  Course Took Kit (Discord and Mentoring Link)

  • Discord Innomatics Server Community Link
  • Zoom Mentoring Sessions Link

  Python Programming

  • Ananconda Installation for Jupyter notebook IDE and Python
  • numerical_datatypes File
  • operators_python. File
  • Python Revision and Intro to List
  • List Operations
  • Sets File
  • List and Tuple File
  • Conditional Statement and Loops File
  • Functions File
  • Function Files
  • Class and Objects File
  • Anaconda Installation Google Colab and Jupyter notebook
  • Basic Programming - Part 1
  • Basic Programming - Part 2
  • Strings - Part 1
  • String - Part 2
  • List and Tuple - Part 1
  • List Tuple and Set - Part 2
  • Dictionary and Conditional Statement -I
  • Conditional Statement - Part 2
  • Conditional Statement and Loops - Part 3
  • Functions - Part 1
  • Functions - Part 2
  • Modules and Problem Solving - Part 1
  • Problem Solving - Part 2
  • File Handling
  • Exceptional Handling and OOPS - Part 1
  • OOPs - Part 2

  Data Analysis Using Python

  • Numpy - 15th Nov
  • Numpy - Part 2 16th Nov
  • Numpy - III 17th Nov
  • Descriptive Stats - Data and Descriptive Stats PDF
  • Pandas Basics, Subsetting , Groupby pivot Files
  • pandas_pivot_merge 29th Nov
  • Regular Expressions
  • Web Scraping - I
  • Visualization and EDA File
  • Descriptive Statistics - I
  • Descriptive Statistics - II and Numpy
  • Numpy - II
  • Pandas - Series and DataFrame and Basic Operations
  • Indexing and Merge concatenation & Joins
  • Basic Cleaning and Filtering
  • Missing Data Handling
  • Grouping_and_Summarising and Lambda_Functions_Pivot_Tables
  • Regular Expression
  • Reg ex - II and Web Scraping
  • Web Scraping - III
  • Web Scraping - II
  • Visualization - Matplotlib
  • Visualization - Seaborn

  Assignments

  • Python - Variables and Datatypes
  • Python - Strings
  • Python - List and Tuples
  • Python - Sets
  • Python - Dictionary
  • Python - Conditional Statements and Loops
  • Python - Functions
  • Python - Class and Object
  • Data Analysis - Numpy
  • Data Analysis - Pandas
  • Data Analysis - Visualization
  • SQL - Assignment 1
  • SQL - Assignment 2
  • Statistics Assignment

  Projects

  • Web Scraping Project Final Submissions
  • Web Scraping Project Documentation
  • SQL Project Demonstration
  • SQL Project -
  • Excel - Dashboard Project
  • Tableau - DATA ANALYSIS PROJECT

  SQL

  • MySQL Workbench Installation Processor
  • MySQL_Installation Processor
  • Day 1 & 2 Lab File on DDL Commands - CREATE, DROP & Data TYpes
  • SQL INTRODUCTION PDF
  • 23rd Dec - DDL and DML Commands File
  • MYSQL - Datatypes File
  • 26th Dec - DML Commands File
  • RetailDB_Class Code
  • 27th Dec - Update Delete Filters Copy of table
  • 28th Dec - OPERATORS ,GROUP BY ,FOREIGN KEY,TCL
  • 29th Dec - Joins SubQuery ,Operator Aggregate and String & Math Function
  • 30th Dec - windows functions, stored procedures and views case studies
  • 30th Dec - Python Connection MySQL
  • SQL All Files along with Adv Topic and Revision PDF
  • SQL Lab - 1
  • SQL Lab - 2
  • SQL Lab - 3
  • SQL Lab - 4
  • SQL Lab - 5 Joins Merges Concepts
  • SQL Lab - 6
  • SQL Lab - 7

  Tableau

  • Introduction to visualization & Tools

  Statistics

  • 23rd Jan - Descriptive_stats File
  • 24th Jan - Descriptive_stats_ File
  • Introduction to Descriptive Statistics
  • Measure of Dispersion
  • Correlation Correlation, Percentiles, Deciles, Quartiles, IQR, Population, Sample, Data Categories
  • 25th jan - Covariance_Correlation
  • 27th Jan - Probabbility_Theroy_RandomVariable File
  • 30th Jan - Descrete Random Variables File
  • Importance of Probability, Introduction to Probability, Types of Probability
  • Revision of Probability, Conditional Probability, Bayes Theorem, Independent Events
  • random variables, Types of Random Variables , Bernouli , Binomial
  • Expected values, PDF, PMF, CDF, Uniform Distribution in continuous space and discrete space
  • Poisson and Exponential Distributions, Example problems
  • 31st Jan -- Poisson_Exponential Distributions File
  • 2nd Feb Unifrom Distribution File
  • 3rd Feb - Normal Distribution
  • 6th Feb - Normal Distribution File
  • 7th Feb - CLT File
  • Normal Distribution, Empirical Rules, How to Plot Normal Distribution
  • Standard Normal Distribution, Problems on Normal Distribution, Z-tables, Transformations
  • Bootstrapping, Central Limit Theorem
  • 8th Feb - Confidence Interval
  • CLT for Proportion Estimation of Population parameters point and Interval
  • Confidence Interval, Criterial Value Significance Level
  • Example on CI , T Distribution and Excel Lab
  • 9th Feb - Confidence_Interval_Problems
  • 10th Feb - T distribution, Python Implementation, Confidence Interval with T distribution
  • 13th Feb - What is Hypothesis Testing, Null & Alternative, Apps of CLT in Hypothesis testing.
  • 14th Feb - left & Right Tail and p value approch and evaluation
  • 15th Feb - Hypothesis testing 1 sample testing, z-test, t-test.
  • Chebyshev's theorem, Bias, Introduction to Hypothesis testing, Null & Alternative Hypothesis
  • Hypothesis Testing - Part 2 Type 1 & 2 Errors
  • Z-Test, T-test, p value approach, p value calculation, Example Problems.
  • 17th Feb Chisquare File
  • Z-Test, T-test, p value approach, p value calculation, Example Problems.
  • Python lab of hyp testing, Chi square dist, Chi square test for independence
  • Chi Sqaured and F Distribution & ANOVA
  • 20th Feb - Chi Square File
  • 21st Feb - F test and ANOVA
  • 22nd Feb File

  Machine Learning

  • This section has no content published in it.

  Deep Learning

  • This section has no content published in it.

  Test

  • Basic Python Test

  Excel Module

  • 1st Mar - Intro to Excel
  • 2nd Mar - Conditional Formatting File
  • 1st Mar - Introduction to Excel
  • 2nd Mar - Conditional Statement
  • 3rd Mar - Excel - Data Validation
  • conditional_formatting File
  • Intro to excel File
  • Data_validation File
  • 6th Mar - Pivot Table
  • Pivot Table File
  • 7th Mar - Dashboard
  • Dashboard File 7th march
  • 9th Mar - VLOOKUP & HLOOKUP
  • VLOOKUP & HLOOKUP File
  • 10th Mar - EXCEL- MACROS
  • Macros File

  Data Analysis Assessment

  • Python Data Analysis Assessment