A Modern Take on Data Visualization with SAP Analytics Cloud

I have been working in data connectivity and visualization for over a decade and have spent countless hours building reports and dashboards to respond to a plethora of business needsI have created operational reports for shop floor managers and financial dashboards for chief executivesIf a position exists in an organization, I have developed some sort of visualization for that role. The process always begins with requirements gathering“What is it that you’re trying to do?” and “How do you need this to look?” are typical questions that I ask. Looking for a response and furiously making notes, I begin the process of visualizing potential prototypes in my headWhile this is a proven and repeatable process, I’ve learned there are more modern ways of getting actionable data from intelligent systems. 

Looking at requirements gathering from new perspectiveI began to take the approach of “What questions are you trying to answer?” If I supplied the end users a system through which they could ask questions naturally, would that be more useful and successful? Extending traditional analytics development by asking real world questions speeds adoption by end users.  This led me to the concept of augmented analytics. Do not let that pair of buzzwords be a deterrent. We hear about augmented analytics in numerous articles and publications on modern business intelligence practices. Many vendors have implemented their own take on augmented analyticsSo, let’s have a look at how this topic in SAP Analytics Cloud (SAC) can help enhance and modernize current data visualization processes. 

Introduction to Augmented Analytics 

Augmented analytics is a process in which actionable insights can be derived using artificial intelligence and machine learning through simple interfaces such as natural language queries. To put it in simpler terms, ask a question and get an answer! All that is needed is a platform such as SAP Analytics Cloud and a good data model. The data model will have business terminology such as “sales revenue” and “patient count.” In a well-built model, users can ask questions such as “What is the sales revenue by region for last quarter?” or “What is the patient count for yesterday?” The system responds by reviewing all data models and objects within those models for names that match. The platform then supplies the most correct answer possible. 

Preparing SAP Analytics Cloud for Questions 

Here is a timely example of how SAP Analytics Cloud approaches augmented analytics through a feature called “search to insight. We have a data set that has 1,267 records. Each record relates to the daily COVID-19 vaccinations by country. The data has been imported (this works for live connections as well) and the model has been prepared for analysis. To properly prepare the model, the measures and dimensions were named appropriatelyFor instance, rather than keeping a measure called “people_fully_vaccinated,” the field was named “People Fully Vaccinated.”  This makes it easier for end users to find the information they need. Additionally, we need to index the model for “search to insight” queries (model -> model preferences -> search to insight -> index model). 

Getting Actionable Information Through Questions 

So far, we have found a data set and generated a model to help us gather actionable information. Now, we will use SAP Analytics Cloud to visualize the data.  In SAC, there is a small light bulb icon at the top right cornerClicking that icon opens the search to insight panel. At the bottom is a bar with the words “ask a question.” If we type a real question such as “how many people vaccinated yesterday? we get a response:

This response can be added to a new story or simply used to take action. Keep in mind that this data set reports on all vaccinations by day for all countries. Taking this a step further, we can query the number of vaccinations by country by issuing the query people vaccinated yesterday by country”: 

We can continue with more questions of the data such as “people vaccinated for USA by date”: 

The platform presents us with a time series chart showing the number of people vaccinated only for the United States for all time within our data set. 

Next Steps 

Traditional development of data visualizations has always happened through the addition of widgets, then assigning the correct data to those widgets — a very technical method of visualization creation. With the latest features of SAP Analytics Cloud,  end users will have the ability to visit a webbased platform to ask data related questions in business terms and receive the insights that they need when they need them. With a well-developed data model and an optimized database providing fast and accurate results, the adoption of these trusted systems will rise. The Search to Insight feature of the SAP Analytics Cloud platform supplies a very quick and powerful way to get timely information. This reduces the need for development bottlenecks and time to delivery. Consider how augmented analytics can help speed time to insight and have a look at the SAP Analytics Cloud platform to take advantage of these features. 


To learn more about our SAP capabilities, contact us or visit Protiviti’sSAP consulting services. 

Chris Hickman

Associate Director
Enterprise Application Solutions

Subscribe to Topics

As businesses compete for #quantum compute time, things can get complicated. @Strangeworks provides shorter queue times and cost and access control for customers. Join @KonstantHacker as he chats on this with Cesar Rodriguez from @Strangeworks. http://ow.ly/jERF50Gvo0W

Read this #SAP Blog to learn five considerations that have improved #ROI for our clients, highlight new ways of working and the art of the possible in the organization’s future #S4HANA system compared to ECC 6.x systems. http://ow.ly/WE5I50GuBRT

#ProtivitiTech #analytics #cloud

The intersection of #5G and #edgecomputing technologies will reinvent industries, change the way #security is implemented and revolutionize business operations. Learn in #Technology Insights why 5G and edge computing impacts approaches to security: http://ow.ly/hut750Gu2Um

Digitally transforming business with #Dynamics365 CE provides organizations with easy configuration and #integration with other #Microsoft products, fewer post-deployment issues and can be accessed anywhere. Read more in the #Technology Insights blog: http://ow.ly/AueX50GqQZs

In Protiviti's #cybersecurity #webinar series, learn insights from the effectiveness of crisis management response in #ransomware attacks to articulating core concepts of #zerotrust and the toolsets needed to architect zero trust. Explore sessions here: http://ow.ly/qVLp50Gi52T

Load More...