DataGeek III Challenge: Formula 1 Statistics

[former_member198781]

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

[Former Member]

Well done Amit, this is very cool stuff! 🙂

[former_member198781]

Thanks Niklas!

[former_member205785]

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

[former_member198781]

Thanks a lot Oliver!

[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?.

[JayThvV]

Exceptional work. Great job!

[former_member198781]

Hi Andrew,

Thanks!

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

- Amit

[former_member198781]

Thanks Jay!

[former_member186220]

Wow !! very nice !!

[former_member198781]

Thanks Mohamed!

[Former Member]

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

[former_member198781]

Thanks Shiraz!

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

[Former Member]

Great Job.

[Former Member]

This is simply awesome. Great job.

[Former Member]

Excellent !! Great work!!

[former_member198781]

Thanks Hari!

[former_member198781]

Thanks Mojan!

[former_member198781]

Thanks Satya!

[Adem_Baykal]

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

[former_member66229]

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!

[former_member66229]

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.

[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.

[former_member198781]

Thanks Adem!

[former_member198781]

Thanks Ty!

[former_member198781]

Thanks Richard!

[former_member197751]

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

[former_member198781]

Thanks Sateeh!

[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! :smile:

Mario

[former_member198781]

Thanks Mario!

[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

[former_member198781]

Hi Alex,

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

Regards,

Amit

[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

[former_member198781]

Hi Alex,

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

Regards,

Amit

[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

[former_member198781]

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

[former_member66229]

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

[Former Member]

Hi Amit,

This looks really fantastic.

Thanks for sharing.

Regards,

Deepak

[former_member198781]

Thanks Deepak!

[guillaume-hrc]

This looks incredible!!

[former_member198781]

Thanks Guillaume!

[Former Member]

Great stuff Amit

[former_member198781]

Thanks Shiva!

[Former Member]

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

[former_member207874]

Great work.

[former_member186220]

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

Mo

[Nadeem_Akhtar]

Hi Amit,

Awesome stuff!

[former_member198781]

Thanks Manirujjaman!

[former_member198781]

Thanks Nadeem!

[Former Member]

Well done Amit :smile:

[former_member207989]

Hi...Its really amazing!!!!

All the best..!!!!!