Powered by
Codebasics DA Bootcamp

Ashutosh Jha

Data Analyst, Supply Chain Analyst,

+91 8240476972 [email protected]

Resume

Hello, I am

Ashutosh Jha.

1

Excel Project

2

PowerBI Projects

1

SQL Project

About Me

Welcome to my portfolio! I’m an aspiring Data Analyst who loves turning numbers into stories. With skills in Excel, PowerBI, SQL, and Python, I can find insights in any dataset.

Although I started with a B-Tech in Electrical Engineering, I discovered my true passion lies in data analysis. I may not have worked in a company yet, but I’ve completed several business projects that showcase my ability to tackle real-world problems. You can see these projects in my portfolio below.

I’m excited to bring my skills to a great team and make a difference with data. Take a look at my work and let’s connect to see how I can help your organization thrive!

Key Skills

stakeholder management

Effective Communcation

My SQL

Power BI

MS Excel

My Projects

My Experience

Data Analyst Intern

AtliQ Technologies

June 2023 – Present

Developed a comprehensive dashboard providing actionable insights across various business dimensions, enhancing decision-making capabilities.
Collaborated with cross-functional teams to gather requirements and ensure data accuracy and relevance.
Utilized tools such as Power BI and Excel for data visualization and analysis.
Conducted data cleaning and preprocessing to ensure high-quality data for analysis.
Assisted in generating reports and presentations to communicate findings to stakeholders.
Engaged in continuous learning and skill development in data analytics and visualization techniques.

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/ashutosh-jha01/

+ 91 8240476972

https://github.com/jhaashutosh548

Excel Project

Sales Analytics(FMCG)

Domain/Function: Cunsumer Good

I created two reports for the sales team. These reports help them see how well their customers are doing and understand their market performance compared to their goals.

View Project
Engagement

View Project
on GitHUB

Sales Analytics(FMCG)

Customer Performance Report: Provides net sales performance of each customer across years

Sales Analytics(FMCG)

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

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

Domain/Function: Cosumer Goods

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 and make in

View Project
on GitHUB

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, I created a report that can be used by people in sales, marketing, finance, and the executive team. The main focus was on:

Strong Data Modeling
Easy-to-use Report Design
Detailed, Drillable Insights
Here’s what I learned:

Power Query (basic and advanced tasks)
Simple and complex DAX formulas
Working with more than 10 tables
Picking the right visuals and formatting them well
Dashboard design principles
Using bookmarks for easy navigation
Deploying reports in Power BI service
Implementing feedback from stakeholders
Understanding metrics for sales, marketing, finance, and supply chain
This project helped me improve my skills and create valuable tools for different teams.

Live Interactive Dashboard

PowerBI Project

Power BI Project For Shield Insurance

Domain/Function: Buisennes Insights

Track daily revenue and customer growth. Monitor monthly policy changes. Segment by age group, analyze by city/age. Create revenue/customer trend switch with filters. Add sales mode and age group analysis pages.

View Project
Engagement

View Project
on GitHUB

Power BI Project For Shield Insurance

The home page of this project has a small brief and links for all the other dashbords

Power BI Project For Shield Insurance

the general view page has all the important KPI's requires

Project Details

The objective of this pilot project is to conduct a thorough examination of customer growth and revenue patterns at Shield Insurance Company. The project's primary emphasis is on extracting significant observations regarding customer behavior, revenue generation, geographical distribution, and age group-based statistics. By analyzing these metrics, the project aims to offer valuable insights that help comprehend the company's performance and facilitate informed decision-making based on data

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Ad hoc Insights

Domain/Function: Consumer goods

The SQL-based project for AtliQ Hardwares collects and analyzes consumer insights to address ad-hoc business requests, providing data-driven solutions with optimized queries, dynamic reports, and detailed documentation.

View Project
Engagement

View Project
on GitHUB

View Project
on

Consumer Goods Ad hoc Insights

SQL query to find gross sales in the fiscal year 2021 and the percentage of contribution

Consumer Goods Ad hoc Insights

Top 5 Indian Customers with Highest Average Discount Percentage of FY 2021

Project Details

improve every points and dont increase the haracters
ChatGPT
About Company
AtliQ Hardwares, a leading computer hardware manufacturer in India, also has a strong international presence.

Background
The management has identified a lack of sufficient insights to support quick and smart data-informed decisions.

Problem
There are 10 ad-hoc requests requiring insights.

Approach
Execute SQL queries to address these requests, convert the results into visualizations, and present the insights to top-level management.