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, 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.
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.
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.
In this project, I have employed a diverse dataset sourced from Google to develop a
comprehensive
Bike Sales
Data analysis project using Excel, SQL, Tableau ,and Power BI.
Links:
- Power Bi DashBoard.
- Excel DashBoard.
- SQL Query.
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.
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.
In this project, I have employed a diverse dataset sourced from Google to develop a
comprehensive
HR
dashboard using Excel, SQL, and Power BI.
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.