Portfolio - kusum pareek

kusum pareek

Data Analyst

1

Excel Project

3

PowerBI Projects

1

SQL Project

About Me

Hey there, I'm Kusum Pareek, and I'm setting out on a journey to become an exceptional Data Analyst. Even though I studied finance, I've found a love for unlocking the stories hidden within data.

With tools like Excel, SQL, and Power BI, I'm turning numbers into useful insights that help businesses.

You might wonder why I switched from finance to data. It's because I enjoy finding patterns and making sense of information. And this shift wasn't a departure, but rather an evolution. My financial background allows me to understand the context and business implications of data, making my insights more impactful.

Explore my projects below to see real-world examples of how I've used data to solve problems and discover valuable insights.

While I haven't yet worked in a formal setting, I've applied my expertise to captivating projects using real-world datasets.

Join me on this exciting journey as we harness the power of data to drive impactful change.

Key Skills

Effective Communication

Problem Solving

Stakeholder Management

Presentation Skills

My Projects

Sales and Financial Analytics (FMCG)

Business Insights 360

Hospitality Analysis

Domain/Function: Hospitality Sector

Ad-Hoc Insights

Lok Sabha Elections Analysis

Domain/Function: Political Data Analysis

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

Data Analytics Bootcamp 4.0: With Practical Job Placement Support + AI for Data Analysts

Certificate of Achievement

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/in/kusumpareekhere/

GitHub

https://github.com/Kusumpareek

Excel Project

Sales and Financial Analytics (FMCG)

The goal of this project is to deeply understand how the company is doing financially and where it stands in the market. I have created different reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using basic and advanced Excel skills.

View Project
Engagement

View Project
on GitHUB

The Customer Performance Report reveals the net sales performance of each customer over multiple years.

The Market Performance vs Target report allows stakeholders to evaluate how well the country is doing and compare it against the target.

Project Details

In this project, I've developed a dynamic sales report using Excel pivot tables, offering businesses invaluable insights into customer discounts, negotiation strategies, and untapped markets. These reports provide actionable recommendations, empowering businesses to refine sales tactics, elevate customer experiences, and maximize revenue.

Throughout this journey, I've honed skills in:

1. Pivot tables
2. Power Query
3. Basic DAX functions
4. Effective Conditional Formatting
5. Report Presentation
6. Sales Domain Metrics

The primary goal is to arm businesses with the tools and insights needed to monitor, assess, and optimize their sales efforts. By leveraging data-driven analysis, businesses can uncover opportunities for growth, adapt to market changes, and maintain a competitive edge in an ever-evolving landscape.

PowerBI Project

Business Insights 360

AtliQ Hardwares, a consumer electronics company, is growing fast but struggles to keep up with competitors who use data effectively. Most of their reports are still in Excel. My aim is to set up a smart analytics system using Power BI. This will help the company in making smarter decisions.

View Project
Engagement

View Project
on GitHUB

Finance Insights: Unveiling key financial metrics and trends from the project's analytics dashboard.

Data Model: Incorporating 10+ Tables.

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.

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

Domain/Function: Hospitality Sector

I'm on board to help AtliQ Grand, a well-known hotel chain with five-star properties in major Indian cities. Despite its good reputation, they're seeing a drop in revenue and market share. They seek my help to analyze data and offer insights. Using Power BI, I'll chart the course to success.

View Project
Engagement

Gives a snapshot of vital performance indicators like revenue, RevPAR, and occupancy percentage, average rates and other metrics.

Examines booking patterns, cancellations, and guest behavior. Generates actionable insights to improve operational efficiency and drive revenue growth

Project Details

I crafted this project as a third-party data analyst to assist AtliQ Grand, a renowned hotel chain, in reclaiming lost market share and boost revenue. Facing tough competition and lacking data-driven decisions, they sought expertise to turn the tide.

This project offers three comprehensive views:

Performance Overview:
Gives a snapshot of vital performance indicators like revenue, RevPAR, and occupancy percentage. Detailed metrics such as average rates and cancellation percetage are included.

Revenue Breakdown:
Delves into revenue distribution across cities, hotel categories, and booking platforms. These insights are crucial for optimizing sales strategies.

Booking Analysis:
Examines booking patterns, cancellations, and guest behavior. This yields actionable insights to improve operational efficiency and drive revenue growth.

I learned the following things in this project

1. Data Visualization
2. Revenue Analysis
3. Presentation Skills
4.Critical thinking
5. Dax

Project video

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights

AtliQ Hardwares, a leading computer hardware producer, faced challenges in making data-driven decisions. To solve this, they needed a comprehensive report to analyze business queries. This involved utilizing SQL for data analysis and Power BI for creating clear, actionable insights.

View Project
Engagement

View Project
on GitHUB

Complete report of the Gross sales amount for the customer “AtliQ Exclusive” for each month.

This shows the highest and lowest manufacturing cost product.

Project Details

Title: Ad-Hoc Insights

Company: AtliQ Hardwares (an imaginary leading computer hardware producer in India with a global presence)

Challenge: AtliQ Hardwares aimed to enhance data-driven decision-making by expanding their analytics team. Tony Sharma, the Data Analytics Director, devised a SQL challenge to evaluate candidates' technical and soft skills.

My Task: As a hypothetical applicant, I:

Reviewed 'ad-hoc-requests.pdf' with 10 business queries.
Crafted and executed SQL queries.
Developed a Power BI and PowerPoint presentation to showcase insights to top management.

Approach: Utilized MySQL for data retrieval and analysis. Employed Power BI for impactful visualizations. Designed a professional presentation to communicate findings and recommendations effectively.

Outcome: This project demonstrated my ability to handle complex data queries and present findings effectively, enhancing both my technical and communication skills.

Project video

PowerBI Project

Lok Sabha Elections Analysis

Domain/Function: Political Data Analysis

AtliQ Media aims to present unbiased insights into the Lok Sabha elections of 2014 and 2019, focusing on themes like voter turnout. As a data analyst, I have used various tools to analyze the data and generate meaningful insights for a show, avoiding debate on election outcomes.

View Project
Engagement

View Project
on GitHUB

The tables highlight constituencies where BJP and INC gained vote share in 2019 compared to 2014, showcasing changes in voter preferences.

Shows % split of votes of parties between 2014 vs 2019 at state level.

Project Details

Project Overview:

AtliQ Media, a private media company, aimed to create a special broadcast for the 2024 Lok Sabha elections. Rather than engaging in typical debates, they wanted to present unbiased insights from previous elections and explore themes like voter turnout. As a data analyst, I was tasked with this mission, leveraging guidance from my manager and addressing key questions.

My Approach:

1. Analyzed the ‘primary_and_secondary_questions.pdf’.
2. Utilized Power BI and Excel for comprehensive data analysis.
3. Incorporated additional data from official government sites to enhance the analysis.
4. Cleaned and organized data using Power Query in Power BI.
5. Developed interactive visualizations and crafted a compelling presentation.

The project demonstrated my ability to handle large datasets, conduct thorough analysis, and deliver clear, impactful insights.