Custom calculations in dashboards have arrived!

Posted on August 15, 2014 by Rebecca Morris

Reply

We just released another set of updates for you in our August release... there's one in particular that we think you'll be thrilled about!

Have you ever wanted to display a ratio in your dashboard based on 2 fields from your dataset, e.g. Loss Ratio = Gross AAL / Premium? Have you ever wanted to display the sum of multiple fields, e.g. TIV = Coverage A + Coverage B + Coverage C + Coverage D?

In response to your feedback, you now have flexibility to create custom calculations in your dashboard by combining different metrics within your data. With this new feature, there is no longer a need to calculate derivative metrics, like ratios, summations, differences, etc., outside of SpatialKey.

You can now create your own equation using any metric fields in your dataset and analyze this value-added data in maps and visualization pods.

It's simple - just use our wizard for define your calculations...

advanced_calculations_setup2

...and visualize! Advanced calculations work in most visualization pods, and can also be a powerful way to visualize your data on the map.

Screen Shot 2014-08-15 at 2.32.59 PM

We hope you enjoy the flexibility and analytic value this new feature delivers. Don't forget to check out the rest of the features in the August release as well.

Posted in Insurance, Releases, Analytics, Data visualization | Leave a reply

We are on a roll in 2014, see what's new!

Posted on March 21, 2014 by Rebecca Morris

Reply

March 2014 brings the third SpatialKey release of the year! We've added a new app, improved a few of our existing app offerings, and spent time refining the design of the core product. We can't promise continued new release every month, but we're on a roll so far in 2014.

New Accumulations app with Grid model

accumulations-iconThe much awaited Accumulations app is here! Visualize your top accumulations based on pre-defined or custom grid accumulation scenarios. For example, you can find where you have the most risk within any 500 x 500 meter square.

To see the app in action, check out the demo video below.

Select any exposure to analyze with the Grid model - whether it's single country or worldwide exposure. Then select from a predefined grid scenario or customize your own.

Screen Shot 2014-03-18 at 11.47.57 AM

Customize the extent in which the analysis will run as an optional step, or just analyze your entire dataset.

Screen Shot 2014-03-18 at 11.48.42 AM

Once your analysis completes, enter the dashboard to visualize the top accumulations.

Screen Shot 2014-03-17 at 1.16.56 PM

Drill into a specific accumulation to understand exposure concentrations and add analytical pods to enhance your analysis.

Screen Shot 2014-03-17 at 1.25.36 PM

The Grid model is the first of many models we plan to roll out and we are excited to get your feedback. Terror rings and peril-specific event models will be added to the app over time. If you are interested in licensing the Grid model with the Accumulation app, please contact us.

Flood Underwriting updates

Our Flood Underwriting app ships with newly designed PDF reports that are cleaner and clearer than the previous versions. In response to user feedback we've also improved usability by adding a quick link to jump you to a specific risk in Map Analyst, and we've added latitude/longitude lookups to complement address searches.

New Flood Underwriting PDFs

Screen Shot 2014-03-19 at 2.51.55 PM

Quick Map Analyst link

Screen Shot 2014-03-19 at 12.35.04 PM

Latitude/longitude lookups
Sometimes geocoding results aren't 100% reliable. To help get around this, SpatialKey now provides the ability to enter latitude and longitude coordinates so you have added confidence in the flood risk lookup result.

Screen Shot 2014-03-18 at 4.38.33 PM

If you don't already license Flood Underwriting and would like to learn more, contact us.

Enhancements to the Hail app

The Hail app was first released last September as the 2013 hail season was dying down. Now as we enter the 2014 season we've released an update to the Hail app. We've improved the launch process as well as filtering within the app. We've added the ability to name your analysis, which will be helpful when you come back to the app to select from previously run analyses.

Screen Shot 2014-03-19 at 8.59.02 AM

And within the Hail app we've added quick controls so you can toggle filtering on and off and easily filter by hail size.

hail

Dashboard sharing

Collaboratively sharing your saved SpatialKey dashboards with your colleagues is one of the most powerful features we offer. We've improved the sharing process by providing better visibility into exactly who within your organization can view saved dashboards. Dashboard sharing is driven by dataset permissions, so the new sharing screen makes it easier to see exactly who has the proper data access that's required.

Screen Shot 2014-03-21 at 1.58.06 PM

The key thing to remember about sharing a dashboard is that in order for a user to view a dashboard, they must have permissions to view the underlying datasets.

Header look and feel updates

As part of our constant design refinement we've refreshed the header and menu items. These changes are rather small, but show our commitment in making the SpatialKey interface as easy to use and visually enjoyable as possible. One item to highlight on the home screen is that the logout option was moved into the username drop down.

Screen Shot 2014-03-18 at 4.49.30 PM

In the dashboards, you'll notice a dedicated sharing option in the header as well as a new camera button. Those options will help you to share the dashboard within SpatialKey and capture screen shots to share with others.

Screen Shot 2014-03-18 at 4.54.42 PM

We hope you enjoy these updates and new apps. As always, if you are interested in learning more or have any questions, contact us.

Posted in Releases | Leave a reply

SpatialKey February 2014 Release

Posted on February 28, 2014 by Rebecca Morris

Reply

Quick on the heels of last month’s update, we have a new February release that adds a few requested features and adds much needed support for our growing international customer base.

Global language and character support

This release focuses on supporting our international customers by allowing non-English characters in your data, dashboard names, and more. Any characters that can be displayed on your computer are now supported, such as Japanese Kanji or accents characters in French or Spanish.

