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

Focused View

Jenson Berry

14:45:50

24 View

1. Welcome!

1. The Complete Data Analyst Course From Zero to Data Hero!.mp4

05:04

2.1 002 - Course Materials.zip

2. Read Before Starting.html

2. Data Analysis Fundamentals and Career Path

1. Introduction to Data Analysis.mp4

09:16

2. Types of Data & The Data Analysis Stages.mp4

10:11

3. Quiz Categorising Data Types of Data.html

4. Data Analyst vs. Data Scientist & Career Path.mp4

05:59

3. Microsoft Excel Fundamentals

1. Introduction to Excel.mp4

06:25

2. Excel Basics.mp4

09:26

3. Basic Formulas and Functions.mp4

16:00

4. Working With Data - Data Tools

1. Importing Data.mp4

05:40

2. Sorting Data.mp4

06:10

3. Filtering Data.mp4

05:23

4. What-if Analysis (Goal Seek + Scenario Manager).mp4

07:00

5. Conditional Formatting.mp4

05:09

6. Additional Excel Tools.mp4

12:29

7. Data Analysis Addon Pack.mp4

08:46

5. Working with Data - Essential Functions

1. Ultimate LOOKUP Tutorial (VLOOKUP, HLOOKUP, XLOOKUP).mp4

09:35

2. Conditional Functions (IF, IFERROR, Nested Functions and More!).mp4

08:48

3. Text-based Functions Part 1 (LEFT, MID, RIGHT).mp4

07:22

4. Text-based Functions Part 2 (TRIM, CONCAT, LEN ).mp4

05:30

5. Date-time Functions.mp4

05:52

6. Mathematical Functions Part 1 (COUNTIF, SUMIF, COUNTA).mp4

06:26

7. Mathematical Functions Part 2 (SEQUENCE, LARGESMALL, RANK and More!).mp4

06:38

6. Microsoft Excel Data Visualisation & Graphs

1.1 data-visualisation-starter.xlsx

1. The Importance of Data Visualisation & Creating our First Chart.mp4

16:05

2. Chart Formatting + Chart Elements.mp4

09:48

3. Additional Advanced Chart Types.mp4

08:11

7. PivotTables & PivotCharts

1. Introduction to PivotTables.mp4

10:56

2. PivotTable Formatting.mp4

09:56

3. PivotCharts.mp4

09:55

8. Microsoft Excel for Data Analysis - An Example

1. Cleaning Data with Microsoft Excel.mp4

29:09

2. Data Analysis EDA with Microsoft Excel.mp4

30:39

9. Environment Setup and Overview

1.1 002 - Course Materials.zip

1. Python Anaconda Installation.mp4

06:51

2.1 002 - Course Materials.zip

2. Anaconda & Jupyter Notebook Overview.mp4

07:42

10. Python Crash Course

1. Data Types, Variables and Printing.mp4

18:48

2. Data Structures and Operators.mp4

18:40

3. If Else-if Else Statements, Loops and Functions.mp4

20:08

4. Lambda Expressions, MapFilterReduce and Modues.mp4

13:48

5. Python Practice Activities.mp4

03:10

6. Python Practice Activities Solutions.mp4

19:08

11. NumPy Basics

1. Introduction to NumPy.mp4

02:26

2. NumPy Arrays (ndarrays).mp4

22:40

3. Indexing and Slicing.mp4

12:37

4. Universal Functions and Other Array Manipulations.mp4

04:42

5. NumPy Practice Activities Overview.mp4

01:32

6. NumPy Practice Activities Solutions.mp4

13:25

12. Pandas Fundamentals

1. Introduction to Pandas.mp4

02:13

2. Data Structures - Series.mp4

12:08

3. Data Structures - DataFrames (Part 1).mp4

14:20

4. Data Structures - DataFrames (Part 2).mp4

08:16

5. Grouping and Sorting Data.mp4

09:41

6. Missing Data.mp4

06:40

7. Combining Datasets.mp4

13:16

8. Dataset Operations.mp4

09:49

13. Pandas Practice Activities

1. Pandas Practice Activities Overview.mp4

02:02

2. Pandas Practice Activities Solutions.mp4

15:14

14. Matplotlib Fundamentals

1.1 Matplotlib Gallery.html

1. Introduction to Matplotlib.mp4

02:30

2. Matplotlib Fundamentals.mp4

08:22

3. Exploring Different Plot Types.mp4

16:55

4. Plot Customisation and Styling.mp4

10:18

5. Figures and Subplots.mp4

16:22

6. Matplotlib Practice Activities Overview.mp4

03:10

7. Matplotlib Practice Activities Solutions.mp4

12:04

15. Seaborn Fundamentals

1.1 Seaborn Gallery.html

1. Introduction to Seaborn.mp4

02:31

2. Seaborn Fundamentals.mp4

16:43

3. Categorical Plots.mp4

10:55

4. Matrix Plots.mp4

16:18

5. Grid Plots.mp4

09:43

6. Styling and Colour.mp4

06:10

7. Seaborn Practice Activities Overview.mp4

03:22

