Portfolio - fahad rasool | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

fahad rasool

Data Aspirant

Resume

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About

Me

🔍 Aspiring Data Analyst

Hello there! I'm Fahad Rasool, on a passionate journey towards becoming a skilled Data Analyst and Data Engineer.

📊 Keen Analytical Mindset.
💡 Aspiring Data Engineer.
📚 Continuous Learning Journey.
🌐 Networking and Collaboration.
🚀 Ready to Contribute.

Key

Skills

python

sql

dax

My

Projects

P&L Report for AtliQ Hardware

P&L Report for AtliQ Hardware

Created a detailed P&L report for AtliQ Hardware FY 2022 with advanced Excel features with includes Sales and Finance Data for last 4 years and comparisons .

Business 360

Designed a Power BI dashboard to understand AtliQ hardware’s last 4 years' sales trends including (sales, finance, supply chain, executive, marketing, products) views.

AtliQ Hospitality Analysis

AtliQ Hospitality Analysis

Embarked on a comprehensive analysis of revenue data within the hospitality industry, aiming to extract actionable insights to drive strategic decision-making and optimize business performance.

Executive Management

Executive Management

Provide Insights to Management in Consumer Goods Domain. Check ‘ad-hoc-requests.pdf’ - there are 10 ad hoc requests for which the business needs insights

Contact Me

Email

[email protected]

Github

https://github.com/rasoolfahad631

Linkedin

https://www.linkedin.com/in/fahad-rasool-9b8b171b1/

Call

+91 6260412341

fahad rasool

Data Aspirant

Download Resume

Resume

Excel Project

P&L Report for AtliQ Hardware

Created a detailed P&L report for AtliQ Hardware FY 2022 with advanced Excel features with includes Sales and Finance Data for last 4 years and comparisons .

View Project
Engagement

P&L Report for AtliQ Hardware

Customer Net Sales performance for with comparison over years.

P&L Report for AtliQ Hardware

Sales performance at market level with Sales Varianc.

Project Details

● Automated data cleaning using Power Query, saving approximately 4 hours of manual work.
● Used DAX measures, improving calculation accuracy by 20% and enhancing user flexibility for 30% faster data interpretation and
decision-making.
● Focused on granular analysis of revenue streams and expense categories.
● Overall, the approach aimed at providing better user experience and operational efficiency.

PowerBI Project

Business 360

Designed a Power BI dashboard to understand AtliQ hardware’s last 4 years' sales trends including (sales, finance, supply chain, executive, marketing, products) views.

View Project
Engagement

Home pages navigating to different views.

Finance view.

Project Details

● This dashboard could assist in raising the revenue at least by 7% in the next quarter.
● Implemented multi-view Power BI dashboard for AtliQ hardware (sales, finance, supply chain, executive, marketing, products).
● Aimed for 10% scaling of business processes through data-driven decisions.
● Imported data from MySQL and Excel sources, each exceeding 1 million records.
● Conducted data modeling, boosting analysis efficiency by 25% and reducing errors by 30% for more informed decision-making.
● Utilized DAX studio to optimize the report, achieving 30% storage savings.
● Improved overall performance by 10%.

Live Interactive Dashboard

PowerBI Project

AtliQ Hospitality Analysis

Embarked on a comprehensive analysis of revenue data within the hospitality industry, aiming to extract actionable insights to drive strategic decision-making and optimize business performance.

View Project
Engagement

AtliQ Hospitality Analysis

Interactive dashboard

AtliQ Hospitality Analysis

Interactive Dashboard

Project Details

-> Advocate for strategic promotional initiatives, especially targeting weekdays, to capitalize on potential revenue growth opportunities.
-> Suggest a focused approach on promotional campaigns in key regions such as Delhi and Hyderabad to maximize revenue potential

Live Interactive Dashboard

SQL Project

Executive Management

Provide Insights to Management in Consumer Goods Domain. Check ‘ad-hoc-requests.pdf’ - there are 10 ad hoc requests for which the business needs insights

View Project
Engagement

Executive Management

Request 1

Executive Management

Request 2

Project Details

● Presented Insights on 10 ad-hoc business requests to the executive management team, by querying the million rows database using SQL.
● Insights from my presentation have the potential to significantly reduce overall operational costs by approximately 10 %.