Portfolio - Harsh Jariwala

Excel Project

Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

Unlock Data with Customer Performance Analytics. This is analytic provides a comprehensive overview of customer performance over period of 2019-2021.

Navigate through the intuitive and valuable insights with the Market performance vs Target, this gives accurate analysis for future plannings

Project Details

Project Description:

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.

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

User-empathetic landing page as a part of dashboard design

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

Excel Project

Coffee Sales Insights

The Coffee Bean Sales Dataset offers a multifaceted exploration of the thriving coffee industry, providing a comprehensive view of sales, customer profiles, and coffee product details. This rich dataset is a gateway to understanding consumer behavior, optimizing product offerings, and improving.

Established connections between all the slicers and the various visual elements present. This linkage ensures that whenever filters are applied throug

A pivot table titled "TotalSales" was generated with the purpose of visually representing the aggregate sales across different time.

Project Details

Overall Objectives:

Identify top 5 customers
Track coffee-type sales trends for better inventory management.
Analyze sales by country to aid expansion.
Solution Requirements:

User-friendly and visually appealing dashboard.
Interactive visualizations for trend identification.
Expected Outcomes:
The Coffee Sales Dashboard will give actionable insights to boost sales, improve customer satisfaction, and drive strategic expansion efforts.

PowerBI Project

Credit Cards Insights with Mitron Bank!

Credit Cards Insights with Mitron Bank! Embarked on an exhilarating journey with Mitron Bank to redefine credit card experiences! Unleashing the power of data analytics, I delved into a treasure trove of insights from 4000 customers across five dynamic cities.

View Project
Engagement

1. Customer Demographic Classification Overview: This view provides a comprehensive classification of customers based on demographics.

Credit Card Insight Overview: This view focuses on insights related to credit card expenditure, analyzing spending patterns

Project Details

Project Objective
The primary objective of this project is to provide Mitron Bank's strategy team with data-driven recommendations to enhance their credit card offerings. Insights are generated through demographic classification, average income utilization, spending patterns, and key customer segment profiling.

Dashboard Views
1. Customer Demographic Classification
Overview: This view provides a comprehensive classification of customers based on demographics, including gender, age group, marital status, city, occupation, and average income.
Key Metrics: Utilizes visualizations to highlight the distribution of customers across various demographic categories.
2. Credit Card Expenditure Insight
Overview: This view focuses on insights related to credit card expenditure, analyzing spending patterns across different categories.
Key Metrics: Visualizes total spending, average income utilization percentage, and key spending categories.

Hello, I am

Harsh Jariwala

2

2

About

Key

My

Sales Analytics(FMCG)

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

Coffee Sales Insights

Credit Cards Insights with Mitron Bank!

Contact Me

Email

Linkedin

Call

Harsh Jariwala

Download Resume