Portfolio - Shaik Thaheer | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

Shaik Thaheer

Data Analyst

1

Excel
Project

2

PowerBI
Projects

About

Me

I'm Thaheer, Data Analyst. I'm an accomplished professional with 2+ years of experience, I've successfully led customer and technical support teams at various organisational levels. My strengths include team building, incident management, and collaborative leadership, driving success through partnerships with fellow managers and stakeholders.

My career journey has honed my analytical and problem-solving prowess, and I'm now excited to pivot into a data analyst role where I can apply these skills to deliver valuable insights. I'm Proficient in Microsoft Excel, SQL, and Power BI.

I'm eager to kick-start my data analyst career.

Technical

Skills

Excel

PowerBI

SQL

Data Analysis

Data Visualization

Problem-solving

Adaptability

ETL

My

Projects

IT Ticket Analysis

IT Ticket Analysis

Provided actionable insights to IT management for resource allocation, user support, and process improvement initiatives.
Improved decision-making processes by enabling stakeholders to quickly grasp IT ticketing trends and patterns.

Sales Insights Data Analysis

Sales Insights Data Analysis

Created a Business Intelligence dashboard using Power BI to analyse Sales Insights trend and key performance indicators (KPIs) specific to the Sales by Market, Product and Customer such as Revenue, Sale Qty and Trend in various cities in India.

Coffee Shop Sales 2023

Coffee Shop Sales 2023

The project focuses on analyzing sales data from coffee shops to unveil trends and insights within the industry. Its aim is to support strategic decision-making by providing actionable information derived from comprehensive data analysis.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 2.0

CB Cert

SQL Beginner to Advanced For Data Professionals

SQL Basic

Contact Me

Email

[email protected]

Github

https://github.com/thaheer17/

Linkedin

https://www.linkedin.com/in/thaheer/

Call

+91 8904325998

Shaik Thaheer

Data Analyst

Download Resume

Resume

PowerBI Project

IT Ticket Analysis

Provided actionable insights to IT management for resource allocation, user support, and process improvement initiatives. Improved decision-making processes by enabling stakeholders to quickly grasp IT ticketing trends and patterns.

View Project
on GitHUB

IT Ticket Analysis

Total Tickets by Classification (Pie Chart): - Classify tickets based on their nature (e.g., software issues, hardware problems, user errors).

IT Ticket Analysis

Satisfaction, Severity, Priority, and Groups: - Use these metrics to gauge the overall performance and effectiveness of the IT support team.

Project Details

Here are some insights you can draw from the data:

1.Total Users, Tickets, and Departments:
- Use these metrics to understand the overall workload and user engagement within the IT system.
- Look for trends in ticket creation and user activity over time.
2.Total Users by Gender (Donut Chart):
- Analyze the distribution of users based on gender to identify any gender imbalances within the IT system.
- This could help in understanding potential biases or areas for improvement in inclusivity.
3.Total Tickets by Ticket Type (Donut Chart):
- Identify which types of tickets are most common.
- This insight can help in resource allocation and prioritization of IT support efforts.

PowerBI Project

Sales Insights Data Analysis

Created a Business Intelligence dashboard using Power BI to analyse Sales Insights trend and key performance indicators (KPIs) specific to the Sales by Market, Product and Customer such as Revenue, Sale Qty and Trend in various cities in India.

View Project
on GitHUB

Sales Insights Data Analysis

Calculated various KPIs such as Revenue, Sales Qty, Product and Markets.

Sales Insights Data Analysis

Contributed to the company's success by providing actionable insights that drove Revenue growth and improve Trend efficiency in the Sales Insights.

Project Details

Present the analysis in an easy-to-understand format using Visualisation such as Charts to communicate key insights to the stakeholders effectively.

Excel Project

Coffee Shop Sales 2023

The project focuses on analyzing sales data from coffee shops to unveil trends and insights within the industry. Its aim is to support strategic decision-making by providing actionable information derived from comprehensive data analysis.

View Project
on GitHUB

Coffee Shop Sales 2023

Product dashboard from Microsoft Excel.

Coffee Shop Sales 2023

Product dashboard from Microsoft Power BI.

Project Details

1. Revenue Performance: Total revenue for Jan to June 2023 amounted to $698.81K, showing consistent growth.
2. Foot Traffic: Total footfall recorded was 149K.
3. Average Order Value: The average order value is $4.69.
4. Peak Sales Hours: Sales peak during weekdays from 7 AM to 10 AM, with lower sales observed from 6 PM to 10 PM.
5. Product Analysis: Coffee and Tea emerge as top-selling items, contributing to 67% of total revenue, while Branded and Packaged Chocolate are least favored.
6. Location Distribution: Sales are evenly distributed across three locations, each contributing approximately 33% to total revenue.