— Portfolio
My Projects
LAPD Crime data dashboard – Short Case Study
Excel, Power Query, Power Pivot
I cleaned and transformed 800K+ LAPD crime records in Power Query and Excel, handling missing values, inconsistent categories, and date/time formats. I built a dashboard that visualizes crime trends by area, victim demographics, crime types, and weapons used, providing clear insights into the most affected divisions and patterns over time.
IT Business Dashboard – Long Case study
LucidChart for Data Modelling, APIs, PostgreSQL, Tableau
This dashboard project was designed to give business leaders a visual overview of company performance across IT services, clients, and revenue. It helps spot trends, track KPIs, and support strategic decisions without relying on scattered reports.
vehicle report automation – short case study
Excel, Macros, VBA, Power Query, Power Pivot
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Donec sollicitudin molestie malesuada. Sed porttitor lectus nibh.
Food marketing data analyst project
Python, Pandas, Seaborn
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Donec sollicitudin molestie malesuada. Sed porttitor lectus nibh.