Skip to Content

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

To report this post you need to login first.

92 Comments

You must be Logged on to comment or reply to a post.

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

    (0) 
  2. Andrew Fox

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

    (0) 
  3. 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!

    (0) 
  4. Richard Qi

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

    (0) 
  5. 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

    (0) 
  6. Mario Prkacin

    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

    (0) 
  7. Alex Yang

    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

    (0) 
      1. Alex Yang

        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

        (0) 
        1. Amit Gupta 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

          (0) 
          1. Alex Yang

            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

            (0) 
            1. Amit Gupta 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

              (0) 
  8. Hrushikesh Salla

    Hello Amit,

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

    (0) 
  9. Alex Yang

    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

    (0) 
  10. 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

    (0) 

Leave a Reply