ArcNorthNews An Esri Canada publication celebrating GIS use coast to coast

Location Analytics Please Click On Each Article

Business Analyst Online: A key ingredient in CARA’s growth strategy

 ringing recreation to B Ontarians through Location Intelligence

Mapping the way to a healthier province

Students develop real-world market analysis skills

Building strong & safe communities with Business Analyst

Ontario Lottery and Gaming Corporation wins big with location analytics

Fall 2013

ArcNorthNews Editor

Amanda Graff [email protected] Special Contributions

Peter Cuthbert Ontario Lottery & Gaming Corporation olg.ca Dr. Ela Dramowicz Centre of Geographic Sciences (COGS) cogs.ns.ca Anna Malenkov The Regional Municipality of York york.ca Oleg Mikaelov Nova Scotia Department of Health & Wellness novascotia.ca/dhw Kamal Paudel Credit Valley Conservation creditvalleyca.ca Chris Ward CARA Operations cara.com Chris Wilkinson Conservation Ontario conservation-ontario.on.ca Graphic Design

Oksana Yepur Esri Canada 12 Concorde Place, Suite 900 Toronto ON M3C 3R8 © 2013 Esri Canada Limited. All rights reserved. Trademarks provided under licence from Environmental Systems Research Institute Inc. No part of this publication may be reproduced in whole or in part without the written permission of the publisher. Esri Canada Limited retains all rights to published material. Errors and omissions excepted.

2

| Fall 2013

ArcNorthNews

PRESIDENT’S LETTER // Alex Miller

It’s never been a more exciting time to be a GIS professional. We’re witnessing a major transformation where ArcGIS is emerging as a complete platform for building solutions and sharing maps across the enterprise. Supporting this transformation is the release of 10.2, which delivers several new enhancements. An enhanced focus on Web GIS enables users to work seamlessly across multiple devices. You can also now leverage ArcGIS Online in the cloud and behind your firewall. Additionally, you can easily integrate your GIS with data stored in IBM Cognos, SAP, Excel and SharePoint systems, among others. Geographic capabilities and content are fast becoming a core component of mission-critical workflows within many different industries, giving birth to a new era of location intelligence that adds a critical element of “where” to business data. Esri’s location analytics solutions make this easy to accomplish by connecting directly with business systems, providing a natural extension to enterprise applications that does not disrupt traditional workflows. Nearly everyone working in an organization now has the ability to turn rows of spreadsheet data into visually intuitive Web maps to look for trends and patterns not readily apparent. Traditional business information can also be geo-enriched with endless variables such as demographic, lifestyle and consumer behaviour for deeper insights. Maps can then be easily shared across the organization in presentations or reports. In this issue of ArcNorth News, you’ll read about organizations that have reached new heights with Esri’s location analytics solutions. You’ll read how Canada’s largest restaurant development company leverages location intelligence to expand its presence across Canada and the world. You’ll learn how Nova Scotia’s award-winning healthcare system relies on Web mapping to share near-real time data across the province. You’ll also find out how a large provincial conservation authority effectively promotes an active, healthy lifestyle using Esri Business Analyst. In this new era of location intelligence, you, the GIS user, are in a unique position to apply your knowledge to integrating geographic capabilities and content into your organization’s traditional BI systems. We hope that you enjoy this issue of ArcNorth News and that it inspires you with ideas for leveraging the power of location analytics in your own organization. Jamais il n’aura été aussi stimulant d’être un spécialiste des SIG. Nous sommes témoins d’une transformation majeure, portée par l’émergence d’ArcGIS comme plateforme complète de création de solutions et de partage de cartes dans l’ensemble d’une entreprise. Cette transformation passe par le lancement de la version 10.2, qui propose plusieurs améliorations. Une attention particulière a été portée au SIG Web, lequel permet aux utilisateurs de passer sans heurts d’un appareil à un autre. ArcGIS Online peut maintenant être exécuté dans le nuage et derrière votre pare-feu. Vous pouvez même intégrer facilement à votre SIG des données stockées dans IBM Cognos, SAP, Excel et SharePoint, entre autres. Dans bon nombre de secteurs, les fonctions et les contenus à teneur géographique sont rapidement en voie de s’implanter au cœur des processus fondamentaux. Nous assistons donc à la naissance d’une ère nouvelle en matière de veille géographique, une ère où la localisation des données est vitale. Les solutions d’analyse d’emplacement d’Esri facilitent les tâches de localisation en se connectant directement aux systèmes des entreprises de façon à devenir une extension naturelle des applications en place, sans entraver les processus traditionnels. Aujourd’hui, presque tout le monde dans une organisation est en mesure de transformer des feuilles de calcul remplies de données en des cartes Web intuitives et révélatrices pour y constater des tendances difficiles à voir autrement. Les données d’entreprises peuvent également être enrichies d’un nombre incalculable de variables géographiques susceptibles de les éclairer sous un jour nouveau : facteurs démographiques, considérations sur le style de vie, sur le comportement des consommateurs, etc. Les cartes ainsi créées peuvent circuler facilement dans l’ensemble de l’organisation, dans des présentations ou des rapports. Dans ce numéro d’ArcNorth News, vous découvrirez des organisations qui ont atteint de nouveaux sommets grâce aux solutions d’analyse d’emplacement d’Esri. Vous apprendrez de quelle façon la plus grande société de développement en restauration au Canada utilise la veille géographique pour poursuivre son expansion au Canada et dans le monde. Vous verrez comment le système de santé primé de la Nouvelle-Écosse compte sur la cartographie Web pour partager des données presque en temps réel dans l’ensemble de la province. Vous saurez enfin de quelle manière un grand office provincial de protection de la nature réussit à faire la promotion de styles de vie actifs et sains à l’aide d’Esri Business Analyst. Nous sommes dans une nouvelle ère de veille géographique. Il s’agit là d’une occasion unique pour vous, à titre d’utilisateur de SIG, d’appliquer vos connaissances afin d’intégrer des fonctions et des contenus géographiques dans les systèmes d’informatique décisionnelle traditionnels de votre organisation. Nous espérons que ce numéro d’ArcNorth News vous plaira et qu’il saura vous inspirer des idées qui permettront à votre organisation de tirer parti de tout le potentiel des analyses d’emplacement.

ON THE COVER // Location Analytics For decades, organizations have recognized the importance of business intelligence (BI) for gaining a competitive advantage and long term stability in the marketplace. However, until recently, BI has largely been missing the critical element of location. Through recent technological advancements and the rise of location analytics, it’s become easier and more affordable for organizations to add the essential fifth

Location Analytics

dimension of “where” to their operational data.

TABLE OF CONTENTS // Volume 16

. Issue 2

Features

Columns

4

8 Technology Spotlight Uncover a world of new insights from your business intelligence with location analytics



Business Analyst Online: A key ingredient in CARA’s growth strategy CARA Operations

6  Mapping the way to a healthier province Nova Scotia Department of Health and Wellness 14 Ontario Lottery and Gaming Corporation wins big with location analytics Ontario Lottery & Gaming Corporation (OLG) 16 Bringing recreation to Ontarians through Location Intelligence Conservation Ontario

10 Pleins feux sur la technologie Découvrez un monde rempli de nouvelles perspectives grâce à une veille stratégique à laquelle s’ajoute l’analyse d’emplacements 26 Events & Training Across Canada A nationwide listing of Esri Canada events, Web seminars and tradeshows

