LEARN DATA ANALYTICS WITH PYTHON & EXCEL
Today there is a growing number of students who want to become Data Analysts which is the need of the hour. The tools that students and professionals are learning are Excel, Python, R, and others. Python is the most popular of all due to the simplicity of commands and the comprehensive output it gives.
Before you start the course you need to pause and ask a question, How do I develop an Analytical Mind-Set. I may learn the tools but if I don’t have the analytical mindset I may struggle with the data and end up using only the data entry skill set.
We encourage students who wish to start their career in Data Analytics to do a basic course for beginners which teaches you the tools and also gives you an insight into what data is, along with how to read, visualize, focus, interpret the same.
TOPICS COVERED IN 30 HOURS
- Overview of Python, Excel, Jupyter & Data Analysis
- Excel for Data Analysis
- Operations & Variables
- Data Types and It’s Usage
- Conditional Statements
- Looping Construct
- Data Structure
- List Functions
- Tuple Functions
- Functions (Def)
- Numpy & Basic Functions
- Pandas Data Frame and Basic Operations
- Reading & Writing Csv & Excel Files in Python
- Data Cleaning
- Data Manipulation
- Types of Graphs & Its UA
- Data Visualization (Numbers & Figures)
- Basic Understanding of Descriptive & Inferential Data
- Basic Understanding of Linear Regression & Correlation
- Assessment (Assignment – Project)
Who Can Learn this Course?
While being a specialization course, our data analytics course, with python & excel also includes the very basics there are for a newcomer to know, making it an asset for the following demographics:
Students: Those who don’t have prior programming knowledge and who wish to start their career working with data. (Knowledge of math’s is optional)
Principals and Teachers: Teachers who wish to upgrade their skills in analyzing class performance and who wish to create good insightful reports for their management.
Managers: Managers from any field who wish to dive deep into their data and learn how to analyze data and present insightful reports which will help in decision making.
Marketing and Sales Professionals: Professionals working in the field of marketing and sales who work with data can enhance their profiles with this course.
Research Professionals: professionals who want to learn how to use python and excel to develop their reports will find this course very insightful.
