Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 

As the Plan to Win: Get Active with Data Hackathon approaches its halfway point, I find myself reflecting on the journey of preparing and working towards this extraordinary event. In this blog post, I am excited to share some insights about our content and challenges.

The triathlon world is no stranger to challenges, and the world of data science and technology is always ready to embrace them. This year, the two worlds collide in an exciting event: the Plan to Win: Get Active with Data Hackathon. SAP is teaming up with Jan Frodeno, a World Championship triathlete, to deliver this Virtual Self-Paced Hackathon. In a world where virtual collaboration has become the norm, the Virtual Self-Paced Hackathon offers participants the flexibility to contribute at their own pace, within the designated timeframe.  


The Hackathon

Participants will analyze Jan’s training data and complete missions to optimize his training for the 2023 Ironman World Championship, which will take place in Nice in September. With his coach Dan Lorang, SAP Workouts were developed, which Jan has already completed several times while preparing for the Ironman European Championship in Hamburg. Jan Frodeno, the renowned German triathlete and Ironman World Champion, has partnered with SAP to unleash the power of data in his training. Numerous KPIs are included in the data, namely heart rate, power, cadence, glucose level, lactate, pain level, saturated hemoglobin, and core body temperature. 

The data will be made available after registration for the hackathon and offer a unique opportunity for data scientists, developers, and sports enthusiasts to analyze, understand, and make use of the extensive data collected by Frodeno during his SAP Workouts. The challenge of the hackathon is simple: Analyze Jan Frodeno’s data from his SAP Workout executions and provide interesting insights to him! Extract intriguing patterns, uncover valuable correlations, and present Jan with unique perspectives to enhance his performance. Whether alone or in a team, the hackathon can be run in both ways. How you tackle the challenge is up to you. We have created 5 missions that support conquering the challenge or you simply access the data and do the analysis as you like. In the handbook, which we send out upon registration, we provide further assistance on how to technically solve the requirements exemplary. Of course, you are also free to complete the analysis without our assistance. 

Once you’ve completed the missions, there is only one step left. Submit a short video to that outlines your or your team's key findings. With an end date of July 31st, 2023, participants are granted ample time to delve into Jan Frodeno's workout data, leveraging their skills, creativity, and passion for data analysis. 


The Missions 

In order to accomplish the challenge, you can fulfill different missions, which you can find in our guide. Before I go into more detail about each step, you can find a summary of the missions in the image below.


Mission 1

The first mission is to access the data. If you use Datasphere, you get this step done within a click by using the provided license key and downloading our data products. More specifically, we provide eight data products, that include data from different sensors and Jan's race schedule. 

The integrated Data Marketplace simplifies data exchange. You as a participant can access Jan's data in a few clicks into your SAP Datasphere tenant without doing any integration work. Once the data is integrated via the Data Marketplace, you can benefit from the entire data management functionality of SAP Datasphere to start working on your data model!  

When using other tools, the provided CSV files can be uploaded into your tool of choice. 


Mission 2

After the preliminary work is completed and the data is ready to use, the second mission is to familiarize yourself with the data. Answer our questions to understand the data and to identify important metrics to assess the possible need of further data modeling.

  1. What is the maximum value of the Power KPI for the second workout?

  2. How many tables have been provided (with the Data Product or through the files) and which file has the most records?

  3. On which time granularity are the different provided KPIs?

  4. How many intervals has a workout & how long are the intervals?

  5. What is the start time of the first workout.

Through answering those five questions you get acquainted with the data and build up sound knowledge to start building the data model in the next mission.


Mission 3

In mission three, the centerpiece of the hackathon will be created, namely the data model. The Analytic Model in SAP Datasphere is the foundation for making data ready for consumption in SAP Analytics Cloud. It enhances the analytical dataset by the possibility to model calculated measures, restricted measures and count distinct measures. As the basis of your visualization, there are different demands that need to be fulfilled. For one, all KPIs that have been collected must be featured. Therefore, the different granularities of the data have to be unified. As data from three workouts are provided, Jan also wants to flexibly compare his performance in one workout to another. The entire focus of Jan's training is currently on the Ironman World Championships. That is why the third demand is that he wants to know how many weeks he has remaining until then. 

The screenshot below illustrates the lineage of the Analytic Model. It starts with eight data products and involves several steps to harmonize the data, resulting in an analytical dataset used to create the Analytic Model.