sk_foreign_characters

We’ve put together a list of tips for the best way to import your data with full character support.

Manual control of point and shape colors

You can now set individual colors for points or shapes when coloring by a text field. First, select a text field in layer manager for your point dataset or shape dataset. In the example below, “occupancy”, which is text, was selected.

To manually set the different colors select the “Colors” tab and then click “Customize”.

Tile map layers

SpatialKey has previously supported WMS layers to allow you to add visual layers to your dashboards. We now support tile layers, which is a standard way to produce map layers used by companies like Google and MapBox.

Here is an example that you can interact with outside of SpatialKey to get a feel for tile map layers. This is a beautiful example that shows the world in watercolor.

Another cool example is to make the world wooden. Here’s how you set it up in SpatialKey. Click on the “+” icon in the layer manager and select the “Visual Map Layer” option. Then select “Tile Map Service”.

Enter the Tile Map Service URL and a label.

Here is the resulting tile map layer in SpatialKey.

Here are the URLs for a these examples so you can check them out:

  • Woodblock map – https://a.tiles.mapbox.com/v3/eleanor.mnyzxgvi/{z}/{c}/{r}.png
  • Watercolor map - http://c.tile.stamen.com/watercolor/{z}/{c}/{r}.jpg

Refresh option for dataset and dashboard lists

We found that sometimes our automatic refreshes of all lists in SpatialKey doesn’t occur quick enough and sometimes you just need a refreshed list immediately. To help with this, we added manual refresh options to dataset and dashboard lists in SpatialKey. This option is available on the Dashboards, Manage Data, and Data Mart tabs.

Improved launching of Data Mart items

For those of you who license the SpatialKey Data Mart and use it regularly, this feature will be a welcome surprise. After a dataset from the Data Mart completes importing into SpatialKey, you can directly launch it in Map Analyst without having to go back to the “Manage Data” tab and find it.

Posted in Releases | Leave a reply

SpatialKey January 2014 Release

Posted on January 16, 2014 by Rebecca Morris

Reply

We're eager to get our 2014 started! Based on your feedback, we have enhanced several features within SpatialKey as well as added new capability and a new application. We're hoping this release will enhance your experience with SpatialKey and add value to your operations. Check-out the scope of this release below...

SpatialKey Portfolio Composition application

For those of you that may not have seen the recent announcement of our new Portfolio Composition app, we wanted to tell you a bit about it. This application empowers you and your management team to stay on top of your portfolio's risk position and composition. You can quickly respond to patterns and trends in your exposure and loss data using purpose-built workflow and visualizations. This app can be accessed from your desktop or mobile device, so you can access these insights, anytime and anywhere.

Start with a high level summary of your portfolio metrics by peril. From this perspective, you can identify areas of concern that you want to explore further.

Visualize performance by lines, operating units, policy renewal dates and geography on the Business Summary screen. Adjust metrics and change pods to show custom dimensions to flexibly interrogate your portfolio.

Drill-in further to review risk composition in more detail on the Risk Summary screen. All applied filters work together across dashboard screens to help bring focus to your analysis.

With the Portfolio Composition app, everyone in your organization is looking at a consistent snapshot of your portfolio, helping you to standardize portfolio analysis and communication. To learn more, please take a look at the SpatialKey Portfolio Composition product sheet and demo video (below) for a quick orientation. Contact us if you are interested in learning more.

Configure national currency for reporting

Continuing in our effort to better support international data, we have added the ability to select your desired national currency for any data field with a currency data type. This will help SpatialKey display your data with the appropriate currency symbology in any SpatialKey dashboard, helping you clearly communicate reporting currency to others.

During import, select from a list of common national currencies or use the "advanced" option to customize the currency symbol or code for the selected column.

jan_release_currency_import

If you forget to set this up during import or want to adjust the currencies for datasets already imported into SpatialKey, edit the field in the advanced settings for a dataset.

jan_release_currency_modification

Improved data type detection and adjust numeric data types

Did you accidentally import your currencies as regular numbers? No problem, now you can adjust numeric data types post-import!

jan_release_currency_modification2

Also, field detection during import has been enhanced to better identify IDs and Date fields when the text "ID" or "Year" is identified in the field headers. This will help avoid data formatting issues downstream for these fields, e.g. IDs are best visualized as 123456 rather than 123,456.

Pod enhancements

In response to your feedback, we've added the option to show a column in the Unique Value List as a percentage representing percent of total, giving your clear insight into top contributors. In the pod below, 7.78% of the records in the dataset are in Charleston County.

jan_release_percent

While we were at it, we also made some updates to the Policy Exposed Limit pod. Now, you have the ability to view TIV and Location Count columns when grouping the results by different policy attributes. Note that if you have multiple policy layers covering the same locations, your TIV and location count may be overstated.

jan_release_pel_pod

Note that the Policy Exposed Limit feature must be enabled for your organization to use this pod. Contact us to learn more.

Support for CRESTA 2010 and 2013

We've expanded CRESTA support to include the 2010 and 2013 (low resolution) vintages. If your organization is interested in licensing global boundaries, please contact us or check out this article for additional details.

jan_release_cresta

Refreshed Map Tools

Our design team has been busy revisiting some existing SpatialKey tools to make things easier to use, cleaner, and more consistent. Elevation lookups, map markers, distance rulers, and custom shapes all got a refresh.

