Description:
Excel users will review the foundations of data analytics using Excel and then transfer and advance that knowledge to perform a complete data analysis using the Python programming language. You will learn how to conduct exploratory data analysis, data visualization and hypothesis testing, and you’ll learn how to use Python to access and manipulate Excel files. At the end of the course, you will be able to perform a complete data analysis using Python.
Course Code/Duration:
BDT127 / 1 Day
Learning Objectives:
After this course, you will be able to:
- Understand the Foundations of Analytics in Excel
- Explore Variables in Excel
- Understand Exploratory Data Analysis
- Understand the Foundations of Inferential Statistics and Hypothesis Testing
- Use the Python Programming Language for Data Analysis
- Access Excel Files Using Python
- Perform Data Visualization and Exploration in Python
- Perform More Efficient and Deeper Data Analyses using Python
- Explore Correlation and Linear Regression in Excel and Python
- Use Python to Manipulate Excel Files
- Use Python to Perform Machine Learning
