Description
In this course, you will :
- shares practical skills to help you get the most out of your data and kickstart your data career
- discusses business rules, filtering out the noise in the data that we all deal with, and delivering what decision-makers want.
- covers how to build data sets with queries, joins, and appends, then moves on to aggregate data with total queries.
- how to use pivots to create basic dashboards and visualisations, and how to use Power Query to transform data
- concludes with best practises for meetings and taking your organization's work to the next level
Syllabus :
1. Working with Business Data
- Understanding business rules
- Understanding noise in data
- Breaking down the ask
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
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
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
5. Building in Power BI Desktop
- Building dashboards
- Building a matrix and visuals
- Use cards for numbers
- Using visuals in Power BI for filters
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
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