Start your career in
Data Analyst in less than 6 months

Start from the fundamentals and nail it by building your career in the most epic industry of technology.

Quick-start your career by learning Data Analyst from experts in fail-proof ways with verified curriculum and get to upskill yourself with desired industry ready projects.
Enroll Now
Vertocity IBM
Students placed at
Vertocity Infosys
Vertocity Genpact
Vertocity Swiggy
Vertocity Zomato
Vertocity B
Vertocity Wipro
Vertocity U
Vertocity WB

Career in Data Analyst now made easy with Vertocity.

Analyse Data Analyst role salaries across years of experience.
Vertocity G1

Become a Data Analyst in less than 6 months

Our Learners journey explained

Vertocity 31

Enrolled in the course

You are among the top 70% data enthusiast

Excel

You have acquired 20% skills required for a data analyst!
Vertocity 32
SQL
You have acquired 35% skills required for a data analyst!
Vertocity 34
Power BI
You have acquired 55% skills required for a data analyst!
Vertocity 36
End Project
You are ready to take the leap as a data analyst!

Mentors & Guest Lectures

Vertocity 41Vertocity 42Vertocity 43
Job Opportunities After Course Completion
Vertocity 44

Business analyst

A Business Analyst is a professional who works closely with stakeholders to identify goals, develop best practices for data collection, and analyse current processes to determine what can be improved to achieve their desired outcome.

Data analyst

A data analyst collects and stores data on sales numbers, market research, logistics, or other behaviours. They bring technical expertise to ensure the quality and accuracy of that data and present it to help people, businesses, and organisations make better decisions.

Curriculum

In today's technology-driven world, data is collected, analyzed and interpreted to solve a wide range of business problems. With a career as a data analyst,  play a decisive role in the growth and success of an organization.

About

A data analyst is a lot more than a number cruncher. Analysts review data and determine how to solve problems using data, learn critical insights about a business's customers and boost profits. Analysts also communicate this information with key stakeholders, including company leadership.

Data Analyst Career Acceleration Program

₹ 80,000
exclusive of taxes


170+ Video Lessons
Access on desktop, tablet and mobile
Lifetime access
Certificate of Completion
100 % Placement Guarantee

EXCEL BASIC PROJECTS

Creating Payroll
Vertocity 00

Creating Payroll Part-1
Creating Payroll Part-2
Creating Payroll Part-3
Creating Payroll Part-4
Creating Payroll Part-5

Creating Payroll Part-6
Creating Payroll Part-7
READING MATERIAL
Quiz
Interview Selection System
Vertocity 00

Interview Selection System Part-1
Interview Selection System Part-2

READING MATERIAL
Quiz
Career Decision
Vertocity 00

Career Decision Part-1
Career Decision Part-2

READING MATERIAL
Quiz
Sales Data
Vertocity 00

Sales Data Part-1
Sales Data Part-2
Sales Data Part-3

Full join
Cartesian join
READING MATERIAL
Quiz

ADVANCED EXCEL

Excel
Vertocity 00

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

Slicers
Data Analytics in Excel
Power Pivot
Power Query Introduction
Tabs & Features in PQ
Query Duplication & Reference in PQ
Pivot,Unpivot & Transpose in PQ
Conditional Column & Merge in PQ
Group By & Append in PQ
Date,Time & Numric values fomatting in PQ

SQL

Introduction to SQL
Vertocity 00

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

MS SQL Environment
Categories of SQL Statements
SQL Datatypes
SQL Table
Creating and using a database
Create and insert to tableSelect data from the table
ASSIGNMENT – I
CHAR vs VARCHAR
Saving SQL QueryClass Overview
READING MATERIAL
Quiz
Working with SQL tables and SQL Clauses
Vertocity 00

Import data to SQL
Comment in SQL
Where clause
Like clause
SQL Table creation

Update statement
Delete statement
Alter statement
Drop statement
Truncate statement
READING MATERIAL
Quiz
Advanced SQL Clauses
Vertocity 00

Distinct and Count clause
Order by clause
Group by clause
Having clause

ASSIGNMENT
READING MATERIAL
Quiz
Table Joins
Vertocity 00

ASSIGNMENT REVIEW SESSION
Inner join
Left join
Right join

Full join
Cartesian join
READING MATERIAL
Quiz
Set clauses and table views
Vertocity 00

Union Clause
Union all Clause
Intersect Clause
Except clause
Rules of set clause

Index
Types of index
Views and their features
Condition for updating a view
ASSIGNMENT
READING MATERIAL
Quiz
In-built SQL functions
Vertocity 00

SQL Inbuilt function
SQL String function
SQL Date function

READING MATERIAL
Quiz
Table Joins

ASSIGNMENT REVIEW SESSION
Inner join
Left join
Right join

