{"id":5651,"date":"2024-02-28T20:08:44","date_gmt":"2024-02-28T20:08:44","guid":{"rendered":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/?page_id=5651"},"modified":"2024-03-06T16:47:02","modified_gmt":"2024-03-06T16:47:02","slug":"francesca-koron","status":"publish","type":"page","link":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/","title":{"rendered":"Francesca Koron"},"content":{"rendered":"<!--themify_builder_content-->\n<div id=\"themify_builder_content-5651\" data-postid=\"5651\" class=\"themify_builder_content themify_builder_content-5651 themify_builder tf_clear\">\n                    <div  data-lazy=\"1\" class=\"module_row themify_builder_row dropPadding-bottom tb_0l52602 tb_first tf_w\">\n                        <div class=\"row_inner col_align_top tb_col_count_2 tf_box tf_rel\">\n                        <div  data-lazy=\"1\" class=\"module_column tb-column col4-1 tb_0ygc603 first\">\n                    <!-- module image -->\n<div  class=\"module module-image tb_esex603 image-top   tf_mw\" data-lazy=\"1\">\n        <div class=\"image-wrap tf_rel tf_mw\">\n            <img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2024\/03\/Francesca_Koron.jpg\" class=\"wp-post-image wp-image-5955\" title=\"Francesca Koron\" alt=\"Francesca Koron\" srcset=\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2024\/03\/Francesca_Koron.jpg 300w, https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2024\/03\/Francesca_Koron-150x150.jpg 150w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/>    \n        <\/div>\n    <!-- \/image-wrap -->\n    \n        <div class=\"image-content\">\n                    <h3 class=\"image-title\">\n                                    Francesca Koron                            <\/h3>\n                    <\/div>\n    <!-- \/image-content -->\n        <\/div>\n<!-- \/module image -->        <\/div>\n                    <div  data-lazy=\"1\" class=\"module_column tb-column col4-3 tb_g2w3604 last\">\n                    <!-- module text -->\n<div  class=\"module module-text tb_t7c7604   \" data-lazy=\"1\">\n        <div  class=\"tb_text_wrap\">\n        <h1>Francesca Koron<\/h1>\n<h5>Business Analytics Manager at Durst Image Technology<\/h5>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module accordion -->\n<div  class=\"module module-accordion tb_2plz358 \" data-behavior=\"toggle\" data-lazy=\"1\">\n    \n    <ul class=\"ui module-accordion  glossy tb_default_color\">\n            <li>\n            <div class=\"accordion-title tf_rel\">\n                <a href=\"#acc-2plz358-0\" class=\"tb_title_accordion\" aria-controls=\"acc-2plz358-0-content\" aria-expanded=\"false\">\n                    <i class=\"accordion-icon\"><svg  class=\"tf_fa tf-ti-plus\" aria-hidden=\"true\"><use href=\"#tf-ti-plus\"><\/use><\/svg><\/i>                    <i class=\"accordion-active-icon tf_hide\"><svg  class=\"tf_fa tf-ti-minus\" aria-hidden=\"true\"><use href=\"#tf-ti-minus\"><\/use><\/svg><\/i>                    <span class=\"accordion-title-wrap\">Bio<\/span>                <\/a>\n            <\/div><!-- .accordion-title -->\n            <div id=\"acc-2plz358-0-content\" data-id=\"acc-2plz358-0\" aria-hidden=\"true\" class=\"accordion-content tf_hide tf_clearfix\">\n                                    <div class=\"tb_text_wrap\">\n                        <p>MBA in Finance and Computer Information Systems from University of Rochester William E Simon School of Business Administration. Information Systems consultant specializing in database design and desktop reporting applications from 1990-2009.\u00a0 Founder of Lionsgait Solutions Group based in Rochester NY.\u00a0 With Durst Image Technology as Business Analytics Manager since 2013, focusing on creating and improving reporting, data analysis, data visualizations, and optimization tools.<\/p>                    <\/div>\n                            <\/div><!-- .accordion-content -->\n        <\/li>\n        <\/ul>\n\n<\/div><!-- \/module accordion -->        <\/div>\n                        <\/div>\n        <\/div>\n                        <div  data-css_id=\"u6fe602\" data-lazy=\"1\" class=\"module_row themify_builder_row fullwidth_row_container tb_u6fe602 tf_w\">\n                        <div class=\"row_inner col_align_top tb_col_count_1 tf_box tf_rel\">\n                        <div  data-lazy=\"1\" class=\"module_column tb-column col-full tb_84q1605 first\">\n                    <!-- module text -->\n<div  class=\"module module-text tb_k572608 track  \" data-lazy=\"1\">\n        <div  class=\"tb_text_wrap\">\n        <h6>Track: Logistics<\/h6>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_xwmz608   \" data-lazy=\"1\">\n        <div  class=\"tb_text_wrap\">\n        <h2>Integrating Technician Scheduling: A Microsoft VBA Approach<\/h2>\n<p>Durst Image Technology has several hundred large scale digital printers installed throughout the United States and Canada. Durst employs roughly fifty service technicians across the country who provide installation and break-fix support services. The scheduling process sending technicians to printers requiring service was manually intensive and time consuming. It was also difficult to take all of the scheduling factors into account and to determine the optimal technician to service ticket schedule.<\/p>\n<p>The Durst Analytics Team designed and developed the Dispatch Scheduling Tool to assist in establishing the daily technician schedule. The tool creates scenarios matching technicians to requested service locations based on technician availability, technician skill levels, skill level requests, and travel distance.<\/p>\n<p>The presentation introduces the creation of the logic used to implement this tool in Microsoft Access and Microsoft SQL-Server. The presentation will also explore output functions into visualization tools such as Tableau.<\/p>    <\/div>\n<\/div>\n<!-- \/module text -->        <\/div>\n                        <\/div>\n        <\/div>\n        <\/div>\n<!--\/themify_builder_content-->","protected":false},"excerpt":{"rendered":"<p>Francesca Koron Business Analytics Manager at Durst Image Technology<\/p>\n","protected":false},"author":1001140,"featured_media":0,"parent":712,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"class_list":["post-5651","page","type-page","status-publish","hentry","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.0 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Francesca Koron - 2024 INFORMS Analytics Conference<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Francesca Koron\" \/>\n<meta property=\"og:description\" content=\"Francesca Koron Business Analytics Manager at Durst Image Technology\" \/>\n<meta property=\"og:url\" content=\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/\" \/>\n<meta property=\"og:site_name\" content=\"2024 INFORMS Analytics Conference\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/INFORMSpage\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-06T16:47:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2023\/11\/analytics-2024-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"414\" \/>\n\t<meta property=\"og:image:height\" content=\"414\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@2023_Analytics\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/\",\"url\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/\",\"name\":\"Francesca Koron - 2024 INFORMS Analytics Conference\",\"isPartOf\":{\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#website\"},\"datePublished\":\"2024-02-28T20:08:44+00:00\",\"dateModified\":\"2024-03-06T16:47:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Speakers\",\"item\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Francesca Koron\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#website\",\"url\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/\",\"name\":\"2024 INFORMS Analytics Conference\",\"description\":\"Orlando, FL | April 14-16, 2024\",\"publisher\":{\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#organization\",\"name\":\"INFORMS\",\"url\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2022\/03\/INFORMS_Logo_full_color.jpg\",\"contentUrl\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2022\/03\/INFORMS_Logo_full_color.jpg\",\"width\":300,\"height\":72,\"caption\":\"INFORMS\"},\"image\":{\"@id\":\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/INFORMSpage\/\",\"https:\/\/x.com\/2023_Analytics\",\"http:\/\/instagram.com\/informs_orms\",\"https:\/\/www.linkedin.com\/groups\/82644\/profile\",\"https:\/\/www.pinterest.com\/informs\/_saved\/\",\"https:\/\/www.youtube.com\/user\/INFORMSonline\",\"https:\/\/en.wikipedia.org\/wiki\/Institute_for_Operations_Research_and_the_Management_Sciences\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Francesca Koron - 2024 INFORMS Analytics Conference","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/","og_locale":"en_US","og_type":"article","og_title":"Francesca Koron","og_description":"Francesca Koron Business Analytics Manager at Durst Image Technology","og_url":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/","og_site_name":"2024 INFORMS Analytics Conference","article_publisher":"https:\/\/www.facebook.com\/INFORMSpage\/","article_modified_time":"2024-03-06T16:47:02+00:00","og_image":[{"width":414,"height":414,"url":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2023\/11\/analytics-2024-logo.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@2023_Analytics","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/","url":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/","name":"Francesca Koron - 2024 INFORMS Analytics Conference","isPartOf":{"@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#website"},"datePublished":"2024-02-28T20:08:44+00:00","dateModified":"2024-03-06T16:47:02+00:00","breadcrumb":{"@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/francesca-koron\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/"},{"@type":"ListItem","position":2,"name":"Speakers","item":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/speakers\/"},{"@type":"ListItem","position":3,"name":"Francesca Koron"}]},{"@type":"WebSite","@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#website","url":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/","name":"2024 INFORMS Analytics Conference","description":"Orlando, FL | April 14-16, 2024","publisher":{"@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#organization","name":"INFORMS","url":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#\/schema\/logo\/image\/","url":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2022\/03\/INFORMS_Logo_full_color.jpg","contentUrl":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2022\/03\/INFORMS_Logo_full_color.jpg","width":300,"height":72,"caption":"INFORMS"},"image":{"@id":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/INFORMSpage\/","https:\/\/x.com\/2023_Analytics","http:\/\/instagram.com\/informs_orms","https:\/\/www.linkedin.com\/groups\/82644\/profile","https:\/\/www.pinterest.com\/informs\/_saved\/","https:\/\/www.youtube.com\/user\/INFORMSonline","https:\/\/en.wikipedia.org\/wiki\/Institute_for_Operations_Research_and_the_Management_Sciences"]}]}},"builder_content":"<img src=\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2024\/03\/Francesca_Koron.jpg\" title=\"Francesca Koron\" alt=\"Francesca Koron\" srcset=\"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2024\/03\/Francesca_Koron.jpg 300w, https:\/\/meetings.informs.org\/wordpress\/analytics2024\/files\/2024\/03\/Francesca_Koron-150x150.jpg 150w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/> <h3> Francesca Koron <\/h3>\n<h1>Francesca Koron<\/h1> <h5>Business Analytics Manager at Durst Image Technology<\/h5>\n<ul><li><h4>Bio<\/h4><p>MBA in Finance and Computer Information Systems from University of Rochester William E Simon School of Business Administration. Information Systems consultant specializing in database design and desktop reporting applications from 1990-2009.\u00a0 Founder of Lionsgait Solutions Group based in Rochester NY.\u00a0 With Durst Image Technology as Business Analytics Manager since 2013, focusing on creating and improving reporting, data analysis, data visualizations, and optimization tools.<\/p><\/li><\/ul>\n<h6>Track: Logistics<\/h6>\n<h2>Integrating Technician Scheduling: A Microsoft VBA Approach<\/h2> <p>Durst Image Technology has several hundred large scale digital printers installed throughout the United States and Canada. Durst employs roughly fifty service technicians across the country who provide installation and break-fix support services. The scheduling process sending technicians to printers requiring service was manually intensive and time consuming. It was also difficult to take all of the scheduling factors into account and to determine the optimal technician to service ticket schedule.<\/p> <p>The Durst Analytics Team designed and developed the Dispatch Scheduling Tool to assist in establishing the daily technician schedule. The tool creates scenarios matching technicians to requested service locations based on technician availability, technician skill levels, skill level requests, and travel distance.<\/p> <p>The presentation introduces the creation of the logic used to implement this tool in Microsoft Access and Microsoft SQL-Server. The presentation will also explore output functions into visualization tools such as Tableau.<\/p>","_links":{"self":[{"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/pages\/5651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/users\/1001140"}],"replies":[{"embeddable":true,"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/comments?post=5651"}],"version-history":[{"count":3,"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/pages\/5651\/revisions"}],"predecessor-version":[{"id":5957,"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/pages\/5651\/revisions\/5957"}],"up":[{"embeddable":true,"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/pages\/712"}],"wp:attachment":[{"href":"https:\/\/meetings.informs.org\/wordpress\/analytics2024\/wp-json\/wp\/v2\/media?parent=5651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}