8. Seaborn Practice Activities Solutions.mp4

07:25

16. Python Data Analysis Example Data Loading & Cleaning

1. Project Introduction and Loading our Data.mp4

07:55

2. Cleaning our Data with Python.mp4

19:57

17. Python Data Analysis Example Exploratory Data Analysis

1. Exploratory Data Analysis with Python (Part 1).mp4

10:43

2. Exploratory Data Analysis with Python (Part 2).mp4

13:07

18. Python Portfolio Project

1. Python Portfolio Project Overview.mp4

03:55

2. Python Portfolio Project Solutions.mp4

28:19

19. Introduction to Machine Learning (scikit-learn)

1. Introduction to Machine Learning.mp4

09:46

2. Preparing our Data.mp4

17:09

3. Creating our Machine Learning Model (Logistic Regression).mp4

12:18

20. SQL Essentials for Data Analysis

1. Introduction to Databases and SQL.mp4

07:59

2.1 AdventureWorks Database.html

2.2 Microsoft SQL Server Download.html

2.3 MySQL Installation Guide (macOS).html

2. Installing SQL Server + Importing our Data.mp4

11:48

3. Querying Data with SQL FROM, SELECT and WHERE.mp4

15:02

4. Effective SQL Joins, Grouping, and Aggregate Functions.mp4

23:19

5. Exporting Data from SQL.mp4

09:02

21. The End!

1. Congratulations & Next Steps.mp4

05:39

2. Accessing & Downloading your Certificate.html

Description

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

What You'll 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

Who is this for?

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.

What You Need to Know?

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.

More details

Description
Are you ready to kickstart your career as a data analyst? Welcome to the most comprehensive and in-depth course on Udemy, designed to transform you into a confident and skilled data analyst.
Why Choose This Course?
Data Analysts Are in High Demand! With companies increasingly relying on data-driven decisions, data analysts have become some of the most sought-after professionals globally. According to Glassdoor, the average salary for a data analyst in the United States is over $80,000, and many positions offer remote and flexible working arrangements.
All-in-One Learning Experience! This course is designed for everyone, whether you're a complete beginner or an experienced professional looking to enhance your skills. You'll learn everything from the basics of data analysis to advanced techniques used by industry experts.

What You Will Learn
Data Analysis Fundamentals: Understand the basics of data analysis, types of data, and the different stages of data analysis. Learn the difference between data analysts and data scientists, and explore potential career paths.
Microsoft Excel Mastery: Get hands-on with Excel, starting from the basics to advanced data manipulation tools, essential functions, and data visualisation techniques. Learn to create PivotTables and PivotCharts, and perform comprehensive data analysis using Excel.
Programming with Python: Master the fundamental programming skills needed to manipulate and analyse data efficiently.
Data Handling with Pandas: Learn how to use Pandas for data manipulation and analysis, including working with data frames and handling Excel files.
Data Visualisation: Create stunning visualisations using Matplotlib and Seaborn to present your data insights clearly and compellingly.
SQL for Data Analysis: Understand database fundamentals and SQL syntax. Learn to query databases, join tables, group data, and export your findings for further analysis.
SQL Integration: Connect Python to SQL databases and perform complex queries to manage and analyse your data.
Machine Learning Introduction: Get an introduction to machine learning with Scikit-Learn, covering data preparation, model creation, and logistic regression.

Course Highlights
Over 80 HD Video Lectures: Detailed, high-quality video content to guide you step-by-step through each topic.
Hands-On Projects: Apply your skills in multiple practical projects that mimic real-world scenarios, helping you build a strong portfolio.
Comprehensive Code Notebooks: Access detailed code notebooks for every lecture, ensuring you have all the resources you need to succeed.
Extensive Theory Resources: Benefit from downloadable slides, theory notes, and detailed lecture content that you can reference anytime, providing a solid theoretical foundation to complement your practical skills.
Practice Activities and Challenges: Test your knowledge with coding challenges and assignments designed to reinforce your learning.

Enroll Now / Join the Course Today!
Don't miss this opportunity to become a highly skilled data analyst. Enroll today and start your journey towards a rewarding and lucrative career in data analysis.
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

About MeHi, I'm Jenson! I'm an accomplished, self-taught data analyst and data architect with extensive experience working as a contractor for top firms across various industries, including finance, education, manufacturing, nuclear energy and automotive. With a professional background in cyber security, I bring a unique perspective to data analysis, ensuring robust and secure data solutions.Over the past couple of years, I've successfully led and worked on numerous projects through my own firm, providing innovative and effective data strategies to global companies and public sector clients. My passion for data and its transformative power has driven me to share my expertise and help others unlock their potential in this exciting and growing field.I discovered my passion for teaching early on in my career when I started mentoring and providing training for new team members and conducting in-house cybersecurity training. This passion led me to Udemy, where I can combine my love for teaching with my expertise in data and technology.If you don't want to go through all of the books and thousands of online tutorials and articles that I did, then enrol today for a structured, all-in-one learning experience that will provide you with the most in-demand skills and technologies! I'll be very happy to share my knowledge with and support you every step of the way.Jenson

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.