Tarek Husam
Portfolio

"Disclaimer: The data in these dashboards is not real and is only for display purposes."

Data Analyst well versed in Excel, SQL, Python, Power BI and Tableau.
Front-End Developer versed in HTML, CSS, BootStrap, JavaScript and CMS systems.
Automation expert, specialized in eliminating repetitive tasks to enhance productivity and streamline the workflow using Python, Pandas and excel magic tricks.
@Tarek Husam

Pharmacy Sales Report

In this project, I successfully spearheaded a comprehensive data analytics project encompassing 28 pharmacy branches, leveraging the power of Power BI, Excel, and Python automation to harness big data for precise sales insights. My strategic implementation facilitated data-driven decision-making, optimizing operational efficiency and driving substantial business growth across the entire pharmacy network.

Basket Analysis & Top Items Sales

Basket analysis, also known as market basket analysis or affinity analysis, is a data analysis technique that explores the relationships between different items that are frequently purchased or used together. The goal is to uncover patterns of association among products, identifying items that tend to be bought or consumed in combination.

Pharmacy & Pharmacists KPIs

In this project, I utilized a dataset from the Pharmacy Industry to establish Key Performance Indicators (KPIs) tailored for both the pharmacy as a whole and individual pharmacists.

Pharmacy comprehensive report

In this project, I have conducted data collection from Pharmacy group company to generate a comprehensive product sales report utilizing MS Excel, SQL, Python, and Power BI.

Peak Time analysis

This report presents a comprehensive analysis of peak times within the Pharmacy, aiming to identify and understand periods of heightened activity in order to enhance decision-making and optimize resource allocation.

UNHCR

I utilized a dataset sourced from the United Nations High Commissioner for Refugees Site to construct a comprehensive report tailored for a governmental department in Jordan. This initiative involved the extraction, analysis, and interpretation of pertinent information to deliver insights and findings relevant to the department's specific needs. The utilization of this authoritative dataset from UNHCR ensures the reliability and accuracy of the information presented in the report, thereby contributing to informed decision-making processes within the government department in question.

HR Dashboard

In this project, I have employed a diverse dataset sourced from Google to develop a comprehensive HR dashboard using Excel, SQL, and Power BI.

CTC Company Report

In this project, I have conducted data collection from CTC Company's authentic sources to generate a comprehensive product sales report utilizing MS Excel, SQL, and Power BI.