Project Details

This project involves generating comprehensive Profit & Loss (P&L) reports for AtliQ Hardware for fiscal years 2019, 2020, and 2021. Using advanced Excel features like Pivot Tables and DAX measures, I analyzed and visualized key financial metrics such as Net Sales, Cost of Goods Sold (COGS), and Gross Margin (GM%). Each fiscal year's data is segmented by month and quarter, providing granular insights into revenue streams and expense categories. The data showcases significant improvements in financial performance, with notable increases in Net Sales and Gross Margin percentages over the years.

A detailed Net Sales comparison highlights year-over-year growth, showing a 204.5% increase in 2021 compared to 2020 and a 124.8% increase in 2020 compared to 2019. These insights are critical for strategic decision-making and demonstrate the impact of effective data analysis and financial planning. Explore my portfolio to see how I transform raw data into actionable bus

Project Details

Dive into the enchanting world where art meets data, revealing the secrets of renowned masterpieces and their creators. Explore canvas sizes, museum displays, and the timeless themes that captivate audiences across generations. Unveil the hidden narratives behind the brushstrokes, shedding light on the profound interplay of creativity and analysis. Join us on a journey that transcends boundaries, offering new perspectives on the art that shapes our world.

Project Details

After discovering an opportunity, a proposal was made to Mitron Bank for a project. The bank requested a pilot using a sample dataset before committing fully. This dataset includes online spending details for 4000 customers across five cities.

A data analyst was assigned to analyze the data and report key findings to Mitron Bank's strategy team. The goal is to tailor the bank's credit card offerings to better meet customer needs and market trends.

The analysis will include:
- Demographics: Age, gender, location, occupation breakdowns.
- Spending Insights: Online spending patterns and trends.
- Income Utilization: Income levels and spending capacity.
- Key Insights for Customization: Features appealing to segments.
- Recommendations: Personalized rewards, tailored credit limits, and marketing strategies.

This analysis aims to help Mitron Bank develop better-aligned credit card products.

Live Interactive Dashboard

Project Details

CodeX, a German beverage company, aims to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India. The Marketing team, tasked with increasing brand awareness, market share, and product development, conducted a survey with 10,000 respondents. Peter Pandey, a marketing data analyst, is converting these survey results into actionable insights.

Demographics: Analyzes age, gender, income, and location to tailor strategies.

Consumer Preferences: Examines flavor, packaging, and brand preferences for product development.

Purchasing Behavior: Studies purchase frequency, preferred channels, and spending patterns.

Competition Analysis: Identifies competitors, market share, strengths, and weaknesses.

Marketing View: Assesses marketing campaign effectiveness and brand recall.

CodeX Performance: Evaluates market penetration and customer satisfaction.

These insights will guide CodeX’s strategic actions in the Indian market.

Live Interactive Dashboard