Skip to Content
Technical Articles
Author's profile photo Kousik Mukherjee

Data Visualization simplified for SAP Data Consultant

Searching for latest Technology trends will fetch you “Data Visualization”, as one of the latest trends. Why Data Visualization? In simple terms Data Visualization is visual representation of data. It is the key element and important stepping stone for Data Driven Decision Making (DDDM). Data driven decision making (or DDDM) is the process of making organizational decisions based on actual data rather than intuition or observation alone. Every industry today aims to be data-driven. There is an old saying which goes as “There‘s Gold in Those Hidden Data Sources”. If data is visualyzed properly, it can bring valuable Businness Insights leading to enourmous progression and competitive edge for organizations.

In this blog post we will walk through rather simple ways of Data preparation, relationships, and reporting using Microsoft Power BI. Now most of us are using Microsoft Office everyday and very much familiar with office products. Power BI is a part of Power Apps and easily downloadable as Power BI Desktop. The Reports created in Power BI Desktop can easily be published as online reports to Power Bi Service (https://app.powerbi.com).

For this blog post, I have used data sources which I have extracted as excel sheets and XML files from SAP ECC, as this blog post is not related to integration, but this does not restrict you from connecting directly to SAP systems from Power BI.

Get%20Data

 

Get Data

Now lets try to build some meanng business insights form the Customers data of an organization. The Customers data has been extracted as XML format from SAP ECC.

Customers%20XML

Customers XML

This data can be easily uploaded to Power BI desktop as below and viewed in Power BI Data view.

Customers%20Data%20View

 

Customers Data View

And now comes the most interesting part. The data is transformed accordingly and visualized as Reports in Power BI Report View. The report serves as Storytelling which brings out valuable business insights.

Data Visualization (Customers Segment Storytelling)

Data modelling is also possible where relationships can be created. The good part is that data can remain in separate tables as it is and through relationships they can be combined into one Data Set.

 

Data%20Modelling

Data Modelling

Manage%20Relationships

Manage Relationships

We can bring out many meaningful insights through relationships between tables and data modelling.

Data Visualization (Product Sales Storytelling)

 

Data Visualization (Annual Sales Storytelling)

 

Data%20Visualization%20%28Sales%20Orders%20Storytelling%29

Data Visualization (Sales Orders Storytelling)

 

Conclusion: Data Visualization is a tactics for Storytelling through which we can portray business insights are extremely important and useful for data-based decision making for organizations in todays context. SAP Data Consultants and Data Analysts and perform these tasks easily by using Power BI.

 

Please read through my other blog posts.

Mapping different domains in SAP Master Data Governance to SAP S/4HANA processes | SAP Blogs

Understanding SAP MDG in a Traditional way | SAP Blogs

Using SAP BTP for Master Data Governance with Fiori Tiles | SAP Blogs

Simple steps to start RISE with SAP S/4HANA Cloud | SAP Blogs

Demystifying One Domain Model w.r.t Master Data Objects | SAP Blogs

Data Journey from SAP MDM to SAP MDG | SAP Blogs

Exposing master data as ODATA service from S/4 HANA on-premise | SAP Blogs

A Simple illustration for SAP Data & Analytics | SAP Blogs

Understanding basics of SAP Master Data Integration and Orchestration

 

Best Regards,

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.