{"id":931,"date":"2023-03-01T21:03:41","date_gmt":"2023-03-01T21:03:41","guid":{"rendered":"https:\/\/kpwalters.com\/?page_id=931"},"modified":"2023-08-12T01:28:05","modified_gmt":"2023-08-12T01:28:05","slug":"data-analyst","status":"publish","type":"page","link":"https:\/\/kpwalters.com\/index.php\/data-analyst\/","title":{"rendered":"Data analyst"},"content":{"rendered":"\n<div class=\"wp-block-uagb-container uagb-block-ff807ef5 alignfull uagb-is-root-container\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-0cbb530d\"><h4 class=\"uagb-heading-text\">Data analyst projects<\/h4><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-82dd4f9c alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-container uagb-block-802502c6\">\n<p><a href=\".\/election-analysis\">Data Journalism, election analysis<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-58e6cc33\">\n<p>An analysis of Presidential elections for the purpose of identifying \u201cswing\u201d voters.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-c89fda9b\"><\/div>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-27b2cb80 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-container uagb-block-c35fcb84\">\n<p><a href=\".\/uk-gender-pay-gap-project\">UK Gender Pay Gap project<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-cb1828b1\">\n<p>Creation of a local PostgreSQL database from the <a rel=\"noreferrer noopener\" href=\"https:\/\/gender-pay-gap.service.gov.uk\/\" target=\"_blank\">UK Gender Pay Gap<\/a> data.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-07135fb3\"><\/div>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-859c2fc9 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-container uagb-block-4461144d\">\n<p><a href=\".\/recursive-cte-project\">Recursive CTE project<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-8bb808f6\">\n<p>A demonstration of a recursive common table expression, applied to the Gender Pay Gap database in order to extract SIC codes and join to SIC code tables.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-bf839fa4\"><\/div>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-6655cd7a alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-container uagb-block-a384a053\">\n<p><a href=\".\/pricing-model\">Pricing model<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-1841f603\">\n<p>Demonstration of how to use Excel and regression lines in order to create an algorithm for pricing software licenses.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-fd89874d\"><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Data analyst projects Data Journalism, election analysis An analysis of Presidential elections for the purpose of identifying \u201cswing\u201d voters. UK Gender Pay Gap project Creation of a local PostgreSQL database from the UK Gender Pay Gap data. Recursive CTE project A demonstration of a recursive common table expression, applied to the Gender Pay Gap database &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/kpwalters.com\/index.php\/data-analyst\/\"> <span class=\"screen-reader-text\">Data analyst<\/span> Read More &raquo;<\/a><\/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":"default","site-content-layout":"page-builder","ast-global-header-display":"","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":"","footer-sml-layout":"","theme-transparent-header-meta":"enabled","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"kevin.p.walters@live.com","author_link":"https:\/\/kpwalters.com\/index.php\/author\/kevin-p-walterslive-com\/"},"uagb_comment_info":0,"uagb_excerpt":"Data analyst projects Data Journalism, election analysis An analysis of Presidential elections for the purpose of identifying \u201cswing\u201d voters. UK Gender Pay Gap project Creation of a local PostgreSQL database from the UK Gender Pay Gap data. Recursive CTE project A demonstration of a recursive common table expression, applied to the Gender Pay Gap database&hellip;","_links":{"self":[{"href":"https:\/\/kpwalters.com\/index.php\/wp-json\/wp\/v2\/pages\/931"}],"collection":[{"href":"https:\/\/kpwalters.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kpwalters.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kpwalters.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kpwalters.com\/index.php\/wp-json\/wp\/v2\/comments?post=931"}],"version-history":[{"count":13,"href":"https:\/\/kpwalters.com\/index.php\/wp-json\/wp\/v2\/pages\/931\/revisions"}],"predecessor-version":[{"id":1697,"href":"https:\/\/kpwalters.com\/index.php\/wp-json\/wp\/v2\/pages\/931\/revisions\/1697"}],"wp:attachment":[{"href":"https:\/\/kpwalters.com\/index.php\/wp-json\/wp\/v2\/media?parent=931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}