DataGeek III Challenge: Formula 1 Statistics

Hi,

I started using SAP Lumira few months back and got totally hooked on it. Undoubtedly, its one of the best Self Service BI tool. Apart from bundled with lots of out-of-the-box extensions it also provides flexibility to developers to create custom visual/data extensions. In short, it provides endless possibilities to individuals / companies to create stunning visual stories.

I accepted the Data Geek III Challenge and analysed Formula 1 statistics using SAP Lumira. I started with collecting data for Formula 1 results and developed corresponding extension, which i felt suited to the stories. Main source of data and images have been Formula 1® – The Official F1® Website and Wikipedia.

I have created following storyboards:-

1. Current Standings
   • F1 Top Ten – Year wise, race wise standings
   • F1 Top 5 – Season’s Standing (2014)
2. Historic Standings
   • F1 Top Ten – Season’s winners (last 10 years)
   • Team’s season wins by year

Each of these storyboards is discussed below in detail.

Current Standings

These storyboards presents Formula 1 standings of team and driver for year and race.

Dataset contains year, race, position, Driver, team as Dimensions and Laps, Time, Grid, Points as Measures.

First storyboard is “F1 Top Ten – Year wise, race wise standings”, which shows top ten drivers for selected year and race.

Above bar chart uses animation with a moving F1 car image. Check out video at the end of the blog.

User can select year, race and on click of “Go” button, storyboard would change to display data for selected year & race.

A circuit diagram for selected race is also displayed.

Second storyboard is “F1 Top 5 – Season’s Standing (2014)“, which shows top 5 drivers for year 2014.

On the left of storyboard, Top 5 drivers are shown based on their total points for the season 2014. User can select the driver and his performance is shown in the storyboard.

In the middle, table shows name of the driver and his national flag, his team and its logo, his overall ranking (based on earned points) and total points.

Right side bar chart shows selected driver’s performance for the races he took part in 2014.

Historic Standings

These storyboards show driver’s and team’s performance over period of time.

Dataset contains season (year), driver, team as Dimensions and Poles, Wins, Podiums, Points, Point Margins as Measures.

First storyboard is “F1 Top Ten – Season’s winners (last 10 years)”, which shows season winners for last 10 years. On hovering over the year, driver’s photo and corresponding data is highlighted.

Second storyboard is “Team’s season wins by year”, which shows winning by teams since beginning of Formula 1 championship. Team names and their total number of wins are presented in a bar chart. On clicking “+” sign, a tree structure with years and driver names is displayed.

To sum it all, all of these stories contain lots of animation which cannot be presented by images. I recommend you to watch below video to see these storyboards in action.

My main objective was to show power of Lumira. Its a next generation BI tool which can help organizations to create amazing dashboards.

Thanks for reading this blog, hope you enjoy it.

—— Dec 04, 2014

There was another extension which I wanted to share but couldnt do it earlier. Finally managed to complete it.

F1 Race Simulator

This is my effort to simulate a F1 race with cars moving on selected track. To keep it simple I have only taken first 3 cars and try to simulate their movements on track in a single lap.

Once year and race is selected and button”Go” is pressed, cars start moving on the track. With their speeds proportional to the time taken by the drivers to complete the race.

At the end of the race, results are shown in a podium like fashion.

Use can click on Reset button to go back to main screen. and select another race to simulate.

You can see it in action in following video.

Thanks again for reading this blog, hope you enjoy this part as well.

Regards,

Amit Gupta