map_tools_jan_release

As much as we love shipping new features, we also place a priority on going back to focus on how we can improve the overall user experience through core areas of SpatialKey.

Recover and save closed dashboards

Focus on our core product has led us to another seemingly minor feature: saving dashboards. Have you ever closed a dashboard and then suddenly realized you forgot to save it? You can now re-open the dashboard for a brief period of time, giving you a chance to recover any work you may need to save. Simply click "re-open" to open the dashboard exactly as it was right before you closed.

jan_release_reopen_dash

We've also added some shortcut save options that appear when closing your dashboard. This allows you to easily ensure your work is saved before you exit out of the dashboard. Adding both the re-open and Close and Save features has allowed us to get rid of that big "You have unsaved changes" popup that has annoyed us all!

jan_release_close_menu

Better integration with SpatialKey

SpatialKey supports a variety of APIs to help our systems talk to your systems. Did you know that we even have a version of the Data Management API that doesn’t require any programming knowledge to use? Over the last few months, we have been hard at work behind the scenes to update our APIs, bringing you ultimate flexibility in managing data, enabling insurance features and launching SpatialKey via the API. For updated documentation and information on the new APIs, click here.

Posted in Insurance, Releases, Analytics | Leave a reply

What we did in 2013 - Year in Review

Posted on January 5, 2014 by Rebecca Morris

Reply

2013 was a productive year for SpatialKey! Taking a moment to pause and pull together this Year in Review gave us a full sense of the great things we accomplished. We want to thank all of our clients for their continued support and commitment to evolving the SpatialKey product suite. We thoroughly enjoyed working together to deliver more innovation.

Let’s carry this momentum forward to 2014!

Cheers,

- The SpatialKey Team


Before we dive into all of the great product enhancements, we wanted to share some of our higher level accomplishments this year.

After that, we will take a look at new apps and features, both big and small.

Finally, check out a sneak peek of the what's already happening in 2014.

Marketing & Partnerships

SpatialKey's web presence

Early in 2013, our website, support site, and blog got a facelift and were enhanced with better and targeted content. Feeding off of that momentum, we also created a suite of videos discussing the business application of the SpatialKey products and our culture of innovation. We are very proud of our compelling story as I'm sure you can tell.

Ecosystem

At SpatialKey, we believe you need choices and that innovation is borne by agile, customer-focused companies who are strategically committed to the pursuit of excellence in their core competencies. Which flood modeler best represents your view of risk and regional concentrations? What data warehousing solution provides the most up-to-date views of your business? Who knows the insurance business better than you? Working with specialist firms and your resident experts, SpatialKey is truly able to offer a best of breed solution for a seamless user experience!

We are fostering a collaborative and interoperable environment with leading technology platforms, content providers and client in-house systems. This ecosystem brings the best scientific and innovative thinking to the market and delivers seamless solutions and operating environments for your business-critical processes. Insurers can now leverage SpatialKey throughout the insurance lifecycle from product management, to underwriting, to exposure management, to claims adjudication.

To name a few, we have partnered with iPartners and Innovation Group to develop seamless integrations for our mutual clients; we have worked to serve up expert content from public data sources and commercial firms, like JBA Risk Management, KatRisk, GfK GeoMarketing and Willis Re; and we have co-developed numerous SpatialKey apps with Willis Re, Aspen, and RLI.

On top of the latest events

2013 proved to be a intense year of severe storm events with significant loss from the tornados in Oklahoma and Illinois. Flood also generated significant disruptions and loss across the globe, and many of our clients were able to quickly assess the extent of damage to events in the US, Canada, UK, and Central Europe.

Working closely with our content partners, we were able to get critical event information in the hands of our clients shortly following (and during) these events, enabling them to provide relief and aid to their customers.

SpatialKey Features and Apps

Hail app

The U.S. has been impacted by several devastating hail outbreaks this year. Our clients require a rich analytic solution to help them understand and respond to these events. As such, we built a flexible and extensible application platform that allows us to integrate hail data from leading content providers.

During the analysis process, each location is enhanced with the the relevant hail sizes that each was subject to. Once complete, the dashboard is launched and you can immediately visualize your impacted exposures in the context of the hail footprints. As with all SpatialKey applications, you can flexibly filter, segment, and visualize hazard data and any attributes within your location dataset to understand and quantify the impact of these events and help mobilize your response.

If you are interested in learning more about this app and licensing options, please contact our sales team.

Big impact features

Dashboard Templates

Do you import weekly, monthly, or quarterly data and find yourself creating a new dashboard for each dataset? SpatialKey’s new Dashboard Templates feature removes the tedium and frustration created by redundant report production processes and let’s you get straight to analysis. Now, you can create a dashboard once and reuse it as a template for multiple datasets without having to recreate the dashboard each time.

These templates help automate report production, so you can immediately interrogate and derive insights from a new data vintage, a derivative dataset, or any other dataset of similar content. If you want to learn more, check out this article.

Redesigned pods

In February, we unveiled our redesigned pods. Now nearly a year later, we hardly recognize the old SpatialKey in the image on the left below. We hope you are enjoying the new look and feel.

The new pods also came with powerful new features:

  • The Statistics Pod can now contain multiple stats in a single pod and can be oriented vertically or horizontally to optimize space in your dashboard.

  • The Unique Value List Pod received a couple of updates: Totals row and the ability to add multiple calculated and grouping columns to a single pod. We hope you've found this functionality helps to conserve screen real estate and better organize your dashboards.

