Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kajal_Jamadar
Discoverer
405

Introduction

SAP Analytics Cloud is an end-to-end cloud solution that brings together business intelligence, augmented analytics, predictive analytics, and enterprise planning in a single system. There are two ways to retrieve the data from backend to SAC. Either we can retrieve the data from excel or from sap system. In this blog will see how to get data from excel to SAC.

What is the advantage of SAP Analytical Cloud?

The main benefits of SAP Analytics Cloud include ease of viewing content, access to various visualization tools, augmented analytic capabilities, financial planning features, and access to trusted data by integrating with other SAP products. In a single cloud system, you can analyze, predict, plan, and report.

1. Once you login to SAC click on create your story.

Kajal_Jamadar_0-1738672681434.png

2. Then click on Responsive.

Kajal_Jamadar_1-1738672681443.png

3. Once you click on Responsive you can see below screen. It will ask you what design mode do you like to use for your dashboard. Nowadays Classic Design Experience are being phased out so it's good practice to use Optimized Design Experience. Then click on create.

Kajal_Jamadar_2-1738672681448.png

4. Click on More  >>  Add New Data  >>  Add New Data

Kajal_Jamadar_3-1738672681454.png

Kajal_Jamadar_4-1738672681462.png

5. Click on Data uploaded from file.

Kajal_Jamadar_5-1738672681474.png

6. Click on Select Source File. Once you click on it screen will redirect to your system . There you can select your excel file.

Kajal_Jamadar_6-1738672681482.png

In our example I have created dummy bank data.

Kajal_Jamadar_7-1738672681488.png

7. Once you select file from the system then click on import. Here you can see that we have option called Use first row as column header. If you have column headings in your excel then check the checkbox if no then remove the check.

Kajal_Jamadar_8-1738672681499.png

After clicking on import your excel data will start to import in SAC.

Kajal_Jamadar_9-1738672681506.png

Once the data import is done successfully you can see below screen. Using Measures and Dimensions we apply our logic.

Kajal_Jamadar_10-1738672681513.png

8. In our case I want to see how much amount bank has given in each city.  Click on the cube which appears beside the City dimension.

Kajal_Jamadar_11-1738672681527.png

9. Here we can see count of back accounts which has been created in each city. Now click on Exit Data Preparation in top right corner.

Kajal_Jamadar_12-1738672681553.png

10. Then below screen will appear.

  • Under Currently Selected Chart option we can find options like Bar/Column, Line, Stacked area, Donut, Bullet pia etc.  Based on our requirement we can select any one of them for visualization. Here I have selected Pie Chart.
  • And as I mentioned above (point 😎 that I want to see how much amount bank has given in each city that is the reason Amount is selected as Measures here.
  • We can select the color also.
  • Once all the inputs are done then click on save in top right corner.

Kajal_Jamadar_13-1738672681558.png

11. Give your dashboard name and save.

Kajal_Jamadar_14-1738672681562.png

After saving it will appear under stories folder. From there you can access and see it.

Kajal_Jamadar_15-1738672681570.png

Kajal_Jamadar_16-1738672681575.png

 

 

 

Labels in this area