Category Archives: Uncategorized

Authors: Kavya Menon

 

Abstract: Modern enterprises increasingly rely on business intelligence (BI) platforms to transform raw data into actionable insights. Tableau, as a leading BI tool, offers sophisticated visualization, analytics, and reporting capabilities. However, the underlying operating environment significantly impacts performance, scalability, security, and cost efficiency. This review explores the strategic advantages of deploying Tableau on Linux-based systems, specifically Red Hat Enterprise Linux (RHEL) and CentOS, for enterprise-grade BI implementations. It examines the role of Linux in enhancing system stability, providing robust security frameworks, supporting modular and automated workflows, and enabling high availability and scalability. The article analyzes data integration strategies, ETL pipelines, and dashboard optimization practices tailored to Linux environments, emphasizing both operational efficiency and user experience. Case studies across healthcare, finance, and retail illustrate real-world applications, demonstrating how Linux-based Tableau deployments support secure, high-performance analytics, regulatory compliance, and business agility. Furthermore, the review addresses monitoring, maintenance, and performance tuning, highlighting best practices for sustained system reliability. Future trends, including AI integration, real-time streaming, hybrid cloud architectures, and advanced automation, are discussed to illustrate the evolving landscape of enterprise BI. By combining Tableau’s visualization capabilities with Linux’s reliability and flexibility, organizations can achieve cost-effective, scalable, and secure BI solutions. This article underscores the importance of selecting an appropriate operating environment to maximize Tableau’s potential and provides a comprehensive guide for IT professionals, analysts, and business leaders seeking to optimize their BI infrastructure.

DOI: https://doi.org/10.5281/zenodo.17275816

 

Published by: vikaspatanker

Authors: Rani Kumari

Abstract: The transition from traditional reporting methods to interactive, data-driven dashboards has transformed how organizations interpret and act upon information. This review examines the role of Tableau in the Business Intelligence (BI) lifecycle, focusing on its ability to convert raw data into actionable insights that support both strategic and operational decision-making. Tableau’s integration capabilities, including connections to diverse data sources and support for live or extracted datasets, enable organizations to streamline data preparation, cleansing, and transformation. Its visual analytics and interactive dashboards allow stakeholders to explore trends, perform what-if analyses, and monitor key performance indicators (KPIs) in real time. Advanced features, such as calculated fields, predictive modeling, and integration with AI/ML frameworks, enhance the depth and accuracy of insights, while collaborative and cloud-enabled solutions facilitate enterprise-wide adoption. Case studies from retail, healthcare, and finance illustrate Tableau’s practical impact in improving operational efficiency, forecasting, and decision support. The review also addresses challenges, including data quality management, user adoption barriers, and performance scaling, highlighting best practices to overcome these limitations. Looking forward, the integration of AI-driven analytics, real-time data streams, and embedded BI promises to expand Tableau’s influence in decision-making workflows. By adopting Tableau strategically, organizations can foster a culture of data literacy, enhance agility, and ensure that insights are actionable, timely, and aligned with business objectives. Overall, Tableau represents a bridge between complex datasets and operational intelligence, providing organizations with a robust, flexible, and scalable BI platform.

DOI: https://doi.org/10.5281/zenodo.17275764

 

Published by: vikaspatanker

Authors: Joseph Fernandes

Abstract: Power BI has established itself as a versatile and comprehensive platform for the business intelligence (BI) lifecycle, supporting data integration, development, visualization, collaboration, and ongoing maintenance. This review article examines Power BI’s capabilities in consolidating heterogeneous data sources, performing robust ETL transformations, and delivering interactive dashboards that provide actionable insights for enterprise decision-making. The discussion explores key aspects of implementation, including agile development methodologies, data governance, role-based access controls, and performance optimization techniques. Case studies across healthcare, retail, and finance demonstrate the platform’s practical impact, highlighting efficiency gains, improved reporting accuracy, real-time analytics, and enhanced regulatory compliance. Additionally, the article addresses common challenges such as integration complexity, technical skill requirements, and governance concerns, providing recommendations for mitigation. Emerging trends such as AI-driven analytics, predictive modeling, real-time streaming data, and cloud-native architectures are analyzed, illustrating the evolving role of Power BI in enabling intelligent decision-support systems. The review emphasizes the strategic advantages of Power BI, including democratization of analytics, scalability, and adaptability to diverse organizational requirements. By synthesizing current practices, technological capabilities, and future innovations, this article provides a roadmap for leveraging Power BI effectively to drive operational efficiency, data-driven decision-making, and organizational agility in dynamic business environments.

