This course covers foundational data analysis skills such as thinking like an analyst, gathering useful data, SQL queries, data cleaning, and more. Are you ready to be an analyst?
Overview
Syllabus
Introduction
- Beginning your data analysis journey
- What you should know
- Using the exercise files
- Defining data analysis and data analyst
- Discovering if you are an analyst
- Organizational roles in data
- Understanding types of data job roles
- Discovering skills of the data analyst
- Learning to identify data
- Learning about data fields and types
- Dealing with the data you don't have
- Learning syntax
- Learning basic SQL statements
- Challenge: Reading SQL
- Solution: Reading SQL
- Learning to interpret existing data
- Finding existing data
- Cleaning data
- Understanding data and workflow
- Understanding joins
- Working with joins and validation
- Challenge: Products are not categorized
- Solution: Products are not categorized
- Getting started with data projects
- Discovering common beginner mistakes
- Learning Excel datasets
- Learning database datasets
- Maintaining original data
- Understanding truths
- Learning about data governance
- Understanding source data
- Working with flat files
- Working with connections
- Creating datasets for others
- Understanding ETL in data
- Cleaning data using Excel macros
- Cleaning data with Power Query
- Working with reusable data
- Modeling data with queries
- Modeling data in Power Query
- Challenge: Rename headers in Power Query
- Solution: Rename headers in Power Query
- Convert data in Power Query
- Finding and removing duplicates
- Changing case and replace values
- Combining data with merge columns
- Creating logical functions
- Building aggregate datasets
- Challenge: Count and amounts of products
- Solution: Count and amounts of products
- More resources for your learning data analytics journey
Taught by
Robin Hunt
