Learning Data Analytics: 1 Foundations
4.7 /5- Offered byLinkedin Learning
Learning Data Analytics: 1 Foundations at Linkedin Learning Overview
Duration | 4 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Learning Data Analytics: 1 Foundations at Linkedin Learning Highlights
- Earn a sharable certificate
Learning Data Analytics: 1 Foundations at Linkedin Learning Course details
- 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 learner to SQL queries, PowerBI, and more
- Robin goes into syntax and explains how to interpret the data learner see, find the data learner need, and clean the data for effective data work
Learning Data Analytics: 1 Foundations at Linkedin Learning Curriculum
Introduction
Beginning your data analysis journey
What you should know
Using the exercise files
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
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
Challenge: Reading SQL
Solution: Reading SQL
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
Challenge: Products are not categorized
Solution: Products are not categorized
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
Data Importing, Exporting, and Connections
Learning about data governance
Understanding source data
Working with flat files
Working with connections
Creating datasets for others
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
Challenge: Rename headers in Power Query
Solution: Rename headers in Power Query
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
Challenge: Count and amounts of products
Solution: Count and amounts of products
Conclusion
More resources for your learning data analytics journey
Learning Data Analytics: 1 Foundations at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?