Advertisers Canadian Institute of Geomatics 613-224-9851 cig-acsg.ca Environics Analytics 416-969-2733 environicsanalytics.ca Grebit Solutions 905-684-3856 grebitsolutions.com Motion Computing 416-287-1100 motioncomputing.com Remsoft 1-800-792-9468 remsoft.com

20 Students develop real-world market analysis skills Centre of Geographic Sciences (COGS) 22 Building strong & safe communities with Business Analyst The Regional Municipality of York

ArcNorthNews

Fall 2013 |

3

Business Analyst Online: A key ingredient in CARA’s growth strategy

CARA Operations is Canada’s largest and fastest-growing full-service restaurant company, with over 700 locations across the country and sales in excess of $1.3 billion. CARA operates five brands that represent some of the country’s favourite restaurants: Swiss Chalet, Harvey’s, Milestones, Montana’s and Kelsey’s. The privately held company has been transitioning to a franchise-focused business model and is actively pursuing growth, with a goal to open 40 new locations annually. To support this growth, CARA invested in Business Analyst Online (BAO) – a Web-based solution that combines GIS technology with extensive demographic, consumer spending and business data to deliver on-demand analysis, reports and maps. When seeking optimal sites for expansion, BAO makes it possible to effectively assess a wealth of variables such as market size, visibility and proximity to high-traffic generators. “CARA made a strategic decision to heavily-invest in both development professionals 4

| Fall 2013

ArcNorthNews

and efficient technology tools to enable fast and accurate decision making on new markets and sites,” said Chris Ward, Market Planning Manager, CARA. “BAO was a good fit because it aligns with this objective, serving as a low-cost, easy-to-use system that makes it possible to run customer reports quickly and efficiently.”

Taking the guesswork out of site selection To identify optimal sites for restaurant development, analysts within the company use BAO to evaluate areas that are successfully served by existing restaurants and then uncover new areas with similar characteristics. The comparison-reporting feature within the tool makes it easy to evaluate existing versus potential sales and print out a variety of reports. “BAO allows everyone to focus on trade areas that are most promising before venturing out to visit the prospective site,” said Chris.

“This significantly decreases the time required to narrow down our options and quickly weeds out the markets that don’t fit our criteria.” The tool is used to dive into a wealth of demographic variables so that CARA can analyze their most profitable customers in a geographic context and find more like them. For example, each of CARA’s five brands targets customers from various age groups and income levels. Harvey’s serves a much younger crowd while Swiss Chalet is a popular choice for baby boomers and young families. Using BAO, analysts can locate pockets of the population that fit this description and reside in areas not currently served by an existing franchise. Territory design tools allow analysts to quickly identify market saturation or gaps, and then make decisions that will balance their territories. The Milestones brand targets a professional consumer with an above-average household income and restaurant spend. Largely

How can I find other locations like this? BAO is also used to quickly uncover and analyze new commercial and residential developments. Large movie theatres are plotted on a map view, allowing CARA to identify potential strategic partnerships and to Using intuitive wizards within BAO, analysts can easily map variables on a large market scale and uncover characteristics of the population that live and work around existing or open locations in prospective restaurant locations. close proximity. Fluctuations in the performance of existing sites are also closely monitored. For example, if there is a major store opening such as a Walmart or a Target that drives increased traffic to an area, BAO is used to analyze the amount of spillover to nearby restaurants. Variables such as restaurant spend and average income per household are analyzed by If there appears dissemination area. to be a significant spike in restaurant concentrated in Ontario and British Columbia, performance, BAO will be leveraged to track CARA is currently using BAO to expand other new store openings and assess the Milestones to other provinces including characteristics of the surrounding areas. Territory Manitoba, Newfoundland and Saskatchewan, design tools enhance the ability to respond with a goal to open three to four new locations to market changes and increase or reduce the by the end of the year. BAO makes it easy for number of territories in a network when the analysts to accurately measure markets in other need for change arises. provinces across the country. “Nearly twice the market threshold is required to sustain a Milestones restaurant versus some of our other brands, due to the unique and upscale nature of the venue,” said Chris. “Within minutes, we can now accurately Historically, nearly two-thirds of CARA measure markets across the country and locate restaurants have been located within Ontario. high concentrations of potential customers.” In the next few years, the corporation will focus Using intuitive wizards, analysts can on expanding their presence across all ten answer questions such as: Where are the provinces. Mapping tools within BAO allow neighbourhoods that tend to have higher sales analysts to develop an in-depth understanding volumes? How can I reach these customers? of underserved areas across the country

from the desktop. They can quickly pinpoint bustling commercial centres, high-performing retail plazas and populous residential neighbourhoods. “It’s quick and easy to map variables on a large market scale,” said Chris. “Once we drill down to a particular area, we can begin to have a look at who lives and works there, mapping out restaurant spend and average income per household. In fact, the number of variables that we can map at the touch of a button is enormous.” Optimal sites can be further narrowed down by factoring in characteristics such as high visibility, close proximity to strong traffic generators and easy access. This information can then be communicated to real estate managers through intuitive maps, helping to inform decision making around site selection across the country. “BAO eliminates a lot of the legwork that was typically involved with vetting potential sites,” said Chris. “Real estate managers can now do their due diligence and rely on factbased analysis, which saves us valuable time and money as we continue to expand both across the country and potentially outside of Canada.”

Learn more about Business Analyst Online. Access demos that can help you to get the most out of your BAO experience.

Expanding into new markets

“BAO allows everyone to focus on trade areas that are most promising before venturing out to visit the prospective site. This significantly decreases the time required to narrow down our options and quickly weeds out the markets that don’t fit our criteria.” Chris Ward CARA

ArcNorthNews

Fall 2013 |

5

Mapping the way to a healthier province

Nova Scotia is the second most densely populated province in the country and has the highest population in Atlantic Canada. With almost one million residents, the province boasts an exemplary healthcare system that is focused on a commitment to innovation

sharing near real-time data. They created a centralized portal to consolidate information from provincial health organizations. Next, they leveraged Esri Maps for SharePoint: a software download that allows the Department to display, analyze and share this data on

Using a basemap from ArcGIS Online, the Nova Scotia Department of Health and Wellness mapped all healthcare facilities across the province.

and sustainability. In fact, the Emergency Health Services (EHS) system has become an internationally recognized leader in the provision of emergency care. The province’s use of Collaborative Emergency Centres to provide round-the-clock emergency care in rural areas is also gaining wide-ranging attention. To effectively coordinate services across Nova Scotia, the Nova Scotia Department of Health and Wellness recently recognized the power of Web mapping for accessing and

6

| Fall 2013

ArcNorthNews

interactive maps directly in the SharePoint environment.

Getting a near real-time snapshot of provincial healthcare services Using a basemap from Esri’s cloud mapping platform ArcGIS Online, the Nova Scotia Department of Health and Wellness mapped all healthcare facilities across the province; everything from hospitals to nursing homes and paramedic bases which are all represented as points on the map. This enables the Department to pan and zoom around the map and easily identify gaps in services and programs, both across the entire province or within specific areas. “The mapping function included with this tool allows us to visualize coverage and get regular, province-wide status updates,” said Oleg Mikaelov, Senior Project Manager, EHealth Solutions, Nova Scotia Department of Health and Wellness. All groups that offer services included on the map have access to the SharePointbased portal and can update their information directly when it changes. This includes the IWK, a regional maternity and children’s hospital,

“We’re able to share data easily, and understand patterns and relationships that are difficult to detect in charts and spreadsheets. Maps make it possible to communicate simple or complex concepts based on a common operating view.” Oleg Mikaelov Nova Scotia Department of Health and Wellness

