SAC Interview Questions (Basic)

[DheerajHJ]

Here's a quick questions and answers guide for preparing SAP Analytics Cloud (SAC). This guide covers essential aspects of SAC, including its features, capabilities, and best practices. SAP Analytics Cloud is a comprehensive cloud platform designed to combine business intelligence, planning, and predictive analytics in a single solution. It empowers organizations to make data-driven decisions through advanced data visualization, interactive dashboards, and robust analytical tools. Whether you're a seasoned professional or new to SAC, this guide will help you understand the fundamentals and prepare for effective use of the platform.

Questions:

1). What is SAC?

A cloud-based analytics tool by SAP for data analysis, visualization, and decision-making.

SAP analytics cloud is end-to-end cloud solution offered by SAP that integrates Business Intelligence , Planning, Augmented analytics, predictive analytics in a unified platform to make effective decision on organization's data. Basically, a SaaS that combines all analytical capability in a single product for all its users

2). What is the purpose of SAC?

It enables users to access and analyze data from various sources, create interactive dashboards and reports, conduct predictive analytics, and collaborate on insights

3). What is Model in SAC?

 "Model" refers to the structured representation of data that is imported or connected to SAC for analysis, visualization, and reporting purposes.

It includes the data schema, dimensions, measures, and relationships necessary for analyzing and visualizing the data effectively within SAC.

4). Types of Model?

Live Data Connection :

model establishes a direct connection to an external data source, such as SAP HANA, SAP BW, or other databases. It allows SAC to query and analyze data in real-time without importing it into SAC.

Imported Data Model :

 type of model, data is imported from external sources into SAC and stored within the SAC environment. This allows for offline analysis and provides more flexibility in data manipulation and modeling within SAC.

5). Briefly describe stories in SAP Analytics Cloud

Combine visualizations, charts, and text to communicate insights derived from data analysis.

6).In SAP Analytics Cloud, what is the role of predictive analytics?

Predictive analytics allows for predicting future trends by analyzing present and past data. We can uncover valuable insights from the given data by applying robust predictive models. We can also discover relationships between different data with the support of predictive models.

7). Name the vital components of an SAP Analytics Cloud.

Digital Boardroom

Analytic applications

Stories

MS Office integration

Enterprise Planning

Business Intelligence

Platform Services

Augmented Analytics

8).What do you understand by digital boardroom in SAP Analytics Cloud?

A single presentation in the SAP analytics cloud combines multiple stories. hey give an overview of a business with summaries of different sections in one place.

9).List the various data modeling applied in SAP Analytics Cloud.

Relational Data Modeling

E-R Data Modeling

Dimensional Data Modeling

10). How is smart prediction performed in SAP Analytics Cloud?

 Smart prediction is made with the help of SAP Machine Learning algorithms. The ML algorithms dig out the relationships between different data and build a formula known as a predictive scenario. We use this formula to predict future trends.'

Three predictive scenarios: regression, classification, and times series

11). How is SAP Analytics Cloud advantageous to Tableau?

SAP Analytics Cloud offers better connectivity than Tableau.

Pricing is better for SAP Analytics Cloud than Tableau

Upgrades are challenging in Tableau

SAP Analytics Cloud provides robust BI models to generate effective reports.

12). What is Smart Predict

Smart Predict uses SAP machine learning algorithms to explore relationships in your dataset and build a formula – a Predictive Scenario – to predict future events or trends

13). What is  Smart Insights

With Smart Insights features, business users uncover critical hidden insights from data previously unseen.

 14). What is Smart Discovery

Smart Discovery gives an overview of your data by automatically building charts to begin discovering more about your data.

15). What is Search to insights

“Search to Insight” is one such feature that brings conversational AI to SAP Analytics Cloud wherein you can create a story by asking questions in natural language.

16). What are dimensions in SAC?

dimensions are attributes that provide context and structure to your data. They typically represent qualitative data, such as product names, customer

17). What are Measures in SAC?

Measures are numerical values representing quantitative data that can be analyzed, aggregated, and compared.

18.) What are the different types of Charts?

In SAP Analytics Cloud, there are various types of charts available for visualizing data. Some common types include:

**Column Chart**: Represents data using vertical bars, suitable for comparing values across categories.

**Bar Chart**: Similar to column charts but with horizontal bars, useful for comparing values within categories.

**Line Chart**: Displays data as points connected by lines, suitable for showing trends over time or continuous data.

**Area Chart**: Similar to line charts but with the area below the lines filled, emphasizing the magnitude of values over time.

**Pie Chart**: Shows data as slices of a circular pie, useful for displaying proportions or percentages of a whole.

**Donut Chart**: Similar to pie charts but with a hole in the center, allowing for multiple series comparison.

