The University Success Analysis project is a comprehensive exploration of higher education dynamics using data analytics techniques such as Power BI, SQL, and Excel. The structured dataset, combined with MECE analysis and dynamic Power BI visualizations, enables a comprehensive understanding of the factors influencing university success. This project aims to provide insights into various aspects of universities, including rankings, demographics, and performance metrics, to facilitate informed decision-making in academia.
The University Success Analysis project delves into the intricate landscape of higher education, leveraging data analytics to uncover valuable insights. Through a combination of Power BI dashboards, SQL queries, and Excel charts, the project explores trends in university rankings, student demographics, and institutional performance over time and across different countries.
-
Utilized Power BI to create interactive dashboards for year analysis, university analysis, country analysis, and ranking analysis, offering stakeholders a comprehensive view of higher education metrics.
-
Employed SQL queries to extract and analyze data on university rankings, criteria weights, and demographic trends, providing deeper insights into the factors influencing academic success.
-
Leveraged Excel charts and visualizations to illustrate correlations between ranking scores, student demographics, and institutional performance, facilitating data-driven decision-making in academia.
-
Addressed exploratory data analysis (EDA) problems to uncover correlations between a country's GDP, population, and the number of universities, as well as trends in university rankings and criteria weights over time.
-
Ultimately, the project aims to empower stakeholders in the higher education sector with actionable insights to enhance institutional performance, drive strategic initiatives, and foster academic excellence.