Change your stagnant job for
dynamic career. Become a Data Analyst
by learning from world experts!
dynamic career. Become a Data Analyst
by learning from world experts!
The Data Analyst
Profession:
study from mentors,
succeed faster
Profession:
study from mentors,
succeed faster
English
Language
8 months
Duration
Online
Format
27th Feb
Start
Learn hand-in-hand with mentors, request 1-1 sessions, and follow your personal career track
Visit career sessions, create CV, and get employed within 3 months after graduation
Employment help
You will study in a job-simulator with virtual colleagues, bosses, and rewards
Job-ready skills
1-1 mentorship
I want to work in IT but don’t have enough knowledge
I try hard to be noticed and get promotion
My job doesn’t motivate me
I am working in a stable sphere where all the money goes
I earn 6+ lakhs and my salary is raising up
I am a skilled professional who never runs out of offers
I work in a dynamic field and grow fast
Data analytics is one of the most in-demand professions of the 21st century
About Profession
Processes and interprets big data
Suggests how to optimize business processes
Visualizes the results
What does a Data Analyst do?
A data analyst is a professional who works with data to extract valuable insights from it. Data Analyst:
Your career track
7 lakhs
4-5 years
Analyst Team lead or Data Scientist
5 lakhs
5-8 months
Junior analyst
13 lakhs
6 years
Chief Data Officer
This course is for you if:
You want to change a stagnant job for dynamic career
You want to work in a big company or move out of India
You want to upskill yourself and get a higher position at work
You want to take control of your life
Get consultation
Leave your phone number, and our counselor will call you back and answer all your questions about the course!
In 8 months you will master all skills needed to be a Data Analyst. The course contains 12 blocks and 22 modules, 10 projects, 3 exams, and a lot of practice! You will complete the course with full knowledge of how IT works and how to fit in the industry.
Your skills after the course
What Is Inside
projects and business cases
30+
months
to complete
to complete
8
1500+
Access assignments
Google sheets
SQL
Statistics
Power BI
Python
SQL
Statistics
Power BI
Python
Get personal employment help
4
Mailing CV to our HR partners
Sessions that emulate your future interviews with employers
3
Mock interviews
10 solved business cases that show you’re ready for work
2
Portfolio
Mentors define your strengths and create a CV that will catch employers
1
Attractive resume
Why Coding Invaders?
Compare
Simulation at Coding Invaders
Other online schools
24/7 support from your personal mentor
1-1 sessions with mentors anytime
Live sessions and recorded theory
Introducing you to hiring partners
Personal career track &
8 career sessions
8 career sessions
Applied hard & soft skills after the course
Practice based education
Other schools
Coding Invaders
24/7 support from your personal mentor
Other schools
Coding Invaders
1-1 sessions with mentors anytime
Other schools
Coding Invaders
Personal career track & 8 career sessions
Other schools
Coding Invaders
Introducing you to hiring partners
Other schools
Coding Invaders
Live sessions and recorded theory
Other schools
Coding Invaders
Practice based education
Other schools
Coding Invaders
Applied hard & soft skills after the course
Who created the program
The course is developed by field experts: Data Analysts, software engineers, and business consultants. Make experience of the best professionals work for your success!
SYLLABUS
In 8 months you will master all skills needed to be employed as a Data Analyst. The course contains 22 week-long modules of theory and practice, 10 group cases from real business and 3 exams to test your skills and employability
Google Sheets
Block 1. Google Sheets Theory & Practice. 6 weeks, 60 hours
1) Basics
- Preparation
- Formatting
- Calculation
- Automate
- IF
- VLOOKUP
- COUNTIF
- SUMIF
- SUMIFS
- Introduction
- Analyzing data using pivot table
- Putting it all together
Block 2. Two real business cases
- Reports for a retail store brand
- Group project for video content platform
SQL
Block 3. SQL Theory & Practice. 7 weeks, 70 hours
1) Operators and Queries
- Introduction to SQL and its terminology
- Basics
- Working with Operators
- Working with Strings & Datetime
- Mastering complex SQL Queries with basic statements
- Aggregate functions
- HAVING clause
- SQL Joins
- Sub Queries
- Windows functions
- CONTROL FLOW FUNCTIONS
- HANDLING NULL VALUES
- DATABASE NORMALIZATION
Block 4. Two real business cases
- Project for an investment bank
- Project for YouTube video trends
Statistics
Block 5. Statistics Theory & Practice. 5 weeks, 50 hours
1) Basics
- Intro to statistics
- Central tendency, variance
- Inferential Statistics
- Types of Probability Distribution
- Exploratory data analysis
- Data Preprocessing
- Hypothesis testing (parametric tests)
- Chi square test and 1 way ANOVA
Block 6. Real business case
- Project for a bank
Power BI
Block 7. Power BI Theory & Practice. 6 weeks, 60 hours
1) Setup and dashboards
- Introduction to Power BI
- Connecting to data sources and Creating basic charts and visuals
- Cleansing data with Query Editor
- Creating Report by combining all visuals
- Types of Visuals in Power BI
- Managing Relationships between Tables in Power BI
- Addition of New columns using Power Query
- Transforming Columns in Query Editor
- Modeling and Optimization
- Customisations
- Interactions
- Introduction to DAX
Block 8. Two real business cases
- Project for a Finance department of a company
- Project on supply chain domain to optimize the supply and profit
Python
Block 9. Python Theory & Practice. 6 weeks, 60 hours
1) Operators and functions
- Introduction
- Installation
- Basic operators
- Brief on Jupyter notebook
- Data types, variables, and Numbers
- Strings
- List
- Conditional statements if/else
- Looping
- Functions
- Introduction on Numpy
- Creating arrays
- Indexing arrays
- Array Transposition
- Shape manipulation
- Conditional Selection
- Array Operations
- Broadcasting
- Introduction to pandas
- Reading local data set
- How to read data files from pandas
- How to write data using Pandas
- Creating dataframe
- Playing with Rows and columns of dataframe
- Filters and operations using dataframe
- Handling missing values using Pandas
- Usage of apply function in pandas
- Aggregate data in Pandas
- Merge operation on dataframes
- Introduction to Matplotlib
- Basics of Matplotlib figure
- Creating Line Plots
- Adding texts to plots
- Adding legend
- Adding labels
- Applying different styles
- Subplots
- Scatter Plot
- Bar chart
- Pie Chart
- Histogram
- Heat map
- Plotting Curves
- Brief on visualization python libraries
Block 10. Two real business cases
- Project for a Global Health
- Project for a Fleet Maintenance
Student’s reviews and success stories
Media writes about us
DIGITAL FIRST MAGAZINE
HIGER EDUCATION DIGEST
HINDUSTAN TIMES
YOUR STORY
INDIA TODAY
TECHIEXPERT
FINANCIAL EXPRESS
THE PRINT
Livemint
Media writes about us
Sale offer
Register before
midnight of February 20th
midnight of February 20th
Tuition
Rs 6 500 / month
(12 months no cost EMI)
-20%
Our counselor will contact you shortly to answer all your questions about profession and course and to provide full syllabus
Just type your contacts
CODING INVADERS PRIVATE LIMITED
The Tax Deduction and Collection Account Number (TAN) of the company is PNEC15378G
Registration Number : 27AAJCC3027H1ZS
Address: Office No. 202 Kamal Kirti, B Wing, Second Floor, Sr. No 120 AB/3, Pune,Pune, Maharashtra, India, 411030
The Tax Deduction and Collection Account Number (TAN) of the company is PNEC15378G
Registration Number : 27AAJCC3027H1ZS
Address: Office No. 202 Kamal Kirti, B Wing, Second Floor, Sr. No 120 AB/3, Pune,Pune, Maharashtra, India, 411030
