Advancing into Data Analytics from Excel to Python

Big Data Trunk is all about Big data and Hadoop providing training, placement and job/project assistance on Big data.

Big Data Trunk

This six-hour session will review the foundations of data analytics using Excel and then transfer and advance that knowledge to perform a co

Prerequisite: Learners should have an understanding of Basic Programming and Excel.You will have the opportunity to learn how to conduct exploratory data analysis, data visualization and hypothesis testing, and 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.Learning Objectives:During this course, you will have the opportunity to learn how to:<ul><li>Understand the Foundations of Analytics in Excel</li><li>Explore Variables in Excel</li><li>Understand Exploratory Data Analysis</li><li>Understand the Foundations of Inferential Statistics and Hypothesis Testing</li><li>Use the Python Programming Language for Data Analysis</li><li>Access Excel Files Using Python</li><li>Perform Data Visualization and Exploration in Python</li><li>Perform More Efficient and Deeper Data Analyses using Python</li><li>Explore Correlation and Linear Regression in Excel and Python</li><li>Use Python to Manipulate Excel Files and to perform Machine Learning</li></ul>Topic Outline:<ol><li>Overview of Data Analytics</li><li>Excel Review</li><li><ol><li>Foundations of Analytics in Excel</li><li>Variables in Excel</li><li>Exploratory Data Analysis in Excel</li><li>Data Visualization in Excel</li></ol></li><li>Introduction to the Python Programming Language</li><li><ol><li>Installing Anaconda</li></ol></li><li>Milestone 1: How to use Jupyter Notebooks</li><li><ol><li>Python Essentials</li><li>Introduction to Pandas</li><li>Using Pandas to access Excel files</li><li>Data Analysis with Pandas</li></ol></li><li>Milestone 2: Perform exploratory data analysis using Pandas</li><li><ol><li>Using Python for data wrangling</li><li>Using Python to manipulate Excel files</li><li>Data Visualization in Python: Matplotlib, Pandas, Seaborn</li></ol></li><li>Milestone 3: Perform data visualization using Python</li><li><ol><li>Inferential Statistics and Hypothesis Testing in Python</li><li>Correlation and Linear Regression using Excel and Python</li><li>Using Python to perform machine learning</li></ol></li><li>Milestone 4: Perform complete Python data analysis</li><li>Conclusion: Data Analytics in the real world, and next steps.</li></ol>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Advancing into Data Analytics from Excel to Python

More events from Big Data Trunk

Discover more events from Big Data Trunk, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Advancing into Data Analytics from Excel to Python

More events from Big Data Trunk

Discover more events from Big Data Trunk, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.