Skilled Data Analyst in SQL, Power BI, Tableau, Excel, and Python.
LinkedIn Profile @omaralan.
During my internship with the City of Playford, this project automated job data collection, validation, and analysis for the North Adelaide 2024 Career Expo. Using Python, SQL, and Tableau, it provided real-time insights for decision-making.
This project analyses a bank dataset with over 10,000 records to predict customer churn using machine learning techniques. It involves data cleaning, data exploration, correlation analysis, feature selection, and building a decision tree model with Python.
This project demonstrates the use of SQL for data cleaning and exploratory analysis, focusing on vehicle thefts in New Zealand during 2021-2022. It prepares data and identifies key insights based on vehicle type, brand, region, and other factors, providing actionable intelligence for strategic decisions.
This Power BI dashboard analyses over 450,000 crimes in South Australia (2018-2023), offering visualizations of crime trends, high-incidence suburbs, and key types for deep regional safety insights.
Explore vehicle theft trends in New Zealand for the years 2021 to 2022 through this interactive Tableau dashboard. The dashboard allows you to identify the vehicle brands and models most frequently targeted by thieves, and analyse theft patterns by type and region.
This dashboard provides a comprehensive analysis of Australian vehicle listings as of December 2023, detailing brand preferences, features, and market distribution. It delivers professional insights into car market dynamics, including popular brands and transmission types.