Powered by
Codebasics DA Bootcamp

Snehal Mahi

Data Analyst

[email protected]

Resume

Hello, I am

Snehal Mahi.

1

Excel Project

1

PowerBI Project

About Me

I’m Snehal Mahi, an aspiring Data Analyst with hands-on experience in Excel, Power BI, SQL, and Python. While I hold a diploma in Computer Programming, I discovered my true passion in data analysis—turning raw data into actionable insights that drive business decisions.

I am honing my skills through an internship at Atliq Hardware, where I work on real-world data challenges. Additionally, I have completed multiple business projects, showcased in my portfolio below, which demonstrate my ability to analyze complex datasets, build interactive dashboards, and deliver data-driven solutions.

I am eager to apply my analytical mindset and technical expertise to solve business problems and contribute to a data-driven culture. Let’s connect!

Key Skills

Power BI

Advanced Excel

SQL (Structured Query Language)

Python

MySQL

My Projects

My Experience

Data Analyst Intern – Atliq Hardware

Dec 2024 – Present

Leveraged Power BI, SQL, and Excel to ensure 97% data accuracy while optimizing data workflows by 43%.
Conducted an in-depth analysis of Shield Insurance’s sales channels, leading to strategic adjustments that enhanced reporting accuracy by 15%.
Improved data modeling, BI, and ETL processes, boosting performance by 33% and enabling more effective data-driven decision-making.
Designed interactive Power BI dashboards, reducing report generation time by 40% and enabling real-time insights for key stakeholders.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

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/snehal-mahi/

https://github.com/snehalmHi

Excel Project

P&L Report

Domain/Function: Financial Analytics & Business Intelligence

P&L Report – Financial Analytics Automated the Profit & Loss report using Power Query, Pivot Tables, and DAX, improving accuracy and reducing manual effort. The report provides insights into revenue, expenses, and profitability, enabling smarter financial decisions.

The sales of the top 10 products grew from 6.4M to 52M (708%) in 2021, with AQ Mx NB leading with a 5623% growth rate.

This represents top 5 countries

Project Details

Project: P&L Report – AtliQ Group 📊

Domain: Financial Analytics & Business Intelligence 💰

This project focuses on automating the Profit & Loss (P&L) report for AtliQ Group using Power Query, Pivot Tables, and DAX in Excel. The goal was to eliminate manual data processing, improve accuracy, and provide real-time financial insights. By integrating multiple datasets, the report analyzes **revenue, expenses, and profitability trends**, helping stakeholders make data-driven financial decisions.

The automation reduced manual effort ⏳, minimized errors ✅, and improved report generation speed ⚡. Key metrics such as gross profit, net profit, and expense breakdowns are dynamically updated, ensuring up-to-date financial insights.

Key Contributions:
🔹 Automated financial reporting, reducing errors and manual work
🔹 Improved financial data accuracy and decision-making
🔹 Enabled dynamic updates for real-time insights

Tools: Excel (Power Query, Pivot Tables, DAX) 🛠️

PowerBI Project

Business 360

Domain/Function: Brick & Mortar and eCommerce

Designed a Power BI dashboard for AtliQ Hardware, optimizing sales analysis, forecasting, and ETL, improving data accuracy by 25% and accessibility by 32%.

View Project
Engagement

View Project
on GitHUB

Executive View

Sales View

Project Details

Business 360 – Brick & Mortar and eCommerce

This project focuses on analyzing AtliQ Hardware’s global sales trends using Power BI, SQL, Excel, and DAX Studio. A multi-functional Power BI dashboard was developed, integrating data from multiple sources to enhance data accessibility (32%) and reporting accuracy (25%). Advanced DAX calculations and trend analysis were implemented to optimize performance and drive revenue growth (10%). The project also applied ETL techniques to clean and transform data, improving decision-making efficiency while reducing data-related expenses (20%).

Live Interactive Dashboard