Data Analytics from scratch

BY
Coding Invaders

Learn about the basic to the advanced level tools and techniques of data analytics to become an efficient data analyst.

Mode

Online

Duration

6 Months

Fees

₹ 11490

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based

Course overview

The ‘Data Analytics from scratch’ certification course is developed for the students to gain knowledge of the concepts and theories of data analytics to begin their career as data analysts. This is a career-oriented online course and is provided by the Coding Invaders educational platform for a duration of eight months. The learners in this program will study through a simulator mode with live sessions and professional mentorship.

This online training will engage the students to gain professional skills and experience from scratch to an established career in data analytics. This online data analyst course offers career guidance and valuable insights on data processing, optimization, and data visualization for those without any background knowledge in data analytics. 

The ‘Data Analytics from scratch’ training course helps the students of the program get hands-on experience with the principles and strategies of data analytics with a course completion certificate after completing the course study.

The highlights

  • Online programme
  • 6.5 months certificate course
  • Data analytics training
  • Mentorship available
  • Career support
  • Course certificate
  • Earn upto 6-15 LPA

Program offerings

  • Simulator format
  • Live sessions
  • Assignments
  • Exercises
  • Mid term exams
  • Career development track
  • Recorded theory
  • Business case solving
  • Personal mentor
  • Course completion certificate
  • Simulator based learning industrial projects

Course and certificate fees

Fees information
₹ 11,490

The candidates of this program should pay  ‘Data Analytics from scratch’ certification fee to join the course

The Data Analytics from scratch fee structure

Program Fee

Rs 8,143/month

Sale Offer

Rs 6,500/month

certificate availability

Yes

certificate providing authority

Coding Invaders

Who it is for

The ‘Data Analytics from scratch’ online certification program is framed for students who are from different fields such as finance, sales, and marketing, and wish to develop their career in data analytics to become data analysts by gaining a comprehensive understanding of the domain through this course.

Eligibility criteria

Certificate qualifying details

The students of this online program will become eligible to receive the Data Analytics from scratch certificate by Coding Invaders after completion of the program.

What you will learn

Knowledge of big data Knowledge of data visualization Statistical skills Sql knowledge Data science knowledge

The ‘Data Analytics from scratch’ certification syllabus is designed for the students to enable students to gain expertise in the knowledge of big data, data analytics, and data visualization. It helps the learners in understanding the tools of Python, Power BI, SQL, and google sheets.

The syllabus

Google Sheets

Module 1: Basics
  • Basics
  • Preparation
  • Formatting 
  • Calculation
  • Automate
Module 2. Functions
  • IF 
  • VLOOKUP
  • COUNTIF
  • COUNTIFS
  • SUMIF
  • SUMIFS
Module 3. Pivot tables and dashboards
  • Introduction to Pivot Tables
  • Analyzing data using pivot table
  • Putting it all together
Projects
  • Create reports for a retail store brand 
  • Group project for video content platform

SQL

Module 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
Module 2. Advanced Queries
  • Aggregate functions
  • Having clause
  • SQL Joins
  • Sub Queries
Module 3. Advanced functions
  • Windows functions
  • Control Flow Functions
  • Handling Flow Functions
  • Database normalisation
Projects
  • Project for an investment bank
  • Project for YouTube video trends
Midterm exam 1

Statistics

Module 1. Basics
  • Intro to statistics
  • Central tendency, variance
  • Inferential Statistics
  • Types of Probability Distribution
Module 2. Data and hypothesis
  • Exploratory data analysis
  • Data Preprocessing
  • Hypothesis testing (parametric tests)
  • Chi-square test and 1 way ANOVA
Projects

Project for a bank

Power BI

Module 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
Module 2. Modeling and Optimization
  • Modelling and Optimization
  • Customisations
  • Interactions
  • Introduction to DAX
Projects
  • Project for a Finance department of a company 
  • Project on supply chain domain to optimize the supply and profit
Midterm exam 2

Python

Module 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
Module 2. Arrays
  • Introduction on Numpy
  • Creating arrays
  • Indexing arrays
  • Array Transposition
  • Shape manipulation
  • Conditional Selection
  • Array Operations
  • Broadcasting
Module 3. Datasets and dataframes
  • 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
Module 4. Plots and charts
  • 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
Projects
  • Project for a Global Health
  • Project for a Fleet Maintenance
Final exam

Career development

Module 1. CV and Portfolio
  • CV preparation 
  • LinkedIn profile 
  • Portfolio
Module 2. Mock interviews and job search
  • Interview preparation 
  • Job search and application

Admission details

The students who are interested in joining The Data Analyst Profession from scratch to Employment, by Coding Invader can apply through the course website.

Step 1: Find the course page using the following link-https://codinginvaders.com/data-analyst-njg

Step 2: Click on the ‘Get Started’ link

Step 3: Fill in the details.

Step 4: Speak to the Counsellor to join the course.

How it helps

The students of the ‘Data Analytics from scratch benefit the students by helping them gain statistical skills and domain knowledge from the basics even without any prior knowledge of the subject. This certification enables students to get guidance for career development and consistent personal support from the coordinators of the course.

FAQs

Which institute offers the ‘Data Analytics from scratch’ certification course?

The course is provided by the online education platform Coding Invaders.

Do I need prior experience in the data analysis field to apply for the ‘Data Analytics from scratch’ classes?

No, you don’t need any prior experience.

Can I learn the ‘Data Analytics from scratch' online course on my own?

No, the course consists of live sessions, assignments, exams, and projects as part of the course curriculum.

How long will it take to complete the ‘Data Analytics from scratch’ training?

It will take eight months to complete the program.

Will I get a certificate for the ‘Data Analytics from scratch’ online training?

Yes, you will receive the certificate of completion after the training.

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books