DOI: https://doi.org/10.5281/zenodo.17275705

 

Published by: vikaspatanker

Authors: Ayush Pravin Kudale

Abstract: This study offers a repeatable, Python-based framework for unified social media analytics that uses open APIs to connect disparate platforms like YouTube, Reddit, and Twitter. The strategy promotes transparency, explainability, and real-time engagement by emphasizing cross-platform integration, user-centric sentiment analysis, and graph-based pattern recognition for actionable insights. The framework's adaptability solves the research problems of data heterogeneity, scalability, and ethical stewardship while opening up new possibilities in marketing, crisis management, public opinion tracking, and policy-making. The massive, dynamic, and diverse statistics generated by social media platforms offer enormous possibilities for examining sentiment, public opinion, trending patterns, and the spread of information

DOI: http://doi.org/10.5281/zenodo.17275671

Published by: vikaspatanker

Authors: Vivek Sharma

 

Abstract: In contemporary enterprises, data fragmentation across multiple systems, departments, and formats poses significant challenges to decision-making, reporting accuracy, and operational efficiency. A Single Source of Truth (SSOT) addresses these challenges by consolidating heterogeneous data into a centralized, authoritative repository. This review examines the implementation of SSOT using SQL databases, robust ETL pipelines, and Power BI for visualization and governance. It explores the principles of data governance, including data ownership, quality control, role-based security, and regulatory compliance, emphasizing their critical role in maintaining data integrity and trustworthiness. The review also details best practices for relational database design, performance optimization, and ETL automation to ensure timely and accurate data delivery. Case studies across healthcare, financial services, and retail illustrate practical applications, demonstrating improved reporting efficiency, operational responsiveness, and decision-making capabilities. Furthermore, the integration of SSOT across enterprise workflows, combined with monitoring, audit trails, and automated alerts, underscores the value of a governed, centralized data ecosystem. The article highlights current challenges, including system complexity, adoption barriers, and legacy integration, and offers strategies for mitigation. Looking forward, emerging trends such as cloud-native architectures, real-time streaming, AI-enhanced analytics, and hybrid or federated data models suggest new avenues for enhancing SSOT utility and scalability. By providing a comprehensive framework, this review underscores the strategic, operational, and compliance benefits of SSOT, positioning it as a cornerstone for modern, data-driven enterprises seeking reliability, agility, and insight-driven decision-making.

DOI: https://doi.org/10.5281/zenodo.17275623

 

Published by: vikaspatanker

Authors: Anjali Thomas

 

Abstract: In today’s competitive business landscape, data-driven decision-making has become a strategic imperative. Organizations are increasingly turning to business intelligence (BI) platforms to transform raw data into actionable insights that guide growth, efficiency, and innovation. Among these platforms, Power BI stands out as a versatile solution that bridges the gap between technical complexity and user accessibility. This review article presents a comprehensive framework for successful Power BI adoption, emphasizing the interplay between governance, integration, scalability, and organizational readiness. The paper begins by outlining the challenges enterprises face when shifting from intuition-based management to data-centric practices, highlighting issues of data silos, inconsistent reporting, and resistance to cultural change. It then explores how Power BI’s architecture—spanning ETL processes, SQL integration, cloud deployment, and security mechanisms—can serve as the backbone for a sustainable BI strategy. The review further examines practical use cases across industries, DevOps-driven automation, and the role of training programs in fostering a self-service analytics culture. Through a critical discussion of opportunities and limitations, the article underscores that successful Power BI adoption requires more than technology; it demands alignment between people, processes, and platforms. By providing a structured roadmap, this study offers organizations a pragmatic guide to embedding Power BI within their BI lifecycle. The conclusion reaffirms that Power BI is not simply a reporting tool but a catalyst for building data-driven cultures that enhance agility, competitiveness, and long-term decision-making excellence.

DOI: https://doi.org/10.5281/zenodo.17275574

 

Published by: vikaspatanker

Authors: Prof. Mayanka Roy Mandal, Prof. Shraddha Tiwari, Prof. Ankita Fouzdar

Abstract: The rapid growth of electric vehicles (EVs) has created a strong demand for compact, reliable, and high-efficiency DC–DC converters to ensure effective power management and extended driving range. This study focuses on the development of high-efficiency DC–DC converters specifically designed for EV applications, addressing challenges such as wide input voltage variations, high power density, and stringent thermal constraints. Advanced topologies including interleaved, resonant, and soft-switching techniques are explored to minimize switching losses and improve overall efficiency. Furthermore, integration of digital control strategies and advanced semiconductor devices such as SiC and GaN MOSFETs enhances performance while reducing converter size and weight. Simulation and experimental results demonstrate improved efficiency, voltage regulation, and transient response under dynamic load conditions. The proposed converters are shown to meet the critical requirements of modern EV powertrains, offering a sustainable solution for future electric mobility.

