Refreshing Concepts for SAP Analytics Cloud

Objective

After completing this lesson, you will be able to describe SAP Analytics Cloud and its components related to the SAP Analytics Cloud, add-in for Microsoft PowerPoint: stories and widgets.

What Is SAP Analytics Cloud?

Before you start discovering how you can use SAP Analytics Cloud within your Microsoft PowerPoint presentation, let’s refresh some basic concepts of SAP Analytics Cloud that are relevant for this add-in.

SAP Analytics Cloud is a cloud-based analytics platform. It lets you connect to your business data, analyze it, and share insights with your team. You access it through a web browser. You do not need to install anything on your computer.

Business users rely on SAP Analytics Cloud to monitor performance, track key metrics, and make better business decisions.

Stories and Widgets

SAP Analytics Cloud organizes your data visualizations in stories. A story is a document that contains charts and other visual elements. These elements display your business data in a clear and meaningful way.

SAP Analytics Cloud refers to each chart or visualization within a story as a widget. For example, a bar chart showing revenue by region is a widget. A line chart showing sales trends over time is also a widget.

When you use the SAP Analytics Cloud, add-in for Microsoft PowerPoint, you select widgets from stories and embed them directly into your slides.

SAP Story presents filter checklist, line and bar charts, bubble map, and data table cards.

The Model Behind Every Widget

Each widget in a story gets its data from a model. A model is a structured representation of your business data. It defines the measures and dimensions that SAP Analytics Cloud uses to build visualizations.

As a business user, you do not build or manage models. Your IT team creates them. However, knowing that a model exists behind each widget helps you understand why the data in your widgets looks and behaves the way it does—for example, why certain filters or drill-down options are available.

When you edit a widget in PowerPoint using the add-in, the panel shows the name of the model behind that widget. This tells you which data source drives the chart you are working with.

How Data Gets into SAP Analytics Cloud

Before embedding data from SAP Analytics Cloud into your slides, you need to know how SAP Analytics Cloud gets its data. So, it connects to your business data in two ways:

  • When you refresh a widget from a story that uses a live connection, SAP Analytics Cloud queries the data source directly. The model stores no data — it is an empty structure that defines how to read the source. Your widget always displays the latest values.
  • When you refresh a widget from a story that uses an import connection, SAP Analytics Cloud queries the model. When the IT team creates the model, SAP Analytics Cloud copies the data from the data source into the model. By default, any changes in the data source do not affect the data in the model. However, your IT team can schedule data updates at a defined frequency to keep the model up to date.
Live connection keeps data at data sources, while import connection moves data from data sources into SAP Analytics Cloud.

Both connection types work with the add-in. Your widgets in PowerPoint display data regardless of how the source story connects to its data.

Note

For more information about this topic, please read Exploring SAP Analytics Cloud

What This Means for This Course

In this course, you use SAP Analytics Cloud stories as the source of the charts you embed in PowerPoint. You do not need to build stories yourself. Your role is to select the right widgets from existing stories and present them to your audience.

Data and Analytics Learning Group

If you would like more information about any of the topics covered in this course, we encourage you to join the Data and Analytics Learning Group. It's an SAP Community comprised of data and analytics learners and experts where you can ask your questions, exchange ideas, and build connections. With discussions, blog posts, and a knowledge base, it's a great place for current news, tips, and tricks to make your life a little easier when learning about SAP Analytics Cloud!

Summary

Let's summarize what you've learned:

  • SAP Analytics Cloud lets you connect to business data, analyze it, and share insights through a web browser.
  • Widgets are individual visualizations, such as bar charts or line charts, within a story.
  • SAP Analytics Cloud supports live connections and imported data.
  • In PowerPoint, you embed selected widgets from existing SAP Analytics Cloud stories.