Portfolio - Sandhya H M

Excel Project

Sales Analytics(FMCG)

I created two reports for the sales team to help them evaluate customer performance and understand their market performance in relation to their targets.

View Project
on GitHUB

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

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

Project Details

In this project, I developed a sales report using Excel pivot tables. These reports allow businesses to identify effective customer discounts, negotiate better with consumers, and find new expansion opportunities in promising countries. The insights and recommendations provided help businesses optimize their sales strategies, improve customer satisfaction, and boost revenue.
Skills Acquired
Pivot tables
Power Query
Basic DAX
Conditional formatting
Report beautification
Sales domain metrics
Overall, this project equips businesses with the tools and insights needed to monitor, evaluate, and enhance their sales activities. By analyzing sales data, businesses can discover new opportunities, drive growth, and stay competitive in a dynamic market.

PowerBI Project

BUSINESS INSIGHT 360 Dashboard for Finance, Sales, Marketing, Supply Chain and Excecutive

AtliQ Hardwares, a rapidly growing consumer electronics company, struggled to compete using data because most of their reports were still in Excel. My goal was to implement an advanced analytics solution using Power BI to help the company gain insights and make informed decisions.

View Project
on GitHUB

BUSINESS INSIGHT 360 Dashboard for Finance, Sales, Marketing, Supply Chain and Excecutive

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

This project aimed to create a single report that stakeholders from sales, marketing, finance, and the executive team could use. The key focus areas were:

1. Robust data modeling
2.User-friendly report design
3.Detailed, drill-down insights
Skills Learned
-Power Query (basic and advanced operations)
-Basic and complex DAX formulas
-Data modeling with over 10 tables
-Selecting the right visuals and formatting
-Dashboard design principles
-Using bookmarks
-Deploying reports in Power BI service
-Implementing stakeholder feedback
-Metrics for sales, marketing, finance, and supply chain
This project equipped me with the skills to create comprehensive and insightful reports that help businesses make better decisions.

Live Interactive Dashboard

PowerBI Project

HR ANALYTICS

This project involved analyzing the attendance data of Atliq Technologies over the past three months to provide valuable insights to the HR Generalist. By employing data extraction, transformation, and loading (ETL) techniques, we utilized Power BI Desktop to generate insightful visualizations.

View Project
on GitHUB

visualized the data and created interactive dashboards. Developed visualizations to highlight attendance trends, sick leave

Visual created using different charts which helped to understand employees attendance

Project Details

Atliq Technologies' HR Generalist needed to gain insights from the attendance data collected over the last three months. The goals included understanding employee attendance patterns, developing retention strategies, and identifying reasons behind sick leave percentages. Additionally, the analysis aimed to differentiate between Work From Home (WFH) and Work From Office (WFO) percentages.

Data Source The attendance data was provided in an Excel file. It underwent ETL operations to prepare it for detailed analysis.

Steps :

-Understanding the Problem:
Defined the analysis scope, focusing on attendance patterns, retention strategies, and sick leave percentages.
- Data Gathering and Transformation:
Collected attendance data from the provided Excel file.
Applied ETL operations to clean and transform the data for analysis.
-Utilized Data Analysis Expressions (DAX) to create key metrics such as attendance percentages, sick leave percentages, and WFH/WFO percentages.

Hello, I am

Sandhya H M

1

2

About

Key

My

Sales Analytics(FMCG)

BUSINESS INSIGHT 360 Dashboard for Finance, Sales, Marketing, Supply Chain and Excecutive

HR ANALYTICS

Contact Me

Email

Github

Linkedin

Call

Sandhya H M

Download Resume