Learning Data Analytics Part 2: Extending and Applying Core Knowledge
- Offered byLinkedin Learning
- Private Institute
Learning Data Analytics Part 2: Extending and Applying Core Knowledge at Linkedin Learning Overview
Duration | 4 hours |
Mode of learning | Online |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Learning Data Analytics Part 2: Extending and Applying Core Knowledge at Linkedin Learning Highlights
- Earn a sharable certificate
Learning Data Analytics Part 2: Extending and Applying Core Knowledge at Linkedin Learning Course details
- Robin Hunt, CEO and co-founder of ThinkData Solutions, shares practical skills to help you get the most from your data and jumpstart your career in data
- Robin discusses business rules, filtering out the noise in the data we all deal with, and how to deliver what decision-makers want
- She covers how to create data sets with queries, joins, and appends, then goes into building aggregate data with total queries
- Robin goes over pivots, how to use pivots to build basic dashboards and visualizations, and how to use Power Query for data transformations
- She concludes with best practices for meetings and taking your work to the next level for your organization
Learning Data Analytics Part 2: Extending and Applying Core Knowledge at Linkedin Learning Curriculum
Introduction
Extending your data analysis skills
What you should know
Required software
1. Working with Business Data
Understanding business rules
Understanding noise in data
Breaking down the ask
Challenge: Getting started
Solution: Getting started
2. Building Data Sets with Queries
Understanding queries
Building basic select queries
Building distinct queries
Building queries with Joins
Building append queries
Building total queries
Challenge: Total number of orders by customer
Solution: Total number orders by customer
3. Chart Data Anytime and Anywhere
Ad hoc reporting
Building basic charts visual
Visuals using conditional formatting
Setting templates and default charts
Linking verus embedding charts and data
Challenge: Ad hoc presentation
Solution: Ad hoc presentation
4. Pivot Data Anytime and Anywhere
What are pivots?
Build basic pivot tables
Modifying pivots for readability
Visualizing pivot tables
Using pivots to filter data sets
Challenge: Best customer year
Solution: Best customer year
5. Building in Power BI Desktop
Building dashboards
Building a matrix and visuals
Use cards for numbers
Using visuals in Power BI for filters
Publishing visuals and data sets
Challenge: Product dashboard
Solution: Product dashboard
6. Power Query Tips and Tricks for Data Analysts
Using column profile to learn the data
Appending data by leveraging folders
Duplicate or reference data sets
Unpivoting data from existing reports
Custom sorting in Power BI
Challenge: Custom sort by education
Solution: Custom sort by education
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?