Hi,
When I first saw SAP VI data geek challenge I said what is SAP VI? Hmm . A new SAP software for analytics. Of course I downloaded trial version and tried to use software. But it didn't worked at first :sad: We found the reason after some forum discussions. I've created a simple SAP VI user guide (you can download my user guide from this link) and done some visualizations.
First of All, I should say this tool is really for business users. There is nothing for coding or customizing for a typical SAP IT expert :smile:
It has click by click visualization options.
I selected provided workforce distribution data set. What a nice values :smile: And I started some investigations on data set.
A. Let’s have a look Names And Phones. Do you think there are repeating data in our data sheet? Of course :smile: We should clean data with SAP VI easily to make correct analyzing.
First of all we need to clarify relations in data. Eg:We filter Diego sanchez. We have 11 Diego. It seems Phone& Date of Birth& Address are same with specific Diego Sanchez. Hmm :smile:
Conclusion:
“Looking to Facets, ordering and filtering data Hmmm. We can say some measures or attributes (cost center,pay scale,annual salary etc) are being changed and employee having a new number , a new hire date and being added as a new line to the list yearly. But in Any Case we know some Diego’s are same.”
Of course I checked and checked the data more times. Then I had below lessons for any kind of analyzing and reporting.
After understanding relation in data. I can say here my one sample analysis total employee based on Occupations by Hire Year
I didn't sort years in x-axis. Also this is not the key analysis of world :smile: You can have millions of analysis with this data set. You can download my sample svid file from this link.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |