Portfolio - Basil Abdulla P E

Excel Project

Sales Analytics

Developed six insightful reports for the sales team, providing them with the data to analyze customer trends and track progress towards sales goals.

View Project
Engagement

View Project
on GitHUB

Customer Net Sales Report: Provides net sales performance of each customer across years.

GM % by Quarters & Subzone: Provides Gross Margin % for every subzone in each quarters across years

Project Details

Leveraging Excel pivot tables, I constructed a sales report empowering businesses to:
▫️ Identify optimal customer discount strategies
▫️ Facilitate informed customer negotiations
▫️ Uncover promising international expansion opportunities
These data-driven insights enable businesses to refine sales strategies, elevated customer satisfaction, and achieve revenue maximization.

Learnings from the project:
▫️ Power Query
▫️ Pivot table
▫️ DAX (Basics)
▫️ Conditional Formatting
▫️ Report Beautification
▫️ Sales Domain Metrics

This project equips businesses with a powerful toolkit to transform their sales game. Through in-depth sales data analysis, we unlock hidden opportunities for growth. Stay ahead of the curve in today's dynamic market by gaining valuable insights to optimize your sales activities, maximize efficiency, and leave the competition in the dust.

PowerBI Project

Business Insights 360

AtliQ Hardwares, a fast-growing consumer electronics company, struggles to compete with data-driven rivals. Their reliance on static Excel reports hinders strategic decision-making. I propose implementing Power BI, an advanced analytics platform. This will unlock valuable insights from their data,

View Project
Engagement

Other Tools

Excel

SQL Database

Contextual dashboard introduction

Data modelling involving 10+ tables

Project Details

This project delivers a comprehensive report designed for seamless use by sales, marketing, finance, and the executive team. I prioritized the following:
▫️ Ensuring data accuracy and reliability for informed decision making across departments.
▫️ Creating an intuitive report that caters to each stakeholder's needs.
▫️ Providing deep-dive capabilities for granular analysis and strategic planning.

Learnings from the project:
▫️ Power Query (Basic and Advanced Operations)
▫️ Complex DAX formulas
▫️ Data modelling involving 10+ tables
▫️ Dynamic report titles based on filters
▫️ Implementing data validation techniques
▫️ Deploying in Power BI service
▫️ Stakeholder Feedback Implementation
▫️ Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

PowerBI Project

Atliq's Hospitality Data Analysis

Atliq Grands is a hotel management group in India. They have losing their market share and revenue due to ineffective decision making. My intention is to provide a insightful Power BI report that will help them to regain their business in the industry.

View Project
Engagement

Other Tools

Excel

Landing Page: The first dashboard from which the user can navigate to other dashboards.

Revenue Dashboard: Provide Important revenue insights in an interactive fashion.

Project Details

For this project, I would design a report which includes revenue, booking and rating analysis which assist the stakeholders to recover their loss and to reclaim their market share and revenue.

Project involves the following steps:
▫️ Data Importing
▫️ Data Modeling
▫️ Creating required measures
▫️ Designing interactive dashboard

Learning from the project:
▫️ Data transformation using power query
▫️ Proper usage of DAX measures
▫️ Creation of calculated and conditional columns
▫️ Significant terms and principles in hospitality domain

Project video

Live Interactive Dashboard

SQL Project

Ad_Hoc Insights in Customer Goods

Atliq Hardwares is a leading computer hardware producer in India with a strong international presence. The company lacks enough data professionals to produce insights from raw data. So I'm here to help the management on producing effective insights from data to address 10 ad_hoc requests.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

MySQL output that identifies the top-selling products within each division for fiscal year 2021

A graph showing Atliq Exclusive's monthly gross sales for the fiscal years 2020 and 2021

Project Details

For this project, my intention is to write MySQL queries for each ad_hoc request in order to generate valuable insights from the raw data.

Learnings from the project:
▫️ Employing a comprehensive SQL toolkit (subqueries, CTEs, various joins, functions, and views) to transform raw data into actionable insights.
▫️ Creating data visualizations in Power BI based on the data retrieved through SQL queries.
▫️ Design a systematic framework to showcase these visuals effectively.

Hello, I am

Basil Abdulla P E

1

2

1

About

Key

My

Sales Analytics

Business Insights 360

Atliq's Hospitality Data Analysis

Ad_Hoc Insights in Customer Goods

Contact Me

Email

Github

Linkedin

Call

Basil Abdulla P E

Download Resume