The Web map reveals patterns and relationships not readily apparent in a spreadsheet.

along with nine district health authorities, 811 telehealth, and the EHS paramedic service. “It allows us to not only share data easily, but also understand patterns and relationships that are difficult to detect in charts and spreadsheets,” said Mikaelov. “Maps make it possible to communicate simple or complex concepts based on a common operating view.” Data stored within SharePoint is also used for contingency planning and to visualize the impact that a service disruption might have. During emergencies, planners can quickly identify facilities that offer a landing pad or pinpoint where the provincial caches of disaster supplies are located. They can also identify acute care facilities that offer in-patient as

well as out-patient services, intensive care or obstetrics, and then categorize institutions based on services offered. Esri Maps for SharePoint allows users to examine routes between mapped points for planning, routing and logistics analysis.

Preparing for the unexpected In August 2013, a natural gas line rupture prompted an evacuation in downtown Halifax and Esri technology was leveraged to coordinate response. “Esri’s mapping database allowed us to assess the evacuation zone for impacted health facilities early on,” said Andy Boutilier, Manager of Operational Readiness, Nova Scotia Department of Health & Wellness. The Department of Health and Wellness can also use Esri Maps for SharePoint to shift services between facilities when needed. For example, the Nova Scotia Hospital in Dartmouth

provides a laundry service for other facilities in the province. If it were to lose power, planners could use a map view to identify the facilities that may be impacted. When a service is cancelled or reduced, this information can be updated quickly and reflected on the map. All users, including emergency planners, can subscribe to alerts and be notified of status changes almost as soon as they happen.

Watch this demonstration and see how easy it is to download and configure Esri Maps for SharePoint.

Users can visualize healthcare coverage and get regular, province-wide updates.

ArcNorthNews

Fall 2013 |

7

Technology Spotlight

Location Intelligence: Uncover a world of new insights from your business intelligence with location analytics For decades, organizations have recognized the importance of business intelligence (BI) for gaining a competitive advantage and longterm stability in the marketplace. BI transforms raw data into meaningful and useful information; large amounts of data are leveraged to identify and develop new opportunities, equipping knowledge workers with insights that drive sound business decisions. Traditionally, within larger organizations, BI and GIS investments existed in silos with little communication between the two technologies. Integration of the two systems would require custom coding and integration of maps with APIs. As a result, BI has largely been missing the critical dimension of location. Organizations capture a vast amount of data with a geographic component, but often struggle to manage it or derive insights from it. This presents a significant challenge because there are many pivotal questions that can be answered only within the context of location, such as: Where do my best customers reside? Where can I find more like them? Are my sales territories balanced? Where have our marketing efforts succeeded and why? The good news is that recent technological advancements and a focus on enterprise applications are making it easier and more affordable for organizations to add an essential location-based component to their BI enterprise systems through a new era of solutions known as location analytics. Furthermore, an explosion of big data has made a wealth of real-time, location-aware information available, allowing organizations to take their BI to the next level and tap into the power of location intelligence.

Adding the missing perspective to business analysis Esri offers a range of location analytics solutions that open up a wealth of opportunity for organizations to derive new insights from existing data. For example, you can create vivid maps directly in Excel or drag and drop your Excel data into a basemap to automatically show your data as points on a map. Other tools allow you to clearly delineate trade areas to uncover pockets of potential new customers, add a visual component to information stored in a Cognos database and much more. These solutions enable GIS to be seamlessly integrated with enterprise systems to add content, mapping and geographic capabilities, without disrupting the business workflow. As a result, organizations can build informative, intelligent maps to discover trends and patterns that can often be overlooked in a simple spreadsheet. Four key characteristics of Esri’s location analytics solutions allow even non-GIS experts within an organization to discover intuitive insights from their data. 1. Mapping and visualization: Esri’s location analytics solutions let users turn rows of data into visually intuitive maps. This allows knowledge workers and key decision makers to instantly spot trends and patterns in data that can often go unnoticed. Visualize regions that are over performing on a national or global scale or identify areas where

8

| Fall 2013

ArcNorthNews

Esri Business Analyst (Canadian Edition) comes complete with a wealth of high quality Canadian data so that you can immediately begin to perform deep analysis of demographic and consumer trends.

your target market resides and where they are currently purchasing their products or services. Much more than dots on a map, Esri solutions allow you to actually interact with the data on your map, create charts and graphs with geographic data, make changes on the fly and then share your maps through the Web or in the cloud. You can also create your map without leaving the environment that you are working in, whether it be Excel, Cognos or SharePoint, among others. Colour-coded, clustered point and heat maps can be added to PowerPoint presentations or reports and shared across the organization. 2. High-value spatial analytics: Location analytics solutions have been credited with clearing the analytics’ “blind spot”. Creating a bi-directional relationship between a map and data stored in a tabular format allows data to be easily analyzed based on its location. When you make a change to the tabular data, it is instantly reflected on the map. You can start simply with finding the nearest location and then

With Community Analyst, even users with little GIS experience can quickly explore the geographic characteristics of their community and then leverage this insight to allocate resources effectively.

progress to advanced analytics like geographically weighted regression. Analysis tools allow you to create profiles of your most profitable customers, see how far your customers might be willing to drive for a particular product or service, analyze overlapping trade areas, and then make sound marketing and merchandising decisions based on this data. 3. Geographic data enrichment: Esri’s location analytics solutions allow you to supplement your existing, traditional BI data with demographic and consumer data, landscape data and other information. This provides a new level of insight about your customers and what drives them, allowing you to make better business decisions. Users within your organization can also access Web maps and geo-enriched information based on thousands of demographic, lifestyle and landscape variables that are available in ArcGIS Online. Home addresses and postal codes can be automatically converted to geographic co-ordinates, enabling you to explore geographic trends and patterns in your business data. Use this information to design, analyze and manage geographic territories, and choose from rich basemaps to display information in a highly impactful way. Place your maps in a presentation or report, without leaving your current environment. 4. Complementary technology: Because Esri’s location analytics solutions are specifically designed to complement existing BI systems, there is a short learning curve are quick results. GIS technology is non-disruptive to the business workflow, and serves as a natural extension to the enterprise applications that are already in place within your organization.

Esri Maps for Cognos plugs directly into the IBM Cognos BI report authoring and deployment workflow so that anyone in the organization can create intuitive maps from BI data.

Learn more about Esri Location Analytics

Esri Maps for Office allows you to quickly map addresses and create graphs and charts to visualize data such as sales by territory, province, or postal code. You can then create dynamic maps with this data directly in your spreadsheet.

Familiar workflows remain completely intact for both the person authoring the BI content and the person consuming the information in published reports and dashboards. Mapping and analysis become native to the underlying business system and a key component of informed decision making. Users benefit from enhanced insight into business data without leaving the business system or disrupting their workflow.

Getting started with Esri location analytics solutions Esri’s location analytics solutions span the spectrum and are known for being easy to implement. They’re flexible and customizable, and they enable organizations to adopt an approach that makes the most sense for their business. For example, map integration using an Esri solution can consist of any combination of on-premises or cloud-based map servers. The solutions can also be instantly plugged into the existing BI, providing a low-cost, low-risk option for organizations looking to realize increased business value and agility. Whether you’re looking to expand to a new site, analyze financial performance, optimize your marketing efforts or manage your workforce, Esri offers a range of products that bring location analytics to mainstream business users. Empower platforms such as Microsoft and IBM with invaluable spatial analysis capabilities. Find out more about Esri’s location analytics solutions: • Esri Maps for Office • Esri Maps for SharePoint • Esri Maps for IBM Cognos • Esri Business Analyst (Canadian Edition) • Esri Community Analyst

