Data Analysis for Beginners

Focused View

Matthew Walcott

4:31:28

432 View

1. Introduction

1. Welcome Introduction.mp4

00:56

2. Excel - Data Entry

1. Introduction.mp4

00:51

2.1 Excel for web.html

2. Downloading Excel.mp4

01:34

3. Active Cell.mp4

02:25

4. Excel Introduction.mp4

04:54

5. Entering Data.mp4

05:05

6. Auto-Fit.mp4

02:25

7. Auto-Complete.mp4

03:43

8. Entering Numbers.mp4

02:16

9. Inserting & Deleting ColumnsRows.mp4

01:59

10. Auto Sequencing.mp4

02:19

11. Navigating Edges.mp4

02:46

12. Selecting Cells.mp4

02:05

13. Number Formatting.mp4

06:06

14. Numbers & Fractions.mp4

02:04

15. Currency & Accounting.mp4

02:03

16. Percentage.mp4

01:11

17. Date Format.mp4

02:37

18. Time Format.mp4

01:15

19. Data Entry.html

3. Excel - Formatting

1. Bold, Italics & Underline.mp4

01:47

2. Borders.mp4

01:56

3. Fill & Font.mp4

01:29

4. Alignment.mp4

03:03

5. Formatting.html

4. Excel - Editing

1. Editing a cell.mp4

01:10

2. Autofill.mp4

05:50

3. Copy & Paste.mp4

05:05

4. Sorting.mp4

02:43

5. Filter.mp4

02:23

6. Find and Replace.mp4

02:10

7. Editing Quiz.html

5. Excel - Calculations

1.1 Test sample.xlsx

1. Download File.mp4

00:59

2. Signs.mp4

01:30

3. Functions.mp4

02:20

4. Auto-Sequence with calculations.mp4

02:33

5. SUM.mp4

02:46

6. SUMIF.mp4

02:30

7. SUMIFS.mp4

02:41

8. COUNT.mp4

01:41

9. COUNTIF.mp4

01:54

10. COUNTIFS.mp4

01:47

11. MIN, MAX, AVERAGE.mp4

02:28

12. IFELSE.mp4

01:56

13. VLOOKUP.mp4

04:13

14. TRIM.mp4

00:49

15. LEFTRIGHT.mp4

02:04

16. FIND.mp4

01:22

17. LENMID.mp4

01:41

18. REPLACE.mp4

01:37

19. Calculations.html

6. Excel - Visualisations

1. Tables.mp4

04:40

2. Slicers.mp4

02:13

3. Pivot Tables.mp4

05:40

4. Pivot Charts.mp4

04:00

5. Conditional Formatting.mp4

04:46

6. Save As.mp4

00:59

7. Visualisations.html

7. Excel - Power Query

1. Fetching Data.mp4

02:04

2. Power Query Editor.mp4

03:06

3. Adding Columns.mp4

01:55

4. Conditional Column.mp4

01:22

5. Close & Load.mp4

01:26

6. Key Takeaways.mp4

00:30

7. Excel Power Query.html

8. Power BI - Load Data

1. Power BI introduction.mp4

00:35

2.1 Download Power BI Desktop.html

2.2 Power BI for web.html

2. Download Power BI.mp4

02:14

3.1 list of countries and dependencies.csv

3. Get Data.mp4

02:18

9. Power BI - Data Transformation

1. Power Query.mp4

04:23

2.1 countries.csv

2. New Query.mp4

01:10

3. Merge Query.mp4

06:15

4. Load Data to Model.mp4

00:32

5. Data Transformation.html

10. Power BI - Report Editor

1. Report View.mp4

00:31

2. Report Editor Intro.mp4

02:16

11. Power BI - Visualisations

1. Text Box.mp4

02:06

2. Bringing Data into visualisations.mp4

01:51

3. Styling Visuals.mp4

03:03

4. Conditional Formatting.mp4

01:26

5. General Formatting.mp4

01:47

6. Filters.mp4

04:39

7. Slicers.mp4

08:27

8. Pie Chart.mp4

02:51

9. Donut Chart.mp4

02:41

10. More Visuals.mp4

02:21

11. Column Chart.mp4

02:07

12. Map VisualSyncing Slicers.mp4

02:22

13. Slicer Interactions.mp4

02:13

14. DuplicatingHiding Pages.mp4

01:45

15. Create new hidden pages.mp4

01:56

16. Visualisations Quiz.html

12. Power BI - Navigating Reports

1. Buttons.mp4

09:05

2. Bookmarks.mp4

02:30

3. Navigating Reports.html

13. Power BI - DAX fields

1. Add a column.mp4

01:31

2. DAX todays date.mp4

02:46

3. Measures.mp4

01:47

4. Save & Publish.mp4

01:04

5. DAX Fields - Quiz.html

6. Key Takeaways.mp4

00:47

14. SQL - Getting Started

1. SQL Introduction.mp4