Full join
Cartesian join
READING MATERIAL
Quiz
Set clauses and table views
Vertocity 00

Union Clause
Union all Clause
Intersect Clause
Except clause
Rules of set clause

Index
Types of index
Views and their features
Condition for updating a view
ASSIGNMENT
READING MATERIAL
Quiz
In-built SQL functions
Vertocity 00

SQL Inbuilt function
SQL String function
SQL Date function

READING MATERIAL
Quiz
User-defined SQL functions
Vertocity 00

ASSIGNMENT REVIEW SESSION
User Defined SQL Functions

READING MATERIAL
Quiz
Sub-Queries
Vertocity 00

Sub Queries introduction
Rules for sub queries
Insert data using sub query
Delete data using sub query
Update data using sub query

Correlated Sub Queries introduction
Exists operator
Assignment 9 review session
READING MATERIAL
Quiz
Procedure
Vertocity 00

Creating simple procedure
Droping a procedure and procedure execution
Creating a simple parameterized procedure
Creating parameterized procedure with calculated field

Parameterized procedure for data insertion and data retrieval
READING MATERIAL
Quiz
Transaction and Sequences
Vertocity 00

Transactions
Auto increment field
Simple sequence
Procedurized sequence

Using function in procedure to generate sequence
READING MATERIAL
Quiz

Power BI​

Introduction
Vertocity 00

Introduction Part 1
Introduction Part 2
Introduction Part 3

READING MATERIAL
Quiz
Preparation of Data
Vertocity 00

Data Sources
Storage Modes
Data Source Setting
Custom Table Creation
Transform Data Introduction
Query Duplication & Query Reference

Transpose, Unpivot and Pivot
Conditional Column
Table, Column & Text Transformation
Group by Advance & Aggregations
READING MATERIAL
Quiz
Data modelling
Vertocity 00

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

Relationship Cardinality
Connecting Multiple Data Tables
Understanding Filter Flow
Two way Filtering
Hiding Fields from Data Model
Data Model Options and views
Hierarchy
How to create Column, Table & Measure
READING MATERIAL
Quiz
Table Joins
Vertocity 00

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

More Functions
SWITCH Functions
Iterator Functions(SUMX)More Iterators (MINX,MAXX)Time Intelligence Functions
Additional Time Intelligence Functions
Variables in DAX
Formatting Numbers
Formatting Time
Formatting Dates
Rounding off Numbers
READING MATERIAL
Quiz
Visualization in Power BI
Vertocity 00

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

Gauge Chart
Interactions
Drill Through
Bookmarks
What-If Parameters
Row Level Security
Other visual plots
More visuals from library
Mobile Layer & PBI Services
Q&A Feature
Key Infuencer
READING MATERIAL
Quiz

Tableau (as self paced learning)​

Introduction
Vertocity 00

Introduction to Tableau
An Overview of Different Products
How to Install Tableau
Tableau Help and Online Resources

Applications of Tableau
Components of View Section
Data Terminologies
READING MATERIAL
Quiz
Preparing Data
Vertocity 00

Preparing Data For Tableau
Organising Simplifying Data
Custom Table Creation
Transform Data Introduction
Query Duplication & Query Reference

Transpose, Unpivot and Pivot
Conditional Column
Table, Column & Text Transformation
Group by Advance & Aggregations
READING MATERIAL
Quiz
Creating Chart
Vertocity 00

Creating Chart In Tableau Intro
Creating Chart In Tableau

READING MATERIAL
Quiz
Performing Calculations
Vertocity 00

Performing Calculations in Tableau
Using Maps in Tableau
Creating Dashboards in Tableau

Using Analytics to Analyze Data
READING MATERIAL
Quiz
Please Note : Tableau is a complimentary self-paced learning module and no paid software is included in the course.

Quantitative Aptitude​

Shortcut Tricks for Calculations
Vertocity 00

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 - Alligation and its Application
Averages Questions Solved with Tricks
READING MATERIAL
Quiz
Profit and Loss - Tricks and Shortcuts
Vertocity 00

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

Moderate and Difficult Questions - Profit and Loss, Faulty Weights
Short Quiz: Profit and Loss
READING MATERIAL
Quiz
Percentages, Successive Percentages Change - Tricks and Shortcuts​
Vertocity 00

Concept Session - Basics of Percentages, Approximations of Percentages
Concept Session: Successive Percentage and its Two Applications

Percentages Aptitude Questions Solved with Tricks
Moderate and Difficult Questions on Percentages
READING MATERIAL
Quiz
Profit and Loss - Tricks and Shortcuts
Vertocity 00

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

Moderate and Difficult Questions - Profit and Loss, Faulty Weights
Short Quiz: Profit and Loss
READING MATERIAL
Quiz
Simple and Compound Interest - Tricks and Shortcuts
Vertocity 00

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

