The Most Addictive Python and SQL Courses
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Discover how to avoid key mistakes in Microsoft Power BI so you can save time and grow your skills.
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