Watch this Web seminar to get started.

ArcNorthNews

Fall 2013 |

9

Pleins feux sur la technologie

Veille géographique : Découvrez un monde rempli de nouvelles perspectives grâce à une veille stratégique à laquelle s’ajoute l’analyse d’emplacements Pendant des décennies, les organisations ont reconnu l’importance de la veille stratégique pour obtenir un avantage concurrentiel et profiter d’une stabilité à long terme sur le marché. La veille stratégique permet de transformer des données brutes en information significative et utile. Les travailleurs du savoir utilisent cette information et le point de vue complémentaire qu’elle offre pour repérer et exploiter de nouvelles occasions, ainsi que pour prendre des décisions d’affaires éclairées. Traditionnellement, les investissements des grandes organisations destinés aux systèmes de veille stratégique et ceux destinés aux SIG étaient distincts; il y avait peu de communication entre les deux types de système. Le jumelage des systèmes nécessitait du codage personnalisé et l’intégration de cartes avec interface API. Par conséquent, il manquait à la veille stratégique une dimension essentielle : la dimension géographique. Les organisations

Grâce à Community Analyst, même les novices en matière de SIG seront en mesure d’explorer les particularités géographiques de leur communauté afin d’affecter judicieusement les ressources.

et l’accent mis sur les applications d’entreprise permettent aux organisations d’ajouter facilement et de façon rentable cette composante géographique essentielle dans leurs systèmes de veille stratégique et de profiter des solutions d’analyse d’emplacements que la nouvelle ère apporte. En outre, l’explosion des données massives a engendré une panoplie de renseignements à volet géographique en temps réel. Les systèmes de veille stratégique peuvent ainsi passer à un niveau supérieur et à leur plein potentiel.

Ajouter la perspective qu’il manquait à l’analyse commerciale Esri offre une gamme de solutions d’analyse d’emplacements que les organisations emploient pour extraire de leurs données une multitude de nouveaux renseignements. Par exemple, vous pouvez créer des cartes parfaitement limpides directement Esri Business Analyst (Canadian Edition) comprend un riche éventail de données canadiennes de grande dans Excel ou glisser-déposer vos données Excel dans qualité. Vous pouvez ainsi réaliser immédiatement une analyse approfondie des tendances en matière de un fond de carte pour les afficher automatiquement démographie et de consommation. sous forme de points. D’autres outils vous permettent de clairement recueillent une importante quantité de données comportant un volet délimiter les secteurs commerciaux afin de découvrir ceux qui recèlent géographique, mais elles ont souvent du mal à les gérer ou à en des clients potentiels, d’ajouter une composante visuelle aux données extraire des renseignements utiles. Cela pose un important problème, stockées dans une base de données Cognos, et bien plus encore. puisque de nombreuses questions centrales ne trouvent une réponse Grâce à ces solutions, il est possible d’intégrer harmonieusement que dans le contexte géographique, par exemple : Où résident mes les SIG dans les systèmes d’entreprise, de façon à ajouter du contenu meilleurs clients? Où puis-je trouver d’autres clients semblables? ainsi que des fonctionnalités cartographiques et géographiques, sans Mes secteurs de vente sont-ils équilibrés? Où nos activités de perturber les activités habituelles. Ainsi, les organisations peuvent créer commercialisation ont-elles porté leurs fruits et pourquoi? des cartes intelligentes et informatives où se dégagent des tendances La bonne nouvelle est que les récentes avancées technologiques qui auraient été faciles à rater avec une simple feuille de calcul. 10

| Fall 2013

ArcNorthNews

Quatre caractéristiques clés des solutions d’analyse d’emplacements d’Esri permettent même à ceux qui ne sont pas des spécialistes des SIG de découvrir des renseignements utiles de façon intuitive à partir des données dont dispose leur organisation. 1. Cartographie et visualisation : Les solutions d’analyse d’emplacements d’Esri permettent aux utilisateurs de convertir des lignes de données en cartes visuellement intuitives. Ainsi, les travailleurs du savoir et les principaux décideurs peuvent instantanément observer les tendances qui se dégagent des données et qui passent souvent inaperçues. Visualisez les régions où le rendement dépasse la moyenne nationale ou mondiale, ou repérez les secteurs où réside votre clientèle cible et où elle achète actuellement ses produits ou ses services. Vous obtenez bien plus que des points sur une Esri Maps for Office vous permet de cartographier vos adresses et de créer des diagrammes et des graphiques en carte. Les solutions d’Esri vous permettent d’utiliser toute rapidité afin de visualiser vos données, par exemple les ventes par territoire, par province ou par code postal. Vous pouvez ensuite créer des cartes dynamiques directement dans votre feuille de calcul à partir de ces données. les données de vos cartes de façon interactive, de créer des diagrammes et des graphiques à partir autrefois les analyses. La création d’une relation bidirectionnelle de données géographiques, d’apporter des modifications à la volée, entre une carte et les données stockées sous forme de tableau facilite l’analyse de ces dernières en fonction de leur volet géographique. Lorsque vous apportez des modifications dans les données tabulaires, la carte s’actualise instantanément. Vous pouvez simplement commencer par la recherche de l’emplacement Esri Maps for Cognos plugs directly into the IBM Cognos BI report authoring and deployment workflow so that any0ne in the organization can create intuitive maps from BI data. le plus près, puis graduellement passer aux analyses avancées comme la régression géographiquement pondérée. Les Esri Maps for Cognos s’intègre directement dans le flux de création et de déploiement des rapports d’IBM Cognos BI, de sorte que n’importe qui au sein de l’organisation peut créer des cartes intuitives à partir de données de veille stratégique. outils d’analyse vous permettent puis de partager vos cartes sur le Web ou dans le nuage. Vous pouvez de créer les profils de vos meilleurs clients, de voir la distance que vos également créer une carte sans quitter l’environnement dans lequel clients sont prêts à parcourir pour obtenir un produit ou un service vous travaillez, peu importe qu’il s’agisse d’Excel, de Cognos ou de précis, d’analyser les secteurs commerciaux qui se chevauchent et SharePoint, entre autres. Vous pouvez ajouter des cartes à code de de prendre des décisions de commercialisation et de marchandisage couleur, des cartes à grappes de points et des cartes des points chauds éclairées qui reposent sur ces renseignements. dans des diaporamas PowerPoint ou dans des rapports, puis les 3. Enrichissement des données géographiques : Les solutions partager à l’échelle de votre organisation. d’analyse d’emplacements d’Esri vous permettent d’enrichir les 2. Analyses spatiales à valeur élevée : Les solutions d’analyse données traditionnelles de veille stratégique dont vous disposez d’emplacements ont permis de corriger les lacunes que présentaient déjà par l’ajout de données sur la démographie, la consommation,

ArcNorthNews

Fall 2013 |

11

Pleins feux sur la technologie l’environnement, etc. Vous profitez donc d’un niveau accru de précision des renseignements sur vos clients et leur motivation de sorte qui fonde de meilleures décisions d’affaires. Les utilisateurs de votre organisation peuvent également accéder à des cartes Web ainsi qu’à des données enrichies d’un volet géographique s’appuyant sur des milliers de variables relatives à la démographie, aux styles de vie et aux environnements, lesquelles sont disponibles dans ArcGIS Online. Il est possible de convertir automatiquement les adresses de domicile et les codes postaux en coordonnées géographiques, ce qui vous permet d’explorer des tendances géographiques dans vos données commerciales. Utilisez ces renseignements pour concevoir, analyser et gérer les secteurs géographiques et choisissez parmi une sélection de riches fonds de carte pour afficher ces mêmes renseignements d’une façon tout à fait saisissante. Intégrez vos cartes dans un diaporama ou dans un rapport sans quitter votre environnement actuel.

