Tutors

Innomatics Research Labs

PROGRAM OVERVIEW

CURRICULUM

  Course Took Kit (Discord and Mentoring Link)

  • Discord Innomatics Server Community Link
  • Zoom Mentoring Session Links

  SQL Setup

  • MySQL Installation Step by Step Procedure
  • MySql Installation Processor File

  SQL Module

  • SQL - I Data its types and Introduction to SQL
  • SQL - II Basics and First Command
  • SQL - III Lab Session
  • SQL - IV Lab
  • SQL - V Lab
  • SQL - VI Lab
  • SQL - VII Lab
  • SQL All Lab Files and Material

  SQL Assignments

  • SQL Task 1
  • SQL Task 2

  Tableau(Ongoing)

  • Tableau 1 - Intro to Tableau Connecting to DB, Tableau vs Excel Live vs Extract
  • Tableau Installation Procedure Files
  • Super Store Dataset
  • Tableau 2 - Hierarchy Grouping Data Relationship Filters (Categorical Data Source and Continuoues)
  • Tableau 3 - Data Filters Adv Filters Parameter as filters sets color label
  • Tableau 4 - Calculates Conditional Formatting Logical Functions Rank Shape Shading Number Function
  • Tableau 5 - Models Forecasting Trend Line Regression Reference Line and band Clustering
  • Tbaleau 6 - Filter in all Sheets Dashboard Storyboard Extract and publish dashbaord and Formatting
  • Tableau 7 - Special charts and live exercise
  • Tableau Tasks (18 Excercises)

  Tableau Assignment

  • Tableau Tasks (18 Excercises)

  Python - Problem Solving

  • Python Revision - 1

  Python Programming - Assignment(on-going)

  • Task - 1 (Basic Python Programming)
  • Task - 2 (Data Types)
  • Task - 3 (Python Maths)
  • Task - 4 (Basic Python - Strings)
  • Task - 5 (RegEx)

  Data Analysis and Statistics(On going)

  • Pandas - Data Analysis - 1
  • Data Analysis - I
  • Data Analysis - II
  • Data Analysis - II
  • Statistics - I
  • Stats - I PDF