Easily Drill Down into Your Geodata with Galigeo for Lumira

Hi all,

Galigeo for Lumira is back in a fresh new version, introducing a new feature that might be of interest to many of you.

Whether you are already using Galigeo for Lumira or not, you can find the latest version on the SAP Analytics Market Place.

EDIT, 07th July 2016 : with the release of Galigeo For Lumira 2.0, the drill-down/drill-up feature presented below has been improved. Find more details about it right here…

…or see it live right now!

What is this new feature about?

That’s right, you’ve got it…the title of this blog post says it all. We have decided to call it Smart Drill Down (or more generally speaking, Smart Drill), firstly because it will allow anyone to drill up or down on the layers on the map, and secondly because it does not need any configuration from the user in order to take effect. There is also no need to define a hierarchy in Lumira and it will work with any custom or default data.

To demonstrate how it works, let’s look at a real world example.

We’ll put ourselves in the shoes of a drinks manufacturing company.

This company has an abundance of data about the pubs and restaurants delivering its products, such as how many products are delivered each week, net income, turnover, … like any company that uses Lumira, I suppose.

Please note that the following example derives from a real case study from one of our clients but the data values have been modified for the sake of this example.

Well, let’s get started!

I want to display a potential turnover over for Paris, France. I have several layers for it.

• The first one is made of polygons that display sectors. It’s technical sectors, mostly related to sales.
• The second one is also made of polygons that display subsectors, also called subareas. Each sector from the first layer contains several subsectors.
• The third layer is made of points, and represents the pubs/restaurants where the company is delivering fresh products.

With the previous version of Galigeo For Lumira, if I’d chosen a single indicator (Potential Turnover in K€) and then dropped the three layers into the Geolayers input, this is what I would have so far.

It already provides good insights for sure but there are several drawbacks :

• The layers are all displayed at the same time by default.
• I have no way to emulate drill up or drill down onto the layers.

I would therefore have to manually filter the data, manually hide/show my layers in order to explore my data – a process that can be quite lengthy when you have a lot of data.

Now, let’s see what the new Galigeo for Lumira version does when I configure my Indicator and my Geolayers dropboxes in the same way.

Interesting enough, this time, only the top layer is displayed, and there is an additional icon on the top left of the map.

This icon allows me perform two actions : drill up and drill down.

Let’s have a go.

If I click on the drill down button, when hovering a sector on the map, it’s outlined in red.

Let’s click on the sector which has the highest turnover potential.

Magic?!

The sector layer has been drilled down and now only the subsectors of the drilled sector are displayed.

With Drill Down still enabled, I’ll click again on the subsector which has the highest potential turnover.

Same effect, the subsector has been drilled down, and now only the pubs/restaurants that geographically belong to the drilled subsector are being shown.

The bubbles representation is giving me a a clear idea of which pubs/restaurants have the highest potential turnover.

The drill up button has, as you might expect, an inverted effect. If I click on it, it will drill up from the pubs/restaurants layer to the subsectors layer.

You might notice that the filter on the subsectors layer, that was made when drilling down from sectors to subsectors, is still active, which is handy to keep exploring with other subsectors from the initially selected sector.

That’s pretty much it.

Yeah, it’s that simple.

No configuration needed, that drill hierarchy can take as many layers as are necessary.

For example, it could be Country > Regions > SubRegions > Custom Subregion > POI and it would still work.

The few, basic prerequisites are as follows :

• The first layer of the hierarchy has to display a polygon
• At least two layers must share the same indicator (but by experience, this is usually the case anyway as they all share the same indicator)

Really excited or still not convinced?

Download the Galigeo for Lumira extension (if you haven’t already done so), and take it for a test drive! You can download the Galigeo for Lumira extension for free at http://www.galigeo.com/products-overiew/location-intelligence-products/sap-lumira. As always any feedback or ideas you may have are more than welcome.

Please note that Galigeo for Lumira is coming soon for Lumira Server for BI Platform.

Cheers,

Vincent