Thematic mapping updates

In June, we took a big step in expanding our international support with the integration of global boundaries. Some of the new boundaries require an additional subscription level so please reach out to us if you are interested in learning about the available options.

Images below: Country and France Postal Code (requires additional subscription level) thematic boundary examples

Comparison Mapping with any Geographic Boundary

Our comparison analytics became more powerful with the expansion of thematic visualization support to any boundary, anywhere in the world! Whether it is a built-in boundary used for standard thematic mapping (US County or High Resolution Postal Codes for example) or a custom shapefile that has been joined with your dataset, now you can view results of comparing two data points thematically by these boundaries.

Visualizing portfolio growth between 2011 and 2012 for a client’s Japan portfolio (dark green signifies larger growth)

In addition to simple portfolio growth, you can visualize premium adequacy, compare results from various models, perform market share analyses, and much more. Select any two data points and how you wish to relate them, and you will have a powerful map, telling you much more about your data than before!

SpatialKey Architecture

Leveraging best practices and new features of Amazon Web Services, SpatialKey has built out a multi-tiered architecture, leveraging a Virtual Private Cloud and multiple availability zones to increase security and the availability of SpatialKey in the event of system or cloud outages.

Additionally, in the event of catastrophic data loss, we have multiple copies of critical data in multiple locations including both the West Coast and East Coast of the United States.

API

Integrate directly with SpatialKey using the Data Management API, which is now more flexible and simple to use than ever. Before, only IT and development teams could implement the Data Management API. With the new Data Management API Command Line Tool, typical users of SpatialKey can leverage this functionality without any programming knowledge.

For updated documentation and information on the new APIs, click here.

It's the little things that count

Now with only a single click, you can create a map! Click to “Let SpatialKey Decide” so you can get into your dashboard quicker. You still have flexibility to change visualizations and metrics once in your dashboard but with this feature, you can save the decision making until after you have started exploring your data.


Now you can find the closest address to any point on the map. Right click on any point on your map and click to get “lat/long” or “closest address”.

Address and lat/long information will be retrieved and you will be provided with direct links to copy this information or view in Google Maps.

Default basemaps were updated to use data from MapBox, a leader in the geo-imagery space. With this update, we increased our zooming capabilities by an additional zoom level. 

Left image shows max zoom level before this release. Right image shows zoom level with new basemaps.

We made a few redesigns on the layer manager, bringing frequently used features front and center!

As an initial step towards providing multiple point visualization options, we have added an additional marker icon. We hope this has helped you add some visual distinction to your dashboards by calling attention to select datasets.

For those of you who license the Policy Exposed Limit feature, we've added the much desired ability to export policy files and to review and edit the policy file setup.

 

The Data Upload Wizard got smarter! We shuffled the screens, added a couple additional options and now the Data Upload Wizard is able to learn from you as you walk through the upload process, delivering an enhanced user experience. For those of you with a little OCD, the pods now snap to a grid so that you can nicely line up the edges without making yourself crazy.

Integration of multiple geocoding options to give you flexibility and control over your data.

Along with this feature, we added the ability to export geocoded latitude and longitude coordinates and visualize geocodes on any basemap. For more details on geocoding option, check out this article.

 

2014 sneak peek

We also made substantial progress in 2013 on items that won't be officially released until 2014. Here is a quick sneak peek...

  • Monitor and understand your portfolio exposure with the new Portfolio Composition app. This app will be accessible from your desktop or mobile device, so you can access these insights, anytime and anywhere.
  • Evaluate and understand peak portfolio accumulations relative to US fluvial, pluvial and surge hazards through our forthcoming Flood Accumulation app.
  • Configure the national currency of fields included in your datasets and your dashboards will display them appropriately.
  • In additional to the CRESTA 2007 data, we will be adding CRESTA 2010 and 2013 boundary data.
  • You will soon be able to recover dashboards that you may have closed before saving so you don't accidentally use your work!
  • Seamlessly integrate your systems with SpatialKey with our re-architected Data Management API and new Embedded Client API. We have been working behind the scenes to expanded our API capabilities and put more flexibility in your hands. Early in 2014, you will get access to these new capabilities.

Stay tuned for updates on these items and much more to come in 2014. We want to thank you again for an amazing 2013.

Posted in Releases | Leave a reply

SpatialKey September 2013 Release

Posted on September 9, 2013 by Rebecca Morris

Reply

We've been busy cooking up some new features and a new application, and they are finally ready to be sampled! One of these is available as a beta release right now; but we didn't want to wait any longer to get the word out, start conversations, and get feedback.

Dashboard templates

Do you import weekly, monthly, or quarterly data and find yourself creating a new dashboard for each dataset? SpatialKey's new Dashboard Templates feature removes the tedium and frustration created by redundant report production processes and let's you get straight to analysis! Now, you can create a dashboard once and reuse it as a template for multiple datasets without having to recreate the dashboard each time.

Within the SpatialKey Analyst applications (Map Analyst and Blank Canvas), you simply select “Save as New Template” from the Save menu to create a template for the dashboard in focus.

You will need to configure a few options as well as provide contextual information that will help you and your colleagues identify it later.

Saved dashboard templates can be launched from the Dashboard tab or can be selected within the Analyst apps.

After selecting a template, choose a dataset to report against. This dataset must include the attributes and metrics that were used to create the template, which are listed in the Data Requirements panel on the left.

