September 18, 2020
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.
July 27, 2019
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.
June 15, 2019
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.