Portfolio - Sonia Aggarwal

Excel Project

AtliQ Hardware Sales Report

As a Data Analyst, I helped AtliQ Hardware in managing over 1 million rows of sales and finance data using advanced Excel techniques, answering critical business questions, and gaining knowledge in key areas to improve future decision-making.

View Project
Engagement

View Project
on GitHUB

Report for country-wise Net Sales vs Target performance

Report for customer-wise Net Sales performance at year on year basis.

Project Details

AtliQ Hardware is a growing company that faced challenges collecting and analyzing data from various sources, hampering business decision-making.
As a data analyst, I crafted a solution by analyzing sales and finance data, managing over 1 million rows using advanced Excel techniques like Power Pivot, Power Query, and conditional formatting. This helped answer critical business questions and gain knowledge in key areas, including:
👉 Formulas (basic and advanced)
👉 Enhancing data appearance with conditional formatting
👉 Crafting dynamic pivot tables
👉 Harnessing Power Query for data transformation
👉 Constructing effective data models
👉 Leveraging Power Pivot for in-depth analysis
👉 Introduction to DAX (Data Analysis Expressions)
👉 Polishing reports for a professional look
👉 Grasping sales domain metrics
👉 Navigating finance domain metrics (creating P&L)

My work helped AtliQ Hardware improve data collection and analysis, enabling better decision-making for future growth.

PowerBI Project

Hospitality Analysis - Hotel Chain Business

Stepping in as a dedicated data analyst, I embarked on a journey to revamp AtliQ Grand's data analytics capabilities. With Power BI, I aimed to provide them with real-time insights and actionable information, allowing them to thrive in the competitive hospitality landscape.

View Project
Engagement

View Project
on GitHUB

Hospitality Analysis - Hotel Chain Business

This dashboard helps in analyzing the performance over key metrics like Revenue, RevPAR, DSRN, ADR, Realisation%, Cancellation%, and Occupancy%, etc.

Project Details

Stepping in as a dedicated data analyst, I embarked on a journey to revamp AtliQ Grand's data analytics capabilities. With Power BI, I aimed to provide them with real-time insights and actionable information, allowing them to thrive in the competitive hospitality landscape by comparing Key Performance Indicators WoW basis.

Since implementing Power BI, AtliQ Grand has witnessed a remarkable transformation:
✅ **Streamlined Operations:** Real-time data insights have optimized staff allocation, maintenance schedules, and inventory management.
✅ **Personalized Guest Experiences:** Data-driven decisions enable tailored guest experiences, resulting in increased guest satisfaction and loyalty.
✅ **Revenue Growth:** Smart pricing and marketing strategies, driven by Power BI insights, have led to consistent revenue growth.
✅ **Cost Savings:** Enhanced cost control and waste reduction efforts have improved overall profitability.

Live Interactive Dashboard

SQL Project

Executive Management