If the selected dataset doesn’t meet all Data Requirements, you are presented with the option to “pick a different dataset” or “use it anyways”. If you "use it anyways", some analytic pods may not appear in the dashboard due to insufficient data. For example, if the template requires “Sq Ft” and this attribute is not included in the chosen dataset, the pod(s) reporting Sq Ft will not appear when the dashboard is launched.

That’s all there is to using dashboard templates! These templates help automate report production, so you can immediately interrogate and derive insights from a new data vintage, a derivative dataset, or any other dataset of similar content. If you want to learn more, check out this article.

This premium SpatialKey feature is available as a beta release to give users the opportunity to help us enhance the user experience for the production release. If you are interested in licensing this premium feature and signing up to be a beta user, contact us.

Hail app

The U.S. has been impacted by several devastating hail outbreaks this year. Our clients require a rich analytic solution to help them understand and respond to these events. As such, we built a flexible and extensible application platform that allows us to integrate hail data from leading content providers!

The SpatialKey Hail application is the latest addition to the SpatialKey Insurance Intelligence solution. In this release, the Hail app integrates data from Weather Decision Technologies (WDT). You may remember the preliminary footprint WDT provided to help our clients respond to the Moore, OK tornado on May 20th (see blog post). The SpatialKey Hail app is purpose-built to help you visualize and derive insights from detailed WDT data, which includes 14 hail size contours ranging from 0.25" to 4.0".

We have made it easy to access and filter a rich library of hail events! Simply, use the calendar tool to select an event date, view the available event reports from the Storm Prediction Center (SPC) at NOAA in the map to the right, then set the desired geographic extent for the analysis.

During the analysis process, each location is enhanced with the the relevant hail sizes that each was subject to. Once complete, the dashboard is launched and you can immediately visualize your impacted exposures in the context of the hail footprints. As with all SpatialKey applications, you can flexibly filter, segment, and visualize hazard data and any attributes within your location dataset to understand and quantify the impact of these events and help mobilize your response.

If you are interested in learning more about this app and licensing options for WDT data, please contact our sales team.

Basemaps

Our default basemap has been updated to use data from MapBox, a leader in the geo-imagery space. MapBox is committed to delivering continuous innovation and conflates the best data sources into a single solution, mitigating vendor bias. When zoomed out you're looking at data from NASA satellites that MapBox has processed to color correct and remove clouds, which they call their "Cloudless Atlas". When zoomed in you're looking at data from Digital Globe.

With the update in default basemap, we have increased zooming capabilities in SpatialKey by a full zoom level! Here is a quick snapshot of the zoom level available before and after the switch to MapBox.


Image on left shows zoom level before this release. Image on right shows enhanced zoom level in this release, using MapBox.

Marker icons

As an initial step towards providing multiple point visualization options, we have added marker icons. These can be selected as an alternative to traditional plots by selecting "More visual options" for the desired dataset within the Layer Manager.

Check back soon as we have many other enhancements under development... we will have more to share in October!

Posted in Releases | Leave a reply

SpatialKey June 2013 Release

Posted on June 6, 2013 by Rebecca Morris

Reply

It's time for another release! Over the last few months, we've been working both behind the scenes and on the user interface to enhance your experience with SpatialKey. The new release focuses on improvements to getting data into SpatialKey and visualizing it in a dashboard.

In addition to these new features, you will notice significant thematic mapping performance enhancements. Displaying data for all US Counties for a 1.5M record dataset used to take around 90 seconds... now it takes only 3.5 seconds. Yes, you read that right, 25X faster!

Let's dive in and check out each of the new features in more detail.

Thematic Mapping

Are you importing locations outside of the US?

Our global thematic mapping release is here! SpatialKey has always offered thematic mapping by US State, County, and Postal Code (or by your own custom geographic boundaries) but now, through an additional subscription, you can map your data by Countries, Postal Codes, and CRESTA Zones internationally.

Images below: Country and France Postal Code (requires additional subscription level) thematic boundary examples

What is thematic mapping? Thematic maps (aka. Choropleth maps) show the distribution of a single attribute by various different geographical areas. They provide quickly digestible information and can highlight outliers and trends for datasets. Also, thematic maps can help you visualize data that isn’t otherwise mappable. You may run into a situation where you don’t have address information or latitude/longitude coordinates for the records in a dataset. When this happens, your data cannot be visualized on a map in traditional ways like individual points or a heatmap, but you can still use thematic mapping. Simply identify which thematic boundary each record belongs in, and we can create a visual representation of your data.

If your organization is interested in licensing global boundaries, please contact us or check out this article for additional details. If you have a need for additional thematic options - like Metropolitan Statistical Areas (MSAs), Legislative Districts, etc - please let us know. We are always looking to expand the built-in boundary options in SpatialKey.

Comparison Mapping with any Geographic Boundary

Our comparison analytics have just become even more powerful with the expansion of thematic visualization support to any boundary, anywhere in the world! Whether it is a built-in boundary used for standard thematic mapping (US County or High Resolution Postal Codes for example) or a custom shapefile that has been joined with your dataset, now you can view results of comparing two data points thematically by these boundaries.

Visualizing portfolio growth between 2011 and 2012 for a client's Japan portfolio (dark green signifies larger growth)

In addition to simple portfolio growth, you can visualize premium adequacy, compare results from various models, perform market share analyses, and much more. Select any two data points and how you wish to relate them, and you will have a powerful map, telling you much more about your data than before!

