Data Analytics: Get Certified! Get Hired!

Download as pdf or txt
Download as pdf or txt
You are on page 1of 38

Data ANALYTICS

Get Certified!
Get Hired!
Why

Data ANALYTICS?
About Career Track

50+

Data Analytics
Mentors
Understand the root cause of business

problems by breaking down the details

structurally before presenting solutions. Build

and strengthen analytical and problem-solving

skills to solve business problems effortlessly.

Become proficient in identifying the root

cause of a business setback and sharpen the

1.3K

problem-solving skills by learning to crack

Students
solutions analytically. Excel in managing Excel

and SQL, the most important tools for a data

analytics career. Learn to break a business

problem and design solutions in a structured

and data-driven manner.

upto

32LPA
WHY DATA ANALYTICS

Industry Outlook
As companies are becoming more tech-driven and fast-paced now, data
analysis professional are playing an increasingly crucial role in businesses.
Both startups and tech giants in India are adding data analysts to their
workforce who are able of recording, analyzing and dissecting data to drive
efficient decision-making.

Avg. salary of Growth in


Size of Industry Job Openings
Data Analysts openings

USD 196.47 Bn+ INR 12LPA 195K+ 24% YoY

Data Analysts are growing exponentially in their careers

₹45+ LPA
₹50 LPA

₹40 LPA ₹20-40 LPA

₹30 LPA

₹20 LPA ₹15-18 LPA

₹8 LPA
₹10 LPA

< 1 yr 2-3 yr 4-6 yr +7 yr


Why

Skillovilla?
WHY Skillovilla
Key Highlights
Industry Aligned Learn LIVE from the

Curriculum Masters of Industry


Curriculum designed by graduates LIVE Sessions on real business use
of MIT, LBS, ISB & IIT. cases delivered by the masters of
the industry from Amazon, Google,
Microsoft, and many more.

Real life Case-studies


Placement
and Projects Prep

Do it yourself with our live case Build your resume by solving real
studies and real business case studies and undergo mock
projects. interviews before your real interview

300+ Partner
2Year Alumni
Companies
Support
Get hired among our 300+ partner
Get an extended 2 year alumni
hiring companies such as Google,
support and get access to
Microsoft, Swiggy, Razorpay,
excusive job opportunities
PharmEasy, Cred, and many more.
MENTORS
Learn LIVE from Industry Experts

Deepak Kharol Abhishek Tayal Nakul Laad


Co-Founder, SkilloVilla
Category Manager, Amazon
Director - Business Strategy,

Ex- Sr. Growth Manager,


Ex- AT Kearney
Swiggy

Swiggy Ex- Times Internet Ex-Accenture, Ex-Entrepreneur

IIT Delhi IIT Delhi, IIM Calcutta IIT Madras

Eshan Tiwari Preeti Singh


Product Analytics Lead
Lead Product Analyst

Facebook OLX Group

Pranay Jha Vikram Datla


Analytics Lead
Head of Analytics

Clear Careem

Deepanshu Malhotra Shwetab Sushil


Director - Analytics Head of Analytics

Razorpay Myntra

Bhagyashree Upadhyay Aditya H K


Analytics Manager, Director - Analytics

Citybank Dream11

50+ More Industry Experts


How

It works?
HOW IT WORKS

Get Upskilled

Curriculum that matches industry trends

Material designed by top industry experts from top companies

Learn in-demand skills to make strong foundational career

Learn from the basics to advanced. Become a pro

Our mentors are the industry's top 1%

Learn, ask question, discuss problems with the best experts

Meet your mentors in live sessions, address every doubt directly.

Dedicated mentors will help you to solve every problem

Experience different ways of learning

Have a structured learning plan you can fit in your schedule

Study through self paced content through the week and engage with

mentors in live classes

Solve real problems with industry leaders in live sessions


HOW IT WORKS

Get Placed

Make a resume that stands out

Learn how to give the best first impression with your resume

Get guidance on how make a resume that fits every job description

Learn to highlight your career experience, skills, and knowledge in

the best way possible

Practice with mock interviews

Learn to approach the most frequently answered questions

Get personalised actionable feedback from experts

Practice and build your interview confidence

Now, it's time to get your dream job!

Extensive job support from shortlisting to interview preparation

Get access to opportunities in over 300+ partner companies

