{"id":7,"date":"2023-11-13T15:08:05","date_gmt":"2023-11-13T15:08:05","guid":{"rendered":"https:\/\/johnthedataguy.com\/?page_id=7"},"modified":"2023-11-16T14:17:39","modified_gmt":"2023-11-16T14:17:39","slug":"about","status":"publish","type":"page","link":"https:\/\/johnthedataguy.com\/index.php\/about\/","title":{"rendered":"About John the Data Guy"},"content":{"rendered":"\n

Hey there! <\/p>\n\n\n\n

I’m John, a data visualization, analytics and business intelligence (BI) developer with experience in building Power BI, Looker Studio and Tableau dashboards, reports and visualizations.<\/p>\n\n\n\n

I started my journey with analytics and BI as part of my full-time job a little over 4 years ago, with Tableau and Power BI. Since then, I’ve deepened and broadened my skillset considerably, and now my experience includes things like scripting, automation, data engineering and more (see more details below).<\/p>\n\n\n\n

I’m also a Product Manager by trade, so I understand the importance of effective prioritization and time management, and of building for a User Experience (UX) that clients adore.<\/p>\n\n\n\n

I have built reports and dashboards for clients on a wide variety of data sources, including but not limited to:<\/p>\n\n\n\n

Marketing, Ads and E-Commerce<\/span><\/strong><\/h4>\n\n\n\n
    \n
  • Google Analytics (both UA and GA4)<\/li>\n\n\n\n
  • Google Ads<\/li>\n\n\n\n
  • LinkedIn Ads<\/li>\n\n\n\n
  • Facebook Ads<\/li>\n\n\n\n
  • Amazon Seller<\/li>\n\n\n\n
  • Amazon Ads<\/li>\n\n\n\n
  • Active Campaign<\/li>\n\n\n\n
  • ShareASale<\/li>\n\n\n\n
  • Ascend<\/li>\n\n\n\n
  • Impact CRM<\/li>\n<\/ul>\n\n\n\n

    ERP and Financial systems<\/strong><\/span><\/h4>\n\n\n\n
      \n
    • HubSpot<\/li>\n\n\n\n
    • Salesforce<\/li>\n\n\n\n
    • MS Dynamics 365<\/li>\n\n\n\n
    • MS Dynamics GP<\/li>\n\n\n\n
    • Netsuite<\/li>\n\n\n\n
    • Workfront<\/li>\n<\/ul>\n\n\n\n

      Databases and Data warehouses<\/span><\/strong><\/h4>\n\n\n\n
        \n
      • SQL Server<\/li>\n\n\n\n
      • MS Excel<\/li>\n\n\n\n
      • Google BigQuery<\/li>\n\n\n\n
      • PostgreSQL<\/li>\n\n\n\n
      • Google Sheets<\/li>\n\n\n\n
      • MS Access<\/li>\n\n\n\n
      • Azure SQL<\/li>\n\n\n\n
      • Azure Data Lake<\/li>\n<\/ul>\n\n\n\n

        Other<\/span><\/strong> <\/h4>\n\n\n\n
          \n
        • Custom API connections<\/li>\n\n\n\n
        • GIS data<\/li>\n\n\n\n
        • SharePoint<\/li>\n\n\n\n
        • CSV<\/li>\n\n\n\n
        • PDF<\/li>\n\n\n\n
        • And many more…<\/li>\n<\/ul>\n\n\n\n

          In terms of tools, here’s what I have experience in:<\/p>\n\n\n\n

          Data Visualization & Business Intelligence<\/span><\/strong><\/h4>\n\n\n\n
            \n
          • Power BI<\/li>\n\n\n\n
          • Tableau<\/li>\n\n\n\n
          • Looker Studio (formerly Google Data Studio)<\/li>\n\n\n\n
          • Qlik<\/li>\n\n\n\n
          • ThoughtSpot<\/li>\n<\/ul>\n\n\n\n

            Scripting & Automation<\/span><\/h4>\n\n\n\n
              \n
            • Python<\/li>\n\n\n\n
            • Google Apps Script<\/li>\n\n\n\n
            • Power Automate<\/li>\n<\/ul>\n\n\n\n

              Data Engineering (Storage, Cleaning, Wrangling, etc.)<\/span><\/strong><\/h4>\n\n\n\n
                \n
              • Google BigQuery<\/li>\n\n\n\n
              • SQL (MySQL, SQL Server, PostgreSQL, Amazon RDS, etc.)<\/li>\n\n\n\n
              • Excel<\/li>\n\n\n\n
              • Power Query\/M<\/li>\n<\/ul>\n\n\n\n

                Other<\/span><\/strong><\/h4>\n\n\n\n
                  \n
                • AWS<\/li>\n\n\n\n
                • GCP<\/li>\n\n\n\n
                • WordPress<\/li>\n\n\n\n
                • JavaScript<\/li>\n\n\n\n
                • HTML\/CSS<\/li>\n\n\n\n
                • Postman<\/li>\n<\/ul>\n\n\n\n

                  I do well with both well-defined projects with detailed requirements and vague, ambiguous business problems that need both a creative mind and concrete data skills to tackle.<\/p>\n\n\n\n

                  Would love to chat about your next project!<\/p>\n","protected":false},"excerpt":{"rendered":"

                  Hey there! I’m John, a data visualization, analytics and business intelligence (BI) developer with experience in building Power BI, Looker Studio and Tableau dashboards, reports and visualizations. I started my journey with analytics and BI as part of my full-time job a little over 4 years ago, with Tableau and Power BI. Since then, I’ve […]<\/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\/7"}],"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=7"}],"version-history":[{"count":4,"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/pages\/7\/revisions"}],"predecessor-version":[{"id":55,"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/pages\/7\/revisions\/55"}],"wp:attachment":[{"href":"https:\/\/johnthedataguy.com\/index.php\/wp-json\/wp\/v2\/media?parent=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}