Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Contact

Hello, I am

Sharik Khan

Data Aspirant
Resume
Sharik Khan

2

Excel
Projects

2

PowerBI
Projects

1

SQL
Project

About

Me

Hello! I'm Sharik Khan, an MBA specializing in information technology. Recently, I completed a dynamic virtual internship at PricewaterhouseCoopers (PwC) as a data analyst intern. In the "Call Center Trends" project, I utilized SQL, MySQL, Excel, Power BI, and PowerPoint to create insightful dashboards for analyzing customer and agent behaviour. In the "Customer Retention" project, I extracted customer demographics and enhanced retention strategies using Power BI. Proficient in Excel and completed three additional data analysis projects. I'm passionate about exploring and learning, bringing a blend of analytical skills and business acumen to the intersection of technology and management.

Key

Skills

SQL

MySQL

Data Analysis

Data Cleaning

Data Modelling

Data Visualization

My

Projects

Hospitality Analysis - Hotel Chain Business [Power BI | Excel]
Hospitality Analysis - Hotel Chain Business [Power BI | Excel]

Atliq Grands observed a decline in market share and revenue over a few months, necessitating a diagnostic analysis. A Power BI
dashboard was streamlined, utilizing 3 months of data.

Customer Retention (Pwc Forage) - [Power BI | Excel]
Customer Retention (Pwc Forage) - [Power BI | Excel]

The analysis revealed that the total amount of revenue lost amounts to nearly $3 million, with approximately 70% of customers
lost in the fiber optic internet service

Call Centre Trends (Pwc Forage) - [Power BI | Excel]
Call Centre Trends (Pwc Forage) - [Power BI | Excel]

Utilizing this dashboard can prove instrumental in driving improvements across various key metrics, including Csat(Customer Satisfaction) within the 75% - 84% range

Sales Insights – Brick & mortar business [Power BI | SQL]
Sales Insights – Brick & mortar business [Power BI | SQL]

● Designed a Power BI dashboard to understand AtliQ hardware’s last 4 years' sales trends.
● This dashboard could assist in raising the revenue at least by 7% in the next quarter.

Business 360- Brick & mortar and e-commerce [Power BI | SQL | Excel | Dax Studio]
Business 360- Brick & mortar and e-commerce [Power BI | SQL | Excel | Dax Studio]

Established a Power BI dashboard gathering sales data from 2 different sources (Excel/CSV files and a SQL database). Optimized
with DAX Studio, resulting in a 5% performance boost and projected 10% revenue growth and 20% data-related expense
reduction