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.

What you'll learn?

This basic course is created carefully to ensure everyone finds it easy to do and it will also develop an interest in the subject and get you equipped to start working with data. Our course provides a very thorough understanding of the basics in the field, helping you to upgrade your skills by doing other advanced courses in the field. Practicing the concepts taught is the key to proficiency. We prepare our students to be confident enough to use the tools and techniques that they will need to perform data analytics activities with ease and confidence.