Main Dashboard
Analyzed the Olympic data from 1896 – 2016 using Power BI and used the DAX function for building new measures and calculated columns.
Performed the ETL and developed an informative Olympic dashboard using Power BI.
• Selecting the Country India using dropdown country field.
• After selecting India in Country field.
• Count of Gold Medals are 138, Silver Medals are 19 & Bronze Medals are 40, in year range 1898 to 2016
• Youngest Medalist Name changes to Ravindra Pal Singh
• If we continue selecting country field as India and view Hockey sports records India owns.
• To the right hand we get all the list of medal winners for India in Hockey sports.
• After changing the year range between 1947 to 2016.
• Count of Gold Medals are 83, Silver Medals are 17 & Bronze Medals are 40.
• After selecting Japan in Country field.
• Count of Gold Medals Japan Owns are 247, Silver Medals are 307 & Bronze Medals are 357, in year range 1898 to 2016
• Youngest Medalist Name changes to Kyoko Twakasi
• By selecting the view of Athletics Sports, youngest player is Barbara Pearl
• To the right hand we get all the list of Athletics sport medal winners.