Portfolio - Sk Aamir Sohail | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Hello, I am

Sk Aamir Sohail

Data Aspirant

Resume

2

PowerBI
Projects

1

SQL
Project

About

Me

Hi there! I'm a data analytics enthusiast who turned a background in Commerce into a passion for Data Analytics. I’m skilled in tools like Excel, SQL, and Power BI, and I’ve applied them to real-world projects that you’ll find throughout this site. Each project reflects my curiosity for uncovering patterns in data and my drive to help businesses make smarter decisions. As a fresher in this field, I bring fresh perspectives, hands-on experience, and a determination to keep growing and making an impact through data. This website shares my journey so far, highlighting the skills and projects that have fueled my passion for data.

Key

Skills

Excel

PowerBI

SQL

Database

My

Projects

Adidas Sales Analytics

Adidas Sales Analytics

Domain/Function: Sales

This is a Sales Analytics Project of Adidas company in US for the year 2020-2021. This project focuses on Total Revenue earned by the company. It shows total profit earned and profit margin. Various KPIs gives you a clear understanding of the overall health of the business.

Grocery Store Analysis

Grocery Store Analysis

Domain/Function: FMCG

This is a project on Grocery Store sales data. This project focuses on Customer, Product and Trend Analysis. Visualizations were tailored to present key insights into sales performance across customer demographics, product, and seasonal trends.

Healthcare Data Analysis

Healthcare Data Analysis

Domain/Function: Healthcare

This project analyzes a healthcare dataset that includes details about patient admissions, doctor information, billing amounts, and medical conditions. The main objective is to derive valuable insights to improve hospital management, patient care, and financial outcomes.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

SQL

Contact Me

Email

[email protected]

Github

https://github.com/AamirSohail2001

Linkedin

https://www.linkedin.com/in/aamir-sohail-22ba502a4/

Call

+91 8967288640

Sk Aamir Sohail

Data Aspirant

Download Resume

Resume

PowerBI Project

Adidas Sales Analytics

Domain/Function: Sales

This is a Sales Analytics Project of Adidas company in US for the year 2020-2021. This project focuses on Total Revenue earned by the company. It shows total profit earned and profit margin. Various KPIs gives you a clear understanding of the overall health of the business.

View Project
on GitHUB

Adidas Sales Analytics

This is the dashboard of sales analytics.

Adidas Sales Analytics

Adidas Sales Analytics.

Project Details

Created a detailed dashboard of Adidas Sales in US. Where I have shown Sales trend over the period, Product Performance, Retailer summary. Also highlighted the states where sales are in significant numbers. Also made important KPIs. To make this project I used various features of PowerBI like Power Query, Modelling, Different Visuals, DAX. To make this dashboard dynamic and more flexible I used interesting tools like Bookmarks, buttons etc.

Live Interactive Dashboard

PowerBI Project

Grocery Store Analysis

Domain/Function: FMCG

This is a project on Grocery Store sales data. This project focuses on Customer, Product and Trend Analysis. Visualizations were tailored to present key insights into sales performance across customer demographics, product, and seasonal trends.

Grocery Store Analysis

Home page of the project

Grocery Store Analysis

Customer analysis page

Project Details

Customer Analysis: Breakdown of sales by customer, highlighting purchase behavior, loyalty, and sales by various demographics like age group, occupation to identify high-value customer groups.

Product Analysis: Detailed insights into top-performing products, returned rate, average revenue by product. The analysis includes which products are bringing most of the sale value.

Trend Analysis: Visuals illustrating monthly and yearly sales trends, seasonality, and forecasted growth, providing a clear view of performance over time

Live Interactive Dashboard

SQL Project

Healthcare Data Analysis

Domain/Function: Healthcare

This project analyzes a healthcare dataset that includes details about patient admissions, doctor information, billing amounts, and medical conditions. The main objective is to derive valuable insights to improve hospital management, patient care, and financial outcomes.

View Project
on GitHUB

View Project
on

Healthcare Data Analysis

Front page of analysis

Healthcare Data Analysis

Project uploaded in Github

Project Details

The Healthcare Analytics Project analyzed a dataset containing information on patient admissions, doctor details, billing amounts, medical conditions, and other data. By applying SQL queries and analytical techniques, the project aims to derive actionable insights that can assist healthcare providers in improving operational efficiency, patient care, and financial performance. The goal of the project are:
-Determine which age group is most affected by critical medical conditions.
-Analyze the financial flow of the hospital.
-Determine the doctors' availability and their areas of specialization.
- Evaluate how well the hospital handle emergency conditions.
- Identify which diseases are growing every year.
- Assess whether patients with critical conditions (e.g., cancer) are receiving adequate treatment.
- Analyze various aspects, such as improving the hospital's condition, bringing in more specialized doctors, and increase service in emergency ward