Portfolio - Ashwin Shende

Excel Project

VRINDA STORE ANNUAL REPORT

Annual Report of a Vrinda store illustrating the sales trajectory for the year.. Developed a comprehensive dashboard that effectively illustrated the sales empowering users to grasp the data comprehensively and make well-informed decisions

this is the dashboard we made for Vrinda stores.

Project Details

• Showcased the decline in sales in dec. with around Rs 220000.
• Developed a comprehensive dashboard that effectively illustrated the sales empowering users to grasp the data comprehensively and make well-informed decisions.
• Created a dashboard to assist in identifying target demographics, specifically focusing on gender and strategies for marketing campaigns targeting the age group of 30-49.

PowerBI Project

Hospitality analysis

The business chain observed a decrease in market share and revenue over 3 months, necessitating an analysis to identify the cause. Developed a Power BI dashboard using three months of data for this purpose.

The dashboard showcases the data on the basis of 3 filters.

Here all the financial happenings of the business can be analyzed by the user.

Project Details

This project aimed to investigate a 3-month decline in market share and revenue. A Power BI dashboard was developed using this data, providing crucial insights. The final dashboard effectively depicted revenue trends and insights, potentially increasing revenue by 20% in the next month. This project showcased the power of data analysis in strategic decision-making, offering actionable solutions to business challenges.

PowerBI Project

Business 360

The Power BI project provides an executive view, integrating finance, marketing, sales, and supply chain data. It analyzes metrics, tracks ROI, evaluates performance, and optimizes efficiency for informed decision-making and business growth.

Executive View Dashboard: Concise insights from finance, marketing, sales, and supply chain data for informed decision-making.

Finance View Dashboard: Key financial metrics, cash flow trends, budget variances, and forecasts for strategic financial decision-making.

Project Details

The Power BI project integrates key business aspects such as finance, marketing, sales, and supply chain to provide comprehensive analytics and insights.

Finance: Analyze financial data including revenue, expenses, and profitability metrics. Visualize cash flow trends, budget variances, and financial forecasts for informed decision-making.

Marketing: Track marketing campaign performance, customer acquisition costs, and ROI. Utilize interactive dashboards to monitor leads, conversions, and market trends for targeted marketing strategies.

Sales: Evaluate sales performance by region, product, and customer segment. Utilize sales pipeline analysis, deal tracking, and sales forecasts to optimize sales strategies and maximize revenue.

Supply Chain: Monitor inventory levels, supplier performance, and production efficiency. Utilize supply chain analytics to identify bottlenecks, optimize procurement, and improve overall operational efficiency.

SQL Project

CONSUMER GOODS ADHOC INSIGHTS

We thoroughly analyzed the inputs provided by the company to extract valuable insights from the data. Our aim was to derive meaningful conclusions and actionable recommendations based on the information at hand, contributing to informed decision-making and strategic planning processes.

This is the market covered by the Atlique hardwares around the world.

This is the result of for the highest manufacturing and lowest manufacturing products

Project Details

Utilizing MySQL, we structured the necessary tables based on input provided by the company. Leveraging Excel and Power BI, we generated comprehensive charts to visually represent key data points. These charts were instrumental in deriving actionable insights crucial for strategic decision-making.

Furthermore, we utilized Canva to create a professional and engaging presentation that effectively communicates the insights derived from the data analysis process. The integration of MySQL, Excel, Power BI, and Canva enabled us to deliver a robust solution that facilitated informed decision-making and enhanced business outcomes.

Hello, I am

Ashwin Shende

1

2

1

About

Key

My

VRINDA STORE ANNUAL REPORT

Hospitality analysis

Business 360

CONSUMER GOODS ADHOC INSIGHTS

Contact Me

Email

Linkedin

Call

Ashwin Shende

Download Resume