A #SocialHero is someone who has the willingness to create a positive impact in their local community. This fall, SAP Analytics is hosting an online viz-a-thon for students all across North America. Our main focus for this challenge is for students to find ways to measure the UN’s Global Goals for Sustainable Development.

We know you’re just as committed to the UN’s Global Goals for Sustainable Development as SAP is. So, we’re looking to you, our Social Heroes, to create some impactful visualizations using SAP Analytics Cloud. We want to see what you can illustrate from the data and help visualize the world’s progress towards achieving the Sustainable Development Goals. From data beginners to data experts, this challenge is for any student across Canada and the United States.

We understand that coming up with potential solutions isn’t easy, but it can definitely be fun and insightful! By using SAP Analytics Cloud, we were able to unearth hidden insights—and even make some predictions and suggestions. As an example, in today’s blog, I’ll share what I came up with for the results after analyzing the World Bank Sustainability Data.

Step One—Choose the Data and the Model

As for any visualization, model creation is one of the most important first steps in creating an insightful story. For the story that I have built below, I had chosen to work with a public data source, where anyone can use the data for their analytics projects. Specifically, I decided to go with World Bank Open Data.

The data points that I had selected for this particular story are:

  • Capture Fisheries Production (Metric Tons)
  • World Population
  • Forest Area (sq. km)
  • Agricultural Land (% of land area)

The goal of this analysis is to determine the strength of the relationship between each variable.

Step Two—Story Building

Once the data is uploaded into SAP Analytics Cloud and is properly validated, I began the story building process by using the Smart Discovery capability. Smart Discovery is a feature, that uses machine learning, to enables you to quickly discover key influencers, identify outliers, analyze patterns in your data and much more.

After running Smart Discovery for four of the measures in my model, one thing that stood out to me was the Fisheries Production (Metric tons).

With the time as the y-axis, we can see that over the last few decades, fish production nearly quadrupled, with numbers slight dropping in recent years.

Step Three—Making Predictions

With the use of SAP Analytics Cloud, I am also able to predict the forecasted tons of fisheries for the next decade. The Time Series Forecasting feature provides an upper bound of 1,072 million and lower bound of 481 million but with a downward trend in production since 2000, the forecasted Capture Fisheries Production in 2028 will be around 777 million (metric tons). As noted, the lower bound of the prediction for 2028, is still nearly double the amount of fishes captured in the 1960s.

As population increases, it was a surprise to see that food sources, such as fish, have seen a noticeable decrease in production over the last 15 years. Possible reasons for this reduction could be the changes in regulation, stricter quality checks, and even change in consumption pattern. After running a Smart Discovery on the fisheries measure, two key influencers were also determined.

This slideshow requires JavaScript.

Forest Area and Agricultural Land (% of land area) were the two key influencers for Capture Fisheries Production whereas World Population was not.

There were also 385 unexpected values, which indicates the number of values that deviate from the analysis prediction. Since our data set is quite large, the 385 unexpected values do not have a strong influence on the overall analysis.

Step Four—Taking a Closer Look

After going through the exports of the Smart Discovery feature, I then selected the measures and dimensions I wanted to learn more about and created my own comparison graphs.

As noted in this graph above, there are parallel trends between Capture Fisheries Production (metric tons) and Agricultural Land (% of land) over the last few years. There has been a significant increase in the number of movements and business campaigns that aim to care for our environment over the last decade. In addition, many governments worldwide have taken action, creating stricter regulations, fighting to protect our forests and oceans. Naturally, with a finite amount of land, the more space allocated for agricultural purposes, less forest areas remain.

Try It Yourself

This is only one of the many UN goals I have targeted. Now it is your turn to turn data into useful insights. Are you up for the challenge? Join our Social Hero Viz-a-thon Challenge today! Submissions end on December 15, 2018.

Top two submissions of the viz-a-thon will be rewarded with an exclusive prize – fueling the continuation of their analytics journey. Both winners of the #SocialHero Viz-a-thon will win an online 1-1 session with our Chief Product and Field Marketing Officer, Alison Biggan and also our Senior Vice President & Global Head of SAP Next-Gen, Ann Rosenberg.

We’re looking forward to all your SAP Analytics Cloud visualizations. Visit Social Hero Viz-a-thon Challenge to enter the contest.