If comparing two data points within a single dataset, all thematic options for that dataset will be available. If comparing two data points within two separate datasets, only thematic options that are common between the two datasets will be available - e.g. CRESTA will only be available if both datasets have CRESTA enabled.

Data Upload Wizard

The Data Upload Wizard is getting smarter! We shuffled the screens, added a couple additional options and ... the Data Upload Wizard is able to learn from you as you walk through the upload process, delivering an enhanced user experience.

Here's a quick walkthrough of the new Data Upload Wizard workflow.

  • After selecting your dataset, identify if your data is in a single country, multiple country, or if your data is going to be analyzed without mapping. If your data is mappable, select how to map your data. The additional option you have that wasn't present before is to use other geographic boundaries.

  • The next screen is new and provides more optional functionality. If your organization has subscribed to our global boundary offering, you will see global boundary options in addition to the standard US boundary options (US State, County, and Postal Code).

  • Based on your selections on previous screens, we identify field types and required fields. Now you only have to scan the remaining fields and determine if anything other adjustments need to be made. Also, previewing your data is offered on demand now, whereas it was a step in the upload workflow before.

That's it, a few simple changes to bring you a more streamlined import workflow.

Let SpatialKey Decide

Now with only a single click, you can create a map! SpatialKey will now make all decisions to get you into your dashboard quicker. You still have flexibility to change visualizations and metrics once in your dashboard but with the new "Let SpatialKey Decide" feature, you can save decision making until the end, until after you have explored your data.

Coming from someone who opened many dashboards everyday, enjoy this new feature!

Layer Manager

With all of the changes elsewhere in SpatialKey for this release, we couldn't forget about the Layer Manager. Now, instead of having to look in the layer settings menu to find what you are looking for, we brought frequently used features front and center! Now you have quick access to change metrics, add labels, select visualization options, and remove a layer.


Data Import API Command Line Tool

The Data Import API is now more approachable than ever! Before, only IT and development teams could implement the Data Import API. With the new Data Import API Command Line Tool, typical users of SpatialKey can leverage this functionality without any programming knowledge.

Why use the Data Import API? SpatialKey makes it very easy to login and import data directly… so you might ask yourself, why would I need to use the Data Import API? One common use for the Data Import API is to schedule import tasks. Let’s say that your organization has an internal process that generated a new CSV file for your dataset every night, you could use the Data Import API to automatically pick up that file and submit a replace task in SpatialKey. Instead of coming into work in the morning, logging into SpatialKey, submitting the import job, and then working with the data, you can just wake up, login and start working with the refreshed dataset when you use the Data Import API.

For more details and to download the Command Line Tool visit this article.

Geocoding Options

Providing you with more flexibility and control over your data, we have integrated multiple geocoding options into SpatialKey. Some geocoding options will require a transactional fee to use but SpatialKey has also rolled out the SpatialKey Free geocoder, which is our own custom-built geocoding solution offered complementary with any SpatialKey license.

In addition to the added geocoding options, you can now export geocoded latitude and longitude coordinates and visualize geocodes on any basemap. For more details on geocoding option, check out this article.

Posted in data import, Visualization, Releases, choropleth | Leave a reply

SpatialKey February 2013 Release

Posted on February 21, 2013 by Rebecca Morris

Reply

SpatialKey is thrilled to announce some user interface enhancements that will be sure to make heads turn! In this release you will find the following features:

  • Redesigned pods that let your data shine
  • New pod features that help your data tell a more compelling story
  • New functionality that allows you to retrieve address and latitude/longitude coordinates for any point that you click on within your dashboard

Redesigned pods

Check them out, aren't they shiny and awesome! The image on the left shows the old pods, the image on the right shows the new pods.

The new pods look slimmer and blend into the background now that the headers are not as prominent. This allows for your data in the pods and on the map to stay in focus without as much distraction.

When needed, all of the same pod settings become available. Hover over any pod to see the settings appear. You'll notice that as you hover over the gear icon, the setting menu will start to peek out from behind the pod.

All of the pods in your saved dashboards will automatically convert to the new design after the release. We hope you love the new look and feel as much as we do!

New pod features

In addition to the new look and feel, we also added some new functionality to the Statistics Pod and the Unique Value List Pod.

Statistics Pod

The Statistics Pod can now contain multiple stats in a single pod. Click on the "+" icon to add a stat to an existing Statistics pod. Configure your new stat and "save".

Configure whether your stats are vertically or horizontally oriented by resizing the pod in the bottom right corner.

Grab a stat from an existing Statistics Pod and drag it to another Statistics Pod to combine them. To move a stat from an existing pod into a Statistics Pod of its own, grab the stat and drag it away from its original Statistics Pod. Note that when selecting a stat to move, you need to click on the stat value itself, not on the pod header.

Have some fun playing around with this interaction and integrating multiple stats into a single pod. This new functionality will help you organize and clean up your dashboards.

Unique Value List Pod

A row containing totals for all data in the pod in now enabled by default. You have the option to disable the totals in the pod settings.

Instead of adding multiple Unique Values List Pods to your dashboard to show different values and grouping options, you can simply add multiple calculated and grouping columns to a single pod. Rearrange columns as needed by dragging and dropping them into position.

Test out the new feature of viewing your numeric values as mini-charts to see if it is a good option for your data. Hover over a line item in your pod to see the numerical values.

That's it for Unique Value List Pod updates. We hope that this functionality will help you conserve screen real estate and better organize your dashboards.

