Enroll now for free Demo Class on Job Ready, Certification Data Science Course Today

Learning Cycle at Inversa Technosoft

20 Days of Coaching, 3 Hours a Day of Training and 2 Hours of Project – Only on Weekends
5 Modules which can fetch 20+ Job Positions
Certificate on Completion
Live Projects from Day1
Participate in Hackathons
Solve all Popular Datasets
Create GIT Profile
LinkedIn profile building
Resume Preparation
Placement Support

20+ Job Positions for our tailored Course

Detailed Curriculum

  • Spreadsheet Principles and Screen layout
  • Functions – Logical, mathematical, Text, Date and Time
  • V Look Up, H Look Up
  • Index and Match
  • Data Validation
  • Sorting
  • Filters and Advance Filters
  • Data Cleaning – Concatenation, Extracting, Casing, Comments, Substituting, Splitting Columns
  • Conditional Formatting
  • Go To, Range, HyperLinks
  • If condition, Nested If, SumIF, CountIF, AverageIF
  • AND, OR, NOT, Combination
  • Pivot Tables and Pivot Charts
  • Charts – Pie, Bar, Stacked Bar, Line, Column, Area, Histogram, Scatter.
  • Charts – Secondary Series, Waterfall, Formatting & Scaling
  • Dashboard Designing
  • VBA Macros
  • Working with Macros for Charts, Pivot Tables and Dashboard
  • Hands-on Exercise for Manipulating Data using Excel Functions 

Database & RDBMS Concepts
Executing SELECT, UPDATE, DELETE Statements
Using Clauses WHERE, ORDER BY, GROUP BY, DISTINCT, UNIQUE, HAVING
Constraints
Types of Constraints – NOT NULL, UNIQUE, PK, FK, CHECK, DEFAULT
Arithmetic Operators – [ *, / , +, – ]
Special Operators – [ IN, LIKE, BETWEEN, IS ]
Logical Operators – [ OR, AND, NOT ]
Concatenation Operator – [ || ]
Set Operators – [ UNION , UNION ALL, INTERSECT, MINUS ]
Aggregating Data using Group Functions – [ MAX, MIN, AVG, SUM, COUNT ]
Grouping by multiple columns
Character Functions [ UPPER, LOWER, SUBSTR , LOWER, LENGTH, TRIM ]
Number Functions [ CEIL, FLOOR, ABS, SQRT, POWER, ROUND, TRUNC, LEAST ]
Date Functions [SYSDATE, SYSTIMESTAMP, NEXT_DAY, LAST_DAY, ADD_MONTHS ]
Conversion functions [ TO_CHAR, TO_DATE, TO_NUMBER ]
Special Functions [ TRANSLATE, WM_CONCAT, LIST_AGG, CHR, ASCII, DECODE ]
Nested Functions
Data Types – CHAR, VARCHAR, VARCHAR2, NUMBER, INTEGER, DATE, TIMESTAMP, BLOB, CLOB
Displaying Data from Multiple Tables – Joins
Types of Joins – Left, Right, Inner, Outer, Cartesian
Normalization & Different Normal Forms [ 1NF, 2NF, 3NF, BCNF, 4NF,5NF ]
Difference between OLTP & Data-Warehouse
Creating Views
Types of Views – Simple, Composite, Updateable, Non-Updateable, Read-Only, Force
Creating Index
Types of Indexes – Simple, Composite, Unique, Non-Unique, B*Tree, Bitmap, Function Based
Creating simple cluster
Analytical Functions – MAX, MIN, SUM, COUNT, AVG, ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG
Getting nth highest, nth lowest & nth record from the table

The Tableau Application Suite
Installing Tableau Desktop
Data Preparation
Working with Measures & Dimensions
Working with Marks
Saving & Sharing Workbooks
Connecting to multiple source files
Joins – Left, Right, Inner, Outer / Full
Unions – Manual, Wildcard
Editing the meta data
Hierarchies, Calculated Fields, Table Calculations
Charts – Bar, Line, Heat Map, Pie, Bullet, Waterfall
Charts – Formats, Legend, Scaling, Filters
Aggregate functions, Text Operators, Parameters
Calculations – Quick Table, Customized Table
Level of Detail (LOD) Expressions
Maps – Symbol, Filled, Density, Layers, With Pie Charts, Tooltip, Mapbox
Trend Lines, Forecast, Cluster Analysis, Other Statistical Tool
Interactive Dashboards – Placing of Charts, Title, Navigation, Best Practices

Introduction to Python
Numpy Package
Pandas Package
Scipy & Matplotlib
Data Cleaning
Statistics
Machine Learning
Deep Learning

Pricing

Data Analyst 1

Tailored Course for Junior Data Analyst
₹25000
20,000
  • MS Excel
  • SQL
  • Tableau

Data Analyst

Tailored Course for Data Analyst
₹25000
10,000
  • Math & Statistics
  • Python

Combo

All 5 Course
₹50000
25,000
  • MS Excel
  • SQL
  • Tableau
  • Math and Statistics
  • Python
Popular

Why Learn Data Science?