{"id":691,"date":"2025-08-14T12:32:42","date_gmt":"2025-08-14T12:32:42","guid":{"rendered":"http:\/\/www.databykatariina.com\/home\/"},"modified":"2026-04-04T13:08:57","modified_gmt":"2026-04-04T13:08:57","slug":"home","status":"publish","type":"page","link":"https:\/\/www.databykatariina.com\/","title":{"rendered":"Home"},"content":{"rendered":"\n<div class=\"wp-block-uagb-container uagb-block-abc2ec26 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-info-box uagb-block-08c0e953 uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-title-wrap\"><h1 class=\"uagb-ifb-title\">katariina rikkonen<\/h1><\/div><div class=\"uagb-ifb-button-wrapper wp-block-button\"><a href=\"#\" class=\"uagb-infobox-cta-link wp-block-button__link\" target=\"_self\" rel=\"noopener noreferrer\" onclick=\"return false;\"><span class=\"uagb-inline-editing\">Professional   Portfolio<\/span><\/a><\/div><\/div><\/div>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-layout-grid uagb-block-b5e7e8ee alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-info-box uagb-block-0fc90987 uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top wp-block-uagb-info-box--has-margin\" id=\"bio\"><div class=\"uagb-infobox-margin-wrapper\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-title-wrap\"><h5 class=\"uagb-ifb-title-prefix\">Biography<\/h5><h2 class=\"uagb-ifb-title\">thank you for visiting my portfolio<br><\/h2><\/div><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-info-box uagb-block-1f18b2e0 uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-title-wrap\"><\/div><p class=\"uagb-ifb-desc\">I am a Data &amp; GIS Analyst with an engineering background and over a decade of experience working with environmental, spatial, and infrastructure-related data.<br>\u00a0<br>I specialize in turning complex datasets into clear, decision-ready insights that support planning, monitoring, and operational improvement.<br>\u00a0<br>My work combines GIS, data analytics, and reporting to bridge the gap between technical data and real-world decision-making.<br>\u00a0<br><strong>I have experience working in public sector and infrastructure environments, where data quality, traceability, and structured reporting are essential.<br>\u00a0<br>I focus on delivering practical, actionable insights \u2014 not just dashboards.<\/strong><\/p><div class=\"uagb-ifb-button-wrapper wp-block-button\"><a href=\"#\" class=\"uagb-infobox-cta-link wp-block-button__link\" target=\"_self\" rel=\"noopener noreferrer\" onclick=\"return false;\"><span class=\"uagb-inline-editing\"><\/span><\/a><\/div><\/div><\/div>\n\n\n\n<p style=\"font-size:17px\">This website was designed and developed by me using WordPress, with custom CSS and layout adjustments.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-layout-grid uagb-block-355c401a alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-a9c66ba6\" id=\"skills\"><h5 class=\"uagb-heading-text\">SKILLS<\/h5><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-layout-flex uagb-block-d477b15d\">\n<div class=\"wp-block-uagb-info-box uagb-block-80f4f0a2 uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-title-wrap\"><\/div><p class=\"uagb-ifb-desc\">I am a Data &amp; GIS Analyst with an engineering background and over a decade of experience working with environmental, spatial, and infrastructure-related data.<br>&nbsp;<br>I specialize in turning complex datasets into clear, decision-ready insights that support planning, monitoring, and operational improvement.<br>&nbsp;<br>My work combines GIS, data analytics, and reporting to bridge the gap between technical data and real-world decision-making.<br>&nbsp;<br>I have experience working in public sector and infrastructure environments, where data quality, traceability, and structured reporting are essential.<br>&nbsp;<br>I focus on delivering practical, actionable insights \u2014 not just dashboards.<br><br>These tools support my approach to delivering structured, business-focused analytics solutions;<\/p><\/div><\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-layout-grid uagb-block-7b403dff alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-4280547b\" id=\"skills\"><h5 class=\"uagb-heading-text\">TOOLS<\/h5><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p style=\"font-size:18px\"><strong>Geospatial Analytic<\/strong>s<strong> &amp; Reporting<\/strong><\/p>\n\n\n\n<ul style=\"font-size:18px\" class=\"wp-block-list\">\n<li>ArcGIS Pro (Spatial analysis) <\/li>\n\n\n\n<li>Power BI (data modeling, DAX, KPI frameworks)<\/li>\n\n\n\n<li>Spatial reporting &amp; decision support<\/li>\n\n\n\n<li>Dashboard design &amp; data visualization<\/li>\n\n\n\n<li>Environmental &amp; Infrastructure data analysis<\/li>\n\n\n\n<li>Revenue, margin &amp; customer analytics<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p style=\"font-size:18px\"><strong>Data &amp; Technical Tools<\/strong><\/p>\n\n\n\n<ul style=\"font-size:18px\" class=\"wp-block-list\">\n<li>Python (data processing &amp; automation)<\/li>\n\n\n\n<li>SQL (data querying &amp; transformation)<\/li>\n\n\n\n<li>FME (data integration &amp; automation workflows)<\/li>\n\n\n\n<li>ArcGIS Pro<\/li>\n\n\n\n<li>API fundamentals<\/li>\n\n\n\n<li>Cloud fundamentals (AWS, Azure)<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p style=\"font-size:18px\"><strong>Operations &amp; Delivery<\/strong><\/p>\n\n\n\n<ul style=\"font-size:18px\" class=\"wp-block-list\">\n<li>KPI-based reporting frameworks<\/li>\n\n\n\n<li>Process optimization &amp; workflow design<\/li>\n\n\n\n<li>Stakeholder collaboration<\/li>\n\n\n\n<li>Technical documentation<\/li>\n\n\n\n<li>Cross-functional coordination<\/li>\n\n\n\n<li>Fluent in English<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n<div id=\"projects\" class=\"wp-block-uagb-container uagb-layout-grid uagb-block-51691200 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-8c06314e\" id=\"projects\"><h5 class=\"uagb-heading-text\">projects<\/h5><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-layout-flex uagb-block-fd22014f\">\n<div class=\"wp-block-uagb-info-box uagb-block-81dbda37 uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-title-wrap\"><\/div><p class=\"uagb-ifb-desc\">These selected portfolio projects demonstrates my approach to business analysis, data modeling, and performance-driven decision-making.<br>&nbsp;<br>Each case focuses on the business problem, analytical approach, and practical impact \u2014 not just the technical implementation.<br>&nbsp;<br>Across projects, I follow a consistent methodology:<br><br>\u2022 Define the business objective&nbsp;&nbsp;<br>\u2022 Structure and model the data&nbsp;&nbsp;<br>\u2022 Design meaningful performance metrics&nbsp;&nbsp;<br>\u2022 Translate insights into actionable decisions&nbsp;&nbsp;<br>&nbsp;<br>The goal is always the same: turning complex data into clear, decision-ready insights.<\/p><\/div><\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-1fe09c52 alignwide uagb-is-root-container\">\n<div class=\"wp-block-uagb-info-box uagb-block-a43c0aee uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-image-content\"><img decoding=\"async\" src=\"https:\/\/www.databykatariina.com\/wp-content\/uploads\/2025\/08\/Nayttokuva-2025-08-24-194721.png\" alt=\"\" width=\"\" height=\"0\" loading=\"lazy\"\/><\/div><div class=\"uagb-ifb-title-wrap\"><h3 class=\"uagb-ifb-title\"><br><a href=\"https:\/\/www.databykatariina.com\/?page_id=698\">WILDFIRES IN SPAIN \u2013 DATA PIPELINE &amp; WEB MAP<\/a><\/h3><\/div><p class=\"uagb-ifb-desc\"><br>Geospatial data pipeline transforming wildfire datasets into an interactive web map using FME and Leaflet.<br><br><a href=\"https:\/\/databykatariina.com\/wildfires\/index.html\"><strong>View interactive map<\/strong><\/a><strong><a href=\"https:\/\/github.com\/Katariina83\/team-coordination-case\"> <\/a><\/strong><strong><a href=\"https:\/\/github.com\/Katariina83\/team-coordination-case\">\u2192<\/a><\/strong><br><br><strong>Tools:<\/strong> <br>FME Form (ETL workflow, validation, filtering), GeometryValidator, AttributeManager, Leaflet, VS Code, WordPress hosting<br><br><strong>Focus:<\/strong> <br>Data transformation, spatial ETL, web map publishing, data validation<br><br><strong>Outcome:<br><\/strong>Automated workflow from raw shapefiles to a live interactive map<\/p><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-info-box uagb-block-161fd2dc uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-image-content\"><img decoding=\"async\" src=\"https:\/\/www.databykatariina.com\/wp-content\/uploads\/2026\/04\/team-coordination-case-showcase-scaled-e1775293061587.png\" alt=\"\" width=\"\" height=\"0\" loading=\"lazy\"\/><\/div><div class=\"uagb-ifb-title-wrap\"><h3 class=\"uagb-ifb-title\"><br><a href=\"https:\/\/www.databykatariina.com\/?page_id=2\" data-type=\"page\" data-id=\"2\">security service operations performance analytics<\/a><\/h3><\/div><p class=\"uagb-ifb-desc\"><br>Operational performance analysis of a field service organization, focusing on technician efficiency and job complexity.<br><br><a href=\"https:\/\/www.databykatariina.com\/?page_id=2\" data-type=\"page\" data-id=\"2\"><strong>Explore the full project<\/strong><\/a> <strong><a href=\"https:\/\/github.com\/Katariina83\/team-coordination-case\">\u2192<\/a><\/strong><br><br><strong>Tools<\/strong>: <br>Python, SQL (SQLite), Power BI, DAX<br><br><strong>Focus<\/strong>:<br>Performance analysis and dashboard revealing key parformance drivers<\/p><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-info-box uagb-block-66496342 uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top wp-block-uagb-info-box--has-margin\"><div class=\"uagb-infobox-margin-wrapper\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-image-content\"><img decoding=\"async\" src=\"https:\/\/www.databykatariina.com\/wp-content\/uploads\/2026\/04\/fashion-ecom-presentation-scaled-e1775293309368.gif\" alt=\"\" width=\"\" height=\"0\" loading=\"lazy\"\/><\/div><div class=\"uagb-ifb-title-wrap\"><h3 class=\"uagb-ifb-title\"><br><a href=\"https:\/\/www.databykatariina.com\/?page_id=696\" data-type=\"page\" data-id=\"696\">FASHION E-COMMERCE PERFORMANCE &amp; CUSTOMER INTELLIGENCE<\/a><\/h3><\/div><p class=\"uagb-ifb-desc\"><br>Business analysis of customer behavior and revenue drivers in an e-commerce environment.<br><br><a href=\"https:\/\/www.databykatariina.com\/?page_id=696\" data-type=\"page\" data-id=\"696\"><strong>Explore the full project<\/strong><\/a> <strong><a href=\"https:\/\/github.com\/Katariina83\/team-coordination-case\">\u2192<\/a><\/strong><br><br><strong>Tools:<\/strong><br>&nbsp;Python, Power BI, DAX<br><br><strong>Focus:<\/strong><br><strong>&nbsp;<\/strong>Customer segmentation, revenue analysis, AOV, retention<br><br><strong>Outcome:<\/strong><br>Executive-level insights into customer performance and growth opportunities<\/p><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-info-box uagb-block-99883d29 uagb-infobox__content-wrap  uagb-infobox-icon-above-title uagb-infobox-image-valign-top wp-block-uagb-info-box--has-margin\"><div class=\"uagb-infobox-margin-wrapper\"><div class=\"uagb-ifb-content\"><div class=\"uagb-ifb-image-content\"><img decoding=\"async\" src=\"https:\/\/www.databykatariina.com\/wp-content\/uploads\/2026\/04\/Smart-Alarm-Business-Performance-Dashboard-scaled-e1775293438999.jpg\" alt=\"\" width=\"\" height=\"0\" loading=\"lazy\"\/><\/div><div class=\"uagb-ifb-title-wrap\"><h3 class=\"uagb-ifb-title\"><br><a href=\"https:\/\/www.databykatariina.com\/?page_id=694\">Smart alarm &#8211; business performance dashboard<\/a><br><\/h3><\/div><p class=\"uagb-ifb-desc\">End-to-end development of a KPI dashboard for a subscription-based security business.<br><br><a href=\"https:\/\/www.databykatariina.com\/?page_id=694\" data-type=\"page\" data-id=\"694\"><strong>Explore the full project<\/strong><\/a> <strong><a href=\"https:\/\/github.com\/Katariina83\/team-coordination-case\">\u2192<\/a><\/strong><br><br><strong>Tools:<\/strong> <br>Python, Power BI, DAX<br><br><strong>Focus<\/strong>:<br>KPI modeling, churn analysis, revenue tracking, data validation<br><br><strong>Outcome:<\/strong><br>Decision-ready dashboard supporting performance monitoring and growth analysis<\/p><\/div><\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\" style=\"border-style:none;border-width:0px\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<div class=\"wp-block-uagb-buttons uagb-buttons__outer-wrap uagb-btn__default-btn uagb-btn-tablet__default-btn uagb-btn-mobile__default-btn uagb-block-36f374e1\"><div class=\"uagb-buttons__wrap uagb-buttons-layout-wrap \">\n<div class=\"wp-block-uagb-buttons-child uagb-buttons__outer-wrap uagb-block-9b6a3e79 wp-block-button #scrollTopBtn {  display: none; position: fixed; bottom: 40px; right: z-index: 1000; font-size: 22px; background: #4CAF50; color: white; border: outline: padding: 12px 16px; border-radius: 50%; cursor: pointer; transition: 0.3s; } #scrollTopBtn:hover #333;\"><div class=\"uagb-button__wrapper\"><a class=\"uagb-buttons-repeater wp-block-button__link\" aria-label=\"up\" href=\"#\" rel=\"follow noopener\" target=\"_self\" role=\"button\"><span class=\"uagb-button__icon uagb-button__icon-position-after\"><svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 448 512\" aria-hidden=\"true\" focussable=\"false\"><path d=\"M323.5 51.25C302.8 70.5 284 90.75 267.4 111.1C240.1 73.62 206.2 35.5 168 0C69.75 91.12 0 210 0 281.6C0 408.9 100.2 512 224 512s224-103.1 224-230.4C448 228.4 396 118.5 323.5 51.25zM304.1 391.9C282.4 407 255.8 416 226.9 416c-72.13 0-130.9-47.73-130.9-125.2c0-38.63 24.24-72.64 72.74-130.8c7 8 98.88 125.4 98.88 125.4l58.63-66.88c4.125 6.75 7.867 13.52 11.24 19.9C364.9 290.6 353.4 357.4 304.1 391.9z\"><\/path><\/svg><\/span><\/a><\/div><\/div>\n<\/div><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This website was designed and developed by me using WordPress, with custom CSS and layout adjustments. SKILLS TOOLS Geospatial Analytics &amp; Reporting Data &amp; Technical Tools Operations &amp; Delivery projects<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"full-width-container","site-content-style":"unboxed","site-sidebar-style":"unboxed","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"enabled","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-691","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/www.databykatariina.com\/?author=1"},"uagb_comment_info":0,"uagb_excerpt":"This website was designed and developed by me using WordPress, with custom CSS and layout adjustments. SKILLS TOOLS Geospatial Analytics &amp; Reporting Data &amp; Technical Tools Operations &amp; Delivery projects","_links":{"self":[{"href":"https:\/\/www.databykatariina.com\/index.php?rest_route=\/wp\/v2\/pages\/691","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.databykatariina.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.databykatariina.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.databykatariina.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.databykatariina.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=691"}],"version-history":[{"count":191,"href":"https:\/\/www.databykatariina.com\/index.php?rest_route=\/wp\/v2\/pages\/691\/revisions"}],"predecessor-version":[{"id":2649,"href":"https:\/\/www.databykatariina.com\/index.php?rest_route=\/wp\/v2\/pages\/691\/revisions\/2649"}],"wp:attachment":[{"href":"https:\/\/www.databykatariina.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}