Retrieve address and latitude/longitude coordinates

Have you ever wanted to click on any point in your dashboard and find the address or latitude/longitude coordinates? Even if you didn't know you wanted to, I'm sure you will now that this feature is available in SpatialKey. Right click on any point on your map and click to get "lat/long" or "closest address".

Address and lat/long information will be retrieved and you will be provided with direct links to copy this information or view in Google Maps.

Final Words

There is one additional feature worth mentioning. For those of you with a little OCD, the biggest highlight of this release is that the pods now snap to a grid so that you can nicely line up the edges without making yourself crazy.

That's it for what's included in this release, enjoy!

Posted in Releases | Leave a reply

What we did in 2012 - Year in Review

Posted on January 29, 2013 by Rebecca Morris

Reply

Only two years after we started introducing purpose-built apps for the insurance industry, SpatialKey is used by hundreds of insurance and reinsurance companies globally and by thousands of users across all industries. Whether you are working with 10 locations or 2 million locations, SpatialKey can handle it all.

In this last year, we took some time to enhance existing apps and features, while still pushing forward on innovation by introducing four powerful new apps. Here are some highlights of 2012:

  • Three new apps were added to help insurers understand loss potential and manage their response to wildfire, earthquake, and severe storm events.
  • A new app was introduced to assist insurers with evaluating flood risk at the point of underwriting.
  • New analytic capabilities were added with the introduction of policy exposed limit calculation and comparison maps.
  • Visualizations were enhanced with new basemaps, new pods and new methods of rendering your data on a map.
  • The overall usability that SpatialKey is known for has been improved with the addition of improved dashboard management, notifications, and more.
  • Use the new Data Mart feature to view an expanding selection of data that you can import into your organization for analysis.

Event Analysis App Suite

For our insurance customers, we launched the Event Analysis App Suite in 2011 and spent time rounding out the offering in 2012. We added three new applications in 2012 - Wildfire, Earthquake, and Severe Storms. The full Event Analysis offering includes the following apps.

Each of these apps integrates near real-time data from third party sources like NOAA, USGS, and GeoMAC.

Wildfire

With SpatialKey's Wildfire app, you can quickly assess your exposure to live or historical wildfires, forecast the potential spread of the fire, and mobilize claims teams to assist your insureds.

You have direct access to the latest wildfire perimeter data published by GeoMAC. As new intelligence is available, you can quantify insured exposures within the current scope of a wildfire, as well as to forecast loss scenarios by extending the scope of the current perimeters.

The Wildfire app was put to the test during the High Park fire in Colorado this year with hundreds of dashboards generated using SpatialKey during and after the fire event!

Earthquake

SpatialKey's Earthquake app enables you to target risk concentrations, mobilize claims personnel, and track claims associated with live events globally. Additionally, you can calibrate your view of risk and risk management strategy by evaluating loss potential against historical and hypothetical earthquake scenarios.

You have ready access to the USGS’ global library of historical and hypothetical earthquake events. You can quickly compare exposure, model, and claims data in the context of an event and associated ground-shaking severity, helping you build intuition and facilitate understanding of risk throughout your organization.

Severe Storms

SpatialKey Severe Storms enables you to proactively manage exposure, quickly respond to catastrophes, and track claims associated with live and historical U.S. tornado, hail, and straight-line wind events as published by NOAA.

Leverage an innovative storm drawing tool to manipulate the footprint of a storm against industry and claims data with the ability to apply damage assumptions to more accurately assess potential exposure.

Flood Underwriting

The Flood Underwriting app empowers you to action intelligence at the point of underwriting, resulting in more converted opportunities, enhanced underwriting profit, and reduced downstream costs associated with claims.

With seamless access to hazard maps from JBA Risk Management Limited, underwriters can quickly qualify and quote new business with a more complete understanding of flood risk through scorecards, visualizations, and analytics. You can also understand how these new risks contribute to a book of existing business with a visual assessment and quantification of localized risk.

Policy Exposed Limit

To assist you in developing a more accurate view of your exposure that contemplates your policy terms and conditions, we have added a pod tailored to helping you examine your Exposed Limit. This feature comes with additional import configurations for policy data, a financial engine, and a new analytic pod. It calculates Exposed Limit in aggregate, based on a risk zone, and by policy for a specific peril. You can now visualize risk zone accumulations of Exposed Limit.

As with all analytic pods, any filters applied in the map (e.g. defined by map extent, polygons, or event footprints) or other pods will refresh the content of the Policy Exposed Limit pod.

Comparison Maps

You can now create comparison map layers that visualize changes or relationships between two sets of data. These can be two instances of the same dataset (like snapshots of your portfolio from two points in time) or two entirely different datasets (like your portfolio and market data). Comparison maps can be rendered as thematic maps or heat maps.

Enhanced visualizations

NEW BASE MAPS
We've added brand new base maps that make your data really stand out. We want to make sure your data is the center of attention when you're creating maps and city names, roads, rivers, and buildings might add clutter to the map in a visually distracting way. The new base maps are subtler and cleaner, allowing the focus to be on your data instead of brightly colored crisscrossing highways.

NEW PODS
SpatialKey has added a scatter plot chart to its library of analytic pods, which will enable you to efficiently identify patterns and evaluate relationships within your data. Beyond simply plotting points on a chart, we have enabled the ability to leverage analytics to identify concentrations of values easily, akin to the heat map feature you are used to. As with all other pods, this one is also linked to the map and other active pods. This means that you can filter views by selecting a point or collection of points within the chart.

