Advice I would give anyone on working in Data & Analytics

September 18, 2020
directives, data, analytics

Intro # This is just a small collection of my frequently given advice to young or newer members of the analytics industry. If nothing else - I’d start with this: Data Analysis exists as a scientific exploration for the purpose of driving value for it’s audience. That value can be defined as a simple aggregation of observations or, hopefully, to drive better decision making. Everything else you do will become useless if the root goal is lost: Drive value through analytical insight. ...

DQ with Enterprise Gateway for PostgreSQL

July 27, 2019
directquery, enterprisegateway, gateway, customconnector, odbc, analytics

Table of Contents # TLDR ODBC DSN Installing and Managing a Personal vs. Enterprise Gateway Direct Query / Custom Connector settings for Custom Connectors PowerShell Module Service Setup TLDR # This is to establish how to take the connector that you setup in my previous post: [DirectQuery Postgres How-To] ( /posts/directquery-postgres-howto/) And utilize that service to run on an enterprise gateway. ...

DQ with Postgres from PowerBI Desktop

June 15, 2019
directquery, postgres, customconnector, odbc, analytics

Table of Contents # TLDR Postgres DSN Custom Connector for ODBC DirectQuery Enterprise Gateway ** Safety Briefing, this being a PowerBI custom connector, this is entirely focused on a Windows centric walkthrough as I’m not currently working with either a Linux or Mac OS environment. Not discriminating, just not available to me at this time. ** TLDR # I was recently put in the situation of finding a way to reduce refresh time on a PowerBi embedded instance. ...