Basics of Excel Part
Designing Database
KPI creation with pivots
Vlookup,Hlookup and Xlookup.a
Vlookup,Hlookup and Xlookup.b
Top N Values
Line, Donut charts and statistical values
Index & Match concept
Index & Match concept Part-2
SUMPRODUCT
Mini Project 1
Mini Project 1 Answers
Creating Payroll Part-1
Creating Payroll Part-2
Creating Payroll Part-3
Creating Payroll Part-4
Creating Payroll Part-5
Interview Selection System Part-1
Interview Selection System Part-2
Career Decision Part-1
Career Decision Part-2
Sales Data Part-1
Sales Data Part-2
Sales Data Part-3
SQL Installation
Introduction and course agenda
SQL and Common terms
Need of database
Types of DBMS
Need of SQL
SQL Structure and tables
SQL process
Flavours of SQL
Import data to SQL
Comment in SQL
Where clause
Like clause
SQL Table creation
Distinct and Count clause
Order by clause
Group by clause
Having clause
ASSIGNMENT REVIEW SESSION
Inner join
Left join
Right join
Union Clause
Union all Clause
Intersect Clause
Except clause
Rules of set clause
SQL Inbuilt function
SQL String function
SQL Date function
ASSIGNMENT REVIEW SESSION
Inner join
Left join
Right join
Union Clause
Union all Clause
Intersect Clause
Except clause
Rules of set clause
SQL Inbuilt function
SQL String function
SQL Date function
ASSIGNMENT REVIEW SESSION
User Defined SQL Functions
Sub Queries introduction
Rules for sub queries
Insert data using sub query
Delete data using sub query
Update data using sub query
Creating simple procedure
Droping a procedure and procedure execution
Creating a simple parameterized procedure
Creating parameterized procedure with calculated field
Transactions
Auto increment field
Simple sequence
Procedurized sequence
Introduction Part 1
Introduction Part 2
Introduction Part 3
Data Sources
Storage Modes
Data Source Setting
Custom Table Creation
Transform Data Introduction
Query Duplication & Query Reference
Merge
Append
Time & Date Transformations
Exclude & Include Queries
Introduction to M Language
Custom Column Using M Language
Introduction to Data Modeling
Importance of Data Modelling & Normalization
Understanding Data vs Lookup Tables
Creating Table Relationships
Star vs Snowflakes Schema
Introduction to DAX
More about DAX
More about Measures
DATE TIME Functions
LOGICAL Functions
TEXT Functions
RELATED Functions
MATH STATS Functions with business explanations
Count Functions
Working of Measure on TOTALSCALCULATE Functions
CALCULATE ALL Functions
CALCULATE FILTER Function
Introduction to Visualization
Introduction to Report Tab
Simple Visual Creation
Conditional Formatting
Formatting Stacked Barchart
Report Filter Options
Matrices
Slicers
Card
KPIs
Text Cards
Visualize Geo Data (Map Visuals)Tree
Map
Line Chart
Area & Stacked Area Chart
Trend Lines & Forecast in Line chart
Python, Anaconda and relevant packages installations
Why learn Python?
Keywords and identifiers
comments, indentation and statements
Variables and data types in Python
Standard Input and Output
Learning Methodology for Programming
Lists
Tuples part
Sets
Dictionary
Introduction
Types of Functions
Function Arguments
Recursive Functions
Lambda Functions
OOPS
File Handling
Exception Handling
Debugging Python
NumPy.
Numerical operations.
Getting started with pandas
Data Frame
Basics
Key
Introduction to Matplotlib
Introduction to dataset
2D scatter-plot
3D Scatter-plot.
Pair plots.
Limitations of Pair plots
Histogram and introduction to PDF(Probability Density Function)
Univariate analysis using PDF.
CDF(Cumulative distribution function)
Variance, Standard Deviation
Median
Why learn it?
Introduction to Vectors (2-D, 3-D, n-D), row vectors and column vector
Dot product and the angle between 2 vectors.
Projection and unit vector
Equation of a line (2-D), plane(3-D) and hyperplane (n-D)Distance of a point from a plane/hyperplane, half-spaces.
Introduction to Probability and Statistics.
Population & Sample.
Gaussian/Normal Distribution and its PDF(Probability Density Function).CDF(Cumulative Density Function) of Gaussian/Normal Distribution
Symmetric distribution, Skewness, and Kurtosis
Standard normal variate (z) and standardization.
Kernel density estimation.
Sampling distribution & Central Limit Theorem.
Q-Q Plot: Is a given random variable Gaussian distributed?
How are distributions used?
Chebyshev’s inequality
Discrete and Continuous Uniform distributions.
How to randomly sample data points. [Uniform Distribution]Bernoulli and Binomial distribution
Log-normal
Power law distribution
Box-Cox transform.
Application of Non-Gaussian Distributions?
Co-variance
Introduction to Tableau
An Overview of Different Products
How to Install Tableau
Tableau Help and Online Resources
Preparing Data For Tableau
Organising Simplifying Data
Custom Table Creation
Transform Data Introduction
Query Duplication & Query Reference
Creating Chart In Tableau Intro
Creating Chart In Tableau
Performing Calculations in Tableau
Using Maps in Tableau
Creating Dashboards in Tableau
Calculate Squares of no.s close to 100
Concept Session - Averages with Arithmetic Progression
Concept Session -Alligation and its Application
Concept Session - Averages with Arithmetic Progression
Concept Session: Profit and Loss Simplified with Conceptual Questions
Concept Session: When CP and SP of two articles are same and Gain/Loss is given
Profit and Loss Solved Questions with Tricks
Concept Session - Basics of Percentages, Approximations of Percentages
Concept Session: Successive Percentage and its Two Applications
Concept Session: Profit and Loss Simplified with Conceptual Questions
Concept Session: When CP and SP of two articles are same and Gain/Loss is given
Profit and Loss Solved Questions with Tricks
Concept Session: SI and CI Basics, Use of Formulae
Concept Session: Diff. in CI and SI for 2,3 years with Formulae and w/of Formula
Concept Session: When Investment/Principle
Concept Session: Understanding Ratios, Proportions with Conceptual Questions
Concept Session: Understanding Proportions with Conceptual Questions
Concept Video: Mixtures using Alligations
Concept Video: Mixtures with Replacements
Practice Questions with Solutions
Concept Video: Basics of Time and Work
Concept Video: Time and Work - Unitary Approach
Concept Video - Group Related Problems
Time and Work Questions and Answers
Concept Video: Basics of TSD, Proportionaliy
Concept Video: TSD - Understanding of Relative Speed
Concept Video: Understanding of Boats and Streams
TSD - Questions on Basics, Proportionality and Average Speeds
Concept Video: Problems on Trains
TSD - Problems on Trains Questions
Short Quiz: Time Speed and Distance
Concept Video: Diff in P&C, Understanding of Permutations
Permutations Questions and Answers
Concept Video: Understanding of Combinations
Combinations - Questions and Answers
Concept Video: Formula and Probability of Coins, Dice, Cards.
Questions and Answers with Tricks
Concept Video: Classification of Numbers
Concept Video: Divisibility
Concept Video: Remainders
Questions and Answers: Divisibility and Remainders
Concept Video: LCM and HCF Calculation
Set 1: Mock Placement Papers Quant Questions
Set 2: Mock Placement Papers Quant Questions
Set 3: Mock Placement Papers Quant Questions
Set 4: Mock Placement Paper Quant Questions
Calculate Squares of no.s close to 100
Concept Session - Averages with Arithmetic Progression
Concept Session -Alligation and its Application
Concept Session - Averages with Arithmetic Progression
Concept Session: Profit and Loss Simplified with Conceptual Questions
Concept Session: When CP and SP of two articles are same and Gain/Loss is given
Profit and Loss Solved Questions with Tricks
Concept Session - Basics of Percentages, Approximations of Percentages
Concept Session: Successive Percentage and its Two Applications
Concept Session: Profit and Loss Simplified with Conceptual Questions
Concept Session: When CP and SP of two articles are same and Gain/Loss is given
Profit and Loss Solved Questions with Tricks
Concept Session: SI and CI Basics, Use of Formulae
Concept Session: Diff. in CI and SI for 2,3 years with Formulae and w/of Formula
Concept Session: When Investment/Principle
Concept Session: Understanding Ratios, Proportions with Conceptual Questions
Concept Session: Understanding Proportions with Conceptual Questions
Concept Video: Mixtures using Alligations
Concept Video: Mixtures with Replacements
Practice Questions with Solutions
Concept Video: Basics of Time and Work
Concept Video: Time and Work - Unitary Approach
Concept Video - Group Related Problems
Time and Work Questions and Answers
Concept Video: Basics of TSD, Proportionaliy
Concept Video: TSD - Understanding of Relative Speed
Concept Video: Understanding of Boats and Streams
TSD - Questions on Basics, Proportionality and Average Speeds
Concept Video: Problems on Trains
TSD - Problems on Trains Questions
Short Quiz: Time Speed and Distance
Concept Video: Diff in P&C, Understanding of Permutations
Permutations Questions and Answers
Concept Video: Understanding of Combinations
Combinations - Questions and Answers
Concept Video: Formula and Probability of Coins, Dice, Cards.
Questions and Answers with Tricks
Concept Video: Classification of Numbers
Concept Video: Divisibility
Concept Video: Remainders
Questions and Answers: Divisibility and Remainders
Concept Video: LCM and HCF Calculation
Set 1: Mock Placement Papers Quant Questions
Set 2: Mock Placement Papers Quant Questions
Set 3: Mock Placement Papers Quant Questions
Set 4: Mock Placement Paper Quant Questions
Agnidipta Sarkar
Management Trainee , TCS
Gaurav Chaudhary
Android developer, Cognizant
Rajesh Kurivi
Software Development Engineer, Virtusa
Kavita Ladia
HR Associate, Grant Thornton
Lokesh Krishna
Software Development Engineer, Capgemini
Kanhaiya Verma
Full Stack Developer, Vertocity
Mounika raiker
Software Development Engineer, Wipro
Job Guarantee Program is one of our key features which ensures that given an individual fulfils the mentioned criteria, he/she will be having a Guaranteed Job post the completion of the course.
We have mentioned some ethical, academic and project(s) related criteria/standards based on which an individual will be eligible for a Job Guarantee wherein if after finishing the course he/she doesn't get placed, then we would refund the amount of the course fee.
The percentage of students placed in the Job Guarantee program is 100%, i.e., every individual eligible for the program has been identified.
The average years of experience for the tutors is 5 years.
We have a dedicated placement hub that ensures placements starting from 4.5LPA to a highest of 30 LPA depending upon the individual's course, field and experience.
The enrolled individuals have access to the international learning community for any assistance, and we also have 24*7 student support in case of any doubts post-sessions.
Yes, we help individuals thoroughly with Interview Preparation and their Soft-skill Development.
Yes, you surely can get yourself enrolled irrespective of the academic background that you belong. We believe in starting from scratch by focusing on fundamentals initially; therefore, there are no educational prerequisites for the courses.