Skip to content
Research Article Open access CC BY 4.0

Comparing ATI, CCT and SCM in Power BI for Performance and Applications: An Analytical Approach

Aniket Alvekar

Journal of Economics, Management and Trade · pp. 147–156 · Published 26 Sep 2025

10.9734/jemt/2025/v31i91355

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.

Business intelligence power BI auto-time intelligence custom calendar semantic model

Cited by 0

No indexed citations yet.

Article metrics

Real usage data collected on this platform.

27

Page views

0

PDF downloads

3

Outbound clicks

0

Citations

Views over time

Views by country

Approximate, from request IP at view time — not citizenship or institution. Countries with fewer than 5 views are grouped as "Other".

Traffic sources

Referring site, by host.

Views and downloads exclude known bots/crawlers. Citations combines this platform's own DOI-resolved index with each external source's own reported total — see Cited by above for individually listed citing works. Last refreshed 0 seconds ago.