Comparing ATI, CCT and SCM in Power BI for Performance and Applications: An Analytical Approach
Year: 2025
Type: article
Abstract: This research undertakes a comparative evaluation of three distinct approaches to time intelligence modeling within Microsoft Power BI: Auto-Time Intelligence, Custom Calendar Tables, and Imported Semantic Calendar Models. Drawing on a comprehensive dataset and leveraging Power BI’s Performance Analyzer, the study examines core time-based metrics such as Year-over-Year (YoY) and Month-over-Month (MoM) growth across a variety of visualizations. The results demonstrate that Custom Calendar Tables consistently outperform the other models in terms of visual responsiveness and processing efficiency. By offering a practical performance assessment alongside real-world use cases, this study provides valuable insights for business intelligence developers seeking optimized and scalable reporting solutions.
Author: Aniket Alvekar
Language: English
Subfield: Management Information Systems
Domain: Social Sciences
Open Access status: diamond
OpenAlex ID: W4414545402
FWCI:
Cites:
Cited by:
Related to: