Data Analyst Course
The course will cover Introduction to Data Analytics, Business Analytics with Excel, Tableau training, and Power BI. You will also learn Programming Basics and Data Analytics with Python, R programming, and finally, you will get to work on a Capstone project. This program will help you become a data analyst pro.
Introduction
- Introduction of python {integers, floats and Boolean}
- Introduction of Strings
- Introduction of Lists
- Introduction of Tuple, Sets & Dictionaries
- Statements, Indentation and conditionals
- Loops & Iterations
- List Comprehensions
- Functions & Methods
- Production Grade Programming
- Introduction to Numpy
- Introduction to Pandas
- Pandas Operations
- Data Wrangling
- Introduction to Data Visualizations
- Airbnb Hotel Booking Analysis
- Play Store App Review Analysis
- World Wide Data Scientist/Analyst Salary Analysis
- Introduction to Business KPI’s- 1
- Introduction to Business KPI’s- 2
- Introduction Of Excel
- Excel Formulas
- Excel Data Cleaning
- Visualizations
- Dashboard Formatting & pivot Tables
- Data Analytics Capstone Project using Excel
- Introduction To SQL
- SQL Fundamentals
- SQL Query {SELECT ,DISTINCT,COUNT,WHERE}
- SQL Query {ORDER BY, LIMIT STATEMENT,BETWEEN,IN}
- SQL Query {LIKE & ILIKE, Aggregate Functions}
- SQL Query {GROUP BY, HAVING BY , AS SATEMENT}
- SQL Query {INNER JOIN,FULL OUTER JOIN,LEFT/RIGHT OUTER JOIN}
- SQL Query {FULL OUTER JOIN WITH WHERE,LEFT OUTER JOIN WITH WHERE}
- Advanced SQL {TIMESTAMPS & EXTRACT}
- Advanced SQL {SUB QUERY,SELF JOIN,DATA TYPES}
- Advanced SQL {PRIMARY KEY & FOREIGN KEY}
- Advanced SQL {CONSTRAINTS, TABLE QUERIES}
- Conditional Expressions & Procedures
- Introduction to Tableau
- Tableau Visualization-1
- Tableau Visualization-2
- Tableau Visualization-3
- Dashboard creation using tableau
- HR Analytics Dashboard
- Bike sales Analysis Dashboard
- Top You tuber Artist Analysis Dashboard
CCC
Accounting
Software Development 
Designing
Mobile Development 
Digital Marketing
Specialized Courses 
Live Project Training 