Work on hands-on projects that will expand your portfolio


The Journey
Your Upskilling Journey

Get Enrolled to Excel:


Data Analytics Beginner to
Career Track
Advanced

SQL:
Beginner to
Advanced

Structured
Problem Solving
and Case Studies

Data Visualization
in Tableau

Get Certified by SkilloVilla


PLACEMENTS
Path to Your Dream Job
Build your portfolio
Build your portfolio with real life case studies
and projects to showcase your skills

Create an resume that stands out


Build a resume with which showcases your skills to recruiters.
Get shortlisted with ease and stand out from the crowd

Ace your interview


Prepare for interviews with Mock sessions
with hiring experts from across the industries

Get connected with your dream companies

Connect with your dream companies with ease. Skip the


queue of generic job portals and stand out with our career
partners who believe in the quality of SkilloVilla graduates

Interview tips
Get personalised tips for every interview opportunity.
Be the best prepared for every opportunity

Get your dream job


Fast track your career progression and get your dream job

2 year Alumni membership


Get extra assistance to move ahead in your career even
after getting your first job through us.
Apply for your next job switch for free to get further ahead
Network with professionals across different industries.

Learning OutcomeS

Skills you gain

Unleash the power of Excel to handle Automate redundant tasks using


and visualize data named ranges, pivots and macros

Learn to perform complex data Work with multiple tables using SQL
manipulation through SQL to extract relevant information

Kick start your journey to interpret Learn the real-world application


numbers with the help of statistics of probability, distribution and
hypothesis testing

Learn most advanced problem-solving Use frameworks like BCG Matrix,


frameworks and techniques and their Value Chain Analysis, SWOT, etc
application in real world in real business problems
Casestudies and Projects

Projects

Swiggy Drone Flipkart Category


Delivery Management
Find out how the Swiggy drone delivery Use systematic analysis to find how
system should be designed for optimal category managers use trends to
outcomes for business, customers and plan campaigns, inventories and
delivery partners. ecommerce strategies

Monetisation of seasonal Harley Davidson

event Dealer Stock Management


Seasonal events in various countries Run an inventory planning exercise for
trigger huge traffic on the website with a dealership and derive insights to
various intents. Google wants to manage stock planning. How to plan
monetize the opportunity by identifying for supply and demand and measure
seasonal events in various geographical seasonality of such businesses
location.
Casestudies and Projects

Projects

HCL Technologies
Jio Finding target
Digital Marketing market

Experience how HCL used its website Analyse the telecom data of india and
metrics to drive its digital acquisition find where should Jio invest its capital
strategy and how it improved the expense by understanding different
customer experience from various user segments in different cities
metrics and user journey

Uber Ride Analysis Analysing IPL data


Understand the Uber ride data to find Analyse the match data for IPL to
insights on when, where and how the uncover the insights on players and
ride hailing demand move. Get insights teams. Answer basic questions like did
on how uber should plan for demand batting/bowling first matter ? Or was
and supply in such areas to serve there a home ground advantage ?
customers better Does winning a toss matter ? To
advanced insights in players ROI.

Many more projects across diverse Industries


Add - on
Python Selfpaced

Learn the math behind data science and master the art of maneuvering through
complex data effortlessly.

Benefits
Possess the ability to collect, organize, analyze, design, visualize data, and draw
evidential conclusions.

Test and explain the validity of facts and claims in a very precise and sensible manner.

Design potent tools on critical experimental data and draw the correct conclusions using
statistics, and handle variations in data that are pervasive.

Relating a real-world problem scenario to statistical concepts and using these


techniques to solve challenging problems by developing reasoning capabilities.

Key skills
Linear Algebra Probability Descriptive Statistics Inferential Statistics
Data Visualization NumPy Pandas

Get this Add-on on discount


Don’t forget to ask about this python ₹ 10,999/- ₹21,998/-
addon to your career counsellors. Limited time offer - 50% off
LANDING YOUR DREAM JOB
Placement Preperations

Individual Development
Preparing for your job is not just about
learning the right set of skills. We go beyond
that to help you build your profile to make you
an attractive candidates to recruiters across.

Resume Building
Build your resume which shines out among a
sea of candidates. Learn how to personalise
your resume for every job description and
get shortlisted with ease.

