- Job guarantee
- From scratch
- 1-1 mentorship
The Data Analyst Profession: from scratch to Employment
English
Language
8 months
Duration
Online
Format
10th July
Start
Book a place till 30th of June and get 35% off!
We provide end-to-end assistance, from learning basic analytical tools to further support in building a career.
You will study Data Analytics in a Simulator format with industry projects and a full live support.
100% JOB
ORIENTED
COURSE
ORIENTED
COURSE
i don't know how to get relevant skills and start a great career in IT
Got an action plan to climb next career ladder to Business Analyst
Moved from Sales to IT as a Data Analyst
I got Certification in Data Analytics
Data analytics is one of the most in-demand professions of the 21st century
About Profession
What does a Data Analyst do?
A data analyst is a professional who works with data to extract valuable insights from it. Data Analyst:
Processes and interprets big data
Suggests how to optimize business processes
Visualizes the results
Why Data Analytics?
Because the world is completely data-driven, companies are investing great capital in data analytics and specialists who can manage these processes.
Perspectives
The world of big data is a multidisciplinary field that requires people from a variety of backgrounds to work together.
Entry with any experience
Job conditions
Opportunity to work in big companies in India and worldwide
Competitive wage
The average salary for a fresher is ₹500,000 per annum
The Demand is very high
Business need Data Analysts to make the right decisions
Data analyst career path
Marketing Аnalyst
Business Analyst
Financial Analyst
1-3 years
Junior analyst
4-5 years
Team lead
6 years
Chief Data Officer
8 months
Learning data analytics from scratch
Data Scientist
Data analytics consultant
Data analyst career path
This course is for you if:
You do not have coding experience, but want to get a quick start in IT career
You are a fresher and seeking some real-world experience in IT world
You want to get real skills, and not just a certificate
You want to switch your career from Sales, Finance, Marketing...ANY field, and get a new profession
Get consultation
Ask our manager any questions about this course.
How It works
Our goal is to bring you to the Result in gaining real hard and soft skills in Data Analytics
How does the program work?
You will become a part of a Simulator
Access 1500+ assignments, 30+ capstone projects and real business cases developed by industry experts from companies like Amazon, Deloitte, Philips, Zee TV and many more
3 live sessions a week
You will have
Ask questions from Mentors with industry knowledge
1-1 mentorship
You will be able to become a part of a strong community and expand your Network. We want to create an open environment where students of all batches want to see each other succeed
Strong alumni community
You will have a powerful Career Track including live mock technical interviews with industry experts & live sessions with career coaches
Career track
Learning coordinators track each student's success and progress to help a student to complete the course and not drop it in the middle
Personal Support by Learning coordinator
The Data Analytics Specialization is a comprehensive 8-month program.
What will I know after completing this course?
Google sheets
SQL
Statistics
Power BI
Python
SQL
Statistics
Power BI
Python
What Is Inside
testing
tools
tools
10+
1500+
Access assignments
months
to complete
to complete
8
projects and business cases
30+
Why Coding Invaders?
This course is not only tool focused, but Career focused. Our Career development track will help you to map out your career and prepare for a job market
Simulator format with a full live support
Learning through practice:
exercises and industry projects
After 2 months of studying you can get a job as Manual tester while continuing studying Automation tools
Compare us
Compare
Simulation at Coding Invaders
Other online schools
Live sessions and recorded theory
Simulator based learning
Solving real business cases individually and in groups
24/7 help from your personal mentor
Cases in portfolio
Employment and career help
Other schools
Coding Invaders
Live sessions and recorded theory
Simulator based learning
Coding Invaders
Other schools
Solving real business cases individually and in groups
Coding Invaders
Other schools
24/7 help from your personal mentor
Coding Invaders
Other schools
Cases in portfolio
Coding Invaders
Other schools
Employment and career help
Coding Invaders
Other schools
SYLLABUS
Google Sheets
- Basics
- Preparation
- Formatting
- Calculation
- Automate
- IF
- VLOOKUP
- COUNTIF
- COUNTIFS
- SUMIF
- SUMIFS
- Introduction to Pivot Tables
- Analyzing data using pivot table
- Putting it all together
- Create reports for a retail store brand
- Group project for video content platform
SQL
- 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
- Project for an investment bank
- Project for YouTube video trends
Statistics
- 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
- Project for a bank
Power BI
- 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
- Project for a Finance department of a company
- Project on supply chain domain to optimize the supply and profit
Python
- 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
- Project for a Global Health
- Project for a Fleet Maintenance
Career development
- CV preparation
- LinkedIn profile
- Portfolio
- Interview preparation
- Job search and application
Your skills after completing the course
Student’s reviews and success stories
Sale offer
Register before
midnight of July 10th
midnight of July 10th
Tuition
Rs 8 790 / 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
Days
Hours
Minutes
Seconds
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