Atliq Hardware (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too. To participate in its SQL challenge for the junior data analyst role I am presenting my video presentation of ad-hoc requested reports.

View Project
Engagement

View Project
on GitHUB

Data model created for this project in Power BI with Excel/CSV Files with more than 1 million rows.

These are 10 ad hoc requests for which AtliQ Hardware's stakeholders and top-level management need insights.

Project Details

I'm thrilled to be part of AtliQ Hardware's journey to harness the power of data for smarter decision-making. 🌐💼

Project Objective: Strengthening Data-Driven Decision-Making
Atliq Hardware (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.

However, the management noticed that they did not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. So, they conducted a SQL challenge which will help them to understand the candidate in both tech and soft skills.

So, to participate in this challenge for the junior data analyst role I am presenting my video presentation report to top-level management of AtliQ Hardware.

Agenda of this project:
1. Data Exploration
2. Understanding the Ad Hoc Requests
3. SQL Queries and Data Extraction
4. Insights and Visualizations
5. Conclusion and Future Steps

Project video

PowerBI Project

Business Insight 360

This project's hands-on experience gave me a comprehensive understanding of Power BI software and allowed me to refine my expertise in the FMCG sector. As a data analyst, I created a Power BI dashboard that spanned various departments including Finance, Sales, Marketing, and Supply Chain.

View Project
Engagement

View Project
on GitHUB

Power BI dashboard for diverse company divisions including Finance, Sales, Marketing, and Supply Chain

Project Details

Project Overview: Empowering Data-Driven Decisions
AtliQ Hardware a rapidly growing company, was facing the challenge of efficiently collecting and analyzing data from diverse sources such as SQL databases, Excel sheets, and CSV files.

In my role, I meticulously orchestrated a comprehensive solution that spanned across various departments, including Finance, Sales, Marketing, and Supply Chain.

Project’s Objectives:
🔄 Data Modeling Excellence
💡 Transforming Data with Power Query
💰 Finance Insights Unveiled
📊 Sales Performance Redefined
📣 Marketing Analytics at its Best
📦 Supply Chain Visibility Achieved
👨‍💼 Executive Dashboard
🚀 Unleashing the Power of Power BI Services

Some other key implementations are:
🎯 Project Charter Implementation
📈 Benchmark-Backed Data Validation
🎯 Stakeholder Mapping Analysis
📊 Optimized Reports for Seamless Insights
📊 User Acceptance Testing (UAT) Mastery

Live Interactive Dashboard

PowerBI Project

Shield Insurance Project

Analyzing vast insurance data often poses challenges in extracting actionable insights crucial for strategic decision-making. My presentation addresses this by providing a comprehensive overview of crucial insurance parameters.

View Project
Engagement

View Project
on GitHUB

Documentation to provide a comprehensive guide to clients on navigating, utilizing, and deriving insights from the Power BI report.

Shield Insurance Analysis report helps in analyzing the data on various parameters like location, age group, sales mode, popular policies, etc.

Project Details

🏢 About Company
Shield Insurance Services is a leading provider of comprehensive insurance solutions committed to delivering exceptional service and value to its clients. With a strong focus on innovation and customer-centricity, they aim to redefine the insurance landscape by leveraging cutting-edge technologies and data-driven insights.

🎯 Problem Statement:
Analyzing vast insurance data often poses challenges in extracting actionable insights crucial for strategic decision-making. My presentation addresses this by providing a comprehensive overview of crucial insurance parameters.

🎇 Report Layout:
This report is segregated into 4 different pages to offer a holistic view of insurance performance.
➡ Home
➡ General View
➡ Sales Mode Analysis
➡ Age Group Analysis

🎇 Interactivity: Explore data dynamically using filters, slicers, and drill-down features to tailor your analysis.
🎇 Insights: Uncover trends, correlations, and granular details through interactive visuals.

Project video

Live Interactive Dashboard

Excel Project

My Travel Vlog

By analyzing, the data set provided by the Travel Vlog Company includes information on their video kind, viewers, subscribers, shares, watch time, impressions, etc. I created a dynamic dashboard, which assisted the company in making strategic decisions.

Travel Vlog Excel Dynamic Dashboard

Project Details

I examined the Vlog data set as an analyst to create a dashboard that would answer various queries from stakeholders. Their video type, viewers, subscribers, shares, watch time, impressions, and other statistics are all included in this vlog data set.
This project has enabled me to use my analytical skills, which include:
👉 Pivot Tables,
👉 Slicers,
👉 Dynamic Dashboards,
👉 Pivot Charts such as clustered bar charts, doughnut charts, column charts, etc.

Hello, I am

Sonia Aggarwal

2

3

1

About

Key

My

AtliQ Hardware Sales Report

Hospitality Analysis - Hotel Chain Business

Executive Management

Business Insight 360

Shield Insurance Project

My Travel Vlog

Awards

Contact Me

Email

Github

Linkedin

Call

Sonia Aggarwal

Download Resume