des composantes clés favorisant les prises de décisions éclairées. Les utilisateurs profitent des renseignements supplémentaires extraits des données commerciales sans avoir à quitter le système interne ni à perturber leurs activités normales.

Premiers pas dans les solutions d’analyse d’emplacements d’Esri Les solutions d’analyse d’emplacements d’Esri s’appliquent à un vaste éventail de domaines, et elles sont reconnues comme étant faciles à mettre en œuvre. Elles sont flexibles et personnalisables, et elles conduisent les organisations vers la démarche la plus sensée pour leurs activités. Par exemple, l’intégration de cartes à l’aide d’une solution d’Esri peut impliquer le recours à toute combinaison de serveurs de cartes situés sur place ou dans le nuage. Les solutions d’analyse d’emplacements d’Esri permettent aux organisations de surmonter cette difficulté : elles offrent des solutions de rechange prêtes à l’emploi qu’il est possible d’intégrer instantanément dans l’environnement de veille stratégique déjà en place. Ce regroupement de deux puissantes technologies constitue une option à faible coût et à faible risque pour les organisations qui souhaitent accroître leur chiffre d’affaires et devenir encore plus agiles sur le marché. Qu’il s’agisse d’ouvrir un nouveau magasin, d’analyser le rendement financier, d’optimiser les activités de commercialisation ou de gérer les travailleurs sur le terrain, Esri offre un éventail de produits d’analyse des emplacements qui sera d’une grande utilité pour votre personnel. Enrichissez des plateformes, comme celles de Microsoft et d’IBM, de fonctions incomparables d’analyse spatiale. Obtenez des renseignements détaillés à propos des solutions d’analyse d’emplacements d’Esri : • Esri Maps for Office • Esri Maps for SharePoint • Esri Maps for IBM Cognos • Esri Business Analyst (Canadian Edition) • Esri Community Analyst

Apprenez-en davantage à propos de l’analyse d’emplacements d’Esri

4. Technologie complémentaire : Étant donné que les solutions d’analyse d’emplacements d’Esri sont conçues spécialement pour compléter les systèmes de veille stratégique existant, elles n’exigent qu’une courte période d’apprentissage, et les résultats escomptés s’obtiennent rapidement. La technologie de SIG ne perturbe pas les processus des organisations et elle s’intègre naturellement aux applications en place. Les flux de travaux demeurent tout à fait inchangés tant pour le personnel qui crée les rapports et les tableaux de bord de la veille stratégique que pour les personnes qui les consultent. La cartographie et l’analyse deviennent des éléments natifs du système interne et

Regardez ce webinaire

12

| Fall 2013

ArcNorthNews

ArcGIS Online Collaboration made easy.

• • • • •

No installation or setup required Ready-to-use basemaps, apps & templates Easily add your own data & perform spatial analysis Share interactive maps & apps with the rest of your organization Access your information anywhere, on any device

esri.ca/arcgisonline ArcNorthNews

spring 2013 |

13

Ontario Lottery & Gaming Corporation wins big with location analytics Analytical tools drive performance & reveal new insights for OLG’s business intelligence

The Ontario Lottery and Gaming Corporation (OLG) directly and indirectly employs almost 17,000 people at 27 gaming sites, and is responsible for the sale of lottery products at approximately 10,000 retail locations. Generating almost $7 billion annually, the organization contributes a significant portion of its revenue to the province of Ontario while supporting the local economy. In 2010, the OLG’s Analytic Centre of Excellence recognized the power of adding location-based data to business intelligence and invested in Esri Business Analyst for Desktop. As a result, they have achieved a deeper understanding of customer behaviour, optimized offerings, targeted new clientele and streamlined operations across its brands and business lines.

“Supplementing traditional and advanced analytical approaches with geographical insights provided by Esri has unlocked the ability to make fact-based decisions much more rapidly, while strategically directing our financial and human resources.” Peter Cuthbert Director of Business Planning & Analytics

14

| Fall 2013

ArcNorthNews

Marketing spend is now focused on specific trade areas or postal codes versus an entire city or region.

The OLG can accurately assess the ability to draw customers to various site locations and refine or optimize distribution networks.

Adding a fifth dimension to Business Intelligence

analysis. Through a map view, it can be determined whether a campaign was more effective among customers within close proximity of an establishment versus customers within a one-hour radius. Untapped markets and customers that reside outside of trade areas can also be identified and targeted with tailored campaigns and incentives.

The Ontario Lottery and Gaming Corporation manages a number of brands including Lotteries, INSTANT Games, PRO·LINE, OLG Slots & Casinos, Charitable Gaming and Resort Casinos. The organization also hosts regular contests and promotions throughout the year within the province of Ontario. With tens of millions of customers, a diverse portfolio of offerings and billions of dollars in revenue, the OLG manages and processes an enormous amount of statistical and operational data. A commitment to player protection means that data security and privacy are also top priorities. Prior to leveraging GIS, the OLG managed information as tabular datasets stored in spreadsheets. An inability to visualize their data made it difficult to communicate plans with key stakeholders or to map out contests, promotions and product offerings in a geographical context. In 2008, the OLG’s Gaming Division adopted GIS to plot information on a map view, but lacked analysis capabilities to extract meaningful insights from the data. There were no tools in place to profile loyal customers, monitor customer behaviour, model the impact of planned activities or tap into new markets. To optimize its business strategy, the OLG decided to invest in analytical tools and add a geographic element to its business intelligence. Leveraged to serve two key client groups – senior gaming executives and internal marketing staff – Business Analyst supports customer profiling and enables loyalty program activity and market penetration to be analyzed within the context of location. Using trade area analysis, customer behaviour can be correlated with geographic locations to identify OLG’s most loyal customers. Gravity modelling is also used to monitor a gaming site’s ability to draw customers from various locations. This analysis informs the member loyalty rewards program and supports OLG’s overall corporate strategy. Drive times are also monitored and correlated to customer behaviour, which has proven to be especially useful for post-campaign

Using powerful data and visualization to understand your markets Business listings included with Business Analyst are leveraged to identify and contact ideal partners for promotions, such as hotels and restaurants. Using built-in templates, maps and reports are then readily produced to communicate the results of analysis with key stakeholders. By integrating valuable corporate data with location-based data, the OLG can seamlessly monitor customer behaviour on a province-wide scale. As a result, marketing spend is now focused on specific trade areas or postal codes versus an entire city or region. Gaps in market saturation can be readily identified and assessed so that communication efforts can be targeted to areas of lower customer penetration. Through profiling, the OLG can also minimize marketing costs by contacting only those who are likely to be interested in a particular campaign or promotion. Predictive modelling makes it possible to accurately assess the ability to draw customers to various site locations and refine or optimize distribution networks based on location analysis. Rather than sifting through rows of data, analysts now rely on an intuitive map interface to gain a real-world perspective of their trade areas. This has led to improvements in data quality as the ability to visualize information allows inaccuracies or anomalies to be readily identified and corrected. In an effort to build on these successes, the OLG Gaming Division’s Analytic Centre of Excellence is planning to expand its use of Business Analyst to other lines of business including iGaming, an Internet gaming initiative that will aim to set a gold standard for safe and responsible gaming.

