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
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
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
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
Rajesh Kurivi
Software Development Engineer, Virtusa
Yashwanth
Data Analyst,
Latent View
Lokesh Krishna
Software Development Engineer, Capgemini
Akbar
Data Analyst
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.