Recently I downloaded the latest release of Visual Intelligence from SAP. It has some very nice features, but few are as cool as the ability to add a Geographic hierarchy based on Latitude & Longitude. Here's a use case where this makes sense:
Say that you have some data, maybe sales by Regional VP. Each VP manages a region, say North, South, East, West, EMEA and APJ. You'd like to see these sales on a map, but most maps don't know where to place "East". With the new release of Visual Intelligence fixing this is a snap. I created a step-by-step model to show you how to do it.
First, let's understand the data. I created a very simple sample data set using Microsoft Excel (call it Lat_Long_Test.xls).
Note - to get to this data, I simply used Excel's RANDBETWEEN() function. Fpr the dates, I seeded the first rown and then I added random numbers between -120 & 120 to the date in the previous row. I used a random number between 1 & 6 for the regions and picked a random number between 1234 and 23456 for the sales. This is just an easy way to create a lot of data. You'll get random patterns in your data so if you want to test out real timeseries patterns, you'll need to think up another data generation strategy.
To get the latitude and longitude of the regional office, I simply picked a hypothetical office location and found it's Latitude and Longitude:
I created a simple lookup table to assign the East, West...region names, because when I join the data in Visi, I'll want to join on Region=Region_Name. I could have easily just put the region number in the second table and joined on that. Then the fun begins:
Where you go from here is up to you. You could roll the Regional Hierarchies into more generic geographic hierarchies. You could make the rollups more drill-able. You could create multiple custom geo rollups - the sky's the kimit. This is clearly just a quick and dirty example of what you can do with the new Latitude & Longitude functionality in SAP Visual Intelligence, but I hope that these detailed instructions might make it a little easier for you to give this a try on your own - with your own REAL DATA!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
42 | |
25 | |
17 | |
14 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 |