Andy’s Neural Works

A wise folly can lead to great things!


  • Screen Estate (iPad Upgrade)

    Recently, I decided to upgrade my 1st Gen 11” iPad Pro (64GB – WiFi Only) to the newest iPad Pro. There is still a good trade-in value on that 1st Gen so I decided to get an upgrade. Plus, I want to experiment more with alternative workstations. Remember when I talked about generalization vs specialization?

    Read more

  • The Importance of Specifications

    Why do you need a functional spec when you can just “wing it?”

    Read more

  • Recently, Microsoft released a learning series for the programming language Python on YouTube. It is targeted specifically as an introduction to those wanting to learn this popular language.  Having knowledge of Python (in a data analysis arena), made me want to give it a go. I want to see if there are some parts of

    Read more

  • This article goes over a simple technique of banding a data set after importing into SQL Server.

    Read more

  • A Source to Target Map is a blueprint for putting together your systems. This is where you will build out the contract for how data will flow into (and/or out of) your system. This posting will go into the basics of creating that data contract.

    Read more

  • Control Your ETL

    In the world of ETL (Extract, Transform, and Load), there are many ways to get from point A to point B. The coding direction you take all depends on what you are trying to end on. Are you going for a data warehouse structure, a data lake, or a generalized system? You might be loading

    Read more

  • Introduction Whenever a new stream of data comes onto the work scene, it is rarely in a form that is ready to be loaded into a final target table. It is often in the form of a report, where the set might be pivoted and summarized. There will be groaning but it is fine as

    Read more

  • The Task For a while now, I have read that you can install SQL Server 2017 Linux Edition on a Mac. Since macOS is a Unix based OS, this makes it very plausible that everything will work. I have wanted to try it out on my MBP. Now that I have started a blog, this

    Read more

  • Let Us Begin

    Introduction

    Read more