Portfolio - Aman Verma

Aman Verma

Data Aspirant

Resume

3

PowerBI Projects

1

Excel Project

About Me

Greetings! 👋

I am Aman Verma, a BBA graduate passionate about solving business challenges through data analysis. 📊 Proficient in Excel, Power BI, SQL, and learning Python, I enjoy transforming raw data into meaningful insights. ✨

I’ve built dashboards, conducted trend analyses, and delivered data-driven solutions. 📈 I believe every challenge is an opportunity to uncover growth or streamline processes. 💡

In my free time, I focus on fitness 💪, read 📚, or immerse myself in nature 🌿. Let’s connect to explore ideas and drive better decisions with data! 🚀

Key Skills

Excel

Power BI

Problem Solving

Stakeholder management

Effective communication

SQL

My Projects

Power BI 360

Domain/Function: Business Intelligence (BI)

Sales analysis

Domain/Function: Sales Performance Analysis

Revenue Insights | AtliQ Grand Hospitality Power BI Project

Domain/Function: Hospitality

Shield Insurance: Performance Insights and Trends

Domain/Function: Insurance and Business Intelligence

My Experience

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/aman-verma-insights/

Call Me

+91 7080156935

GitHub

https://github.com/amanverma-insights

PowerBI Project

Power BI 360

Domain/Function: Business Intelligence (BI)

Upon completing the Codebasics PowerBI course, I gained a deep understanding of problem-solving that extends beyond tool usage. The course equipped me with critical technical skills, including SQL, PowerBI Desktop, Excel, DAX, and DAX Studio, enabling me to optimize reports and enhance data analysis

View Project
on

It’s the front page detailing the dashboard's contents inside this project.

It’s the data modeling or relationships that I need to create for this.

Project Details

After completing the Codebasics Power BI course, I developed strong problem-solving skills beyond the tools, mastering key technologies like SQL, Power BI Desktop, Excel, and DAX.

✔ Created calculated columns and measures with DAX.
✔ Mastered data modeling techniques.
✔ Used Bookmarks for seamless visual navigation.
✔ Applied the DIVIDE function for accurate calculations.
✔ Built dynamic date tables with M language.
✔ Customized titles based on filters.
✔ Integrated KPIs and conditional formatting with icons.
✔ Explored data validation techniques.
✔ Gained experience in Power BI services, including report publishing, gateway setup, and app creation.
✔ Strengthened collaboration, workspace management, and access control.
✔ Analyzed Gross Price, Pre-Invoice Deductions, and Post-Invoice Deductions for insights.

Live Interactive Dashboard

Excel Project

Sales analysis

Domain/Function: Sales Performance Analysis

Developed comprehensive sales reports to enable the sales team to evaluate customer performance and assess market trends relative to their targets. These reports provide actionable insights, helping the team identify strengths, address gaps, and align strategies to achieve business objectives effect

View Project
Engagement

View Project
on GitHUB

Market performance for 2019, 2020, and 2021, including 2021 actual vs. target and percentage change.

Top and bottom 5 products.

Project Details

This project focused on creating a sales analysis report using Excel pivot tables and advanced tools. The report enables businesses to identify effective discount strategies, support consumer negotiations, and uncover growth opportunities. It provides actionable insights to refine sales strategies, enhance customer satisfaction, and maximize revenue.

Key skills applied include pivot tables for data summarization, Power Query for data transformation, basic DAX for advanced calculations, conditional formatting for trend analysis, and report design for usability and aesthetics.

The project delivers data-driven solutions to optimize discounting, monitor sales performance, and identify market expansion opportunities. It highlights how sales analytics can drive growth and competitiveness through strategic insights.

PowerBI Project

Revenue Insights | AtliQ Grand Hospitality Power BI Project

Domain/Function: Hospitality

This dashboard delivers a comprehensive analysis of hotel performance, focusing on revenue, occupancy trends, and cancellation impacts. It provides actionable insights to optimize strategies and enhance profitability.

This dashboard analyzes AtliQ properties' performance, focusing on revenue, occupancy, ADR, and cancellations to optimize operations.

This showcases the data modeling and relationships implemented in Power BI.

Project Details

Introduction:
This dashboard provides an in-depth analysis of hotel performance metrics, highlighting revenue drivers, occupancy trends, and cancellation impacts. It offers actionable insights for strategic decision-making.

Task Execution:
Defined KPIs like Revenue, ADR, and Realisation% while designing an interactive, filterable dashboard to uncover trends and insights.

Learning Points:
Built time-series visuals, implemented clear filters, analyzed booking platforms, and ensured a consistent color palette for branding.

Key Insights:
1. Total revenue: ₹1.7B.
2. AtliQ Bay has the highest occupancy (66%).
3. Cancellations cause a 24.84% revenue loss, with Elite rooms having the highest rates.
4. Business stays dominate (57.59%), but luxury shows growth potential (58.12%).
The dashboard emphasizes data-driven strategies for improving performance and reducing revenue leakage.

Live Interactive Dashboard

PowerBI Project

Shield Insurance: Performance Insights and Trends

Domain/Function: Insurance and Business Intelligence

Designed a dynamic Power BI dashboard for Shield Insurance, empowering data-driven decisions. Delivered actionable insights into customer count, revenue trends, and daily growth rates. Enhanced analysis with segmentation by age groups, cities, and sales modes.

The General View of Shield Insurance's dashboard provides key performance metrics for tracking progress effectively.

This is the picture of connections in Power BI.

Project Details

🌟 Shield Insurance's Power BI Success Story 🌟
Shield Insurance leverages Power BI to excel in the Indian market by enhancing team communication and strategy.

🚀 𝐖𝐨𝐫𝐤𝐟𝐥𝐨𝐰
- Data Cleaning: Ensured integrity with Power Query.
- Enhanced Model: Added dimension tables for simplified calculations.
- Data Modelling: Created measures for actionable insights.

🎯 𝐎𝐮𝐭𝐩𝐮𝐭: 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝
1. Home Page: Overview of purpose and content.
2. General View: KPIs for monthly/daily revenue and customer growth.
3. Sales Mode: Revenue trends by sales mode (pie & trend charts).
4. Age Analysis: Policy preferences by age (ribbon charts).

🛠️ 𝐓𝐨𝐨𝐥𝐬 & 𝐒𝐤𝐢𝐥𝐥𝐬
- Tools: Power BI, PowerPoint
- Skills: Data Cleaning 🧹, Modeling, DAX, Measures

Shield Insurance drives data-powered growth with customer-focused strategies! 🌟