Developing an Interactive Data Visualization Platform to Present the Adaption of Electrical Vehicles in Washington, California and New York

Abstract

This paper is an overview of using data visualized tools to provide a better insight on a large amount of data and represent it in a visualized form, this study will be applied on a large number of data related to Electric Vehicles (EV) usage in three different states in the USA which are California, New York, and Washington, the tool used for this study is Microsoft Power BI. There are three cases generated to study the number of the used EV's and specify the types, brand, and models used in each state based on the data of the registered EV's, then present how the number of EVs effect station numbers in the three states. The data has been collected from the state's governmental websites, and then it was compiled as a Microsoft Excel workbook, which formed a large database that was used as a data recourse in Microsoft Power BI. After that, it has been visualized and analyzed to end up with some rich visuals which will clarify the data for the end-user. The visualization tool generates reports and dashboards which can be used to provide the final results, where it gives a solid vision on what to improve and how to improve it. After analyzing the data using Microsoft Power BI, a clear vision has been created and recommendations have been suggested. In general, the results of the study indicated that the state of California is the highest state that uses EVs, compared to New York and Washington, respectively. Regarding the EVs brands, Tesla was the top producer of Battery Electric Vehicles (BEV). On the other hand, Toyota and Chevrolet are the top producers of Plug-in Electric Vehicles (PHEV).