How does one access the Advanced Analytics? Is it a separate EXE or part of the Professional download?
The Advanced Analytics feature is not a seperate install. Use the Editor or the Query Builder to compose or build statements using the Advanced Analytics functions. These functions are available through code completion in the Editor or when building a Where condition or calculated column in the Query Builder (with a Local Storage connection). Or one can use the Code Snippets.
The following video demonstrates how to use Advanced Analytics: