Portfolio - Mohammed Saqib

Excel Project

Bank Loan Analysis

Domain/Function: Excel and SQL

Certainly! Here’s a summary of your project focusing on the KPIs: In my recent project, I focused on analyzing key performance indicators (KPIs) related to loan applications. The primary goal was to calculate and monitor the total number of loan applications received over a specified period.

View Project
on GitHUB

Other Tools

Excel

SQL

summary of bank loan analysis

overview of bank loan analysis

Project Details

bank loan analysis

Excel Project

Coffee sales Dashboard

Domain/Function: Excel and SQL

This is a Coffee sales dashboard that I have created to analyze the various KPI's as mentioned below: 1. Total Sales Over Time 2. Sales by Country 3. Top 5 Customers

View Project
on GitHUB

The main dashboard that indicates the total sales over the years, top 5 consumers and sales in different countries

Depicts the sales of arabica coffee type and how it has been the most favorite coffee for the consumers

Project Details

KPIs for Coffee Analytics Dashboard:

1. Total Sales Over Time:
Track the overall sales performance across various time periods (daily, weekly, monthly) to identify trends and measure growth.

2. Sales by Country:
Analyze and compare sales distribution across different countries to identify key markets and regions driving revenue.
Top 5 Customers
Identify and monitor the top-performing customers based on total sales, helping to focus on high-value relationships and opportunities for upselling.

3. Tools and Techniques:

To achieve these insights, I will be leveraging advanced Excel functions such as XLOOKUP and INDEX-MATCH for dynamic data retrieval, extensive formatting for clear visual representation, and Pivot Tables for powerful data summarization and analysis.

PowerBI Project

HR Analytics Dashboard

Domain/Function: Power BI

In the HR analytics dashboard, I was using my Power BI skills to understand overall the important components such as the rate of attrition, Attrition by age, average salary, average years in company which would help the HR's of the company to take informed decisions

View Project
on GitHUB

Dashboard showing various metrics such as job satisfaction score, average attrition age, attrition by salary slab, attrition by job role..

Changes in Dashboard using slicers

Project Details

In the HR analytics dashboard, I was using my Power BI skills to understand overall the important components such as the rate of attrition, Attrition by age, average salary, average years in company which would help the HR's of the company to take informed decisions.
Insights obtained:
The maximum percentage of employees who left the company fell into the age bracket of 26-35.
People who had a salary of upto 5K and less where the people who left the company the most.
Maximum prople have left the company wthin just 1 year of completition of the company.
There were many more insights but these were some of the key insights mentioned above because of which people left the company.
Technicalities used:
Data Cleaning & Processing in Power BI
Power BI Dashboard Setup
Importing data in Power BI
Power Query in Power BI
Using of DAX functions
Using Charts in Power BI
Using Filters and Slicers in Power BI
Creating a Dashboard in Power BI
Exporting Power BI Dashboard

PowerBI Project

Credit Card Analysis

Domain/Function: Power BI

To develop a comprehensive credit card weekly dashboard that provides real-time insights into key performance metrics and trends, enabling stakeholders to monitor and analyze credit card operations effectively.

View Project
on GitHUB

Revenue increased by 28.8%, • Total Transaction Amt & Count increased by xx% & xx% • Customer count increased by xx%

Overall revenue is 57M • Total interest is 8M • Total transaction amount is 46M • Male customers are contributing more in revenue 31M, female 26M

Project Details

Developed an interactive dashboard using transaction and customer data from a SQL database, to provide real-time insights.

Streamlined data processing & analysis to monitor key performance metrics and trends.

Shared actionable insights with stakeholders based on dashboard findings to support decision-making processes.

Python Project

Atliq Grand's Hotel Analysis

Domain/Function: Python

The project aims to conduct a comprehensive analysis of the hotel industry using Python. By harnessing data-driven insights and strategic recommendations, the goal is to empower Atliq Grands to make informed decisions. The ultimate objective is to help Atliq Grands regain a competitive edge in the m

View Project
on GitHUB

Presidential rooms have the highest occupancy at 59.30%, and Delhi leads with a 61.61% occupancy rate.

Weekend occupancy is 72.39%, highlighting strong demand; consider targeted promotions to capitalize on this trend.

Project Details

**Project Overview:** Atliq Grands faces revenue decline and market share loss. External support was sought to use data for strategic insights and customer retention.

**Objective:** Analyze data with Python to develop strategies for market competitiveness.

**Process:** Cleaned and analyzed datasets on bookings, hotels, and rooms.

**Key Insights:** High occupancy in presidential rooms (59.30%) and Delhi (61.61%); better weekend occupancy (72.39%). Mumbai leads in revenue; Bangalore lags.

**Recommendations:** Promote less popular options, enhance weekday offers, and improve ratings and revenue.

**Conclusion:** Provided data-driven strategies to boost Atliq Grands' competitiveness and revenue.

PowerBI Project

EV Analysis using Power BI

Domain/Function: Excel and Power BI

This analysis aims to provide a comprehensive view of the electric vehicle (EV) market by examining both Battery Electric Vehicles (BEVs) and Plug-in Hybrid Electric Vehicles (PHEVs).

View Project
on GitHUB

This is the overall EV Analysis which shows the increasing graph of EV's from 2010 onwards,

This show how the tesla has dominated the market by a staggering 45.96 % of the total market share and how the vehicles manufactured are BEV.

Project Details

Total Number of EVs: We have 150.42k total electric vehicles in our dataset, encompassing both BEVs and PHEVs.
Average Electric Range

Average Range: The average electric range of the vehicles is 67.83 miles. This indicates the average performance capability of the electric vehicles available.

Total BEV Vehicles & % of Total PHEV Vehicles

Total BEVs: There are A Battery Electric Vehicles.
Percentage of BEVs: BEVs constitute 78% of the total EVs in our dataset.

Total PHEV Vehicles & % of Total PHEV Vehicles

Total PHEVs: There are C Plug-in Hybrid Electric Vehicles.
Percentage of PHEVs: PHEVs make up 22% of the total EVs in our dataset.

Hello, I am

Mohammed Saqib

2

3

1

About

Key

My

Bank Loan Analysis

Coffee sales Dashboard

HR Analytics Dashboard

Credit Card Analysis

Atliq Grand's Hotel Analysis

EV Analysis using Power BI

Contact Me

Email

Linkedin

Call

Mohammed Saqib

Download Resume