ArcNorthNews

Fall 2013 |

15

Bringing recreation to Ontarians through Location Intelligence If you’re an outdoor enthusiast living in Ontario, you’ve likely spent time canoeing, hiking, cycling, boating or jogging through picturesque land managed by a Conservation Authority. In fact, almost seven million people visited one of Ontario’s conservation areas in 2012 alone. Conservation Ontario represents the network of 36 Conservation Authorities in Ontario; local watershed management agencies that deliver services and programs aimed at protecting and managing water and other natural resources. With more than 8,400 campsites and 2,400 km of trails, the organization is also focused on promoting a healthy, active lifestyle by offering year-round facilities and outdoor recreational opportunities.

The results of drive-time analysis are communicated through visually intuitive, colour-coded spider diagrams.

16

| Fall 2013

ArcNorthNews

To achieve its strategic goals, Conservation Ontario is increasingly leveraging the power of location intelligence software. The organization is using Esri Business Analyst for Desktop to gain a deeper understanding of existing customers and trade areas, while designing programs and services that will entice new customers to get moving, be active and enjoy the great outdoors.

Understanding customers, one community at a time To build a comprehensive customer profile, several Conservation Authorities within Ontario are engaging in a pilot project whereby postal codes are collected from visitors at the gate. This information is then combined with demographic data included with the Business Analyst software. Profiling and prospecting tools allow analysts to get an accurate snapshot of who is visiting their facilities, revealing that the average customer is between the ages of 35 and 37 and has 2.2 family members. The software is also used to identify segments of the population that are underrepresented. For example, though the population of visible minorities is increasing across Mississauga and Brampton, analysis reveals that they are not choosing to visit conservation areas and Conservation Authorities are missing out on an important and growing population target. These types of insights are leveraged for future planning and to create targeted marketing and awareness campaigns that will attract new customer groups.

“We used to rely on Stats Canada data alone, which was a very labour-intensive process. We’d have to join datasets manually and make updates whenever there was a change,” said Kamal Paudel, GIS Specialist, Credit Valley Conservation (CVC). “With Business Analyst, everything is contained in one software package, giving us 300 to 400 variables at our fingertips rather than simply a handful. Analysis that used to take several months can now be done in one or two days.” Business Analyst is leveraged for comprehensive trade area analysis. Mississauga, Caledon and Brampton all represent major trade areas for provincial parks and natural land located in the Golden Horseshoe region. Drive times were analyzed to see from where the greatest concentration of customers was travelling. It was discovered that in addition to these three major trade areas, some customers were also driving in from Kingston and Peterborough. The results of the drive-

Additionally, the large majority of this market speak Punjabi as a first language. As a result of this analysis, recommendations were provided to key decision makers about the need to include multilingual signs across the Meadowvale Conservation Area and to offer accessible trails that will accommodate an aging population. “We used to have limited knowledge of our existing customers,” said Chris Wilkinson, Water Resources Information Program Coordinator, Conservation Ontario. “The ability to leverage business intelligence to this extent is a new frontier for us, and we’re extracting more value from our data than ever before. This has empowered us to meet strategic goals and better promote health and wellness across the province in a way that is really resonating with people.”

Analysis that used to take several months can now be conducted in one or two days. Business Analyst is used to gain a deeper understanding of existing customers, so that programs and services can be designed that will entice new customers. time analysis were then communicated through visually intuitive, colour-coded spider diagrams. This information can be used to target marketing efforts not only to customers residing in major trade areas, but also to those travelling from farther distances. Drive-time analysis was also conducted for CVC’s Meadowvale A favourite destination for hikers is the Ganaraska Forest, northwest Conservation Area, located in Mississauga. Not considered a traditional of the city of Cobourg. It offers the largest block of continuous forest “destination” area, most customers are local residents who visit the in Southern Ontario, with a huge expanse of 11,000 acres. People use area for trail running, cycling, barbecuing or bird watching. The main the forest for dirt biking, hiking, jogging, cycling, wildlife viewing and objective of the analysis was to gain a deeper understanding of existing horseback riding. Wanting to understand existing customers better and customers and offer targeted services that could improve the health and offer programs and services that might attract new users, Conservation activity levels of local residents. Ontario worked with the Ganaraska Region Conservation Authority Using Business Analyst, customer profiles were created for residents and leveraged PrizmC2 data within Business Analyst to build customer residing within a 30-minute drive time of the conservation area. It was profiles based on membership. discovered that this population would likely increase ten per cent Over 2,000 customers were mapped by postal code. PrizmC2 over the next five years. The data also revealed that 73 per cent of this data was then applied to build social profiles of these customers. The population live in single detached homes, are 40 to 49 years old and data offers 66 unique lifestyle types and is the first system of its kind in have an annual household income of $70,000 to $90,000.

Increasing traffic to Southern Ontario’s largest forest

“We used to have limited knowledge of our existing customers. The ability to leverage location intelligence to this extent is a new frontier for us, and we’re extracting more value from our data than ever before.” Chris Wilkinson Conservation Ontario

ArcNorthNews

Fall 2013 |

17

Canada to integrate geo-demographics and psychographics to provide insights into consumer behaviour and mindset. For example, demographics were analyzed for a cluster of small towns located in and around rural southern Ontario cities. In addition to determining the total population, number of households, education levels and average household incomes, data within Business Analyst established what motivates people living in these communities. Among many insights, it was determined these residents enjoy golfing and canoeing, and often attend cottage and motorcycle events. They like SUVs and mid-sized sedans and prefer to receive advertising in newspaper inserts. Analysts also revealed what these residents like to eat, buy and read. This type of analysis allows Conservation Authorities to identify trade shows and events that prospective new customers will likely attend. As a result, it was decided to have a presence at the Fall Cottage Life Show and advertise Ganaraska Forest membership in local newspapers. A “distance decay” analysis was applied to target new locations to place flyers. This analysis calculates the likelihood that a prospective customer might visit the Ganaraska Forest based on customer profiling and drive distance. Through social profiles, analysts also determined that the majority of people attending the Fall Cottage Life Show enjoy eating ice cream. With the goal of increasing revenue, an ice cream stand was implemented. “We now have access to accurate data that is supporting better decisions,” said Chris Wilkinson. “Previously, the amount of data massaging that would have been necessary to gain these insights would have made it almost impossible.

Advanced tools now do the heavy lifting for us.” Business Analyst will also be used to support Conservation Ontario’s 2014 Healthy Hikes campaign. The campaign invites Ontarians to log the time they spend hiking or walking at any Conservation Area in the province, to be eligible to win exciting prizes. Using the software, analysts will be able to identify the location of prospective participants who are likely to be interested in the program, and then target marketing and awareness initiatives. The organization will continue to focus on analyzing variables that support strategic outcomes and improve access to recreational facilities for all Ontarians. Analysis conducted using Business Analyst software will soon become a shared service to be leveraged across all 36 Conservation Authorities.

UNCOMPROMISING PERFORMANCE. EXCEPTIONAL FIELD CAPABILITIES.

