Citation:

Adarsh Reddy Bilipelli, 2023. "Visual Intelligence Framework for Business Analytics Using SQL Server and Dashboards " ESP Journal of Engineering & Technology Advancements 3(3): 144-153.

Abstract:

A framework of Visual Intelligence of Business Analytics is put forward, the SQL Server and Power BI are utilized to automate generation of dashboards depending on the characteristics of dataset. The framework fully incorporates all business intelligence pipeline facilities, such as ETL, star-schema modelling, and flat-table creation, to enable highly scalable and structured analysis. The visualization assignment is presented in a rule-based manner, which suggests using one of the following visual types Card, Pie, Bar, or Line depending on the size of data sets according to previously determined thresholds (t₁ and t₂). In this paper, the framework is used on the sales data leading to the production of two dashboard variants PLLCC and PBLCC, each comprising different chart arrangements. A quantitative analysis, based on a visual utility measure, shows that Variant 2 (PBLCC) is better than Variant 1 (PLLCC) with a measure of 1.94 against 1.54, indicating its higher performance in visualising medium-sized data. The dashboards provide multidimensional data and information about revenue patterns, product-level measurements, and seasonal patterns, which are in line with the perceptual cognition principles. The paper illuminates the applicative potential of a SQL-driven visual mapping process in boosting decision-making and storytelling. Automation of visual advice and workflow configuration of BI solutions, the framework presents an effective solution in practical workflow conditions to provide an adaptive, resilient, and interactive dashboard business intelligence solution.

References:

[1] S. K. Pala, “Advance Analytics for Reporting and Creating Dashboards with Tools like SSIS, Visual Analytics and Tableau,” Int. J. Open Publ. Explor., vol. 5, no. 2, pp. 2853–3006, 2017.

[2] S. S. S. Neeli, “Optimizing Database Management with DevOps: Strategies and Real-World Examples,” J. Adv. Dev. Res., vol. 11, no. 1, 2020.

[3] D. Orlovskyi and A. Kopp, “A Business Intelligence Dashboard Design Approach to Improve Data Analytics and Decision Making.,” in IT\&I, 2020, pp. 48–59.

[4] V. S. Thokala, “Efficient Data Modelling and Storage Solutions with SQL and NoSQL Databases in Web Applications,” Int. J. Adv. Res. Sci. Commun. Technol., vol. 2, no. 1, pp. 470–482, Apr. 2022, doi: 10.48175/IJARSCT-3861B.

[5] A. Sorour, “Holistic Framework for Monitoring Quality in Higher Education Institutions in the Kingdom of Saudi Arabia using Business Intelligence Dashboards,” Staffordshire University, 2022.

[6] B. Powell, Microsoft Power BI cookbook: Creating business intelligence solutions of analytical data models, reports, and dashboards. Packt Publishing Ltd, 2017.

[7] S. S. S. Neeli, “Serverless Databases: A Cost-Effective and Scalable Solution,” Int. J. Innov. Res. Eng. Multidiscip. Phys. Sci., vol. 7, no. 6, p. 7, 2019.

[8] A. Al Maruf, R. Paul, M. H. Imam, and Z. Babar, “a Systematic Review of the Role of Sql and Excel in Data-Driven Business Decision-Making for Aspiring Analysts,” Am. J. Sch. Res. Innov., vol. 01, no. 01, pp. 249–269, 2022, doi: 10.63125/n142cg62.

[9] M. Himami, A. S. Abdullah, I. Nurma Yulita, and M. Suryani, “Utilization of Data Warehouse in Business Intelligence with Kimball Method at Company XYZ,” in 2021 International Conference on Artificial Intelligence and Big Data Analytics, ICAIBDA 2021, 2021. doi: 10.1109/ICAIBDA53487.2021.9689720.

[10] H. Ashok, S. Ayyasamy, A. Ashok, and V. Arunachalam, “E-business Analytics through ETL and Self-Service Business Intelligence Tool,” in 2020 Second International Conference on Inventive Research in Computing Applications (ICIRCA), 2020, pp. 747–751. doi: 10.1109/ICIRCA48905.2020.9183336.

[11] N. Bagam, “Comparative Study of Data Visualization Tools for Business Intelligence,” Int. J. Enhanc. Res. Sci., vol. 8, no. 6, pp. 52–62, 2019.

[12] W. Boulila, M. Al-kmali, M. Alsharafi, and H. Mugahed, “A business intelligence-based solution to support academic affairs: case of Taibah University,” Wireless. Networks, 2018, doi: 10.1007/s11276-018-1880-3.

[13] R. Ananthanarayanan, P. K. Lohia, and S. Bedathur, “DataVizard: Recommending visual presentations for structured data,” Proc. 21st Work. Web Databases, WebDB 2018, pp. 1–13, 2018, doi: 10.1145/3201463.3201465.

[14] S. M. Kumar and M. Belwal, “Performance dashboard: Cutting-edge business intelligence and data visualization,” in 2017 International Conference on Smart Technologies For Smart Nation (SmartTechCon), 2017, pp. 1201–1207. doi: 10.1109/SmartTechCon.2017.8358558.

[15] L. M. Hernandez Cruz, F. Javier Barrera Lao, D. C. Mex Alvarez, G. Manuel Estrada Segovia, C. E. Uc Rios, and L. Angel Lopez Aban, “Data Analysis using Business Intelligence in the educational context,” in 2021 16th Iberian Conference on Information Systems and Technologies (CISTI), IEEE, Jun. 2021, pp. 1–6. doi: 10.23919/CISTI52073.2021.9476470.

[16] S. Klisarova-Belcheva and G. Ilieva, “Business intelligence and analytics – contemporary system model,” Trakia J. Sci., vol. 15, pp. 298–304, 2017, doi: 10.15547/tjs 2017.s.01.053.

[17] B. Scholtz, A. Calitz, and R. Haupt, “A business intelligence framework for sustainability information management in higher education,” Int. J. Sustain. High. Educ., vol. 19, no. 2, pp. 266–290, 2018.

[18] P. P. Ramadhani, S. Hadi, and R. Rosadi, “Implementation of data warehouse in making business intelligence dashboard development using PostgreSQL database and Kimball lifecycle method,” in 2021 International Conference on Artificial Intelligence and Big Data Analytics, 2021, pp. 88–92.

[19] A. R. de C. Mota, “Dashboards in smart cities’ sustainability performance measurement through business intelligence,” 2021.

[20] D. Silva and A. Vieira, “Implementing an SQL Based ETL Platform for Business Intelligence Solution,” Universidade NOVA de Lisboa (Portugal), 2022.

[21] C. Nourani, “Virtual mobile interfaces, business intelligence, and analytics content processing,” in Ecosystems and Technology, Apple Academic Press, 2017, pp. 207–240.

Keywords:

Business Intelligence, SQL Server, ETL, Dashboard, Visualization, Power BI, Data Analytics.