As Part of the fight against the Data Walkers in DataGeek III – Thrones of Data! I decided to contribute my army too for the fight against Dark Data.I am representing House of Titans – Sworn to Sports and Entertainment.
Step 1. I have accepted the challenge.
For the fellow warriors please accept the challenge by bookmarking the mentioned blog as follows Click Me
Step 2. Download SAP Lumira Desktop.
I have gone for the 30 day free trial version available at SCN. You can check out the details at Lumira Download
Step 3. I declare my allegiance with House of Titans – Sworn to Sports and Entertainment.
I have used one of the sample data set provided as part of challenge.You can find the details at Sample Data set
Step 4. My Data Story
I have used the Sample data
Analysis of the Olympics medal tally
Back Ground :Olympics as we know is foremost sports competition with more than 200 countries participating. As I had enough data in the form of Data samples I thought of analyzing India’s performance in Olympics.
Technical Details :
Software Used : SAP Lumira
Version Used :1.18.0
Data set Used :Olympics Data
My Sample Data:
Necessary Data corrections are done and unnecessary columns are removed just to make the analysis more clear.
- Medal Count by Host country.
Chart Builder Option : Geo choropleth chart option in Geographic charts
Use : To depict the geographical pattern distribution of Olympic medals across the host countries
Observation :India’s Contribution is not in the top list.
2. Medal Count Vs Country Description
Chart Builder Option : Donut Chart option in Pie charts
Use : Easy to identify the medal count distribution across individual countries and helps to identify country wise standings.
Observation :India is having 178 medal counts.
3. Medal Count by sport Vs Country
Chart Builder Option : Tables option in Table.Filter option on country Description really comes handy here.
Use : Depict the sports wise medal count. Helps to identify our core strength games.
Observation : Hockey tops the list with 169 medals and need more attention to sports like Tennis & Weight lifting.
Now I want to know the details of athletes who have toiled hard to get it done.
4.Medal Count by Athlete
Chart Builder Option : Funnel Chart option in Other Charts.Filter option on country Description really comes handy here.
Use : Depict the medal claimed by each Indian individual athlete participated in the event.Helps to identify the top performers from India in Olympics
Observation : Top Contributor is having an individual tally of 4 as the best which is quite average when compared to other countries.
From the performers I wanted to identify the performance of Men and women separately to identify the pitfalls.
5.Medal Count across various Countries based on gender
Chart Builder Option : Pie chart options in Pie chart
Use : Identify the gender wise distribution of medals.
Observation : Indian Women is contributing only 0.56% of overall medal tally.
This is a serious matter which we need to consider and need more training and related facilities for bettering the women’s performance in Olympics.
- Performance of Indian Women needs to be raised by providing them more training and enough exposure.
- India’s overall performance can be improved by concentrating on more games as currently we have only 7 medal winning sports.
Step 5.Submission of Data Story
Kindly submit your data story at Here
For my fellow colleagues kindly join the challenge at Here
For more information visit the SCN space: http://scn.sap.com/community/lumira
Thanks to Thrones of Data Team for this Challenge!.Lets Beat Dark Data Lords together. 🙂 🙂 🙂