YOUSSEF SAIDY
Data Analyst I Business Analyst
About Me
Hi I am Youssef and I am a Data Analyst.
I am passionate about transforming raw data into actionable insights. With a strong foundation in analysis and proficiency in tools such as Excel, SQL and Power BI.
I am adept at data cleaning, visualization, and interpretation.
Skills
Featured Projects
Certifications
SQL I SuperMarket Sales
About The Project
I chose to analyze the sales data of a supermarket with three branches.
About the dataset
The dataset provides information about online orders with order id, branch, costumer type, payment method, order date, city, sales amount, profits and rating.
Questions for the Analysis
1. Which branch made the most sales in the last month?
2. Which city has the highest average rating for customer satisfaction?
3. What product line has the highest total sales? Which product line has the lowest total sales ?
4. What is the difference between the total made by members and non members ?
5. What is the distribution of sales across different times of the day?Key takeaway from dataset
1. The branch who made most sales is branch A followed by C and B
2. Naypyitaw City has the highest average rating for customer satisfaction which is 7.07 and Yangon comes second with a rating of 7.03 and last Mandalay with a 6.82 rating.
There is a correlation between low customer satisfaction and low sales in Mandalay.3. Food and beverages has the highest total sales with a 56144.84$ while Health and beauty has the lowest total sales with a 49193.74$.
4. Members made 5480$ more than non member customers
5. The supermarket is open for 11 hours per day and the highest sales are made between 10-11 AM, 1-3 PM and 7 PM.Recommendations
1. Investigate why the customer satisfaction is low in Mandalay City compared to other cities.
2. Launching a marketing campaign, we aim to attract more customers to subscribe to our supermarket membership program.
3. Decrease the number of employees in non peak time.THANKS
Excel I Car Sales Dashboard
About The Project
This dataset is about car dealerships that aim to optimize their sales performance and to understand the factors influencing sales and identify areas for improvement.
Questions for the Analysis
- Which car models are the top sellers ?
- How do sales vary across different manufacturers and vehicle types ?
- Which region has the highest sales ?
- Which Gender has highest Sales ?I took the following steps to create my analysis:
1- Pulling the data from Kaggle, cleaning it, and preparing it for analysis.
2- Creating charts and placing them in the dashboard tab.
3- Utilizing pivot tables to aggregate KPIs at the top of the page.
4- Creating slicers and syncing all tables together for filtering.
5- Formatting all sections of the dashboard and creating an overall theme.Here are my key takeaways:
1- The Total Revenue generated was ($671,525,465) for the sale of (23,906) Units.
2- Chevrolet was the best performing Manufacturer with selling the most units (1819) and generating the most revenue ($47,655,265).
3- The Mitsubishi Diamante is the most popular car model. It sold 418 units.
4- Austin has the highest sales with a Revenue of ($117,192,531).
5- Males have the highest sales with a Revenue of ($527,085,194).THANKS
POWER BI I canada airlines loyalty program
About The Project
Unveiling the insights derived from this airline loyalty program data.
Questions for the Analysis
- What percentage of loyalty cards were issued in different regions?
- Which regions collectively account for the majority of all issued loyalty cards?
- How does flight distribution align with the issuance of loyalty cards?
- How would you describe the distribution of different types of loyalty cards?
- What role does education level play in influencing people to join the loyalty program?
- What percentage of accumulated points have been redeemed by customers?Here are my key takeaways:1- Loyalty cards are distributed across Canada as follows: Ontario accounts for 32%, British Columbia for 25%, and Quebec for 19% of the total issued.2- Ontario, British Columbia, and Quebec collectively represent 77% of all issued loyalty cards.3- Flight distribution across provinces mirrors the issuance of loyalty cards: Ontario leads with 33%, followed by British Columbia at 27%, and Quebec at 20%.4- The distribution of loyalty card types is evenly balanced.5- Education significantly influences participation in the program: 25% of cardholders have a college degree, while 62% hold a bachelor's degree.6-Only a small fraction, less than 2%, of accumulated points within the loyalty program have been redeemed by customers.7- Moving forward, the program's viability hinges on strategic initiatives such as incentivizing point redemption to drive flight sales and enhancing member benefits to increase flight participation, thereby aligning campaign efforts with tangible outcomes.THANKS