TOOLS utilized
Alteryx for clusering
Tableau for visualizations
tHE APPROACH
Data was already cleaned
Exploaratory Data analysis to uncover key insights
Performed exploratory analysis of the data
Clustering using k-means
results
Exploratory analysis of the data showed the following:
THE CONCLUSION
The following are suggested in the strategic planning for the Ministry of Education:
Encourage students to take extra classes if they can afford to do so. Provide bursarys and grants to those in need
Encourage and promote effective study time for students on and off campus
Foster physical and mental wellness to help students
Recommendations
The following are suggested in the strategic planning for the Ministry of Education:
Identify students with no interest in higher education and create supports for them in either higher education, a trade they're interested in, or further skill development
Increase the availability of access to tutelage for students in need
Create a study plan for students who have had a past failure
Encourage students to take extra classes if they can afford to do so. Provide bursarys and grants to those in need
Encourage and promote effective study time for students on and off campus
Foster physical and mental wellness to help students
IMPACT
The resulting clusters will provide valuable insights for effective portfolio diversification, risk assessment, and informed decision-making, ultimately enabling the firm to optimize investment strategies and deliver favorable outcomes for their clients.
SP500 Stock Performance 2011
THE CHALLENGE
An investment firm is looking to analyze the stock returns of the SP500 companies for the year 2011. Their goal is to cluster these companies into five distinct groups based on their performance during that specific period.
They have received a data set which contains the average stock returns per month for the SP500 index constituents. The firm aims to uncover underlying patterns and similarities among the companies' stock performance.