Mock Interviews
Practice for your big day with experts and
mentors. Get the feedback to be ready to
? perform when you get the chance.
ALUMNI CONNECT
Get benefits beyond
Become part of a driven community of experts and students
Engage with the community

Share your achievements and insights

Network with alumni from top companies at top positions

Learn with the community about new technologies and emerging ideas

Stuck with a problem ? - Ask problems in forums

2 Year Job Support

We got your back even after you start your work

We help you get your second job as well, if you got the first one with us

2Yrs
Alumni Support

6K+
Alumni Network
Premium

Membership
What our
learners say
Testimonials
Alumni success stories

Ajay Pandey
I found the curriculum to be very effective. The course starts
right from basics of a concept to advanced level applications,
the approach was a right fit for me as I had no experience
before into analytics. Mentors were highly experienced and it
was a major add on to learn from such industry professionals.
It was really a great turnaround from being a sales person to
becoming a data analyst in less than 5 months and this was
only possible because of SkilloVilla.

Designation
Hike
Placed at
Data Analyst 100%

Jyoti Chhanwal
If I had to explain the curriculum in a word, it would be very
comprehensive. Everything was properly designed right from
the recorded videos to the assignments to the live classes.
Videos were short, only 5-10mins long that helped us be more
engaged. The live lectures also had very good mentors from the
top companies who made us solve practical problems and
taught various things that they face every day. SkilloVilla even
helped me with my CV and we had mock interviews. All of the
efforts resulted in me getting a job at Swiggy as a Data Analyst.

Designation
Experience
Placed at
Data Analyst Fresher
Testimonials
Alumni success stories
Prateek Mantri Shubham Sharma

I feel great that I was able to upskill myself and


SkilloVilla helped me in improving my skills. The
now I'm super excited about my new role.
mentors guided me in solving different kinds of
Thanks to SkilloVilla for their continuous support
business problems on different tools.
and guidance!

64% hike 65% hike

Ritwik Mishra Jatin Mundra

Upskilling requires patience, resources, proper SkilloVilla is a great platform for those who
guidance, and time. I thank Skillovilla for want to pursue a career in Analytics. The live
providing them all and making me industry- lectures helped us gain industry-relevant
ready. skillsets.

100% hike 75% hike

Shreeyash Bothare Garima Singla

I joined SkilloVilla without any knowledge of SkilloVilla helped in building my confidence with
Data Analytics. SkiloVilla not only helped me in great learning exposure. The mentorship,
my learning but also in my job search as well. guidance and support motivated me the most.

75% hike Fresher


Partner
Companies &
Statistics
OUR TRACK RECORD

Placement Statistics

Average Salary Average Hike

9LPA 42%

92% 98%

Placement Ratio Career Transitions

People Who Hired from Us

300+ partner companies


HIRING PARTNERS
Company Feedback

We always struggled hiring Data Analysts through our standard


process of hiring and takes about months of efforts to shortlist
candidates. SkilloVilla really solved the problem by providing us
shortlisted profiles with a very detailed report on their skillsets. The
hiring process was quick and we hired the very first candidate we
interviewed.

Labdhi Chopda

SkilloVilla has helped us with a great candidate pool who have the
required skills and knowledge. SkilloVilla graduates have integrated
into our teams very quickly and are performing better then other
new joinees. We have been very happy with the ease of hiring
great candidates from them. Our overall selection percentage is
about 5% but with SkilloVilla the same was 30%.

Deepanshu Malhotra
The
Syllabus
Track Curriculum

Data Analytics

C ourse 1
Excel : Beginner to Advanced
z
Learn to manipulate complex data and derive insights through various visuali ation techniques

by using the most popular tool and functions of Excel.

Chapter 1

Kick Start Microsoft Excel

Understand the different features of the excel interface - navigation, selection of

cells, and data entry along with basic calculations.

Chapter 2
Working with formula

Learn to write the most frequently used excel functions in calculations such as

SUM, AVERAGE, MAX, and MIN.

Chapter 3

Formatting

Learn the tools to format datasets using border formatting, alignment, cell, and font

formatting. Insert pictures and learn to make them visually appealing in workbooks.

Chapter 4
Modifying workbooks and worksheets

Learn the tools, techniques, and tricks to manage and structure the workbook.

Conditional formatting will be taught in this chapter too.

Chapter 5
Text and Date functions

This chapter will introduce you to some basic functions to work with dates and

