Portfolio - Harsha Sharma

Harsha Sharma

Data Aspirant

Resume

1

Excel Project

1

PowerBI Project

About Me

Hello! I'm Harsha Sharma, an MCA graduate with a strong interest in Data Analytics, Business Intelligence, and Data Visualization. I enjoy transforming raw data into meaningful insights that help organizations make informed business decisions.

I have hands-on experience with Power BI, SQL, Python, Advanced Excel, ETL, Data Modeling, DAX, Power Query, and MySQL. Through my projects, I have built interactive dashboards, optimized report performance, and analyzed large datasets to uncover business trends and key performance indicators.

One of my key projects, Business Insights 360, involved designing an end-to-end Power BI solution by integrating over a million records from multiple data sources. I also developed comprehensive sales and financial analytics dashboards using Excel, enabling detailed analysis of revenue, profitability, customer performance, and market trends.

Before pursuing my master's degree, I worked as a Desktop Support Trainee at Experis IT Pvt. Ltd., where I resolve

Key Skills

Excel

Power BI

Effective Communication

Stakeholder Management

My Projects

Sales Analytics(FMCG)

Domain/Function: Sales Analytics | Business Intelligence | FMCG

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

Domain/Function: Business Intelligence | Data Analytics | Sales, Finance, Marketing & Supply Chain Analytics

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Power BI : Dashboards for Beginners

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/harsha-sharma30/

Call Me

+91 9538717360

GitHub

https://github.com/HarshaSharma181

Excel Project

Sales Analytics(FMCG)

Domain/Function: Sales Analytics | Business Intelligence | 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.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report Customer-wise sales analysis from 2019–2021 Tracks revenue growth and top customers Provides insights into customer contribution and business growth

Market Performance Vs Target Compares actual sales against 2021 targets Analyzes country-wise sales performance Helps identify underperforming markets

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: Business Intelligence | Data Analytics | Sales, Finance, Marketing & Supply Chain Analytics

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
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables