Portfolio - Shital Waghmare

Shital Waghmare

Data Aspirant

Resume

2

PowerBI Projects

About Me

I am a data enthusiast and aspiring Data Analyst who enjoys working with data to uncover insights and tell meaningful stories. With hands-on experience in SQL, Power BI, and Excel, along with a virtual internship at AtliQ Technologies, I focus on building dashboards and reports that help businesses make better decisions.

Key Skills

SQL • Power BI • DAX • Advanced Excel • Data Cleaning • Data Visualization • KPI Analysis • Dashboard Development • Business Reporting • Data Modeling

My Projects

Shield Insurance BI Dashboard

Domain/Function: Insurance

Hospitality Analytics Project in Power BI

Domain/Function: Hospitality

My Experience

Data Analyst Intern (Virtual)

AtliQ Technologies | Dec 2025 (4 Weeks)

Worked on real-world business datasets with a focus on data cleaning, validation, and reporting.
Built interactive Power BI dashboards to track KPIs and support data-driven decision-making.
Applied DAX, data modeling, and visualization best practices to present insights clearly to stakeholders.
Gained exposure to client requirements and insurance domain analytics.

Key Projects:

Shield Insurance BI Dashboard
Hospitality Analytics Dashboard

Data Operator

Swadhaar FinAccess | Mumbai | 2024

Managed and maintained accurate Excel-based records for operational reporting.
Supported day-to-day data handling and reporting workflows, ensuring data consistency and accuracy.
Collaborated with internal teams to resolve data-related issues.

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/shital-waghmare-47b900350/

Call Me

+91 7710806322

GitHub

https://github.com/shitalw103

PowerBI Project

Shield Insurance BI Dashboard

Domain/Function: Insurance

As part of my Data Analytics internship, I built a full Power BI dashboard to analyze revenue trends, customer growth, sales modes, age groups, and policy performance for Shield Insurance.

View Project
Engagement

View Project
on GitHUB

This dashboard provides a high-level overview of Shield Insurance performance, highlighting revenue trends, customer growth, city and age-group segmentation, and policy-wise revenue to support quick business insights and decision-making.

This view focuses on revenue analysis by sales mode, showing contribution percentages and monthly trends across online and offline channels to understand sales performance and channel effectiveness.

Project Details

This project focuses on analyzing key business metrics for **Shield Insurance** by building an interactive **Business Intelligence dashboard**. The dashboard provides insights into **revenue performance, customer growth, sales mode contribution, age group and city-wise segmentation, policy-wise revenue distribution, and settlement percentage trends**. This project was completed as part of my **Data Analytics Internship**, with the objective of supporting data-driven business decision-making.

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Analytics Project in Power BI

Domain/Function: Hospitality

An interactive Power BI dashboard built to analyze hotel performance across multiple properties, focusing on revenue, occupancy, ADR, cancellations, and booking trends to support data-driven decisions in the hospitality domain.

View Project
Engagement

View Project
on GitHUB

This dashboard presents a comprehensive performance overview, including Revenue, RevPAR, Occupancy%, ADR, and realization metrics, along with property-wise comparisons and weekly trends to monitor overall hotel performance.

This view focuses on weekday vs weekend performance, revenue split by category, and booking platform analysis, helping identify demand patterns and channels contributing to higher realization and ADR.

Project Details

This project analyzes key hospitality metrics using Power BI to help stakeholders track revenue, occupancy, ADR, RevPAR, and cancellations across properties. The dashboard provides property-level, trend-based, and booking-platform insights for better decision-making.