Discover how to avoid key mistakes in Microsoft Power BI so you can save time and grow your skills.
Overview
Syllabus
Introduction
- Improve your Power BI skills
- Main challenges of Power BI
- Systems thinking vs. ad hoc analysis
- Being an effective analyst
- Keys to effective data visualization
- Don't pull in too much data
- Eliminate extra applied steps
- Remember to profile your data sources
- Remove unnecessary rows and columns
- Create a lookup table
- Use star schema
- Eliminate two-way relationships
- Apply user-friendly value replacements
- Define the right level of granularity
- Visualizing time series data
- Use groups to break up the analysis
- Use slicers to improve usability
- Use a custom tooltip to add detail
- Be careful with pie charts
- When to use top-N analysis
- The full potential of visualizations
- Use color sparingly
- Additional resources
Taught by
John David Ariansen and Madecraft
