Description
In this course, you will :
- defines and explains fundamental concepts such as how to think about data, how to collaborate with others in various roles to get the data you need, and the tools you'll need to work with data, such as Excel and Microsoft Access.
- introduces you to SQL queries, PowerBI, and other features Robin delves into syntax and explains how to interpret the data you see, locate the data you require, and clean the data for efficient data work.
- explains data governance and how to ask the right questions of various departments to gather the data you require
- demonstrates how to work with data, including how to import data, work with flat files like CSVs, and create datasets for others.
Syllabus :
1. Getting Started with Data Analysis
- 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
2. Fundamentals of Data Understanding
- Learning to identify data
- Learning about data fields and types
- Dealing with the data you don't have
- Learning syntax
- Learning basic SQL statements
3. Key Elements to Understand when Starting Data Analysis
- Learning to interpret existing data
- Finding existing data
- Cleaning data
- Understanding data and workflow
- Understanding joins
- Working with joins and validation
4. Getting Started with a Data Project
- Getting started with data projects
- Discovering common beginner mistakes
- Learning Excel datasets
- Learning database datasets
- Maintaining original data
- Understanding truths
5. Data Importing, Exporting, and Connections
- Learning about data governance
- Understanding source data
- Working with flat files
- Working with connections
- Creating datasets for others
6. Getting Started with Data Cleaning and Modeling
- 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
7. Applying Common Techniques for All Data Analysts
- 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