Mena Hasan
Data analyst
Overview
Joined customer order data with McDonald's product nutrition metrics using MySQL to build a unified relational dataset for downstream statistical analysis.
Key Technical Steps
Data Joining: Executed a right join between the customer order tables and product attributes using Item_ID to preserve all menu item records.
Dataset Preparation: Structured randomly sampled order IDs and customer names to evaluate item-level purchasing patterns alongside caloric and macronutrient values.
0
9
Business analysis, Is the most common and in-demand fields globally. To keep operations seamless, decision-makers need analysts who precisely match their project goals.
About Me
I am a versatile data analyst capable of handling diverse datasets regardless of row count. I focus on thoroughly understanding core project goals to deliver precise, detail-oriented insights. My primary areas of interest include sports and product analytics.
Overview
Based on an Excel pivot table analysis, this online retail project identifies the top six customers by revenue across different countries. Regardless of Recency, Frequency, or total units purchased, Dutch and British customers generated the highest overall revenue indicating high-volume purchases or premium product selections.
0
20
McDonald's Item Nutrition Analysis by Category
Overview:
Analysis across menu categories (breakfast, regular meals, gourmet, desserts, condiments, and beverages) shows that carbohydrate content varies significantly by item type. While condiments naturally contain lower carbohydrate levels than full meals, total calories and carbohydrates display a strong positive correlation overall—though calorie density is also driven by other macronutrients like fats and proteins.
Additionally, cholesterol and trans-fat show a very weak correlation across the menu, indicating that high-trans-fat items do not reliably predict high cholesterol levels.
0
61
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
169