Portfolio - Dev Mishra

Excel Project

P&L Report

P & L report of Atliq Hardware every year which includes Netsales, COGS, Gross Margin, Gross Margin% of every year 2020, 2021, 2022 and also comparison. It also have some filter like region, market.

This is netsales of every year (customer wise) i.e. 2019,2020,2021 and also a comparison between 2021 vs 2020. which helps comparison.

This includes netsales, cogs,gross margin, gross marign% for all customers in 2019, 2020,2021 and 2021 vs 2019

Project Details

Generated a detailed P&L report for AtliQ Hardware FY 2022, utilizing Excel's Pivot Tables and DAX for
precise revenue and expense analysis, takes me a week to complete this task.

Automated data cleaning with Power Query, saving approximately 4 hours of repetitive manual tasks,
leading to a 20% improvement in efficiency.

PowerBI Project

Sales Insights

Dive into the power of data with our groundbreaking project! We've meticulously sifted through over a million dataset records to craft a comprehensive report that unveils four distinct perspectives: Finance View, Sales View, Marketing View, and Supply Chain View.

View Project
Engagement

Other Tools

Excel

power query

sql

The Finance View offers insights into revenue, expenses, profitability, and resource allocation for informed decisions.

The Marketing View uncovers Net Profit in segment, product, and also in region and country

Project Details

In today's dynamic business landscape, data is the currency that drives decision-making and shapes strategies for success. With the exponential growth of digital information, organizations are faced with the daunting task of harnessing this wealth of data to gain actionable insights. Enter Power BI - a transformative tool that empowers businesses to unlock the full potential of their data assets.

Our project represents a culmination of extensive data exploration and analysis, culminating in a comprehensive report built upon the robust foundation of Power BI. We embarked on a journey through over a million dataset records, meticulously curating and organizing information to extract meaningful insights across multiple dimensions of business operations.

Live Interactive Dashboard

PowerBI Project

Codex Customer Analysis

CodeX, a German beverage company entering the Indian market. As the marketing data analyst, I undertook the task of extracting valuable insights from the survey results to drive actionable decisions for the team.

Other Tools

excel

power query

photoshop

This tells us the consumer in lucknow are very low, which also helps us to know about price range,Market

This tells us that drinking between 50 and 99 price is prevented because not available and also people who want it should reduce their sugar.

Project Details

During the analysis, I focused on delivering insights in the following key areas to assist the marketing team:

1. Customer Behavior and Market Reach: Through the data analysis, I gained valuable insights into customer behavior, preferences, and the most effective platforms for marketing and reaching out to the target audience.
2. Target Customers: By segmenting the data based on demographics and other factors, I identified the ideal target customers for CodeX's energy drink. This information can guide marketing strategies and help tailor product improvements to cater to the identified audience.
3. Product Enhancements: By analyzing customer feedback, preferences, and market trends, I discovered areas for potential product improvements. This includes considerations such as flavors, packaging, and branding, which can elevate the product's appeal in the target market.

Live Interactive Dashboard

Python Project

Hotels Data Analysis Project

In this project, you will gain quick insights into various types of hotels, including which hotel is the best and which platform most people use to book. Additionally, you will find insights such as occupancy percentage.

View Project
on GitHUB

This tells in month of June, Delhi has most occupancy

This tells people book hotel on others platform rather logtrip, direct online.

Project Details

In this project, we aimed to derive quick insights from the dataset by initially removing invalid guests and outliers. After cleaning the data, we performed data transformation to calculate the occupancy percentage. This enabled us to uncover several insights, such as determining whether occupancy was higher on weekdays or weekends.

Hello, I am

Dev Mishra

1

2

1

About

Key

My

P&L Report

Sales Insights

Codex Customer Analysis

Hotels Data Analysis Project

Awards

Contact Me

Email

Github

Linkedin

Call

Dev Mishra

Download Resume