A Data Science Approach to Predictive Analytics: Using PowerBI and SQL for Business Intelligence
International Journal on Advanced Computer Theory and Engineering · 14.08.2025 · 14 (1) · 734-741
DOI: 10.65521/ijacte.v14i1.1530 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal on Advanced Computer Theory and Engineering, online erschienen am 14.08.2025. Verfasst von Vijay Kiran Katikala. Der Volltext ist frei zugänglich (Open Access, CC BY-ND 4.0).
Abstract (Originalsprache)
Predictive analytics plays a crucial role in enhancing decision-making in today’s data-driven business environment. This study explores a comprehensive data science approach to predictive analytics by integrating SQL and Power BI to develop effective business intelligence tools. SQL serves as the foundation for data extraction, transformation, and storage, ensuring data integrity and accessibility. Meanwhile, Power BI enhances data visualization, dashboarding, and real-time insights, allowing businesses to interpret complex datasets effortlessly. The paper delves into the methodologies involved in data modeling, statistical analysis, and machine learning, which help uncover patterns, predict future outcomes, and enable data-driven decision-making. By leveraging SQL's structured querying capabilities alongside Power BI’s interactive analytics, businesses can gain valuable insights, improve operational efficiency, and refine strategic planning. Furthermore, this study highlights the synergy between structured data processing and dynamic visualization, demonstrating how organizations can harness predictive analytics to stay competitive, optimize processes, and drive innovation.
Zitieren
APA
Katikala, V. K. (2025). A Data Science Approach to Predictive Analytics: Using PowerBI and SQL for Business Intelligence. International Journal on Advanced Computer Theory and Engineering, 14(1), 734-741. https://doi.org/10.65521/ijacte.v14i1.1530
Vancouver
Katikala VK. A Data Science Approach to Predictive Analytics: Using PowerBI and SQL for Business Intelligence. International Journal on Advanced Computer Theory and Engineering. 2025;14(1):734-741. doi:10.65521/ijacte.v14i1.1530
BibTeX
@article{Katikala2025,
author = {Katikala, Vijay Kiran},
title = {A Data Science Approach to Predictive Analytics: Using PowerBI and SQL for Business Intelligence},
journal = {International Journal on Advanced Computer Theory and Engineering},
year = {2025},
volume = {14},
number = {1},
pages = {734--741},
doi = {10.65521/ijacte.v14i1.1530}
}
EUVIMED