Skip to Content
Author's profile photo Sara G Ayer

Data Geek Challenge – Sales in a Company

Here I come up with my cooked up sales data for a Company.

This is my 3 years data in Excel, divided on product-city basis, for the measures quantity sold and revenue.

excelview.PNG
Here is how my data looks in Lumira
VIdata.PNGVIdata1.PNG

Capture.PNG

QTY comp.PNG

revenue.PNGcloud.PNGrevenue.PNGmap.PNGradar.PNG

stacked Area.PNGstacked column.PNG

The Table View 🙂
Cool thing in here is that, I just had the City name in my data, it automatically gave me the Country and region names.

table.PNGtable2.PNGrank.PNGBox.PNGCapture.PNG
tree.PNGtrellis.PNGwaterfall.PNGline.PNGcity comparison.PNGcombi.PNGHeat.PNGpie.PNG

I ve used almost every chart available in Lumira.

I ve written a couple of blogs on the functionalists available in Lumira, which we usually skip while working with Lumira, so here are they,

http://scn.sap.com/community/lumira/blog/2013/05/16/3-simple-steps-for-calculating-moving-average-in-visual-intelligence
http://scn.sap.com/community/lumira/blog/2013/06/01/calculations-trellis-chart-in-visual-intelligence

It indeed is an easy and self learning tool.

The KT for this post is given here.

http://scn.sap.com/docs/DOC-45531

Hoping it will be helpful to some extent.

Assigned Tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      Hi Sara,

      Great analysis.

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Jitendra   🙂

      Author's profile photo Former Member
      Former Member

      Good one !!

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Nethaji  🙂

      Author's profile photo Former Member
      Former Member

      Hi Sara,

      good analysis with fact and figure.

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Akhilesh 🙂

      Author's profile photo Former Member
      Former Member

      Sara

      Simple and Nice analysis...Good

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Durga Prasad  🙂

      Author's profile photo Shankar Choudary
      Shankar Choudary

      Hi Sara,

      Nice analysis with Sales data for a company with latest tool(SAP - Lumira)

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Ravi Shankar 🙂

      Author's profile photo Former Member
      Former Member

      Good Analysis....

      Best Regards,

      Naresh K.

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Naresh

      BR,

      Sara

      Author's profile photo Former Member
      Former Member

      Hello Sara

      This is very informatics and knowledgeable. Your hard work for different countries analysis showing very interesting with the help of SAP Lumira technology. Thanks for sharing and please keep it up.

      Wishing you good luck!

      Arshiyan

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thanks Arshiyan -

      Its very easy to do, looking forward for your blog-post too.

      Regards,

      Sara

      Author's profile photo Former Member
      Former Member

      Hi Sara

      Thanks for motivate me, Now I shall try.

      Take care

      Arshiyan

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Hi Arshiyan -

      I've mentioned the way to do it in the bottom of the page, Do have a look and try the same.

      Happy Learning 🙂

      BR,

      Sara

      Author's profile photo Former Member
      Former Member

      good analysis Sara..thanks for sharing..

      Cheers!!

      Durga

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Durgamadhab

      You can check the link given in the bottom of the blog and write your own blog like this.

      BR,

      Sara

      Author's profile photo Former Member
      Former Member

      Good Analysis Done Sara G

      Regards,

      J.Sakthikumar

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank you Sakthikumar

      BR,

      Sara

      Author's profile photo Chandra Shekhar Agarwal
      Chandra Shekhar Agarwal

      Great analysis Sara.. 🙂

      Can see your effort ..

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Thank You  Chandra Shekhar

      BR,

      Sara

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Nice one Sara. A sample of all charts that can be used. I went through your other blogs too and got some real insight.I have a question,

      When I load a Excel file, all my measure are loaded as attributes and they do not appear in the 'enrich' option. Is there any manual way to enrich this data? (Converting the file to csv and loading helps though)

      Benedict

      Author's profile photo Sara G Ayer
      Sara G Ayer
      Blog Post Author

      Hi Benedict Venmani Felix ,

      Yeah there is a way, do a right click and you ll see an option convert to number. Do that and It ll be then enriched.

      Else make sure you have everything in that column in number format (you can check that in excel). So even if one of your values are in alphabet or any other format, it takes it as attribute. This way is good but Am scared you might have to redo the process from choosing the source data.

      Let me know how it worked.

      BR,

      Sara

      Author's profile photo Former Member
      Former Member

      Hi Sara,

      Good Day!

      Nice analysis! I appreciate.

      Lovely analysis ! 😘

      I liked this analysis very very much! Keep rocking!

      Keep sharing new things. Have a nice day! 🙂

      Regards,

      Hari Suseelan