Share Description
In this course, you will learn:
- Learn how to identify your data set—including the data you don't have—and interpret and summarize data. She also shows how to perform specialized tasks such as creating workflow diagrams, cleaning data, and joining data sets for reporting.
Syllabus:
- Introduction
- What you should know
- How to use the exercise files
1. Getting Started with Data Analysis
- Defining data analysis and data analyst
- Discovering if you are an analyst
- Understanding roles in data analysis
- 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 we don't have
- Learning syntax
3. Key Elements to Understand When Starting Data Analysis
- Learning to interpret existing data
- Finding existing data
- Understanding joins
- Understanding data and workflow
- Cleaning data
4. Getting Started with a Data Project
- Getting started with data best practices
- Learning about data governance
- Understanding truths
- Discovering common mistakes of beginners
5. Repurposing Data versus Remanufacturing Data
- Repurposing data
- Understanding source data
- Creating reusable data
- Building data sets to filter data
6. Working with Business Data
- Understanding business rules
- Creating a data dictionary
- Creating read me information
- Documenting data procedures
7. Chart Data Anytime and Anywhere
- Building basic charts visual
- Linking versus embedding charts and data
- Setting default charts and charts shortcuts
8. Pivot Data Anytime and Anywhere
- Build in basic pivots
- Modifying pivots to make them more meaningful to read
- Building pivot charts with slicers
9. Excel Tips and Tricks for Data Analysts
- Selecting data and naming data
- Learning to split text with delimiters
- Removing duplicates
- Transposing data