When it’s time for point-of-service productivity, you need a tablet that works as hard as you do. Built to run on Microsoft ® Windows ®, the Motion Tablet PCs deliver uncompromising levels of power, performance and usability. Featuring an industry-leading display and up to the Intel ® Core TM i7 vPro TM processor for optimized mobility, Motion Tablets offer long battery life and a hot swap battery feature for uninterrupted productivity. These rugged tablets are the only serious solution for companies that need to keep their mobile workers productive and connected. www.MotionComputing.ca See the new rugged F5t Tablet in action at http://www.MotionComputing.ca/F5t_Demo Get Serious about Mobile Productivity with Motion Tablet PCs - The perfect platform for your ArcPad projects. Motion Computing, Inc. All rights reserved. Intel, the Intel logo, Centrino, Intel Core and Core inside are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. All other trademarks and registered trademarks are property of their respective owners. 18 ©| 2013 Spring 2013 ArcNorthNews

When you’re looking for data, look to the Geeks. Environics Analytics offers the most reliable, comprehensive and up-to-date Canadian data for customer insights, target marketing, sales forecasts and trade area analysis. With popular databases such as CensusPlus and PRIZMC2, we’ll help you better understand your markets, customers and competitors. And we can deliver data in whatever platform suits your needs, including ArcGIS Analyst, Esri Business Analyst Desktop 10.1 (Canadian Edition) and Business Analyst Online.

Boost the power of your business solutions with these databases from Environics Analytics: • DemoStats (demographic estimates and projections)

• Social Values

• HouseholdSpend

• Canadian Financial Monitor

• PRIZMC2 at the DA and postal code levels

• Social Media, Mobile and eShopper PRIZMC2Links, powered by AskingCanadians™

• DaytimePop

• PMB, BBM RTS Canada, NADbank (for members only)

• Business Profiles • Shopping Centres

Know more. Market smarter.

environicsanalytics.ca

• WealthScapes

416.969.2733

Students develop real-world market analysis skills Centre of Geographic Sciences (COGS) leverages Business Analyst to prepare students for the 21st century workforce

Tracing its roots back to 1948, the Centre of Geographic Sciences (COGS), part of the Nova Scotia Community College, is a publicly funded training institution that is internationally recognized for its reputation in geomatics training excellence. The school offers advanced diploma programs including a GIS for Business Concentration which allows students to develop real-world market analysis skills and emerge from the program prepared to tackle a range of business, socioeconomic, and demographic challenges. As today’s businesses are increasingly recognizing the value of location intelligence, an Advanced Location Analysis course is offered as part of the GIS for Business Concentration curriculum. Built entirely around Esri Business Analyst Desktop, the course provides students with an opportunity to explore modern-day business operations and gain hands-on experience evaluating site performance and selecting new sites for expansion. “Business Analyst is the most complete tool on the market, providing a comprehensive set of analysis tools in addition to highquality data, all in a single package,” said Dr. Ela Dramowicz, Faculty, COGS. “This allows students to develop advanced market analysis skills 20

| Fall 2013

ArcNorthNews

while learning to effectively evaluate business performance, estimate potential sales volume, design trade areas and much more.”

Evaluating high-performing locations and their fiercest competitors To simulate a real-world market analysis experience, students use a data layer provided by Business Analyst representing Tim Hortons restaurant locations within a specific study area. Using Business Analyst, they’re able to evaluate the performance of existing locations and explore potential new sites for expansion. The tool provides all of the functionality required to define a study area, locate competitors within the study area, and then define trade areas around locations based on a variety of variables including drive time, threshold areas, data-driven rings and much more. Equal Competition trade area polygons, created with Business Analyst allow students to accurately compare the performance of Tim Hortons locations with competitor locations. This type of trade area

The Find Similar analysis tool allows students to select a highperforming master site which is used to find other sites with similar characteristics. Additional tools within Business Analyst allow students to estimate the sales potential of an area, taking into consideration the proposed site location, competitor locations and attractiveness variables. Sales are estimated by applying the Huff Model: a principle stating that the probability of a given consumer visiting and purchasing at a given site is a function of the distance to that site, its attractiveness, and the distance and attractiveness of competing sites. Students are then able to narrow down sites for expansion that have the highest predicted sales, and display the results on a map.

Applying analysis skills to real-world challenges On behalf of RBC in Atlantic Canada, a student analyzed 59 branches within rural communities and their ability to draw customers. Business Analyst was used to build branch profiles and to conduct a sub-study of the surrounding communities.

assumes that consumers will likely travel to the closest restaurant. Using the Append Data tool, students can extract data from one layer and add it to another. They can then use this information to calculate sales per capita, sales per capita of daytime population, sales at restaurants as a percentage of the total food expenditure and other variables for each location’s trade area. With the Market Ranking tool, students then create a report that ranks the highest performing Tim Hortons locations along with the highest performing competing locations. “The fact that Business Analyst comes equipped with its own Canadian data offers a huge advantage,” said Dr. Dramowicz. “We can easily mash up data within the tool with our own data, allowing students to conduct a deep dive into a wealth of market variables without having to purchase additional datasets.”

Pinpointing successful sites and finding more like them Based on the same study area, students are then tasked with finding potential sites for business expansion. Using Business Analyst, threshold trade areas are created around stores based on a set of variables such as mean total daytime population and mean population that is 15 years or older and in the labour force. Students use variables that best represent the group of customers served by a studied business. Thematic maps are created to display threshold trade areas and other information, such as the percentage of food expenditure spent on restaurants in each trade area along with road network data. Students are then asked to visually inspect the maps to pinpoint areas where they see the greatest potential for adding new restaurant sites.

Esri Business Analyst Desktop is also leveraged to facilitate major research projects that form a large part of the GIS for Business Concentration curriculum. The research projects are aimed at developing analytical skills with a focus on the retail, real estate and health sectors, and help businesses to address their problems from a spatial perspective. For example, Business Analyst was leveraged to conduct market research on behalf of RBC in Atlantic Canada. The student analyzed 59 branches within rural communities and examined their ability to draw customers. The project was twofold, requiring the student to build comprehensive branch profiles and also conduct a sub-study of the surrounding communities. Trade areas were established based on drive times for customers within a 15 or a 23 minute drive of the various branches. Historical changes in population and client base were then determined over a four year period. Branch profiles were created by taking into consideration a number of variables such as new clients, number of transactions and product offerings per year, number of competitive locations, average age and average tenure of clients for each drive time trade area. Cannibalization was also analyzed to determine how branches might be attracting customers away from other branches. The sub-study looked into changes in the unemployment rate, average household income, average value of dwellings and key industries within the surrounding communities. “This hands-on experience has opened up a world of opportunity for our students,” said Dr. Dramowicz. “Familiarity with Business Analyst has allowed our graduates to enter the workforce with transferable skills that place them at a considerable advantage. In fact, we’ve watched several graduates move successfully into roles as market analysts for large organizations.”

Find out more about GIS for Education

“This hands-on experience has opened up a world of opportunity for our students. Familiarity with Business Analyst has allowed our graduates to enter the workforce with transferable skills that place them at a considerable advantage. In fact, we’ve watched several graduates move successfully into roles as market analysts for large organizations.” Dr. Ela Dramowicz COGS

ArcNorthNews

Fall 2013 |

21

Building Strong & Safe Communities with Business Analyst The Regional Municipality of York has a vision to create strong, caring and safe communities. This is reflected by a longterm strategic document called Vision 2051 that lays out how it will ensure the ongoing sustainability, health, well-being and livability of its communities over the next 40 years. As the Region’s population continues to grow and diversify, geo-demographic information will be more vital than ever to achieving its goals.

22

| Fall 2013

ArcNorthNews

As such, York Region invested in Esri’s Business Analyst to combine its geodemographic data with purpose-built GIS tools that work with this data. Business Analyst supports York Region’s emergency planning programs by enabling the Region’s GIS staff to quickly produce demographic reports that help emergency planners understand the characteristics of residents in any area within the Region.

