Learning Data Analytics Part 2: Extending and Applying Core Knowledge

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

7. Presenting Data in Meetings

• Consider how to present data in meetings
• What to do before going company wide
• Leveraging PowerPoint for presentations
• Documenting data procedures
• Challenge: Highlight dashboard using PowerPoint
• Solution: Highlight dashboard using PowerPoint

Conclusion

• Continuing on with data analysis