Portfolio - Harshit Arora

PowerBI Project

Analysis on MAANG Stocks using PowerBi

A dashboard for monitoring MAANG Stocks include key financial and performance metrics for each of these companies, allowing investors and analysts to track their stock prices, market capitalization, revenue, earnings, growth rates, and other relevant indicators.

View Project
Engagement

View Project
on GitHUB

The "MAANG Stock Data Analysis Using Power BI" project aims to provide comprehensive insights into the stock performance of MAANG stocks.

Comparison between the debate of Microsoft or Meta should be in MAANG.

Project Details

Project Title: "MAANG" Stock Data Analysis Using Power BI 📊
Project Description: 📈
The "MAANG Stock Data Analysis Using Power BI" project aims to provide comprehensive insights into the stock performance of five of the world's leading technology companies: Meta (formerly Facebook), Amazon, Apple, Netflix, and Google (Alphabet Inc.). This analysis will be conducted using Power BI, a powerful data visualization and business intelligence tool. The project will involve collecting, processing, and visualizing stock data to uncover trends, patterns, and correlations that can inform investment decisions and strategic planning.
Objective: 📉
1 . To understand MAANG's performance in the last 5 years.
2 . And Contribute to debate the Nvidia or Netflix and Microsoft or Meta should be in MAANG.

Project video

Live Interactive Dashboard

Excel Project

Sales Report

Generated a comprehensive P&L report for AtliQ Hardware FY 2022, utilizing advanced features in Excel such as Pivot Tables and DAX to provide granular insights into revenue streams and expense categories.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provide net sales performance of each customer across years.

P&L by Fiscal Year: Our financial health is a reflection of our efforts and decisions.

Project Details

I'm absolutely thrilled to share a deep dive into the data-driven world of customer performance, market dynamics, and the financial health of our organization by fiscal year. 🚀

📈 Customer Performance: Our customers are at the heart of everything we do, and I can't wait to reveal how their behaviors, preferences, and interactions with our products/services have evolved over the past year. These insights will empower us to make strategic decisions that enhance customer satisfaction and loyalty.
📊 Market Performance: Beyond our own walls, we'll explore the broader market landscape. What are the trends, competitors' moves, and opportunities that have shaped our industry? Understanding market performance is the compass that guides our future strategies.
💰 P&L by Fiscal Year: Our financial health is a reflection of our efforts and decisions. Together, we'll dissect the Profit & Loss statements for each fiscal year, analyzing revenue streams, cost structures, and bottom-line results. The

Python Project

Hotel Data Analysis using the Pandas Library in Python

Hotel data analysis has become an essential practice for the hospitality industry to make informed decisions, improve guest experiences, and optimize operations. This project focuses on utilizing the powerful Pandas library in Python to perform comprehensive analysis on hotel-related data.

View Project
on GitHUB

Hotel Data Analysis using the Pandas Library in Python

This project focuses on utilizing the powerful Pandas library in Python to perform comprehensive analysis on hotel-related data

Data Cleaning: 1. Handling missing values, duplications, and outliers. 2. Standardizing data formats and converting data types.

Project Details

In this project, we will explore a variety of tasks and techniques that Pandas offers for handling, cleaning, transforming, and visualizing hotel data. Starting with data loading, we will demonstrate how to import data from various sources such as CSV files, Excel spreadsheets, and databases. Using Pandas DataFrames, we will then delve into the following key aspects of hotel data analysis:

1. Data Cleaning and Preprocessing:
2. Exploratory Data Analysis (EDA):
3. Customer Segmentation:
4. Booking and Revenue Analysis:

Throughout the project, you will learn how to harness the power of Pandas to efficiently manipulate, analyze, and visualize hotel data, thereby extracting actionable insights. By the end of this analysis, you will have gained valuable skills in data preprocessing, exploratory analysis, and even predictive modeling, all while focusing on real-world hotel-related data challenges.

Project video

SQL Project

Census Analysis

Census by definition is the compilation of records such as demographic profile, poverty profile, economic profile, social services and facilities etc. The Census Data Analysis project is a data-driven exploration that effectively organize, store, and analyze large volumes of census-related data.

View Project
on GitHUB

In SQL, joining tables allows you to combine data from two or more tables based on a related column or set of columns. This is a fundamental operation

Shows the population in previous census. Comparison between population vs area

Project Details

The MySQL project on Census Data analysis showcases the power of relational database management systems in handling and deriving meaningful insights from extensive and diverse datasets, thereby contributing to informed decision-making and policy formulation based on accurate demographic information.

Project video

PowerBI Project

Analyze Growth and Present Insights to the Telangana Government

The current Telangana government has implemented impactful policies and initiatives to boost economic growth, investments, and employment in the state.

View Project
Engagement

View Project
on GitHUB

Analyze Growth and Present Insights to the Telangana Government

Aimed to support the government in making informed decisions that would positively impact the lives of Telangana's residents and shape the future.

Telangana is renowned for its opulent cultural heritage, exquisite historic landmarks, captivating natural beauty, and lively festivals.

Project Details

Key Objectives 🚀
1. To Explore Stamp Registration, Transportation and Ts-I pass Datasets.

2. To Understand their attributes, categories and time period.

3. To Analyze trends and patterns within each department.

4. To Identify growth opportunities and areas needing attention.

5. To Find correlation among these departments and report the overall growth of the state through insights and relevant visuals such as shape maps.

📝 Research Questions:

- Preliminary Research
- Secondary Research

📉 Insights:
1. Progress and Potential
2. Sectoral Opportunities
3. Agricultural Focus
4. Investment Gap

📋 Recommendations:
1. Diversify the Economy
2. Healthcare and Well-being
3. Investment Promotion
4. Infrastructure Development
5. Inclusive Growth
6. Agriculture and Rural Development

Project video

Live Interactive Dashboard

PowerBI Project

Analyzing Promotions and Providing Insights to the Director

In this project, I delved deep into the promotional strategies employed by our company, leveraging data-driven insights to uncover valuable opportunities for boosting sales and optimizing marketing efforts.

View Project
Engagement

View Project
on GitHUB

Analyzing Promotions and Providing Insights to the Director

Promotion Effectiveness: Examined the performance of past promotions to identify which ones yielded the highest returns and resonated most with our ta

Recommendations: Provided actionable recommendations to the Sales Director, including targeted promotional campaigns, pricing strategies, and product

Project Details

Problem Statement :
AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Now the sales director wants to understand which promotions did well and which did not so that they can make informed decisions for their next promotional period.
Sales director Bruce Haryali wanted this immediately but the analytics manager Tony is engaged on another critical project. Tony decided to give this work to Peter Pandey who is the curious data analyst of AtliQ Mart. Since these insights will be directly reported to the sales director, Tony also provided some notes to Peter to support his work.

Key highlights of my analysis include:
- Promotion Effectiveness:
- Customer Segmentation:
- Seasonal Trends:

Hello, I am

Harshit Arora

1

3

1

1

About

Key

My

Analysis on MAANG Stocks using PowerBi

Sales Report

Hotel Data Analysis using the Pandas Library in Python

Census Analysis

Analyze Growth and Present Insights to the Telangana Government

Analyzing Promotions and Providing Insights to the Director

Awards

Contact Me

Email

Github

Linkedin

Call

Harshit Arora

Download Resume