Mohammed Shoeb Ahmed

Data Analyst

[email protected]

Hello, I am

Mohammed Shoeb Ahmed.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

About Me

Data Analyst with 2+ years of experience in building dashboards and reports using Power BI, SQL, and Excel. Proven ability to analyze complex datasets and deliver actionable insights for business growth. Experienced in healthcare sector, passionate about data storytelling.

But beyond the technical side, I’ve also focused on strengthening my communication skills. I enjoy turning complex data into clear, meaningful insights that people across any team or level can understand. I believe that being able to connect data with real business needs is what truly makes an impact.

Key Skills

Excel

Power BI

SQL

Problem Solving

Stake Holder Management

My Projects

Shield Insurance Analysis

Domain/Function: Insurance

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Brick & Mortar

Consumer Goods (Ad_hoc Insights)

Domain/Function: FMCG

Provide Insights To The Revenue Team

Domain/Function: Hospitality

Sales & Finance Analytics

Domain/Function: Sales Analytics(FMCG)

My Experience

AtliQ Technologies – Data Analyst Intern April 2024 – May 2024

Enhanced data integrity by standardizing, deduplicating, and normalizing client datasets.

Conducted variance analysis and business trend evaluation using Pandas, Excel, and Power BI

Debugged SQL queries in MySQL Workbench for accurate data extraction.

Created interactive dashboards and visualizations using Power BI to present findings to senior management.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Microsoft Fabric Mini: For Data Analysts

Data Analyst Internship

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/shoaib-ahmed-j100797/

GitHub

https://github.com/shoaibahmed07

PowerBI Project

Shield Insurance Analysis

Domain/Function: Insurance

This project presents a detailed performance analysis of the fictional Shield Insurance company. The interactive Power BI dashboard highlights key metrics on sales, customer segmentation, and revenue growth, empowering data-driven decisions and strategic business optimization.

View Project
Engagement

Other Tools

Power Query

Power Point

Displayed 4 key KPIs and a calendar visual to track daily revenue and customer trends, enabling quick, date-wise business performance insights.

Visual shows monthly revenue share by sales mode, highlighting a gradual shift from offline agents to growing online app and website channels.

Project Details

This project provides a comprehensive performance overview of Shield Insurance, utilizing data-driven insights to strengthen business decisions and customer strategies. The dataset features variables like city, sales mode, and age group, enabling in-depth analysis of customer demographics and revenue trends. The Power BI dashboard includes three key views: a General View showcasing revenue and customer distribution across cities, a Sales Mode View highlighting customer preferences across sales channels, and an Age Group Analysis View detailing revenue contributions by age segments. Visuals such as bar charts, line graphs, and tables ensure clear, actionable insights into critical performance metrics.

Project video

Live Interactive Dashboard

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Brick & Mortar

AtliQ Hardware's is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights.

View Project
Engagement

View Project
on GitHUB

Empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

SQL Project

Consumer Goods (Ad_hoc Insights)

Domain/Function: FMCG

Atliq Hardware, a leading computer hardware manufacturer in India, required data-driven insights to optimize its operations. To address this, the company launched an SQL challenge to evaluate and hire junior data analysts. The project involved analyzing 10 key business requests using SQL to extract

View Project
Engagement

View Project
on GitHUB

View Project
on

Displays the top-selling products in each division based on total sales quantity.

Show the count of new unique products by segment for FY 2020 and FY 2021

Project Details

Identify markets where "Atliq Exclusive" operates in the APAC region.
Analyze year-over-year growth in unique product counts.
Determine top-selling products, sales channel contributions, and quarterly sales performance.
Extract segment-wise product trends and discount patterns for top customers.
Identify products with the highest and lowest manufacturing costs.

PowerBI Project

Provide Insights To The Revenue Team

Domain/Function: Hospitality

This project presents a Power BI dashboard designed to provide detailed revenue insights for the hospitality domain. The dashboard consolidates key metrics related to revenue, occupancy, and booking performance across multiple properties, helping stakeholders make data-driven decisions.

View Project
Engagement

View Project
on GitHUB

Providing key performance metrics for hotel properties. It includes Revenue (1.69bn), RevPAR (7,337), Occupancy (57.8%), ADR (12.70K), and Realization

Visualizes revenue, occupancy, and ratings by city, booking trends by platform and day type, and weekly rating vs. occupancy trends for better insight

Project Details

AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.

Live Interactive Dashboard

Excel Project

Sales & Finance Analytics

Domain/Function: Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.