Published by: vikaspatanker

Authors: Prof. Shraddha Tiwari, Prof. Mayanka Roy Mandal, Prof. Ankita Fouzdar

Abstract: The integration of solar photovoltaic (PV) systems into the electrical grid requires efficient power electronic interfaces to ensure reliable operation and maximum energy extraction. This study focuses on the design and performance analysis of a power electronic interface for grid-connected solar PV systems incorporating Maximum Power Point Tracking (MPPT) techniques. A DC–DC converter controlled by MPPT algorithms such as Perturb and Observe (P&O) and Incremental Conductance (INC) is employed to optimize the PV output under varying irradiance and temperature conditions. The conditioned DC power is subsequently converted into synchronized AC power through a voltage source inverter (VSI) with appropriate grid synchronization and control strategies. The proposed system enhances the efficiency, stability, and power quality of PV-grid integration while minimizing harmonic distortion and ensuring compliance with grid codes. Simulation and experimental results validate that the implementation of an optimized MPPT-based power electronic interface significantly improves energy harvesting capability and supports sustainable and reliable integration of renewable energy into the power grid.

Published by: vikaspatanker

Authors: Prof. Ankita Fouzdar, Prof. Mayanka Roy Mandal, Prof. Shraddha Tiwari

Abstract: The rapid growth of renewable energy sources (RES) such as solar and wind has created new opportunities for sustainable power generation, while also posing significant challenges due to their intermittent and unpredictable nature. Smart grids, equipped with advanced communication and control technologies, offer a promising platform for efficiently integrating these variable energy resources. This study explores the optimal integration of renewable energy into smart grids using artificial intelligence (AI)-based forecasting and optimization techniques. Machine learning and deep learning models are employed to accurately predict renewable generation and demand patterns, reducing uncertainty and enabling proactive grid management. Furthermore, advanced optimization algorithms such as genetic algorithms, particle swarm optimization, and reinforcement learning are applied to achieve optimal scheduling, load balancing, and energy storage utilization. The proposed framework enhances grid stability, minimizes energy losses, reduces reliance on fossil fuels, and ensures cost-effective and reliable power delivery. Simulation results validate the effectiveness of the AI-driven approach in improving renewable energy penetration and overall smart grid performance. This work highlights the potential of AI-enabled forecasting and optimization as key enablers for achieving sustainable, resilient, and intelligent energy systems

Published by: vikaspatanker

Authors: I.C Emeto, B.P Gbaranwi, A.A. Galadima, A.C Okoloegbo, S. Kwaghbee, E.C Ochuba

Abstract: Cloud computing has emerged as a dominant paradigm for delivering scalable, on-demand computing resources, yet efficient load balancing remains a critical challenge in modern data centers. This paper presents a novel Hybrid Bee Ant Colony (HBAC) Algorithm that synergistically combines Ant Colony Optimization (ACO) and Artificial Bee Colony (ABC) metaheuristics to address the inherent limitations of existing load-balancing approaches. The proposed HBAC algorithm leverages ABC's robust exploration capabilities to identify underutilized virtual machines (VMs) and ACO's pheromone-driven exploitation mechanism to optimize task allocation, thereby achieving superior performance in dynamic cloud environments. Through extensive simulations using CloudSim with Google Cluster Data traces, we demonstrate that HBAC significantly outperforms standalone ACO and ABC algorithms across key performance metrics. Experimental results show 15.7% reduction in makespan, 22.3% improvement in response time, and 18.9% better resource utilization compared to conventional approaches. The hybrid model particularly excels in maintaining balanced VM workloads (degree of imbalance reduced by 27.4%) while demonstrating exceptional scalability under varying workload conditions (from 1,000 to 10,000 tasks). The algorithm's innovative two-phase architecture – where ABC scouts first identify high-potential VMs and ACO ants then optimize task placement – effectively overcomes the slow convergence of pure ACO and the excessive exploration of pure ABC. Energy efficiency analysis reveals 13.2% reduction in power consumption, making HBAC particularly suitable for sustainable cloud operations.

DOI: http://doi.org/10.5281/zenodo.17264412

Published by: vikaspatanker