Introduction
Improve your Power BI skills
()
1. Next-Level Power BI
Main challenges of Power BI?
()
Systems thinking vs. ad hoc analysis
()
Being an effective analyst
()
Keys to effective data visualization
()
2. Connecting to Data
Don't pull in too much data
()
Eliminate extra applied steps
()
Remember to profile your data sources
()
Remove unnecessary rows and columns
()
3. Modeling Data
Create a lookup table
()
Use star schema
()
Eliminate two-way relationships
()
Apply user-friendly value replacements
()
Define the right level of granularity
()
4. Visualizing and Analyzing Data
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
()
Conclusion
Additional resources
()
Ex_Files_PowerBI.zip
(1.0 MB)