Divya Baghel

Data Analyst

[email protected] +91 9958335407

Resume

Hello, I am

Divya Baghel.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About Me

"Hey there! I'm on a mission to become a data analyst extraordinaire! I love diving into data using Excel, Power BI, SQL, and Python to uncover hidden gems. Currently, I'm pursuing my Master's in Mathematics and Computing at the Dr. BR Ambedkar National Institute of Technology. While I may not have work experience yet, I've got plenty of hands-on practice through business projects showcased in my portfolio below. From crunching numbers to creating meaningful insights, I'm all about turning data into action. Let's team up and make data work for us! Ready to dive in?"

Key Skills

Statistical Analysis

Data Visualization

Communication Skills

stakeholder management

sql

power BI

EXCEL

Adhoc Analysis

My Projects

Sales Performance Insights: An Analytical Approach Using Excel

Domain/Function: Sales analytics and reporting.

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

Domain/Function: Data Analytics and Dashboard Design

Optimizing Hospitality Revenue: Power BI Dashboard for Strategic Insights

Domain/Function: Hospital Domain

Data-Driven Insights on Festive Promotions: Analyzing AtliQ Mart's Sales Strategy

Domain/Function: ATLIQ MART SALES PERFORMANCE

My Experience

Dataworks Solutions | Data Analysis Intern
July 2023-August 2023

Cleaned and organized pharmaceutical sales and inventory data in Excel, reducing processing time by 20%.
Validated clinical trial data, enhancing accuracy by 15% and ensuring regulatory compliance.
Developed Power BI dashboards to visualize drug performance and patient adherence trends, increasing data accessibility by 10%.
Collaborated with cross-functional teams to analyze market trends, delivering actionable insights for business growth.

Accenture | Virtual Data Analysis Intern
Dec 2023 – Jan 2024

Participated in a data analysis simulation for a social media client, providing strategic insights for content optimization.
Analyzed trends from seven datasets, identifying key metrics for decision-making.
Created concise presentations to effectively communicate findings to clients and stakeholders.

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/feed/

Call Me

+91 9958335407

GitHub

https://github.com/divyaabaghel1509

Excel Project

Sales Performance Insights: An Analytical Approach Using Excel

Domain/Function: Sales analytics and reporting.

Developed two Excel reports: one assessing customer performance with purchase behaviors and metrics, and the other analyzing market performance with sales trends and target progress. These reports support data-driven decisions and strategy optimization.

View Project
Engagement

Customer Performance Report: Shows the yearly net sales data for each customer, highlighting trends and performance over time.

Market Performance vs. Target Report: Allows stakeholders to evaluate the country's annual performance and compare it against the established targets.

Project Details

In this project, I created a sales report using Excel pivot tables. This report helps businesses figure out the best customer discounts, negotiate better with customers, and find new expansion opportunities in potential markets. The reports offer useful insights and recommendations to improve sales strategies, increase customer satisfaction, and grow revenue.

I learned the following:

Pivot Tables
Power Query
DAX (Basics)
Conditional Formatting
Report Design
Sales Metrics
This project gives businesses the tools and insights to track, evaluate, and enhance their sales activities. Using sales data analysis, companies can find new opportunities, drive growth, and stay competitive.

PowerBI Project

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

Domain/Function: Data Analytics and Dashboard Design

AtliQ Hardware, a rapidly growing electronics company, struggles to compete due to outdated Excel reports. My goal is to implement a Power BI analytics solution to deliver actionable insights and enable data-driven decision-making for better competitive performance.

View Project
Engagement

A user-friendly landing page is integrated into the dashboard design for intuitive navigation.

Data model showcasing connections between 10+ tables for comprehensive analysis.

Project Details

This project aims to create a unified report for stakeholders in sales, marketing, finance, and executive teams.

Key focuses include:

Advanced Data Modeling
User-Friendly Report Design
Interactive Insights

Skills acquired:

Power Query (Basic and Advanced)
Basic and Advanced DAX Formulas
Data Modeling with 10+ Tables
Visual and Formatting Selection
Dashboard Design Principles
Using Bookmarks
Power BI Service Deployment
Incorporating Stakeholder Feedback
Metrics for Sales, Marketing, Finance, and Supply Chain

Live Interactive Dashboard

PowerBI Project

Optimizing Hospitality Revenue: Power BI Dashboard for Strategic Insights

Domain/Function: Hospital Domain

Developed a Power BI dashboard with two tabs for the hospitality domain: a main dashboard providing revenue and booking insights, and a tooltip tab offering detailed, on-hover information for enhanced data interpretation and decision-making.

View Project
Engagement

Hospitality Revenue Dashboard: Displays yearly revenue data for each room type and customer segment, highlighting booking trends and performance over.

Provides on-hover insights into revenue for business and luxury categories, helping to fine-tune strategies for each segment.

Project Details

In this project, I developed a hospitality revenue dashboard in Power BI with two key tabs: a main dashboard offering comprehensive insights into revenue trends, room types, and customer segments, and a tooltip tab providing on-hover detailed data for quick reference. This dashboard helps hotels optimize booking strategies, target high-value customers, and improve revenue management. It offers actionable insights to enhance decision-making, increase operational efficiency, and drive revenue growth.

Live Interactive Dashboard

SQL Project

Data-Driven Insights on Festive Promotions: Analyzing AtliQ Mart's Sales Strategy

Domain/Function: ATLIQ MART SALES PERFORMANCE

Analyzed festive promotion effectiveness for AtliQ Mart’s 50+ stores using Power BI and SQL. Created a dashboard to identify successful campaigns, track sales trends, and provide actionable insights for future promotions. Improved reporting clarity, enabling data-driven decision-making for enhanced

View Project
Engagement

View Project
on GitHUB

- Compared sales performance across various promotion types. - Identified high-performing promotion types driving maximum sales uplift.

- Evaluated sales performance for each store location. - identified top-performing stores during festive promotions.

Project Details

- Analyzed AtliQ Mart's festive promotions across 50+ stores during Diwali 2023 and Sankranti 2024, identifying successful and underperforming campaigns.
- Built an interactive Power BI dashboard to visualize sales uplift, product performance, and customer engagement.
- Used SQL to generate ad-hoc reports, addressing specific business questions from senior executives.
- Offered insights on sales trends and customer behavior, pinpointing key products and promotion strategies for future improvement.
- Presented findings in a clear PowerPoint, equipping AtliQ Mart’s Sales Director with actionable insights for optimized promotional planning.