The Complete Data Analyst Course: From Zero to Data Hero!

Learn how to use Excel, Python, NumPy, Pandas, Matplotlib, Seaborn, Sckit-Learn and SQL for data analysis!

Created by: Jenson Berry
Data Analyst, Architect and Teacher

What Will I Learn?

• Master the fundamentals of data analysis and understand the data analysis process
• Use Microsoft Excel for data manipulation, analysis, and visualisation
• Create dynamic and interactive Excel PivotTables and PivotCharts
• Implement advanced Excel functions and formulas for data analysis
• Clean and prepare data using Excel and Python
• Perform Exploratory Data Analysis (EDA) with Excel and Python
• Program with Python from scratch
• Use NumPy for numerical data manipulation and analysis
• Utilise Pandas for complex data operations and data manipulation
• Visualise data with Matplotlib and create various plot types
• Create beautiful statistical plots with Seaborn
• Apply SQL for querying databases and performing data analysis
• Understand database fundamentals and SQL syntax
• Develop machine learning models with Scikit-Learn, including logistic regression
• Build a strong portfolio with hands-on projects that mimic real-world scenarios
• Gain extensive theoretical knowledge with downloadable slides and lecture notes
• Test your skills with coding challenges and practice activities
• Understand the importance of data visualisation and create advanced chart types
• Develop real-world projects to showcase your data analysis skills

Requirements

• No data analysis or coding experience is required to take this course - I will take you from a beginner to expert!
• A basic understanding of Excel and Python would be helpful, but not a requirement! The course includes a crash course on Excel and Python.

Target audience

• Beginners with no prior experience who want to start a career in data analysis.
• Individuals in other fields looking to transition into a data analysis role.
• Great for students or recent graduates in any field who want to gain valuable data analysis skills.
• Anyone interested in understanding how to collect, analyse and visualise data to uncover insights.