QUESTION 2 [5 marks]

You work as a data analyst for a consultancy firm that seeks to analyse Olympic sports data.

They have provided you with a dataset containing player information (Olympic_data.xlsx),

including age. Your task is to first create a Power BI data model that incorporates a new

column, categorizing players into different age groups based on their ages, and then produce

the following visuals with the capability to distinguish between both summer and winter games.

Utilize Power BI to generate a new column named "Age Group" that classifies players into

specific age groups according to the following criteria:

0 to 14, 15 to 20, 21 to 25, 26 to 30, 31 to 35, 36 to 45, 46 to 55, greater than 55

(1) Present the distribution of players' ages alongside their respective age groups using a

column chart and provide commentary on the observed distribution (2.5 marks).

(2) Display the medals won in different age groups-Gold, Silver, and Bronze using a

suitable visualization, and provide comments on the findings (2.5 marks).

Submit the visuals as a Power BI report file. Interpretation can be done in a Word

document.