Skip to content

Latest commit

 

History

History
46 lines (28 loc) · 2.1 KB

README.md

File metadata and controls

46 lines (28 loc) · 2.1 KB

Romania Data Tribe Challenge for Sept 2022 on "Top 200 World Swimming Times"

romania data tribe challenge

Overview:

  • I was provided one Excel File containing "meet_name", "swim_time", "swim_date", "Team Name", "Gender", "meet city", "Country hosted", etc.
  • The sheet contains 200 rows of different championships held for 100m FREESTYLE Swimming in various countries.

Original Excel Page Overview:

Romania Data Excel overview

Note: There was no such demand of the challenge or requirement regarding the visualization to create.

After loading dataset in Power BI, I applied the following applications:

Understanding of Data:

Regarding understanding of data, I would say that it can basically go in 2 ways, one on the basis of final points and other can be on the basis of swim time. But, as final points could change over the years as new rules can be made in the games. So, I focused more on "Swim Time" of swimmers and analyzed the dashboard accordingly keeping more focus on timing.

Steps taken in Power BI application:

Theme and Color Palette:

  • I used a dark theme and used swimming picture as background.
  • Colors chosen for the dashboard was deep blue, light blue, white and orange.

Visualization:

  • Now, the basic design of the dashboard I visualized in Figma and made those shapes there in Figma to place those cards and graphs.
  • Overall, there were mainly 7 visuals in this single-paged dashboard.

Key Insights from the report:

  • Range of swim time varies from 46.86 to 47.88.
  • Swim Time is minimum when France hosted the championship.
  • Average Swim Time is minimum for the swimmers belonging to Romania.
  • Average Swim Time is minimum in the year 2017 and highest in the year 2016.

Conclusion:

Overall, it was a good dashboard to design and it gave me good understanding of data, visualization principles and usage of DAX operations too.

Dashboard