Also, to assist you in collaborating with your colleagues, we are introducing an annotation pod. This enables you to easily draw attention to areas of importance that you wish consumers of your dashboard to note.

NEW MAP VISUALIZATIONS
The graduated circle map renderer now supports bivariate rendering, providing the ability to display two different aggregates at the same time. One aggregate controls the size of the graduated circle while a second aggregate controls the color of the circle. For example, if you were looking at real estate data you could show the average sq footage for a house using circle size and average price using circle color.

Usability enhancements

DASHBOARD MANAGEMENT
With the increased use of saved dashboards, SpatialKey added simple features to allow users to manage and organize their dashboards better. Dashboards can now be filtered by app, saved as favorites, and a counter has been added so you can see how many times a particular dashboard has been accessed. Mark dashboards as favorites by adding them to the favorites folder - favorite dashboards will appear on your home screen when you first log into SpatialKey for quick access.

NOTIFICATIONS
Some processes can take a while to process in SpatialKey. If you're uploading a large dataset, or if you're doing advanced processing on your data, you'll now be notified within SpatialKey when the process is complete. You will have the option to launch viewing of analysis results right from the notification for some of these more advanced processes, like Earthquake analyses.

notifications

ZOOM USING SCROLL WHEEL

Based on your feedback, we have enhanced our zoom feature in all applications. You can now zoom using the scroll wheel on your mouse. As you move the scroll wheel, red indicators will appear next to your mouse arrow, indicating that you are zooming in or out.

thematic

PRE-DEFINED HEADER TYPES

Column data types can be defined prior to upload to save the step of defining types on this screen. Simply enter “|[Data Type]|[Subtype]” after the header names in your CSV file and SpatialKey will automatically assign the provided data types during Upload.

For more details on all supported data types and subtypes, check out this article.

Data Mart

SpatialKey has always made it easy to import third party data; but you had to find, format, and import that data yourself. We have added the Data Mart to mitigate the need for you to invest significant amounts of time in gathering hazard and event data yourself. Within the Data Mart, you can choose from an expanding selection of data, and with one click, have the data imported into your organization to begin analysis against your exposures.

The Data Mart currently contains both real-time and historical data from industry weather, event, and census data sources. We provide easy access to NOAA SPC storm reports, NOAA tropical storm/hurricane forecast, historical hurricanes, historical tornados, USGS earthquakes, and MODIS Wildfire perimeters. The Data Mart also enables you to easily add visual map overlays to your dashboards, like FEMA flood zones, precipitation, and cloud cover.

On to 2013

What great momentum for entering 2013! We have a number of projects already in the works and many more on our roadmap.

Don't forget to follow us on linkedin.

Posted in Releases | Leave a reply

Unveiling the new SpatialKey Natural Perils Suite...

Posted on May 9, 2012 by Bret Stone

Reply

SpatialKey Natural Perils Suite

These intuitive, interactive apps enable analysts, portfolio managers, claims managers, and executives to build intuition surrounding key concentrations of exposure and the composition of those exposures (business, occupancy, construction, and geographic attributes) impacted by a catastrophe event or derivative scenarios of an event. Initially, this is offered for live and historical U.S. hurricane and post-event footprints for earthquake (global coverage via USGS) and wildfire events. Each analysis can be saved as an interactive dashboard for internal collaboration and communication among other users within the enterprise.

Screen Shot 2013-02-11 at 2.44.51 PM

Hurricane Forecasts
SpatialKey’s Hurricane Forecast app instantly forecasts an insurer’s potential exposure to a live event, based on the latest storm data from NOAA. Because it leverages live feeds from NOAA, you can review your portfolio at multiple snapshots in time throughout the life cycle of an event, ensuring that you are analyzing and communicating the latest intelligence to your internal and external stakeholders. Further, you can adjust the trajectory of the forecasted storm track and windfield within the event’s cone of uncertainty to evaluate possible implications of shifts in the storm.

Past Hurricane Scenarios
Past Hurricane Scenarios enables you to evaluate loss potential for a historical hurricane event and run what-if scenarios to determine what would happen if that hurricane struck today. Similar to the Hurricane Forecasts app, you can gain insight into exposure accumulations and the composition of those risks therein and filter your data to review aggregations by event and exposure characteristics. If you wanted to hypothesize what Hurricane Ike would look like if the track shifted 50 miles West and rotated 45 degrees, you could reposition and rotate the track in any direction and resize the windfield of the storm.

Earthquake Impact
Earthquake Impact was built specifically to evaluate the proximity of portfolio exposures to actual earthquake events (recent and historical globally), as well as hypothetical large earthquake event scenarios, delivered via a feed from the USGS. You can understand the distribution and composition of your exposure relative to the event footprint as well as understand the relative impact observed in terms of Peak Ground Acceleration, Peak Ground Velocity, and Modified Mercalli Index and associated risk aggregations by intensity level.

Wildfire
The Wildfire app provides insight into risk potential associated with active, recent and historical wildfire events, based on data from the USDA Forest Service MODIS Active Fire Mapping Program. Events are categorized and listed for each calendar year period, which can be further filtered by month(s) to select the events of particular interest. Users can review their risk accumulations in the context of individual wildfire outbreaks. Furthermore, a user can enlarge the buffer surrounding the event to evaluate multiple deterministic scenarios.

Posted in Insurance, Releases, Analytics, Event response | Leave a reply