Skip to Content
Author's profile photo Amit Gupta

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

F1 Data Current.png

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.

F1 Current1.png

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

F1 Current2.png

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.

F1 Current3New.png

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

F1 Data History.png

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.

F1 History1.png

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.

F1 History2.png

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.

F1 Simulator 1.png

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.

F1 Simulator 2.png

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

F1 Simulator 3.png

Use can click on Reset button /wp-content/uploads/2014/11/reset_601406.pngto go back to main screen. and select another race to simulate.

F1 Simulator 4.png

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

Assigned Tags

      92 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Well done Amit, this is very cool stuff! 🙂

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Niklas!

      Author's profile photo Oliver Schilling
      Oliver Schilling

      Dear Amit,   really outstanding. love it. Go ahead building TCS IP on SAP poroducts... SAP Analytics Development is going to support you for any last mile stuff if necessary :-). Very well done, Best Oliver

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks a lot Oliver!

      Author's profile photo Former Member
      Former Member

      Well done this looks great, certainly things in there I haven't seen before.

      I guess some of these stories are using custom written visualisation components, is this a correct assumption?.

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Hi Andrew,

      Thanks!

      You are right, in fact all visualizations are custom written.

      - Amit

      Author's profile photo Jeroen Thoden van Velzen
      Jeroen Thoden van Velzen

      Exceptional work. Great job!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Jay!

      Author's profile photo Mohamed Abdel Hadi
      Mohamed Abdel Hadi

      Wow !! very nice !!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Mohamed!

      Author's profile photo Former Member
      Former Member

      Amazing. How did you build in some of these animations?

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Shiraz!

      Its build using SAP Lumira's visualization SDK aka vizpacker.

      Author's profile photo Former Member
      Former Member

      Great Job.

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Mojan!

      Author's profile photo Hari Srinivasa Reddy
      Hari Srinivasa Reddy

      This is simply awesome. Great job.

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Hari!

      Author's profile photo Former Member
      Former Member

      Excellent !! Great work!!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Satya!

      Author's profile photo Adem Baykal
      Adem Baykal

      This is a wonderful Lumira report - like it very much. Well done Amit 🙂

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Adem!

      Author's profile photo Ty Miller
      Ty Miller

      Fantastic stuff Amit! The animation is indeed cool and I particularly like your use of the collapsible tree.

      Our engineers will get a kick out of seeing what you’ve done here.

      Love your passion for Lumira!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Ty!

      Author's profile photo Ty Miller
      Ty Miller

      If you're interested in sharing your source files with the Lumira community and having others riff on it we've started a Lumira GitHub repository and I can put you in touch with the person that can help you get it there.

      Author's profile photo Mohamed Abdel Hadi
      Mohamed Abdel Hadi

      Yes - would be great - if Amit can share it to the Community.

      Mo

      Author's profile photo Adem Baykal
      Adem Baykal

      Great idea. This will help many Lumira Fans 🙂

      -Adem

      Author's profile photo Former Member
      Former Member

      So fantastic visualization extensions, Amit! I really like the flyout tree from bar in the second storyboard. Thanks for sharing us the amazing dashboard.

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Richard!

      Author's profile photo sateesh j
      sateesh j

      Superb Amit,

               Really amazing, Column chart with Scaling gaze, and Train like Driver Information and Bar chart and emerging  Tree chart from bar chart its amazing. And good stuff on F1.

      Thanks and Regards

      Sateeh

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Sateeh!

      Author's profile photo Former Member
      Former Member

      Great job Amit,

      I became hooked to my discovery/story instead of paying attention to show functionalities of Lumira. You prepared much better story.

      Congratulation! 🙂

      Mario

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Mario!

      Author's profile photo Former Member
      Former Member

      Hi Amit,

      Thanks so much for your great example

      Just one question for the drop list for selection and Go button, this is also coming from SDK?

      Best regards

      Alex yang

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Hi Alex,

      Unfortunately its not part of the SDK yet, i used jquery to add these controls to extension.

      Regards,

      Amit

      Author's profile photo Former Member
      Former Member

      Hi Amit,

      Thanks for your reply

      So this function is not SAP Lumira default function (I mean only achieve via extenstion)

      I really like the layout you design for your storyboard

      But could I say most of them is using extenstion instead of SAP Lumira defaut function?

      Best regards

      Alex yang

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Hi Alex,

      Yes, you could say that at the moment its not Lumira default function and had to be custom developed.

      Regards,

      Amit

      Author's profile photo Former Member
      Former Member

      Hi Amit,

      Thanks for your reply on this

      Would you kindly let me know from your side, whether this kind of trend will be kept or we 'd better use custom developed way

      BTW, how long it takes for you to develop this kind of report and whether this could be created as a template

      Best regards

      Alex yang

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Hi Alex,

      Hopefully, these features would be available in Lumira in upcoming releases. but for the immediate needs it can be custom developed. It may be a good idea to develop it in a way that it can be replaced with Lumira standard features later.

      Yes, with some extra efforts it can be made as a template. It can be developed in a separate .js file and referenced/added in render.js in vizpacker. That would make it moduler and easy to replace with standard Lumira controls when its available.

      Regards,

      Amit

      Author's profile photo Ty Miller
      Ty Miller

      This is good feedback guys. Richer input controls to all Compose room assets is on the roadmap.

      Author's profile photo Former Member
      Former Member

      Hi Amit,

      This looks really fantastic.

      Thanks for sharing.

      Regards,

      Deepak

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Deepak!

      Author's profile photo Guillaume GARCIA
      Guillaume GARCIA

      This looks incredible!!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Guillaume!

      Author's profile photo Former Member
      Former Member

      Great stuff Amit

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Shiva!

      Author's profile photo Former Member
      Former Member

      Hi Amit- Can you please email or direct message me?

      Author's profile photo Sk Manirujjaman
      Sk Manirujjaman

      Great work.

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Manirujjaman!

      Author's profile photo Nadeem Akhtar
      Nadeem Akhtar

      Hi Amit,

      Awesome stuff!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Nadeem!

      Author's profile photo Former Member
      Former Member

      Well done Amit 🙂

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Ajit!

      Author's profile photo Mutheeshwaran S
      Mutheeshwaran S

      Hi...Its really amazing!!!!

      All the best..!!!!!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks a lot Mutheeshwaran!

      Author's profile photo Former Member
      Former Member

      Really awesome! 🙂

      Well done!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Ketul!

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Well done.  🙂

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Krishna!

      Author's profile photo Former Member
      Former Member

      Great Stuff!! Well done Amit!!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Ranjith!

      Author's profile photo Former Member
      Former Member

      Hi Amit,

      Its really a great stuff.

      Thanks for sharing.

      Thanking You All..!!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Ankit!

      Author's profile photo Former Member
      Former Member

      Hello Amit,

      It's amazing......animation, visualization, statistics..... 🙂 ...... wonderful use of SAP Lumira.... for bringing your imagination to reality..... 🙂

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks a lot for your encouraging comment!

      Author's profile photo Purvang Zinzuwadia
      Purvang Zinzuwadia

      this is super creative!! well done, Amit

      - Purvang

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Purvang!

      Author's profile photo Former Member
      Former Member

      Hi  Amit,

      Would you mind sharing the extenstion and related object (including SAP Lumira Document) you are using for this Data Geek

      This is really awesome

      Best regards

      Alex yang

      Author's profile photo Former Member
      Former Member

      It's really awesome Amit.

      Regards,

      Abhi

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Abhi!

      Author's profile photo Former Member
      Former Member

      Great work Amit. Keep it up!!!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Kishore!

      Author's profile photo Vinod Kumar Akurathi
      Vinod Kumar Akurathi

      Incredible work Amit. Well done.

      Regards,

      Vinod.

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Vinod!

      Author's profile photo Venugopalrao Kavuru
      Venugopalrao Kavuru

      Hi Amit, Just recently realized that SAP Lumira helps Business in knowing unknowns in their data and some times unknown knowns. However its a great and commendable work !!!!! Regards, Venu.K TCS

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Venugopalrao!

      Author's profile photo Carlos Pinto
      Carlos Pinto

      Fantastic work! Congrats Amit!

      Best Regards,

      Carlos

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Carlos!

      Author's profile photo Mustafa Aydogdu
      Mustafa Aydogdu

      great work. congrats Amit.

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Mustafa!

      Author's profile photo Former Member
      Former Member

      Really Cool.. Congrats... 🙂

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Suresh!

      Author's profile photo Former Member
      Former Member

      Hi Amit

      Great Work.congrats. 🙂

      Best Regards,

      Rajaramesh M

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Rajaramesh!

      Author's profile photo Brad Borkan
      Brad Borkan

      Absolutely brilliant!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Brad!

      Author's profile photo Christopher Arias
      Christopher Arias

      Congratz! reaaally Great!

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Christopher!

      Author's profile photo Peter SNOWDON
      Peter SNOWDON

      Thats really great, you make the team here proud of their work by your work.

      cheers,

      peter

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Peter for the encouraging comment!

      Author's profile photo Laurent LIZOURET
      Laurent LIZOURET

      Impressive ans usefull, bravo !

      Author's profile photo Amit Gupta
      Amit Gupta
      Blog Post Author

      Thanks Laurent!

      Author's profile photo Saravanan A
      Saravanan A

      Thanks for sharing Amit. May I have your contact mail ID please. I need some information on Lumira's limitation.

      Author's profile photo Former Member
      Former Member

      Impressive and motivating