texts to extract relevant information.


Track Curriculum

Data Analytics

Course 1

Excel: Beginner to Advanced

Learn to manipulate complex data and derive insights through various visualization techniques

by using the most popular tool and functions of Excel.

Chapter 6

Exploring charts

Understand techniques to visualize the data in different charts and add little

nuances in charts to enhance the visual appeal.

Chapter 7
Named Ranges

Named ranges open the doors for automation in excel workbooks. Learn how to

create, manage and apply named ranges in a function.

Chapter 8

Conditional functions

Learn to perform calculations based on some conditions using advanced formulas

such as SUMIF, COUNTIF, and more. Automate boring work with Excel table.

Chapter 9
Operators

Learn to use AND, OR, and IF operators to write complex instruction in excel

Chapter 10
Pivot tables

Unleash the power of Pivots table and pivot charts to perform complex calculations

within seconds and create basic interactive visualizations using slicers.


Track Curriculum

Data Analytics

Course 1

Excel: Beginner to Advanced

Learn to manipulate complex data and derive insights through various visualization techniques

by using the most popular tool and functions of Excel.

Chapter 11

Data validation

Gather details about creating data validation based on formula and interactive

conditional formatting that ensures data entry is systematically processed.

Chapter 12

Lookup functions

Become proficient in utilizing the Lookup Function, the most frequently used

function of Excel, to solve real-world business problems.

Chapter 13
Auditing a workbook

Master the tips and tricks to identify the hidden errors in a workbook and resolve them.

Chapter 14

Design Principles and building Interactive dashboard

Explore the exciting design principles used by industry experts and create

interactive dashboards through real business projects.

Chapter 15
Macros

Macros can be very useful to perform repetitive tasks with just a click. Learn how to

record and edit a set of actions as many times as you want.


Track Curriculum

Data Analytics

C ourse 1
Excel: Beginner to Advanced
Learn to manipulate complex data and derive insights through various visualization techni ques
by using the most popular tool and functions of Excel.

Chapter 16

Power Pivots

Learn Power pivots to broaden your skills to play with large data using multiple

sources and create data models to perform complex calculations in seconds.

Chapter 17

Data modeling

Learn how to create different business scenarios and optimize a business

objective using Solver and Goal Seek

Chapter 18
Data cleaning techniques

Take care of messy workbooks with dynamic and automated fixes. Learn to fix dates,

remove blank and unwanted characters to clean files.

Chapter 19

Advanced Lookup Functions

Expand your skills in automation using advanced lookup functions INDIRECT,

ADDRESS and OFFSET

Chapter 20
Printing Workbooks

Learn tips and tricks to print the workbooks on a piece of paper


Track Curriculum

Data Analytics

Course 1

Excel: Beginner to Advanced

Learn to manipulate complex data and derive insights through various visualization techniques

by using the most popular tool and functions of Excel.

Chapter 21

Building Professional Dashboard

Data is meaningless unless it tells a story. Learn how to create beautiful and

interactive dashboards using advanced techniques

Chapter 22

Capstone Project

The project test you on all the necessary skills required to become an Excel expert
Track Curriculum

Data Analytics

Course 2

SQL: Beginner to Advanced

Make data-driven decisions by using the most widely used analytics techniques in the industry.

Chapter 1
Database installation and overview

Learn how to install PostgreSQL to kick start your SQL learning journey.

Chapter 2
Fundamentals statements of SQL

Understand fundamental statements of SQL and learn how to write simple SQL

queries to extract data from databases.

Chapter 3
Aggregation functions

Build a deeper understanding of how SQL can aggregate data using various functions

and GROUP BY.

Chapter 4

JOIN statements

Build a solid foundation of concepts of various JOINs in SQL to combine various tables.

Chapter 5
Advance SQL statement

Learn advanced SQL commands to perform complex data manipulations using

various data types.

Chapter 6
Creating database

Learn how to create, update, alter and delete databases and tables from the ground up.
Track Curriculum

Data Analytics

Course 2

SQL: Beginner to Advanced

Make data-driven decisions by using the most widely used analytics techniques in the industry.

Chapter 7
Conditional functions

Learn to write condition-based instructions in SQL to extract relevant information

from databases.

Chapter 8
Application of SQL in the industry

Get familiar with the most commonly asked data questions and best practices to

write efficient, reusable, and readable SQL queries.