Protecting the public through in-depth analysis Each year, the Region is mandated to carry out a mock emergency exercise to test preparedness and maintain strong communication and collaboration protocols with local municipal emergency operations staff. A different emergency simulation is performed annually. This year, the Region evaluated its response to a mock fire in the Township of King

Using configurable reports available with Business Analyst, York Region prepares population calculations for pretend impact areas during annual emergency exercises.

coupled with two near-simultaneous events involving hazardous materials in the Town of Whitchurch-Stouffville. The exercise focused on communication between the Regions’ Emergency Operations Centre (REOC), the local municipal emergency operations centres and first responder personnel. The exercise involved calculating the population of “impact areas” and then reallocating the population from known geographies such as Census Tracts or Traffic Zones, which are used by the Region to forecast population, into a custom geographic area. Previously, this process was based on proportional calculations by area. While this is a commonly used approach, Business Analyst supports a much more detailed methodology, allowing population to be re-distributed using “Block Points” – point data that carries population information. This results in a much deeper understanding of the people that reside in that geographic area. “It used to be a multi-step, technical operation to recalculate daytime population totals into a custom area,” explained Anna Malenkov, GIS Analyst with the Geographic Information Services Branch of York Region. “It took many preparatory steps to ensure that we were using the best population numbers available. Business Analyst allows multiple datasets to merge and the results of our analysis to be calculated very quickly, with repeatability and consistency. It’s also very useful for emergency situations because we can run in-depth analysis even without access to the Internet, which could very well be unavailable during a real-life event.” The tool can also be used to integrate a variety of external datasets. For example, when

Business Analyst is used to translate projected population from Traffic Zones for multiple planning purposes. ArcNorthNews

Fall 2013 |

23

testing an emergency situation related to a flood, flood data is collected from conservation authorities and combined with demographic data in Business Analyst. The Region is then able to quickly map out and identify areas of high risk while noting whether schools and hospitals will be affected. Configurable reports can then be easily generated through the tool, to communicate the results of the exercise.

Promoting sustainability for a growing population

showing the results of the exploration were then referenced by decision-makers as part of the background research.

Functionality within Business Analyst was also leveraged to help the Region determine location and suitability of proposed employment services for youth. Business Analyst was used to explore the make-up of communities and factor-in access to the site. Custom reports

Demographic reports help emergency planners understand the characteristics of residents in any area within the Region.

“ This type of geo-demographic exploration was far more time-consuming prior to having access to Business Analyst. The software makes tasks straightforward and produces consistent results.” Anna Malenkov York Region

GREBIT Solutions

Business Intelligence consultants 100% dedicated to Esri® Location Analytics www.grebitsolutions.com

T: 905.684.3856

Trademarks provided under license from Esri.

GREBIT Solutions 24

Our ArcNorthNews consultants can be where you

| Fall 2012

THE REMSOFT OPERATIONAL PLANNING SOLUTION CAN RESULT IN MILLIONS OF DOLLARS IN COST SAVINGS & INCREASED REVENUE Are you efficiently balancing supply and demand to maximize value and profits? Are your operational planning processes aligned and integrated with your corporate budgets and objectives? Are you using spreadsheets and manual processes to schedule your operational activities? Are you looking for ways to automate and streamline the process of scheduling operational activities?

With an optimization-based operational planning solution you can understand and manage the supply-demand balance, identify current and future supply chain bottlenecks, manage production and delivery capacity, forecast costs and revenues, and generate plans that stay within budget.

On-the-ground optimization provides costs savings, higher revenues, improved business foresight and understanding, risk management and a competitive advantage.

THE REMSOFT SOLUTION INTEGRATES WITH EXISTING SYSTEMS, MAKING THE TIME TO VALUE FAST AND COST EFFECTIVE. THE REMSOFT OPERATIONAL PLANNING SOLUTION IS GROUNDED IN SCIENCE AND WILL HELP YOU TO: n

Optimize operations and drive down costs

n

Minimize waste and maximize productivity

n

Mitigate risk

n

Explore new business opportunities

n

Assess impacts of changes to your business

n

Manage the supply chain and effectively schedule resources

With hundreds of clients on 6 continents, Remsoft software and services uncovers optimal decisions, exposes risks, enables deep analysis, creates plans and schedules, and empowers technical, business and operations staff to communicate and work together on complementary objectives. CLICK TO VIEW

OPERATIONAL PLANNING DEMO

[email protected] | REMSOFT.COM | +1 506 450 1511 | 1 800 792 9468

Events & Training Across Canada 2013 Esri Canada User Conferences Esri Canada User Conferences provide an opportunity to discover exciting developments in Esri’s GIS solutions and network with your peers.

Transforming

Ottawa Halifax Vancouver St. John’s

Our World

Visit esri.ca/events to learn more and to register.

October 22-23 November 5-6 November 13-14 November 19-20 Please Click on each article

Web Seminars Esri Canada offers complimentary Web Seminars that are dedicated to a focused topic, delivered by an Esri Canada technical expert and streamed directly to your desktop. These seminars are live, interactive and free. Visit esri.ca/web_seminars to register. Tradeshows/Conferences

• • • • • Tr • a • • • • •

SARSCENE 2013, Chilliwack BC, Oct. 19-21 2013 Snow & Ice Colloquium, Mississauga ON, Oct. 23 - 24 Computer Using Educators of BC (CUEBC), Vancouver BC, Oct. 25 Manitoba Social Sciences Teacher’s Association Conference, Winnipeg MB, Oct. 25 Nova Scotia Social Studies Teacher’s Association Conference, Halifax NS, Oct. 25 CANIC 2013 (Canadian Intelligence Conference), Oct. 25, Ottawa ON SecureTech, Ottawa ON, Oct. 29-30 Ontario Association for Geographic and Environmental Education (OAGEE) Conference, Waterloo ON, Nov. 1-2 Real Property Community Workshop, Ottawa ON, Nov. 5-7 Québec Mines, Québec QC, Nov.11-14 Salon Business Intelligence, Montréal QC, Nov. 12

• • • •

cience Teacher’s Association of Ontario (STAO) Conference, S Toronto ON, Nov. 14-16 GIS Day, Sherbrooke QC, Nov. 20 CITIG Seven (The 7th Canadian Public Safety Interoperability Workshop), Vancouver BC, Nov. 24-26 Pacific Northwest Prepardeness Society Conference, Vancouver BC, Nov. 26-28

ining For complete tradeshow and conference details, visit esri.ca/events. Training Esri Canada is the only company in the country authorized to deliver Esri developed Technology Training. We offer a wide range of Traditional Classroom and Instructor-led Online options to meet your needs. Visit esri.ca/training to learn more and register. Whether you want to enhance your skills, ensure your knowledge is leading edge or take your career to the next level, the Esri Technical Certification program recognizes, develops and validates your expertise with Esri solutions. Visit esri.ca/certification to learn more.

26

| Fall 2013

ArcNorthNews

Every Industry, Every Need The global marketplace − business, government, energy, natural resources and health care − today is beginning to recognize the value of mapping business activity. Managers, executives and frontline staff can all benefit by using location analytics and map data. • • • • • • • •

Business intelligence (BI) Customer relationship management (CRM) Enterprise resource planning (ERP) Enterprise asset management (EAM) Real estate planning Field workforce management Risk management Operational awareness

Get started at: esri.ca/locationanalytics

27

| fall 2012

ArcNorthNews