Skip to Content
Author's profile photo Harshil Joshi

Data Geek Challenge – Customer Sales/Regional Sales

Dear All,

Here I am submitting my entry with SAP Lumira Data Geek Challenge. In this submission I have focused on regular MIS reporting/analytics which can be developed by any executive/manager without any IT help, that’s what SAP Lumira is designed for.

Subject: Customer Sales Analysis & Regional Sales Analysis

/wp-content/uploads/2013/08/customer_analysis_260091.jpg/wp-content/uploads/2013/08/regional_analysis_260095.jpg

Purpose: To identify Customers’ Sales, Top/Bottom Customers, Growing Region, Region Performance, Regional Sales etc.

Covered KPIs: Gross Sales Value, Returns Value, Net Sales Value, Gross Profit

Covered Dimensions: Customer, (Customer Code), Country, City, Region, Sub-region etc.

Data Preparation:

data.PNG

SAP Lumira Development:

As it is generally all management want regular customer sales analysis report,which shows customer wise gross sales, returns,net sales etc.

customer_sales_repo.PNG

top_25.PNG

gp.PNG

region.PNG

For more you can find



Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice posting...

      Author's profile photo giuseppe caselli
      giuseppe caselli

      Interesting

      Author's profile photo Former Member
      Former Member

      Hi Harshil,

      Nice blog, keep sharing

      Regards

      Hari Suseelan