Brochure
Enquire
- Basics
- Preparation
- Formatting
- Calculation
- Automate
- Home
- Coding Invaders
- Courses
- Data Analytics from scratch
Data Analytics from scratch
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
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.
Articles
Popular Articles
prev
next
Latest Articles
Data Science vs Data Analytics - Difference between Data Science and Data Analytics
Updated On 06 Nov, 2024
Power of Data Analytics in Shaping Product Strategy and Gaining a Competitive Edge
Updated On 06 Jun, 2024
prev
next
