{"id":71,"date":"2023-11-16T15:56:59","date_gmt":"2023-11-16T15:56:59","guid":{"rendered":"https:\/\/johnthedataguy.com\/?page_id=71"},"modified":"2023-11-16T15:56:59","modified_gmt":"2023-11-16T15:56:59","slug":"my-portfolio","status":"publish","type":"page","link":"https:\/\/johnthedataguy.com\/index.php\/my-portfolio\/","title":{"rendered":"My Portfolio"},"content":{"rendered":"\n<p>Here&#8217;s a small sample of projects I&#8217;ve completed for clients:<\/p>\n\n\n\n<ol>\n<li style=\"line-height:2\">Built full suite of sales performance, inventory and payroll Power BI reports for sensor manufacturing company integrating Dynamics GP and SharePoint data.<\/li>\n\n\n\n<li style=\"line-height:2\">Set up Looker Studio marketing\/leads\/CRM dashboard integrating Google Analytics (GA4) and BigQuery data for non-profit newspaper client.<\/li>\n\n\n\n<li style=\"line-height:2\">Migrated a cyber and physical security company&#8217;s Dynamics 365 implementation from direct SQL connection to Azure Data Lake and re-built all reports in Power BI (Dynamics 365 data).<\/li>\n\n\n\n<li style=\"line-height:2\">Set up Looker Studio dashboard integrating e-commerce sales, marketing and CRM data from Google Analytics (GA4), Amazon Seller, Amazon Ads and Shopify for a UK-based spirits brand.<\/li>\n<\/ol>\n\n\n\n<p><br>and many, many more&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s a small sample of projects I&#8217;ve completed for clients: and many, many more&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/pages\/71"}],"collection":[{"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/comments?post=71"}],"version-history":[{"count":1,"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/pages\/71\/revisions"}],"predecessor-version":[{"id":72,"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/pages\/71\/revisions\/72"}],"wp:attachment":[{"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/media?parent=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}