Professional Certification Program in

Data
Analytics
A Beginner’s Guide

1
About Keen Captain Analytics

We at KCA aim to enhance education through technology by improving accessibility, engagement, and
personalization of learning experiences. We seek to streamline administrative tasks and foster collaboration
among stakeholders. Ultimately, we aim to support lifelong learning by providing continuous skill development
opportunities beyond traditional classrooms, and career growth.

Key Features

200+ Hours of Instructor-Led Training

Dedicated Career Coach

50+ Hours of Self Paced Training

Professional Certification Program

150+ Exercises and Assessment

24/7 Support

2
About the course
This Data Science Career Bootcamp
offered by KCA is an eight
month comprehensive Career
Bootcamp focusing on fast-tracking
your career in the field of data
science. You will be trained by
data science experts and will apply
learning through industry-relevant
projects. You will gain access to
resume building, 1:1 mentorship
sessions and mock interviews to
help you crack your dream job. The
program is based on an applied
learning approach that uses a
combination of self-paced videos,
live virtual classes, and hands-on
projects.

3
Careers in Data Analysts

8
$ 210k
7
Salary (in Lakhs) Per Annum

10-19 Years
6
$ 120k
5

5-9 Yrs of Experience

4
$ 81k
3
1-4 Yrs of Experience
$ 75K
2
0-1 Yrs of Experience

Payscale
Source:

1 2 3 4 5 6 7 8

Years of Experience

Some of the job roles associated with Data Science include Data Analyst, Data Science
Generalist, Data Scientist, ML Analyst, ML Engineer, ML Scientist, AI Analyst, AI Engineer,
AI/ML Developer, Business Intelligence Analyst, Associate Data Scientist, Data Architect,
Business Intelligence Developer, Deep Learning Engineer, Decision Scientist, Data
Visualization Specialist, and many others.

4
KCA advantage
Access to a variety of tools used in data
science and hands-on training with
many industry-relevant projects

AI-based feedback on resume

preparation.

Interview-ready with 1:1 mock interviews

and mentorship sessions

Access to the job board curated by

KCA where you can apply for job
openings

5
Eligibility criteria and application
process

Who can apply?

Anyone with

Hold an engineering or statistics degree or any of the MCA/ [Link] (IT)/

MBA/ BCA/ [Link] (IT) degrees

0-3 years of work-ex when you graduate from this program; 2020 and
onwards graduates

How to Apply? For the application process

Submit Application

1 Submit the application with the required

information to check the eligibility.

Application Review

2 Our admission team will review your application &

inform you if you can get enrolled for the program

Admission Rollout

3 Secure admission by completing the payment

and begin your journey to becoming a data
science professional

6
 Phase 1 - Python Basics
STEP 1

Python Introduction for Data Analysis

Mastering Python Data Structures

Understanding Control Structures & Functions

Intro to Object-Oriented Programming in Python

Proficiency in Python File Handling

Exploring Advanced Data Structures in Python

Phase 2 - SQL for Data Analysis

Getting Started with MySQL

SQL Commands Fundamentals

Data Types, Keywords, and Clauses in MySQL

Functions in MySQL

Aggregate Functions in MySQL

STEP 2

MySQL Constraints

MySQL Joins

MySQL Subqueries

Views and Stored Procedures in MySQL

Window Functions in MySQL

7
 Phase 3 - Excel for Data Analysis

Unleashing the Power of Excel

STEP 3

Mastering Data Entry and Formatting

Cleaning and Manipulating Data

Mastering Excel Functions

Creating Stunning Visualizations

Advanced-Data Analysis Techniques

Pivot Tables and Pivot Charts

Descriptive Statistics and Time Series Analysis

Interactive Dashboards and Adv. Data Visualization

Excel Macros

Phase 4 - Statistics and Probability

Unleashing the Power of Excel

Data Analysis with MS Excel

STEP 4

Summarizing and Forecasting

Macros and Dash boarding

8
 Phase 5 - EDA with Python
STEP 5

Exploratory Data Analysis with Python

Utilizing NumPy for Analysis

Basics of Series and Data Frame in Python

Filtering Data with Pandas

Extracting and Aggregating using Pandas

Visualization with Matplotlib and Seaborn

Interactive Plotting with Plotly and Cufflinks.

Phase 6 - Enterprise Dashboards with

Tableau (ELECTIVE)

Introduction to Enterprise Dashboards

Connecting Data Sources in Tableau

Creating Interactive Visualizations in Tableau

STEP 6

Designing Effective Dashboard Layouts

Utilizing Filters and Parameters in Tableau Dashboards

Implementing Advanced Calculations in Tableau

Dashboard Interactivity and User Experience

9
 Phase 7 - Business Dashboard with
Power BI (ELECTIVE
STEP 7

Introduction to Business Dashboards

Connecting Data Sources in Power BI

Designing Visualizations in Power BI

Creating Interactive Dashboards in Power BI

Applying Filters and Slicers in Power BI

Implementing Advanced Calculations and Measures in Power BI

Sharing and Publishing Power BI Dashboards

Phase 8 - Tactical Analytics

Problem Recognition and Framing

Analytical Approaches and Techniques

Case Studies – Problem-Solving in Practice

Collaborative Analytics Problem-Solving

STEP 8

10
 C E R T I F I C AT E
O F AC H I E V E M E N T

DATA ANALYSTS

T H I S I S T O C E R T I F Y T HAT

JOHN DOE
Has successfully graduated from the <Course Name> Masters
Program having completed all mandated course
requirements and industry projects with distinction.

Date: __ / __ /2020

Kajal Sharma (Director)

Upon completion of this Certification Program, you will receive the certificates from
KCA in the Data Analysts courses in the learning path. These certificates will
testify to your skills as an expert in Data Analytics. Upon program completion, you will
also receive an industry-recognized Master’s Certificate from Keen Captain Analytics.

11
Corporate Training

Top clients we work with:

Features of Corporate Training:

Tailored learning solutions

Flexible pricing options

Enterprise-grade learning management system (LMS)

Enterprise dashboards for individuals and teams

24X7 learner assistance and support

12
USA

Keen Captain Analytics LLC.

3412 Old Capitol trail,
Suit 700 Wilmington, Delaware 19808
Phone No: +1 312 777 9449

SINGAPORE

Keen Captain Analytics LLC.

Level 39, Marina Bay Financial Tower 2,
10 Marina Bolvevard, Singapore
Phone No: +65-31297555

[Link]

13