Skip to Content

Hi,

I would like to share my first Sales Overview reports developed using SAP’s new reporting tool  “SAP Visual Intelligence” and its functionality/features.

In order to start developing new reports, go to File menu and select new

Image1.png

Choose source for your report you are going to develop. Using SAP Visual Intelligence you can build reports using data in HANA, CSV , Excel files, SQL e.t.c.  For our demonstration we are using sample excel file “BestRunCorp_Retail.xlsx” provided by SAP in Visual Intelligence trial version.

Image2.png

In the below window, we have options to set first row as column names and to show hidden columns/rows in the source file. Select Acquire button to continue

Image3.png

Initially it displays data view as shown in the below screenshot. You can also merge other data sets from different source by selecting merge button.

Image4.png

You can switch to Split view or Visualize view. Split View gives both data and visualize view. In visualize view you can view your data using different graphs/charts provided by SAP VI.

Image5.png

Select Visualize view for our demonstration. Select required KPI’s for reporting purposes and create measures from context menu. In our example we are using Sales Revenue, Sales Quantity, Discount, Gross Margin and Number for issues reported by customer.

Now drag measures to Y axis and select ‘Rank Values’ to give top 10 sales revenue by manager(x axis).

Image6.png

Image7.png

Image8.png

You can also sort and do calculations based on your requirements

Image9.png

Different Sales Overview reports developed using SAP Visual  Intelligence

Image10.png

Image11.png

Image12.png

Image13.png

Image14.png

Image15.png

Issues reported by customers by Region and Quarter

Image16.png

Image17.png

Drill down by state

Image18.png

Based on my hands-on, I would strongly recommend this tool to utilize for developing  adhoc reports. Business users can easily understand SAP Visual Intelligence tool and develop reports for their day to day adhoc reporting needs without depending on IT.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Rafael Soares

    Hi Uday.

    I am new in SAP Visual Intelligence and I would like to know the big difference between SAP Visual Intelligence and Web Intelligence.

    Thanks!

    Rafael

    (0) 

Leave a Reply