00:26

2.1 SQLite Download link.html

2. Download SQLite.mp4

01:06

15. SQL - Databases

1. Create a database.mp4

01:13

2.1 films.csv

2.2 movie ratings.csv

2. Importing tables.mp4

02:02

16. SQL - Writing Queries

1. Introduction to SQL.mp4

02:49

2. Sams Favourite Word.mp4

03:15

3. Comments.mp4

01:28

4. Select Statement.mp4

02:08

5. SELECT DISTINCT.mp4

01:10

6. WHERE Clause.mp4

01:51

7. ORDER BY.mp4

01:32

8. AND.mp4

01:18

9. OR Operator.mp4

01:22

10. NOT Operator.mp4

01:03

11. UPDATE.mp4

02:10

12. DELETE.mp4

01:32

13. TOPLIMIT.mp4

01:32

14. MAX & MIN.mp4

01:00

15. COUNT.mp4

00:58

16. SUM.mp4

00:56

17. LIKE.mp4

02:17

18. IN Operator.mp4

01:05

19. BETWEEN.mp4

01:08

20. ALIASES.mp4

01:32

21. GROUP BY.mp4

01:58

22. JOIN.mp4

04:36

23. SQL.html

24. SQL.html

25. SQL.html

26. SQL.html

27. SQL.html

28. Key Takeaways.mp4

00:33

17. Project and Outro

1. Employees Analysis project.html

2. Congratulations!.mp4

00:27

Description

Learn the exact technical skills in Excel, Power BI and SQL that you need to land your first job as a Data Analyst

What You'll Learn?

This course provides the complete preparation you need to become a data analyst
Learn how to clean and manipulate in excel
Learn how to code in SQL
Master data visualisation
Learn how to build interactive Power BI dashboards
Learn how to use filters and slicers in excel and Power BI
Learn how to use Power Query for Data transformations
Learn how to build Visualisations in Power BI
Learn how to create Navigation Buttons in Power BI
Learn how to do data preparation
Learn how to create DAX measures in Power BI
Learn how to create charts in Excel
Learn how to do data transformations in excel
Learn VLookup Function
Learn IF, COUNTIF, SUMIF functions in excel
Learn how to create Pivot Charts for Stakeholders
Learn about formatting in excel
Learn how to merge Datasets in Power BI
Learn Joins in SQL
Learn about Databases and Tables
Learn shortcuts in excel and Power BI
Learn Conditional Formatting
Learn how to connect datasets from different sources in Power BI
Learn how to Analyse and Present Data to business Stakeholders
Learn over 20 different SQL statements and operators
Learn how to use aggregations in SQL
Learn how to style your data visuals

Who is this for?

Professionals who don't have a degree but want to become a Data Analyst

Beginners who are interviewing for Data Analyst jobs

Perfect for professionals seeking a career change

Anyone who wants to learn the most frequently used techniques used by analysts

Professionals who want to learn Power BI

What You Need to Know?

No prior knowledge needed. You will learn all the technical skills you need to become a Data Analyst

A positive attitude and willingness to learn

Internet connection

Working computer

More details

Description
This unique Data Analyst course is meticulously designed to provide you with the precise skills needed to excel in the field without drowning you in unnecessary tech jargon. From the fundamentals to advanced techniques, you'll gain hands-on experience in data analysis, visualisation, and interpretation.

The course is split into three sections, Excel, Power BI and SQL. At the end of each section there will be a quiz where you can test your knowledge, there are practical coding exercises and a project at the end of the course.

The goal is to provide you with complete preparation and turn you into an Analyst ready for a Data Analyst job role. To take you there we'll be covering the following topics extensively:
Analysing Data
Manipulating and cleaning Data
Using Vlookups, Pivot tables, charts and various functions in Excel
Building visualisations in Power BI
Using Power Query to automate data cleaning steps
Coding complex queries in SQL
Presenting Data

Unlike other courses, this course focuses solely on the skills demanded by the job market, ensuring you're equipped with the practical knowledge to land your dream job as a Data Analyst. Whether you're a beginner or an experienced professional looking to upskill, this course will empower you to navigate the world of data with confidence and efficiency. Join us and embark on a journey towards a rewarding career in Data Analysis.
Who this course is for:
Professionals who don't have a degree but want to become a Data Analyst
Beginners who are interviewing for Data Analyst jobs
Perfect for professionals seeking a career change
Anyone who wants to learn the most frequently used techniques used by analysts
Professionals who want to learn Power BI

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Matthew Walcott

Instructor's Courses

My name is Matt Walcott, I am a Senior Data Analyst and have worked for some of the world's largest corporations in Insurance, Gaming and E-commerce. I love data and more importantly love teaching. I've mentored many analysts from complete beginners to a very good level and vow to continue doing so. I understand that getting your first job in data to start building your commercial experience can be difficult so I make it my mission to teach the necessary technical skills in an easy way to understand.

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.