**Combo Chart**: Combines different chart types (e.g., columns and lines) in a single chart, useful for comparing different data types simultaneously.

**Scatter Plot**: Represents individual data points on a two-dimensional plane, useful for identifying relationships or correlations between variables.

**Bubble Chart**: Similar to scatter plots but with bubbles of varying sizes representing additional data dimensions.

**Treemap**: Displays hierarchical data as nested rectangles, with the size of each rectangle representing a measure.

**Heat Map**: Represents data using colors in a matrix format, useful for highlighting patterns or trends in large datasets.

19). What are the types of filters in SAC?

In SAP Analytics Cloud (SAC), there are several types of filters that users can apply to analyze data:

Story, page, widgets

**Dimension Filters**: Allow users to filter data based on specific values or ranges within dimensions, such as product categories, regions, or time periods.

**Measure Filters**: Enable users to filter data based on specific numerical values or ranges within measures, such as sales revenue, quantities sold, or profit margins.

**Time Filters**: Specifically designed for filtering data based on time-related dimensions, such as dates, months, quarters, or years. Users can apply time filters to analyze data within specific time periods.

**Input Controls**: Provide interactive filtering options, such as dropdown lists, checkboxes, or sliders, allowing users to select specific values or ranges dynamically.

**Page Filters**: Allow users to create multiple pages within a story or report, each with its set of filters applied to analyze data from different perspectives.

**Rank Filters**: Enable users to filter data based on ranked values, such as top or bottom performers within a dataset.

**Advanced Filters**: Provide more complex filtering options, allowing users to create custom filter conditions using expressions or formulas.

These filters help users customize their data analysis and focus on relevant information based on their specific requirements.

20). What are the different types of pages in SAC?

Responsive, Canvas, Grid, and From Smart Discovery pages

21). What is Linked Analysis:

Linked Analysis in SAP Analytics Cloud (SAC) refers to the capability to create relationships between different visualizations or elements within a story or report. It allows users to interactively explore data across multiple charts, tables, or other visualizations by establishing connections between them.

22). What is Threshold?

A threshold is a predefined limit used to highlight certain conditions they provide visual cues to users for better interpretation and analysis of data in SAC visualizations.

23).What is Geo Map and its types?

 "Geo Map" is a visualization tool that displays geographical data on a map.

Bubble

Choropleth

Heatmap

Flow map

24). Difference between Model and Dataset

25).What are public dimensions?

Public dimensions are stand-alone entities that are created independently and can be shared among multiple models.

26). Two types of model:

Analytic and Planning

26).  What is Planning?

SAC Planning is solution offered by SAP to streamline the planning process, budget and forecasting. It integrates both financial and operational planning along with business intelligence to provide a unified platform for effective business decision making.

27). How do we start with planning activities in SAC?

Firstly, we create any public dimension if we require in our planning purposes. Define the hierarchy and load the data into them. Then, we create model and add these public dimensions, along with Account dimension and load the data to it. Once this is set we can build a story and use this model to create our planning story.

28). What is unbooked data?

Unbooked data is a feature in SAC which shows the cells that contain blank values which can be used for planning. there is no corresponding transactional data for a field.

29).What is Data Lock in SAC?

prevents changes to specific data at different stage of the planning process

The option to lock the cell so that others when collaborated do not edit that particular cell. Right-click data lock.

30). How to maintain currency table in SAC.

In the modeling section, we have currency conversion tab, where we can import the data.

31).What is public dimension?

Stand-alone entities that are created independently and can be shared among multiple models.

Public dimension is entity that can be created by the user which is independent of a model. This can be used in any model

32). What is Allocation?

Allocation is process of splitting the derived source values into multiple values and storing values in the target data. Allocation is used in planning and data analysis to gain insights.

Spreading : values of source cell are spread across the leaf members . Values taken from higher level of hierarchy to lower level

Distributing : Distribution is another type of allocation that changes values within a hierarchy by distributing amounts from a source member to leaf members of its siblings

Assigning: you can append or overwrite target cells without specifying a source cell

33). What is variance

Original Budget

Revised Budget

Actual

Planning variance = Original Budget - Revised Budget

Operational Variance = Revised - Actual

34).  What is Data Action

Data actions are a flexible planning tool for making structured changes to

model data, including copying data from one model to another

35). What is Value driver tree

A value diver tree is a what-if simulation that enables end users to simulate

the outcome of their decisions

SAP Analytics Cloud 

[RajuRam]

Hi DheerajHJ,

Your SAC Interview Questions (Basic) is very useful for SAC job seekers. However, it would be better to post this content in the Blog section, as that is the right place where community members usually search for such material. If it is posted in the Q&A section, many people may not be able to find it easily, and also the Q&A section is meant only for questions and answers, not for articles.

By posting it in the Blog section, you will also gain more visibility and improve your community rank faster.