A county-level EV trend analysis for the Washington State Department of Licensing using Power BI, Tableau, and Google Colab.
Project Overview
This Business Intelligence project was developed for the Washington State Department of Licensing to examine electric vehicle (EV) population trends across U.S. counties. The analysis used a real-world dataset with over 18,000 records and aimed to support sustainable policy-making through data-driven insights and interactive dashboards.
Here are some snapshots from our dashboards–
Objectives
- Analyze EV adoption patterns across counties
- Forecast future EV registration trends
- Identify infrastructure needs (e.g., charging stations)
- Deliver actionable insights to policymakers, entrepreneurs, and the public
- Promote sustainable transportation through data transparency
Contributors
- Tamim Hasan
- Yash Satishkumar Raja
- Rashmika Manawadu
- Sajith Nipuna Karunarathna Sella Hannadige
My Contributions
- Cleaned and transformed 18,769+ data records using Google Colab
- Created 4 interactive dashboards in Power BI and Tableau
- Built a forecast model projecting 15% increase in EVs over 5 years
- Delivered targeted insights for executives, policymakers, and environmental orgs
Tools & Technologies
- Power BI – Dashboard development & forecasting
- Tableau – Data visualization
- Google Colab – Data cleaning & transformation
- Microsoft Excel – Data formatting & calculations
- Dataset – EV Population Size History by County (18,769 records)
tamimhasan.me 