About Me
Hi, I'm Alan. I work as a Financial Data Analyst, turning complex data into clear insights. I help companies make better financial decisions and manage risks. My projects range from building FP&A dashboards to creating predictive models. Take a look at my work to learn more.
Featured Projects
Power BI - Professional FP&A Dashboard
This dashboard was developed during my time as an FP&A Manager at a major event company. It uses synthetic data for confidentiality and shows how I structure financial data to support decision-making.
Explore Power BI Dashboard
Machine Learning - HR Insights & Predictive Model
In this project, I built a model to predict employee turnover. It highlights which factors impact whether someone stays or leaves, showcasing the use of data science in HR.
Explore Notebook
SQL - Tech Layoffs Analysis
Using a public dataset on tech company layoffs, I cleaned the data and performed an analysis using SQL to uncover key insights.
Explore Notion Page
SQL - Top Paying Remote Data Jobs
This project uses SQL queries to analyze the top paying remote Data Analyst jobs by salary, skills required, and demand in 2023, providing insights into the current job market.
Explore GitHub Repository
Python - Ultimate Movies Dataset
I created a comprehensive, daily-updated movies dataset that tracks industry trends, production strategies, and box office performance, showcasing my skills in large-scale data management.
Explore Kaggle Dataset
Tableau - Box Office and IMDb Trends
This Tableau visualization highlights Top 20 Box Office movies by genre and decade, comparing revenue and IMDb ratings to reveal key trends over time.
Explore Tableau Report
Power BI - Cinema Dashboard
This Power BI report uses live box office data and IMDb ratings from my Movies Dataset to deliver various analysis, including box office trends, studio performance, and genre breakdowns, all presented through dynamic visuals.
Explore Power BI Dashboard
Python - A24 Movies Analysis
This analysis explores the filmography of A24 using my Movies Dataset to provide insights into the studio's unique characteristics.
Explore Notebook
Python - Movies Dataset Daily Update
I automated the daily refresh of my Ultimate Movies Dataset, ensuring it stays current with the latest updates and IMDB ratings for immediate analysis.
Explore Notebook
Python - Movies Data Extraction
I developed a process to build the Ultimate Movies Dataset, detailing 1 million movies across 30 fields, refining it for maximum detail and efficiency.
Explore Notebook