Chapter 9
Capstone Project

The project tests you on all the necessary concepts of this course
Track Curriculum

Data Analytics

C ourse 3

Structured Proble m Solving and Case Studies


Make data-driven decisions by using the most widely used analytics techniques in the industry.

Chapter 1
Measure of Central Tendency

Learn simple statistics to define center of gravity.

Chapter 2
Measures of Variability

Learn statistics that can explain, how far the data points are from each other

Chapter 3
Probability

Define randomness with the help of probability

Chapter 4

Probability Distribution

Understand distribution to explain real-world scenarios

Chapter 5
Hypothesis Testing

Learn how to perform hypothesis testing and its real world application

Chapter 6
Inferential Statistics

Learn math behind the analytical techniques to generate insight from Data
Track Curriculum

Data Analytics

Course 3

Structured Problem Solving and Case Studies

Make data-driven decisions by using the most widely used analytics techniques in the industry.

Chapter 7
Inferential Statistics

Learn math behind the analytical techniques to generate insight from Data

Chapter 8
Problem Solving Frameworks

Learn most popular frameworks to attack any business problem

Chapter 9
Real world Case Studies

Experience the art of problem solving through working on real world business problems
Track Curriculum

Data Analytics

Course 4

Data Visualization in Tableau

Make data-driven decisions by using the most widely used analytics techniques in the industry.

Chapter 1
Introduction to Tableau Data Visualization

Learn what data visualisation is all about. Setup your system and get the

basics ready

Chapter 2
Data Connection

Understand how to connect different data sources to Tableau and how clean and

prepare your data for analysis with ease

Chapter 3
Sorting and Filtering Data

Learn how to explore data and get quick insights with various filtering and sorting

techniques in Tableau.

Custom Calculations Chapter 4

Understand the custom calculation to create derived metrics for the reports to get

deeper insights

Data Analysis Chapter 5

Tableau offers many aggregations to analyse data. Learn how to get descriptive

statistics from your data within seconds with Tableau

Chapter 6
Groups, Set and Cross Tabs

Learn how to organise your data with groups and sets to create a hierarchy and

logical groups of your data. Understand how to create easy crosstabs to create

powerful pivot tables with Tableau


Track Curriculum

Data Analytics

Course 4

Data Visualization in Tableau

Make data-driven decisions by using the most widely used analytics techniques in the industry.

Chapter 7
Visualizations and Charts

Learn various visualisation techniques and understand when to use which

type of charts to get the best insights.

Chapter 8
Formatting a Visualization

Enhance your visualizations using various formatting tools.

Geo Maps Chapter 9

Learn how to get insights from geospatial data by using map based visualization

Chapter 10
Dashboards

Learn how to create stories with your data and share them in organised

dashboards. Put all your learnings from visualisations.

Chapter 11
Managing Worksheets

Learn how to handle worksheets in Tableau and manage the data at scale.

Chapter 12
Tableau Public and Other Resources

Explore Tableau public resources for inspiration from the world to create

complex visualization
ABOUT US
Transform your learnings
into earnings

Causes we care about

Learner’s problem
Skill Exposure Guidance
Their skills aren't Fresh graduates No mentorship from
relevant to what the struggle to find a job experts that can
fast-paced industry since they don't have accelerate student's
needs. access to companies. learning.

Company’s problem
Finding talent Training
Difficult to find candidates High expenditure to train new
with a relevant skillset that employees, companies spend
matches their needs. over 50k to do it.

Solution we offer

Upskill Launch careers Connect


Teaching fresh Helping students to Connecting companies
graduates all the start their careers and students with
skills that are relevant with end-to-end relevant skills that
to the industries. preparations. matches their needs.
ABOUT US
Key Information
Career track Who is this Career
Data Analytics track for
Students
DURATION
24 Weeks Program
Graduates

WEEKLY COMMITMENT
10-12 hours per week Working Professionals
2 hours per day
No coding experience required
any pre-requisites?
No pre-requisites.

For further more details call us at +91 8068 051 209 or contact

Pranav Khandelwal, Head of admissions

For further details write to us at


[email protected]
91springboard, 175 & 176, Bannerghatta Main Rd,
Dollars Colony, Phase 4, J. P. Nagar, Bengaluru,
Karnataka - 560076
www.skillovilla.com

You might also like