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.

Created by: Start-Tech Academy
5,000,000+ Enrollments | 4.5 Rated | 160+ Countries

What Will I 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""

Target audience

• 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