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.
Here is how my data looks in Lumira
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.
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.
Hi Sara,
Great analysis.
Thanks Jitendra 🙂
Good one !!
Thank you Nethaji 🙂
Hi Sara,
good analysis with fact and figure.
Thanks Akhilesh 🙂
Sara
Simple and Nice analysis...Good
Thank you Durga Prasad 🙂
Hi Sara,
Nice analysis with Sales data for a company with latest tool(SAP - Lumira)
Thank you Ravi Shankar 🙂
Good Analysis....
Best Regards,
Naresh K.
Thank you Naresh
BR,
Sara
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
Thanks Arshiyan -
Its very easy to do, looking forward for your blog-post too.
Regards,
Sara
Hi Sara
Thanks for motivate me, Now I shall try.
Take care
Arshiyan
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
good analysis Sara..thanks for sharing..
Cheers!!
Durga
Thank you Durgamadhab
You can check the link given in the bottom of the blog and write your own blog like this.
BR,
Sara
Good Analysis Done Sara G
Regards,
J.Sakthikumar
Thank you Sakthikumar
BR,
Sara
Great analysis Sara.. 🙂
Can see your effort ..
Thank You Chandra Shekhar
BR,
Sara
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
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
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