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: 
kousik
Explorer
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.

Data Visualization using Power BI


 

Get Data


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


Customers XML


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


 

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 Modelling



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 Visualization (Sales Orders Storytelling)


 

Data Visualization using Tableau


Data Visualization Using Tableau


Netflix Listings (Publicly available data)


Netflix Listings


Popular Genres from 2010 to 2019


Popular Genres from 2010 to 2019


 

Count of Listings by Country


Count of Listings by Country from 2010 - 2019


Profiles of Netflix Movies Listings Dashboard


Profiles of Movies added 2010-2019



Creating and sharing a story



Netflix Listings Story


 

Story 1: What genres are popular


Popular Genres from 2010-2019


 

Story 2: Which profiles of movies are added


Profiles of Movies added 2010-2019


 

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,
Labels in this area