Starting my journey with these two Dashboards with help from an instructor as I started learning on YouTube using Spreadsheets.
This is another dashboard where I'm using Tableau for the first time to display the data visually.
For a deeper understanding of the project's Conclusion and Insights, please visit the provided links or the Tableau Story
Note: R code available on Kaggle.
Sales Data Analysis Dashboard
π Project Overview: This project analyzed sales data to uncover trends, identify top-selling products, and calculate revenue metrics to support business decision-making. I worked with a large sales dataset to extract meaningful insights.
β³ Objectives:
To analyze sales trends over time.
To identify the best-selling products.
To calculate key revenue metrics, including total sales and profit margins.
To effectively present the findings through visualizations.
π Data Source:
Dataset: MeriSkill Program Internship - Sales Dataset
π»Tool used:
Microsoft Power BI
I gained hands-on experience in transforming data, adding columns with functions, building visuals with different chart types π, adding slicers, performing DAX calculations β, and much more ππ.Β
The QS World Ranking 2025 Analysis
πProject Overview: This project centered on analyzing and visualizing the QS Universities Ranking for 2025. Leveraging a dataset from Kaggle, I meticulously cleaned and processed the data in Excel, and then crafted insightful visualizations using Microsoft Power BI to highlight key trends and comparisons.
π― Goal: With the release of the QS World Universities Report for 2025, individuals in the Middle East often face difficulty determining the best-ranked universities. This project seeks to simplify that process by offering clear, data-driven insights.
π« Target Audience:
βΎ Students exploring their educational options
βΎ Companies assessing potential employee's credentials
βΎ Alumni staying informed on the latest QS rankings
β³ Objectives:
To provide a clear and comprehensive analysis of the QS Universities Ranking.
To highlight the performance of universities in Arab and Middle Eastern countries.
To identify and showcase advancements in the rankings of Lebanese universities.
To present the top-ranking countries globally.
π Data Source:
Dataset: QS Universities Ranking 2025 from Kaggle.
π» Tools and Technologies:
Excel: Used for data cleaning and preprocessing.
Microsoft Power BI: Utilized for data visualization and creating interactive dashboards.
π Key Highlights:
Employee Reputation in Arab Countries: Analyzed the employee reputation scores, with Qatar leading, followed by the United Arab Emirates and Lebanon.
Average QS Score in Middle Eastern Countries: Identified the average QS scores, with Qatar, Saudi Arabia, and Lebanon ranking the highest.
Lebanese Universities Ranking: Detailed the rankings of Lebanese universities, noting significant advancements for the Lebanese University (LU) and Beirut Arab University (BAU).
Top 5 World Countries Ranking: Highlighted the top five countries in the global QS ranking, with the United States, United Kingdom, China, Japan, and Germany at the forefront.