Olympic Games Analysis

• Business Problem

Ensure that the right data has been selected, transformed, and used in the data visualization which is meant to be passed on to the business users.

• Data Collection & Table Structures

The necessary data was first put into a SQL database and afterward transformed using the transformations.

• Data Modeling
• Calculations

The following calculations were created in the Power BI reports using DAX (Data Analysis Expressions). To lessen the extent of coding, the re-use of measures (measure branching) was emphasized:

Number of Competitors:

# of Competitors = DISTINCTCOUNT( ‘Olympic Data'[ID] )

# of Medals = COUNTROWS( ‘Olympic Data’ )

# Of Medals (Registered) = CALCULATE( [# of Medals], FILTER( ‘Olympic Data’, ‘Olympic Data'[Medal] = “Bronze” || ‘Olympic Data’ [Medal] = “Gold” || ‘Olympic Data'[Medal] = “Silver” ))

• Olympic Games Analysis

The finished dashboard consist of visualizations and filters that gives an easy option for the end users to navigate the summer games through history. Some possibilities are to filter by period using year, nation code to focus on one country or look into either a competitor or specific sports over time.