Multiplies under CI and SISI and CI Questions Solved with Tricks - PDF Resources
Short Quiz: SI and CI
READING MATERIAL
Quiz
Ratio and Proportion, Variations, Mixtures Simplified
Vertocity 00

Concept Session: Understanding Ratios, Proportions with Conceptual Questions
Concept Session: Understanding Proportions with Conceptual Questions

Concept Session: Understanding Variations with Conceptual Questions
Ratio and Proportion Questions and Answers
Short Quiz: Ratio and Proportion
READING MATERIAL
Quiz
Mixtures, Alligations and Replacements
Vertocity 00

Concept Video: Mixtures using Alligations Concept Video: Mixtures with Replacements Practice Questions with Solutions


READING MATERIAL
Quiz
Time and Work, Pipes and Cistern, Chain Rules Simplified
Vertocity 00

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


Pipes and Cistern - Questions and Answers
READING MATERIAL
Quiz
Time, Speed and Distance, Problems on Trains, Boats and Streams
Vertocity 00

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

READING MATERIAL
Quiz
Permutations and Combination
Vertocity 00

Concept Video: Diff in P&C, Understanding of Permutations Permutations Questions and Answers Concept Video: Understanding of Combinations Combinations - Questions and Answers

READING MATERIAL
Quiz
Probability
Vertocity 00

Concept Video: Formula and Probability of Coins, Dice, Cards. Questions and Answers with Tricks

Short Quiz: Probability
READING MATERIAL
Quiz
Number Systems for Placements
Vertocity 00

Concept Video: Classification of Numbers Concept Video: Divisibility Concept Video: Remainders Questions and Answers: Divisibility and Remainders Concept Video: LCM and HCF Calculation

Concept Video: LCM Models Questions and Solutions - LCM and HCF
READING MATERIAL
Quiz
Mock Placement Papers Sets - QA
Vertocity 00

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

Difficult Set (Only for Papers where difficult quant is asked)
READING MATERIAL
Quiz

Quantitative Reasoning​

Shortcut Tricks for Calculations
Vertocity 00

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 - Alligation and its Application
Averages Questions Solved with Tricks
READING MATERIAL
Quiz
Profit and Loss - Tricks and Shortcuts
Vertocity 00

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

Moderate and Difficult Questions - Profit and Loss, Faulty Weights
Short Quiz: Profit and Loss
READING MATERIAL
Quiz
Percentages, Successive Percentages Change - Tricks and Shortcuts​
Vertocity 00

Concept Session - Basics of Percentages, Approximations of Percentages
Concept Session: Successive Percentage and its Two Applications

Percentages Aptitude Questions Solved with Tricks
Moderate and Difficult Questions on Percentages
READING MATERIAL
Quiz
Profit and Loss - Tricks and Shortcuts
Vertocity 00

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

Moderate and Difficult Questions - Profit and Loss, Faulty Weights
Short Quiz: Profit and Loss
READING MATERIAL
Quiz
Simple and Compound Interest - Tricks and Shortcuts
Vertocity 00

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

Multiplies under CI and SISI and CI Questions Solved with Tricks - PDF Resources
Short Quiz: SI and CI
READING MATERIAL
Quiz
Ratio and Proportion, Variations, Mixtures Simplified
Vertocity 00

Concept Session: Understanding Ratios, Proportions with Conceptual Questions
Concept Session: Understanding Proportions with Conceptual Questions

Concept Session: Understanding Variations with Conceptual Questions
Ratio and Proportion Questions and Answers
Short Quiz: Ratio and Proportion
READING MATERIAL
Quiz
Mixtures, Alligations and Replacements
Vertocity 00

Concept Video: Mixtures using Alligations Concept Video: Mixtures with Replacements Practice Questions with Solutions


READING MATERIAL
Quiz
Time and Work, Pipes and Cistern, Chain Rules Simplified
Vertocity 00

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


Pipes and Cistern - Questions and Answers
READING MATERIAL
Quiz
Time, Speed and Distance, Problems on Trains, Boats and Streams
Vertocity 00

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

READING MATERIAL
Quiz
Permutations and Combination
Vertocity 00

Concept Video: Diff in P&C, Understanding of Permutations Permutations Questions and Answers Concept Video: Understanding of Combinations Combinations - Questions and Answers

READING MATERIAL
Quiz
Probability
Vertocity 00

Concept Video: Formula and Probability of Coins, Dice, Cards. Questions and Answers with Tricks

Short Quiz: Probability
READING MATERIAL
Quiz
Number Systems for Placements
Vertocity 00

Concept Video: Classification of Numbers Concept Video: Divisibility Concept Video: Remainders Questions and Answers: Divisibility and Remainders Concept Video: LCM and HCF Calculation

