Powered by
Codebasics DA Bootcamp

Utkarsh Mishra

Data Aspirant

+91 +919131115216 [email protected]

Resume

Hello, I am

Utkarsh Mishra.

3

PowerBI Projects

1

Excel Project

1

SQL Project

About Me

Welcome to my data-driven realm! I'm Utkarsh, a dedicated data analyst fluent in Power BI, SQL, and Excel. My expertise lies in transforming raw data into compelling narratives that drive informed decisions. With a knack for uncovering hidden patterns and trends, I merge technical acumen with creative insight to deliver valuable insights. Armed with SQL querying prowess and Power BI dashboards, I excel at crafting meticulous Excel calculations. Beyond numbers, I prioritize effective communication, using intuitive visualizations and storytelling to connect data with decision-makers. Join me in harnessing the power of data to make a meaningful impact. Let's embark on this journey together!

Key Skills

SQL

Effective Presentation

Stakeholder Management

My Projects

Awards & Certificate

PWC Power BI Certification

PWC Power BI Certification

Excel Skill For business by Goldman Sachs

Excel Skill For business by Goldman Sachs

SQL

Power BI

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/utkarsh-mishra-7a14a514b/

+ 91 +919131115216

https://github.com/Utkarsh1m

PowerBI Project

Provide Insights to the Product Strategy Team in the Banking Domain

Mitron Bank is a legacy financial institution headquartered in Hyderabad. They want to introduce a new line of credit cards, aiming to broaden its product offerings and reach in the financial market.

View Project
Engagement

View Project
on GitHUB

Other Tools

EXCEL

Provide Insights to the Product Strategy Team in the Banking Domain

Insightful data snapshot: Avg Income Utilization: 42.82%, Total Income: $1240M, Total Spends: $531M.Top spenders: Males, Married. Sept Peaks spending.

Provide Insights to the Product Strategy Team in the Banking Domain

Key demographic insights: 4000 total customers, 64.93% males, 35.08% females. Top age group: 25-35. Mumbai leads with 1078 customers.

Project Details

AtliQ Data Services proposed a credit card project to Mitron Bank. Mr. Bashnir Rover requested a pilot project with a sample dataset. Peter Pandey, a data analyst, leads the analysis. Tony Sharma advises focusing on customer segmentation, demographic trends, regional variations, and transactional data. Peter uncovers customer segments, regional spending trends, fraud patterns, and popular products. His insights inform tailored credit card offerings. Mr. Bashnir Rover is impressed, and AtliQ Data Services gains approval for the full project.

Live Interactive Dashboard

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

sql

excel

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Excel Project

Sales & Finance Report for Atliq Hardware

AtliQ Hardware is a consumer electronics company and it wants to analyze its sales performance across customers and markets. My task is to develop Sales Reports using MS Excel that will help the company gain insights and make better decisions.

View Project
on GitHUB

Sales & Finance Report for Atliq Hardware

Different Tables in the power pivot

Sales & Finance Report for Atliq Hardware

Building Market Performance VS Target in Pivot Table

Project Details

AtliQ Hardware is a consumer electronics company that sells its products across the globe. The company wants to understand its sales performance over time which could help in devising its plans. I have used MS Excel to create sales reports.

I have created two reports using pivot tables. Those are:
1) Customer Performance Report - this report enables the sales team to identify the best performing customers over the years and the growth/decline in revenue.
2) Market Performance Report - this report gives the amount of sales generated per country and in knowing whether the sales target is achieved or not.

By understanding the insights from these reports, the company can work on optimizing its sales strategy across different markets and customers and maximize Return on Investment (ROI).

What I have learned by doing this project:
1. Pivot table
2. Power Query
3. Data Analysis Expression (DAX)
4. Conditional Formatting
5. important metrics related to the sales domain

SQL Project

ZOMATO - CUSTOMER OREDER BEHAVIOUR

In my Zomato project, I worked with a compact dataset from Zomato, utilizing SQL to extract valuable insights and answer relevant business questions. I started by exploring the dataset, identifying key entities such as customers, Products, and orders.

View Project
on GitHUB

ZOMATO - CUSTOMER OREDER BEHAVIOUR

A screenshot showing data transformation in MySQL Workbench

ZOMATO - CUSTOMER OREDER BEHAVIOUR

.My SQL Codes

Project Details

In my Zomato project, I utilized SQL to analyze a compact dataset from Zomato, extracting valuable insights to optimize business strategies. By exploring customer behavior, product preferences, and transaction trends, I provided actionable recommendations to enhance customer satisfaction and drive revenue growth."

Key Learnings:
"Through my Zomato project, I honed my SQL skills, gaining proficiency in data analysis and query optimization. I learned to interpret complex datasets,
identify meaningful patterns, and derive actionable insights to inform strategic decision-making.
Additionally, I developed a deeper understanding of customer behavior and business dynamics within the food delivery industry,
paving the way for more informed and data-driven strategies in future projects.

PowerBI Project

Good Cabs

Domain/Function: Transportation & Mobility Analytics.

Analyze the operational performance of a cab service company using SQL and Power BI. The project focuses on evaluating trip patterns, passenger feedback, and operational KPIs.

View Project
Engagement

View Project
on GitHUB

Goodcabs faced challenges in understanding trip patterns, passenger satisfaction, and operational efficiency, leading to difficulties in meeting perfo

To address this, we analyzed key metrics such as revenue, passenger feedback, trip distribution, and ratings. Based on these insights, we provided act

Project Details

In this project, I analyzed operational data for Goodcabs, focusing on key performance indicators such as trip volume, passenger satisfaction, repeat passenger rate, and trip distribution. Using SQL, I extracted and transformed raw data to compute these KPIs, identifying patterns and anomalies. I then leveraged Power BI to design interactive dashboards, providing stakeholders with actionable insights.

The analysis helped uncover trends in trip usage, factors impacting customer satisfaction, and areas needing operational improvements, aligning closely with business goals. This project showcases my expertise in data analytics and visualization, along with my ability to derive insights that drive strategic decisions.

Project video

Live Interactive Dashboard