Development of Performance Dashboard Visualization Using Power BI: A Data-Driven Analysis of Global EV Charging Behavior

Abstract

In today's fast-paced and rapidly evolving world, access to the right information and effective
decision-making is crucial for both individuals and organizations. Right decision-making by
businesses not only helps them in problem solving, achieving goals, and strategic thinking, but
also creates competitive advantage in the market. Business intelligence tools like Power BI are
revolutionizing decision-making by empowering businesses to make real-time data-driven choices
by simplifying large datasets into strategic insights. This study leverages Power BI to analyze
Global EV charging station behavior, specifically charging efficiency and cost. The data-set has
been taken from Gallup Pakistan website and includes variables such as charging duration,
charging cost, temperature, energy deliverables, charging session outcomes, and station
utilization rate across multiple countries. In Pakistan, a nation facing rising fuel import expenses,
urban pollution, and energy instability, there is a need to shift on alternative energy sources such
as hybrid electric vehicles. This paper will also offer data-driven insights to support stakeholders
in the Pakistani automobile industry, in assessing the efficiency and economic benefits of EV
battery technologies. One of the findings of the study showed variability in charging preferences
based on station type, with DC Fast charging being the most efficient among all. Additionally,
payment method preferences revealed regional distinctions in digital technology adoption,
further emphasizing the importance of localized strategies. This paper contributes to explore the
importance of Power BI in supporting decision-making by enhancing efficiency and strategic
growth and it will serve as a practical guide for policymakers, infrastructure developers, and
stakeholders aiming to foster a more sustainable and technologically advanced transportation
ecosystem.
Keywords: Power BI, Business intelligence, EV charging station, charging efficiency, station
utilization, Decision-making, automobile industry, Pakistan, Charging Cost, Interactive
Dashboards.