Concept Video: LCM Models Questions and Solutions - LCM and HCF
READING MATERIAL
Quiz
Mock Placement Papers Sets - QA
Vertocity 00

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

Difficult Set (Only for Papers where difficult quant is asked)
READING MATERIAL
Quiz
Group Discussions
Vertocity 00


Mock Interviews
Vertocity 00


Linkedin Workshop
Vertocity 00


Resume Building
Vertocity 00


WHY VERTOACADEMY

Careers Made Easy

  •  1. Mentorship and tutors:
    We ensure to provide through academic as well as career guidance to individuals by having experienced tutors who not only teach but also act as mentors throughout the course.
  •  2. Course curriculum:
    We focus in having a comprehensive curriculum wherein we help individuals get started from the scratch and build their area of expertise by providing live sessions as well as recorded videos and several hours of course content.
  •  3. Training for High performance:
    We have a 24*7 student support system which ensures that individuals, at any time can get assistance at their convenience. We also provide them with a lifetime access to international learning community for other assistance.
  •  4. Placement Guarantee with 100% placement:
    We provide Assured Job Guarantee to the eligible candidates with a refund policy and have a record of 100% placement with a minimum package of 4.5LPA and highest package of 30LPA.
Vertocity

Calculate in EMI

Oops! Something went wrong while submitting the form.
Your monthly payments

0₹

Total Interest

0

Total Payment

0

Time

0

empezar aplicación

Our Finanace Partners

Projects

Vertocity 11

Customer Relationship Management

Vertocity 11

Stock Price Analysis and Forecasting

Vertocity 11

Dropshiping Management System

Vertocity 11

Population Analysis

Become a Data Analyst.
Click here to register now.

Testimonials

I believe that I developed an understanding of the process of usability. This is what I was interested in achieving. This is the third course I have taken from Vertocity and I feel that I am achieving a good understanding of Data Science.
Vertocity

Agnidipta Sarkar

Management Trainee , TCS

The fact that the assignments are graded means that there’s incentive to work on them, solve problems, and ask questions. Traditional online courses don’t offer that incentive.
Vertocity

Rajesh Kurivi

Software Development Engineer, Virtusa

Because of this program I learnt new concepts and languages. I'm able to convert my learning into a career. As a student, I use the knowledge gained through Vertocity to excel in classes and to get a better job.
Vertocity

Yashwanth

Data Analyst,
Latent View

Course materials were good, the mentoring approach was good, and working with other people via the Internet was good. The instructor did a good job of communicating and making it a more intimate arrangement. A lot of online courses fail because of the isolation. Kitty is very good and I think it’s a very solid course. I learned a lot
Vertocity

Lokesh Krishna

Software Development Engineer, Capgemini

I was looking for an online course which could help me in my career and I came across this. The Vertocity SPL is a course that teaches you about different tech and non tech courses at a very affordable price. I am a big fan of the Vertocity SPL since it has helped me learn more about product management. I would highly recommend this to anyone who is looking for a quality course that is delivered by experts.
Vertocity

Akbar

Data Analyst

Not only did this experience teach me the proper techniques of technical writing and the process of Python as promised, but it also taught me how to learn independently, how to stick with a problem and find ways of solving it, and perhaps most significantly, the experience taught me the skills that will enable me to continue to develop my technical writing skills beyond the electronic classroom.
Vertocity

Mounika raiker

Software Development Engineer, Wipro

Here are some growth hacks
you will get access to

Blog title heading will go here

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros.

Blog title heading will go here

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros.

Special Discord Community Bonus

JOIN THE DISCORD GROUP

Become a part of the fastest growing learner's community.
Join Now

Signup today and get 1v1 career guidance session
worth ₹ 5000/- for free

Lifetime access
100 % Placement Guarantee

Data Analyst Career
Acceleration Program

₹ 80,000
Enroll Now
Certificate of Completion
100+ Video Lessons
Access on desktop, tablet and mobile

Get Certified

  • Get an official Certificate
  • Proudly add this achievement in your resume.
  • Be a part of fastest growing community
Enroll Now
Vertocity

FAQs

What is a job guarantee program?
Vertocity

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.

How do you give a job guarantee?
Vertocity

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.

How can I avail this scholarship?
Vertocity

The percentage of students placed in the Job Guarantee program is 100%, i.e., every individual eligible for the program has been identified.

What are the average years of experience for the tutors?
Vertocity

The average years of experience for the tutors is 5 years.

What is the package that I get after completion of the course?
Vertocity

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.

How can I get my doubts cleared after the session?
Vertocity

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.

Will I get interview support?
Vertocity

Yes, we help individuals thoroughly with Interview Preparation and their Soft-skill Development.

I am from a different background; can I enroll in this course?
Full Stack

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.

₹ 90,000
Become a Data Science specialist.
Register Now