Mission 4

Once all steps of data modeling and harmonization in SAP Datasphere have been completed, the next step is to visualize the data in a comprehensible way. This also corresponds to the 4th mission namely, to build a comprehensible dashboard with data visualizations. However, there are several requirements that must be met. For one, it should display the KPIs of a single SAP Workout and also facilitate a comparison between any two SAP Workouts. Furthermore, it is easier for the analysis and interpretation of the data to display the training minute instead of the time of data recording. Since each SAP Workout is the same and follows a fixed structure, displaying data by the minute of the workout makes it easier to compare the data. Most importantly, however, Jan should gain useful insights from the data. For example, it can be interesting to see how high the maximum heart rate was within the intervals. There are two possible approaches for this requirement.  

One is to create a calculated measure in our Analytic Model in SAP Datasphere. As the screenshot below shows, you just have to click on the plus sign and select calculated measure. The new measure must then be assigned a name. In the field expression you have to enter the measure from which the maximum should be calculated, in our case it is called 'Aggregated measure per workout minute'. The main calculation is done in a field further down, namely the exception aggregation. Here we select 'MAX' as aggregation type and the timestamp as aggregation dimension. After deploying the Analytic model, the measure can be used in your SAP Analytics Cloud Story. 

The second way to implement this is directly in SAP Analytics Cloud. To do this, open the builder and add a new calculation. In the pop-up window, select aggregation and enter a name for the calculation. Select the desired aggregation, in our case 'MAX', select the desired key figure and set the timestamp as the aggregation dimension. After clicking OK, the new calculated measure can be used in your story. 


Our manual, which is sent to you upon registration, contains several helpful resources for requirements like this. However, everyone is free to complete the missions without the help provided. 

In preparation for the hackathon, i set myself to work and completed our missions myself. I designed a dashboard that meets all the requirements. For a sneak peak check out the screenshot below.


Mission 5

After successfully completing the 4 missions there is only one thing left to do: submit your solution to win. Walk us through your results and present your key findings in a short video. The judging process will begin in August, and winners will be announced later that month. 

Criteria by which the participants are evaluated are: 

Interesting Insights: Jan Frodeno's quest for improvement is at the heart of this hackathon. Participants will be evaluated based on the uniqueness and relevance of the insights they extract from Jan's workout data. The judges will be looking for innovative approaches that uncover valuable patterns, correlations, and recommendations to help Jan enhance his performance. 

Technical Sophistication: Jan's fascination with technology drives this criterion. Participants are encouraged to showcase their technical prowess by leveraging the power of SAP Datasphere and SAP Analytics Cloud, or any other tool of their choice, to demonstrate the art of the possible in data analysis. 

Attractive Design: Jan's appreciation for style and aesthetics is reflected in this criterion. Participants will be evaluated on the visual appeal, usability, and thoughtfulness of their dashboard design. 


Why should you participate? What is in for you? 

The Plan to Win: Get Active with Data Virtual Hackathon offers a unique opportunity to experience SAP Datasphere and SAP Analytics Cloud in a playful way. As a participant in this hackathon, you gain exclusive access to cutting-edge tools such as SAP Datasphere and SAP Analytics Cloud. Expand your skill set, gain hands-on experience, and demonstrate your ability to harness the full potential of these powerful platforms. 

Showcase your skills to SAP experts: This hackathon provides a platform to showcase your talents, expertise, and innovative thinking directly to industry experts. It's a chance to make your mark, receive valuable feedback, and gain recognition for your exceptional abilities in data analysis and visualization. 

Help Jan Frodeno optimize his training plan: Join forces with a world-class triathlete, Jan Frodeno, and contribute to his journey towards the 2023 Ironman World Championship. Your analysis and insights have the potential to improve Jan's training routine, unlocking new possibilities for performance enhancement. 

Earn prizes for your findings: Your hard work deserves recognition, and the Virtual Self-Paced Hackathon offers just that. By submitting your findings, insights, and recommendations, you become eligible for exciting prizes. Not only will you have the satisfaction of contributing to Jan Frodeno's success, but you also have the chance to be rewarded for your efforts. 

Join the Virtual Self-Paced Hackathon today and register here to let your passion for data analysis and innovation shine! I am looking forward to your solutions, insights, and innovations that you'll bring to the table.

Happy to hear what your thoughts and questions about our Hackathon in the comments!