Mena Hasan
Data analyst
Outcomes :
1) The average price-to-earnings ratio has exceeded the target.
2) Cash on hand and stock price exhibit a strong positive correlation.
3) According to the data cards in the document, the total liabilities remain high reflecting a heavy reliance on debts relative to equity.
Prediction :
Based on the forecast trends in both line charts, McDonald's total revenue and total earnings are steady upward growth through 2035.
0
88
Title
Linear Regression Analysis & Predictive Modeling (SPSS)
Overview
Executed an end-to-end linear regression analysis in SPSS to evaluate relationships between key financial/operational metrics, assess statistical significance, and build predictive models for decision-making.
Key Analysis & Process
Model Fitting & Diagnostics: Evaluated the overall goodness-of-fit ($R$, $R^2$, and Adjusted $R^2$) to quantify how effectively predictor variables account for variance in the target metric.
ANOVA & Significance Testing: Verified model validity using ANOVA testing ($F$-statistic, $p < 0.05$) to ensure observed linear relationships were statistically significant rather than due to random chance.
Coefficient Evaluation: Analyzed unstandardized and standardized ($\beta$) regression coefficients alongside $t$-statistics and $p$-values to measure the directional impact and individual predictive weight of each independent variable.
Assumption Validation: Examined residual distributions and correlation outputs to ensure linear regression assumptions (linearity, normality of residuals, and homoscedasticity) were fully satisfied.
Outcome
Delivered a validated predictive model and actionable statistical outputs, enabling stakeholders to forecast future outcomes based on key data-driven metrics.
2
399
McDonald's Nutritional & Calories Visual Analytics (Tableau)
Overview:
Developed an interactive Tableau dashboard to analyze and visualize nutritional profiles across McDonald's food products, focusing on key metrics like calorie count and trans-fat composition.
Tools: Tableau
Key Analysis & Process:
Nutritional Breakdown: Categorized menu items to compare caloric intake and trans-fat levels across different product categories.
Visual Mapping: Built custom bar charts and comparison visuals in Tableau to highlight high-density nutritional values at a glance.
Outcome:
Delivered a clean, visual summary that allows users and stakeholders to quickly evaluate menu items based on health and nutrition metrics.
1
485
Electric Vehicle Market Share Analysis & Segmentation (Power BI)
Overview:
Designed a visual analytics report in Power BI to analyze Electric Vehicle (EV) sales distribution across different vehicle categories (2-Wheelers, 3-Wheelers, 4-Wheelers, Buses, and Others). This project translates raw sales metrics into categorical market share insights.Key Analysis & Process:Categorical Data Segmentation: Aggregated and grouped raw EV sales quantities by vehicle type to evaluate relative market composition.Proportional Data Visualization: Implemented a custom pie chart visual to display market share percentages and unit distributions clearly at a glance.Data (http://glance.Data) Preparation: Cleaned underlying dataset tables (Vehicle_Category, Vehicle_Class, EV_Sales_Quantity) for accurate aggregation across categories.Outcome:Delivered an intuitive visual summary that highlights category dominance—showing that 2-Wheelers represent the largest market segment ($56.2%$)—allowing stakeholders to quickly identify top revenue drivers and growth opportunities.
1
404