- Basics
- Preparation
- Formatting
- Calculation
- Automate
- Home
- Coding Invaders
- Courses
- Data Analytics from scratch
Data Analytics from scratch
Learn about the basic to the advanced level tools and techniques of data analytics to become an efficient data analyst.
Online
6 Months
₹ 11,490
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
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
certificate providing authority
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
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.
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.
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.
The syllabus
Google Sheets
Module 1: Basics
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
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
The course is provided by the online education platform Coding Invaders.
No, you don’t need any prior experience.
No, the course consists of live sessions, assignments, exams, and projects as part of the course curriculum.
It will take eight months to complete the program.
Yes, you will receive the certificate of completion after the training.