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:-
- Current Standings
- F1 Top Ten – Year wise, race wise standings
- F1 Top 5 – Season’s Standing (2014)
- 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
Well done Amit, this is very cool stuff! 🙂
Thanks Niklas!
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
Thanks a lot Oliver!
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?.
Hi Andrew,
Thanks!
You are right, in fact all visualizations are custom written.
- Amit
Exceptional work. Great job!
Thanks Jay!
Wow !! very nice !!
Thanks Mohamed!
Amazing. How did you build in some of these animations?
Thanks Shiraz!
Its build using SAP Lumira's visualization SDK aka vizpacker.
Great Job.
Thanks Mojan!
This is simply awesome. Great job.
Thanks Hari!
Excellent !! Great work!!
Thanks Satya!
This is a wonderful Lumira report - like it very much. Well done Amit 🙂
Thanks Adem!
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!
Thanks Ty!
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.
Yes - would be great - if Amit can share it to the Community.
Mo
Great idea. This will help many Lumira Fans 🙂
-Adem
So fantastic visualization extensions, Amit! I really like the flyout tree from bar in the second storyboard. Thanks for sharing us the amazing dashboard.
Thanks Richard!
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
Thanks Sateeh!
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
Thanks Mario!
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
Hi Alex,
Unfortunately its not part of the SDK yet, i used jquery to add these controls to extension.
Regards,
Amit
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
Hi Alex,
Yes, you could say that at the moment its not Lumira default function and had to be custom developed.
Regards,
Amit
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
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
This is good feedback guys. Richer input controls to all Compose room assets is on the roadmap.
Hi Amit,
This looks really fantastic.
Thanks for sharing.
Regards,
Deepak
Thanks Deepak!
This looks incredible!!
Thanks Guillaume!
Great stuff Amit
Thanks Shiva!
Hi Amit- Can you please email or direct message me?
Great work.
Thanks Manirujjaman!
Hi Amit,
Awesome stuff!
Thanks Nadeem!
Well done Amit 🙂
Thanks Ajit!
Hi...Its really amazing!!!!
All the best..!!!!!
Thanks a lot Mutheeshwaran!
Really awesome! 🙂
Well done!
Thanks Ketul!
Well done. 🙂
Thanks Krishna!
Great Stuff!! Well done Amit!!
Thanks Ranjith!
Hi Amit,
Its really a great stuff.
Thanks for sharing.
Thanking You All..!!
Thanks Ankit!
Hello Amit,
It's amazing......animation, visualization, statistics..... 🙂 ...... wonderful use of SAP Lumira.... for bringing your imagination to reality..... 🙂
Thanks a lot for your encouraging comment!
this is super creative!! well done, Amit
- Purvang
Thanks Purvang!
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
It's really awesome Amit.
Regards,
Abhi
Thanks Abhi!
Great work Amit. Keep it up!!!
Thanks Kishore!
Incredible work Amit. Well done.
Regards,
Vinod.
Thanks Vinod!
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
Thanks Venugopalrao!
Fantastic work! Congrats Amit!
Best Regards,
Carlos
Thanks Carlos!
great work. congrats Amit.
Thanks Mustafa!
Really Cool.. Congrats... 🙂
Thanks Suresh!
Hi Amit
Great Work.congrats. 🙂
Best Regards,
Rajaramesh M
Thanks Rajaramesh!
Absolutely brilliant!
Thanks Brad!
Congratz! reaaally Great!
Thanks Christopher!
Thats really great, you make the team here proud of their work by your work.
cheers,
peter
Thanks Peter for the encouraging comment!
Impressive ans usefull, bravo !
Thanks Laurent!
Thanks for sharing Amit. May I have your contact mail ID please. I need some information on Lumira's limitation.
Impressive and motivating