Ravindra BagaleCourses & study guides मराठी Track your progress

27. Performance Tips

By Last updated:

If a report is slow, users will not wait. In this module we see why reports become slow, how to use Performance Analyzer, how to reduce model size, and what care to take in DAX and design.

What you will learn in this module

  • Finding slow visuals with Performance Analyzer
  • Making the model smaller (reducing cardinality)
  • Relationship and DAX practices that keep reports fast
  • Report design choices that affect speed

Live story: The report takes 40 seconds to open

Suppose the Swiggy Mumbai report has grown to 2 crore rows and opens slowly. Managers stop using a slow report. This chapter finds the slow visual with Performance Analyzer and fixes the model, the columns and the DAX.

All numbers in this story are fictional practice data.

Concepts in this chapter

  1. 27.1Why Reports Become Slow
  2. 27.2Performance Analyzer
  3. 27.3Reduce Model Size and Cardinality
  4. 27.4Relationships
  5. 27.5DAX Best Practices
  6. 27.6Report Design
  7. 27.7Helpful Tools
  8. 27.8Aggregation Tables
  9. 27.9Composite Models: Limits, Dual Mode and a Shared Model

Review and practice

  1. ★Practice and Answer Key: Performance Tuning

The chapter recap is at the end of the last concept page.

Ravi Sir's Cards: 10 revision, interview and comparison cards for this chapter · मराठी cards