Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python [FREE]

September 18, 2022

Free Certification Course Title: Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python

Begin data analytics by learning Excel, SQL, Python, Analytics & ML concepts from scratch. Must-know for a data analyst

What you’ll learn:

A Beginner’s Guide to Microsoft Excel – Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, Macros
Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index and Match
Make great presentations using Bar charts, Scatter Plots, Histograms etc.
Knowledge of all the essential SQL commands
Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
Become competent in using sorting and filtering commands in SQL
Learn how to solve real life problem using the Linear Regression technique
Indepth knowledge of data collection and data preprocessing for Machine Learning Linear Regression problem
Understand how to interpret the result of Linear Regression model and translate them into actionable insight

Requirements:

Only a PC with any version of Excel installed is needed for this course on “Data Analyst Skillpath: Zero to Hero in Excel, SQL & Python””

Who this course is for:

Anyone curious to master Data Analysis in a short span of time
Business Analysts/ Managers who want to expand on the current set of skills

Description:

You’re looking for a complete course on how to become a data analyst, right?

You’ve found the right Data Analyst Masterclass with Excel, SQL & Python course! This course will teach you data-driven decision-making, data visualization, data analytics in SQL, and the use of predictive analytics like linear regression in business settings.

After completing this course you will be able to:

Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index, and Match
Become proficient in Excel data tools like Sorting, Filtering, Data validations, and Data importing
Make great presentations using Bar charts, Scatter Plots, Histograms, etc.
Become proficient in SQL tools like GROUP BY, JOINS, and Subqueries
Become competent in using sorting and filtering commands in SQL
Learn how to solve real-life business problems using the Linear Regression technique
Understand how to interpret the result of the Linear Regression model and translate them into actionable insight