Ammar Allam Portfolio




Greetings!
Explore my portfolio, where you'll discover a proficient BI Specialist & Data Analyst adept in SQL, PowerBI, Power Builder, SSRS, Excel, and Python.
Access my digital channels by clicking on the menu button.


Database Management System

I emphasized essential components such as ERD, Mapping, OLTP, and Data_Warehouse. By utilizing SSIS, SSAS, and SSRS, I successfully implemented data integration, analysis, and reporting functionalities. This project highlighted the significance of these tools in facilitating efficient decision-making and providing valuable data-driven insights for organizations.


Sales Management

I focused on fulfilling a business request for an executive sales report targeted at sales managers. I followed user stories to maintain acceptance criteria throughout the project. By utilizing SQL, I extracted, cleaned, and transformed data from the database to create a robust data model. The result was an insightful and actionable sales report, providing valuable information to empower sales managers in making informed decisions for business growth.

Customer Satisfaction Analysis of Reviews

I am delighted to present the analysis of the Amazon Fine Food Reviews Dataset, included approximately 500,000 reviews. The main objective of this analysis is to gain insights into customer satisfaction levels and understand their evaluations of various products. Through rigorous examination of the dataset, we have uncovered valuable information that sheds light on customers' sentiments and experiences with Amazon products.

CLTV Analysis using Python

Customer Lifetime Value (CLTV) analysis is a crucial tool for businesses seeking to understand the long-term value of their customers. By estimating the total value a customer brings to the business over their entire relationship, CLTV analysis guides strategic decisions regarding customer acquisition, retention, and resource allocation.