Excel
Projects
PowerBI
Projects
SQL
Project
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.
Skills
SQL
MySQL
Data Analysis
Data Cleaning
Data Modelling
Data Visualization
Projects
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.
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
Utilizing this dashboard can prove instrumental in driving improvements across various key metrics, including Csat(Customer Satisfaction) within the 75% - 84% range
● 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.
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