Portfolio - Priya Sharma

Priya Sharma

Data Aspirant

1

Excel Project

1

PowerBI Project

About Me

Hi, I'm Priya Sharma — an aspiring Data Analyst with a strong foundation in Excel, Power BI, and SQL. While I began my career at Hexaware Technology, I discovered my true passion lies in working with data and uncovering insights that drive smart business decisions.
With a Bachelor's degree in Electronics Engineering, I bring both technical know-how and an analytical mindset to the table. Over time, I’ve sharpened my skills by working on real-world business projects, several of which are featured in my portfolio below. Each project reflects my ability to turn raw data into meaningful insights through clear visualizations and data-driven storytelling.
I'm now actively looking for opportunities where I can apply these skills to solve real business problems and grow further in the field of data analytics.
Thanks for stopping by — feel free to explore my work!

Key Skills

EXCEL

Power BI

MYSQL

DATA VISUALIZATION

ETL

DATA MODELLING

STAKEHOLDER MANAGEMENT

My Projects

AtliQ Hardwares : Sales & Finance Analytics

Domain/Function: Business Sector

AtliQ Hardware - Buisness Insights 360

Domain/Function: Brick& Motar ,E-commerce

My Experience

KnowledgeWorks Global Ltd - Senior Editorial Associate (Full-Time), Mumbai

May 2021 - Apr 2024

Editorial Associates (EA) to support editorial and/ or production workflows for STM peer-reviewed journals.
Perform quality checks on new and revised manuscript submissions following checklists and journal policy guidelines.

Hexaware Technology - Associate (Full-Time), Mumbai

Jan 2019 - May 2021

Analyzed response time data to address a 10% increase in customer complaints, implementing process changes that reduced average response time by 8% over three months.
Investigated a 5% drop in customer satisfaction scores by conducting root cause analysis on feedback data, addressing key issues, and achieving a 4% improvement in satisfaction.
Developed a standardized process to reduce a 15% variance in issue resolution times, training 20 team members and lowering resolution time variability by 10%.
Created an Excel database to improve data management for key accounts, tracking 30+ escalations monthly and reducing data entry errors by 15%.

Awards & Certificate

Excel: Mother of Business Intelligence

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

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.

Mail Me

[email protected]

https://www.linkedin.com/in/sr-priya/

Call Me

+91 9511246513

GitHub

https://github.com/PriyaSharma206

Excel Project

AtliQ Hardwares : Sales & Finance Analytics

Domain/Function: Business Sector

This project provides an in-depth analysis of AtliQ Mart's sales performance, focusing on customer demographics, regional divisions, and other key segments. It also examines financial metrics such as gross margin, total cost, and overall profitability.

This dives into AtliQ Hardware's net sales performance, providing a comprehensive view of customer metrics across regions, divisions, and country.

This project analyzes AtliQ Hardware’s finance performance, covering net sales, COGS, and gross margin% to provide clear insights.

Project Details

AtliQ Hardware lacked visibility into sales and financial performance due to scattered Excel files. I was tasked with transforming this raw data into insightful reports. Using Power Query, I imported and cleaned datasets (customers, sales, markets, finance), built a dynamic data model with a custom dim_date table, and connected related tables using Power Pivot. I then developed two key dashboards:

Sales Analytics Report – Highlighted customer performance, top/bottom product sales, market-wise net sales vs targets, and best-performing countries using DAX and conditional formatting.

Finance Analytics Report – Built dynamic P&L reports by year, month, and quarter to track gross margin trends across regions.

These reports enabled AtliQ to monitor business KPIs, seasonal trends, and profitability with clarity, enhancing their strategic decision-making.

Tools Used: Power Query, Power Pivot, DAX, Advanced Excel
Skills: Data Cleaning, Data Modeling, Business & Financial Analysis

PowerBI Project

AtliQ Hardware - Buisness Insights 360

Domain/Function: Brick& Motar ,E-commerce

This project provides a comprehensive overview of AltiQ Hardware's business insights across finance, sales, marketing, and supply chain domains. It aims to analyze data effectively to identify areas of loss and understand growth metrics, supporting strategic decisions for improved profitability .

View Project
Engagement

Other Tools

EXCEL

DAX MEASURES

POWER PIVOT

DATA MODELLING

Finance View - Show Profit & Loss statement to understand financial performance across Markets, Products, Customers, etc.

Sales View - Show Top/Bottom customers & products along with key metrics.

Project Details

Project Overview: Analyzed AltiQ Hardware's business data to extract actionable insights across finance, sales, marketing, and supply chain sectors.
Objective: Identified loss areas and growth metrics to drive strategic decisions, enhancing profitability and operational efficiency.
Data Cleaning: Mastered techniques for cleaning and preparing data for accurate analysis.
Data Modeling: Developed data models to establish relationships between tables and improve analytical depth.
DAX Measures: Applied DAX formulas to perform complex calculations, enabling detailed financial and sales analysis.
Visualizations: Created clear, impactful visuals to represent data trends and insights effectively.
Analytical Perspective: Gained a holistic understanding of data analytics processes, improving decision-making through comprehensive data examination.