Portfolio - Divya Khandelwal

Hello, I am

Divya Khandelwal

Data Analyst

Resume

2

PowerBI
Projects

About

Detail-oriented and analytical entry-level Data Analyst with a strong foundation in data visualization, statistical analysis, and database management. Microsoft Certified Power BI Data Analyst Associate, skilled in creating insightful dashboards, analyzing complex datasets, and delivering actionable insights. Proficient in tools like SQL, Excel, and Python, with a passion for leveraging data to drive informed business decisions. Committed to continuous learning and eager to contribute to innovative data-driven solutions.

Key

Skills

Power BI

SQL

Excel

Python

My

Projects

Business Insights 360

Domain/Function: FMCG- consumer electronics

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution that will enable the company to get insights and make informed decisions

AtliQ Grands

Domain/Function: Hospitality Domain

AtliQ Grands are losing its market share and revenue in the luxury/business hotels category. My goal is to provide a dashboard that serves as a vital tool to identify revenue opportunities, optimize pricing, and track performance against competitors in real-time.

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

Python: Beginner to Advanced For Data Professionals

Microsoft certified: Power BI Data Analyst Associate

Contact Me

Email

[email protected]

Github

https://github.com/divya220223

https://www.linkedin.com/in/divya-khandelwal-96177113b/

Divya Khandelwal

Data Analyst

Download Resume

Resume

PowerBI Project

Business Insights 360

Domain/Function: FMCG- consumer electronics

View Project
Engagement

Data modelling involving 10+ tables

User-empathetic landing page as a part of dashboard design

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

AtliQ Grands

Domain/Function: Hospitality Domain

View Project
Engagement

Data model with 20+ key measures

Key Performance overview report page

Project Details

AtliQ Grands, with 20 years in the hospitality industry, faced stiff competition and revenue decline in the luxury/business hotel category. Without an in-house analytics team, they needed a solution to uncover insights from their historical data to regain their market share.
💡 Our Solution:
By leveraging their historical data and deploying a Power BI dashboard, we provided the revenue management team with:
📊 Actionable KPIs: Revenue trends, occupancy rates, and market segment performance.
🔍 Advanced Insights: Customer segmentation, booking channel efficiency, and pricing strategies.
🚦 Strategic Visuals: Easy-to-understand visuals that aid quick and effective decision-making.
✨Insights and Recomendations:
✅Optimize Pricing Strategy: Dynamic + differential pricing
✅Enhance marketing and promotions: competitive discounts and campaigns
✅Focusing on customer satisfaction and improving business strategies for underperforming cities(Delhi) and direct online/ offline platforms

Hello, I am

Divya Khandelwal

2

About

Key

My

Business Insights 360

AtliQ Grands

Awards

Contact Me

Email

Github

Linkedin

Divya Khandelwal

Download Resume