Learning Data Analytics: 1 Foundations

Course details

Are you interested in pursuing a career in data analytics? In this course, instructor Robin Hunt brings you into the mind of an analyst. She defines and explains foundational concepts, such as how to think about data, how to work with others in different roles to get the data you need, and the tools you need to work with data, such as Excel and Microsoft Access. She introduces you to SQL queries, PowerBI, and more. Robin goes into syntax and explains how to interpret the data you see, find the data you need, and clean the data for effective data work. She explains data governance and how to ask the right questions of different departments to gather the data you need. Robin shows how to work with data, including how to import data, work with flat files such as CSVs, and create datasets for others. Robin goes into what cleaning and modeling mean, as well as how to use Power Query in Excel. She has also added challenge/solution sets in each chapter to help you evaluate your skills.

Concepts

0. Introduction

01 - Beginning your data analysis journey
02 - What you should know
03 - Using the exercise files

1. Getting Started with Data Analysis

04 - Defining data analysis and data analyst
05 - Discovering if you are an analyst
06 - Organizational roles in data
07 - Understanding types of data job roles
08 - Discovering skills of the data analyst

2. Fundamentals of Data Understanding

09 - Learning to identify data
10 - Learning about data fields and types
11 - Dealing with the data you don't have
12 - Learning syntax
13 - Learning basic SQL statements
14 - Challenge - Reading SQL
15 - Solution - Reading SQL

3. Key Elements to Understand when Starting Data Analysis

16 - Learning to interpret existing data
17 - Finding existing data
18 - Cleaning data
19 - Understanding data and workflow
20 - Understanding joins
21 - Working with joins and validation
22 - Challenge - Products are not categorized
23 - Solution - Products are not categorized

4. Getting Started with a Data Project

24 - Getting started with data projects
25 - Discovering common beginner mistakes
26 - Learning Excel datasets
27 - Learning database datasets
28 - Maintaining original data
29 - Understanding truths

5. Data Importing, Exporting, and Connections

30 - Learning about data governance
31 - Understanding source data
32 - Working with flat files
33 - Working with connections
34 - Creating datasets for others

6. Getting Started with Data Cleaning and Modeling

35 - Understanding ETL in data
36 - Cleaning data using Excel macros
37 - Cleaning data with Power Query
38 - Working with reusable data
39 - Modeling data with queries
40 - Modeling data in Power Query
41 - Challenge - Rename headers in Power Query
42 - Solution - Rename headers in Power Query

7. Applying Common Techniques for All Data Analysts

43 - Convert data in Power Query
44 - Finding and removing duplicates
45 - Changing case and replace values
46 - Combining data with merge columns
47 - Creating logical functions
48 - Building aggregate datasets
49 - Challenge - Count and amounts of products
50 - Solution - Count and amounts of products

Conclusion

51 - More resources for your learning data analytics journey