International Journal of Innovative Research in Computer and Communication Engineering
ISSN Approved Journal | Impact factor: 8.771 | ESTD: 2013 | Follows UGC CARE Journal Norms and Guidelines
| Monthly, Peer-Reviewed, Refereed, Scholarly, Multidisciplinary and Open Access Journal | High Impact Factor 8.771 (Calculated by Google Scholar and Semantic Scholar | AI-Powered Research Tool | Indexing in all Major Database & Metadata, Citation Generator | Digital Object Identifier (DOI) |
| TITLE | To Develop an Integrated Business Intelligence and Visual Analytics Framework Using Powerbi |
|---|---|
| ABSTRACT | Business Intelligence (BI) systems are essential for transforming raw organizational data into actionable insights that support strategic and operational decision-making. This project proposes an integrated business intelligence and visual analytics framework using Microsoft Power BI to deliver efficient, interactive, and scalable data analysis solutions. The framework consolidates data from multiple heterogeneous sources and performs data cleaning, transformation, and modeling using Power Query and DAX expressions. Advanced visual analytics techniques such as interactive dashboards, drill-down analysis, slicers, and real-time reporting are employed to analyze key performance indicators, trends, and patterns. The proposed system enables decision-makers to explore data intuitively, identify performance gaps, and forecast future outcomes with improved accuracy. Automation features reduce manual reporting efforts while ensuring data consistency and reliability. Experimental evaluation demonstrates that the framework enhances data transparency, improves business performance monitoring, and supports faster and more informed decision making across domains such as finance, sales, healthcare, and education. The results highlight the effectiveness of Power BI as a comprehensive platform for integrated business intelligence and visual analytics in modern data-driven organizations |
| AUTHOR | VIJAYALAKSHMI N, AVANIKA T, DEEPIKA S, YUVASREE M Assistant Professor, Department of Computer Science and Engineering, P.S.V College of Engineering and Technology, Mittapalli, Krishnagiri, India. UG Scholar, Department of Computer Science and Engineering, P.S.V College of Engineering and Technology, Mittapalli, Krishnagiri, India |
| VOLUME | 183 |
| DOI | DOI: 10.15680/IJIRCCE.2026.1404052 |
| pdf/52_To Develop an Integrated Business Intelligence and Visual Analytics Framework Using Powerbi.pdf | |
| KEYWORDS | |
| References | [1] Microsoft Power BI Documentation, “Power BI Overview,” Microsoft, 2025. [Online]. Available:https://docs.microsoft.com/en-us/power-bi/ [2] R. Kimball and M. Ross, The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd ed., Wiley, 2013. [3] S. Negash, “Business Intelligence,” Communications of the Association for Information Systems, vol. 13, no. 1, pp. 177–195, 2004. [4] M. A. Beyer and D. Laney, The Business Value of IT: How to Deliver Measurable Results, Gartner Research, 2016. [5] M. Aman et al., “Data Analytics and Visualization using Power BI,” Sensors Journal, vol. 25, no. 1, pp. 123-140, 2025. [6] P. Trujillo, ETL Processes for Data Warehousing, 2nd ed., Springer, 2018. [7] C. L. Davis, Data Modeling and Business Intelligence, McGraw-Hill, 2020. [8] K. Shmueli, Data Mining for Business Analytics, 3rd ed., Wiley, 2019. [9] Microsoft Power BI Blog, “Creating KPIs and Dashboards,” Microsoft, 2025. [Online]. Available: https://powerbi.microsoft.com/en-us/blog/ |
