This course shows you the top mistakes that you should avoid in Power BI: misunderstanding business problems, using the wrong models, misaligning data, and more.
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