The Data Analyst Profession: from scratch to Employment
- Job guarantee
- From scratch
- 1-1 mentorship
Start your Career with : Data Science program from Scratch
- Job guarantee
- From scratch
- 1-1 mentorship
START
11TH FEB
FORMAT
ONLINE
DURATION
5 MONTHS
LANGUAGE
ENGLISH
About Profession
Data analytics is one of the most in-demand professions of the 21st century
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
diverse business processes
Visualizes
the results
The year 2023 is a golden opportunity to advance your skills and work as a Data Analyst professionally!
Great news for the IT aspirants
Join Coding Pact Professional Data Analyst Course & avail one on one Mentorship!
- 100% Job Guarantee
- 10+ projects
- Life time access to the course and certificate
- 1-1 dedicated mentorship
- 10+ tools and technologies
- 700+ assignments
Why Data Analytics?
Intense Demand
Companies are spending a lot of money on data analytics and specialists who can handle these procedures because the world is entirely data-driven.
Comparable pay
A fresher's annual pay is typically around INR 5 LPA to 7 LPA.
Entry with any background
Big data is a multidisciplinary field that involves collaboration between people with various backgrounds.
Job requirements
Possibility of employment with major businesses both in India and abroad
Demand is really high
For business to make the best judgements, data analysts are required.
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
How It works
Golden opportunity to upskill yourself & become a professional Data Analyst in 2023!
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, HCL, Philips etc.,
2 live sessions a week
Every saturday and sunday,we conduct 2 lives classes for 3 hours
1 on 1 Mentorship
You can connect with my mentors every day from 12 PM to 8 PM
What Is the Program?
The Data Analyst program is a 5 Months online Live Program.
What will I learn ?
Google sheets
SQL
Statistics
Power BI
Python
Syllabus
| Module 1. Basics | |
| 1 | Basics |
| 2 | Preparation |
| 3 | Formatting |
| 4 | Calculation |
| 5 | Automate |
| Module 2. Functions | |
| 6 | IF |
| 7 | VLOOKUP |
| 8 | COUNTIF |
| 9 | COUNTIFS |
| 10 | SUMIF |
| 11 | SUMIFS |
| Module 3. Pivot tables and dashboards | |
| 12 | Introduction to Pivot Tables |
| 13 | Analyzing data using pivot table |
| 14 | Putting it all together |
| Module 1. Operators and Queries | |
| 1 | Introduction to SQL and its terminology |
| 2 | Basics |
| 3 | Working with Operators |
| 4 | Working with Strings & Datetime |
| 5 | Mastering complex SQL Queries with basic statements |
| Module 2. Advanced Queries | |
| 6 | Aggregate functions |
| 7 | HAVING clause |
| 8 | SQL Joins |
| 9 | Sub Queries |
| Module 3. Advanced functions | |
| 10 | Windows functions |
| 11 | CONTROL FLOW FUNCTIONS |
| 12 | HANDLING NULL VALUES |
| 13 | DATABASE NORMALIZATION |
| Module 1. Basics | |
| 1 | Intro to statistics |
| 2 | Central tendency, variance |
| 3 | Inferential Statistics |
| 4 | Types of Probability Distribution |
| Module 2. Data and hypothesis | |
| 5 | Exploratory data analysis |
| 6 | Data Preprocessing |
| 7 | Hypothesis testing (parametric tests) |
| 8 | Chi square test and 1 way ANOVA |
| Module 1. Setup and dashboards | |
| 1 | Introduction to Power BI |
| 2 | Connecting to data sources and Creating basic charts and visuals |
| 3 | Cleansing data with Query Editor |
| 4 | Creating Report by combining all visuals |
| 5 | Types of Visuals in Power BI |
| 6 | Managing Relationships between Tables in Power BI |
| 7 | Addition of New columns using Power Query |
| 8 | Transforming Columns in Query Editor |
| Module 2. Modeling and Optimization | |
| 9 | Modeling and Optimization |
| 10 | Customisations |
| 11 | Interactions |
| 12 | Introduction to DAX |
| Module 1. Operators and functions | |
| 1 | Introduction |
| 2 | Installation |
| 3 | Basic operators |
| 4 | Brief on Jupyter notebook |
| 5 | Data types, variables, and Numbers |
| 6 | Strings |
| 7 | List |
| 8 | Conditional statements if/else |
| 9 | Looping |
| 10 | Functions |
| Module 2. Arrays | |
| 1 | Introduction on Numpy |
| 2 | Creating arrays |
| 3 | Indexing arrays |
| 4 | Array Transposition |
| 5 | Shape manipulation |
| 6 | Conditional Selection |
| 7 | Array Operations |
| 8 | Broadcasting |
| Module 3. Datasets and dataframes | |
| 1 | Introduction to pandas |
| 2 | Reading local data set |
| 3 | How to read data files from pandas |
| 4 | How to write data using Pandas |
| 5 | Creating dataframe |
| 6 | Playing with Rows and columns of dataframe |
| 7 | Filters and operations using dataframe |
| 8 | Handling missing values using Pandas |
| 9 | Usage of apply function in pandas |
| 10 | Aggregate data in Pandas |
| 11 | Merge operation on dataframes |
| Module 4. Plots and charts | |
| 1 | Introduction to Matplotlib |
| 2 | Basics of Matplotlib figure |
| 3 | Creating Line Plots |
| 4 | Adding texts to plots |
| 5 | Adding legend |
| 6 | Adding labels |
| 7 | Applying different styles |
| 8 | Subplots |
| 9 | Scatter Plot |
| 10 | Bar chart |
| 11 | Pie Chart |
| 12 | Histogram |
| 13 | Heat map |
| 14 | Plotting Curves |
| 15 | Brief on visualization python libraries |
Certificate
Tuition Fees
A data analyst is a professional who works with data to extract valuable insights from it. Data Analyst:
Choose Interest – Free Installment & Pay
Rs.7190/- per month
For 12 Months!**
**Arrange EMI in one of our partner banks
One Time Payment Is:
Rs.86280**
Pay less if you pay in one payment
Sale Offer
Rs.12500/- month
Rs.7,090/-month
(6 months no cost EMI)
Register before mid-night
Choose your enrollment package
Job Assistance
- Resume and LinkedIn Enhancement
- Mock Calls and Interview Question Bank
- Accounts in LinkedIn,Hirist,Github
- 200 + Job Openings and referrals
- Life time placement Assistance till you get placed
- Actual Price 74,999
Job Guarantee
- Resume and LinkedIn Enhancement
- Mock Calls and Interview Question Bank
- Accounts in LinkedIn,Hirist,Github
- 200 + Job Openings and referrals
- Job Guarantee in 180 days after course completion or else refund
- Actual Price 1,03,757