Power BI Mistakes to Avoid (2022)
1hIntermediate2022-02-18
Authors
John David Ariansen
Helping organizations understand and use data
Madecraft
Full-Service Learning Content Company
Course details
As a data expert using Power BI, it’s crucial for you to always be growing your skills. In this course, instructor John David Ariansen helps you do just that—teaching you some of the key mistakes to avoid in Power BI to save time and build your skill set even faster.
Explore the unique challenges and opportunities of using Power BI. Learn how to become a systems thinker, improve your analytic skills, and use visualization more effectively in your work. Discover the importance of pulling in the right amount of data, eliminating extra steps, profiling sources, and removing unnecessary data. John shows you how to use lookup tables and a star schema, as well as why you need to eliminate two-way relationships when modeling, and what you should do instead. Along the way, find out more about visualizations, groups and slicers, tooltips, Top-N analyses, and more, gathering the tools you need to grow your skills and let your data start speaking for itself.
Explore the unique challenges and opportunities of using Power BI. Learn how to become a systems thinker, improve your analytic skills, and use visualization more effectively in your work. Discover the importance of pulling in the right amount of data, eliminating extra steps, profiling sources, and removing unnecessary data. John shows you how to use lookup tables and a star schema, as well as why you need to eliminate two-way relationships when modeling, and what you should do instead. Along the way, find out more about visualizations, groups and slicers, tooltips, Top-N analyses, and more, gathering the tools you need to grow your skills and let your data start speaking for itself.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligencePersonaData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
Introduction
- Improve your Power BI skills
Next-Level Power BI
- Main challenges of Power BI
- Systems thinking vs. ad hoc analysis
- Being an effective analyst
- Keys to effective data visualization
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
Modeling Data
- Create a lookup table
- Use star schema
- Eliminate two-way relationships
- Apply user-friendly value replacements
- Define the right level of granularity
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