I would assume it's pretty straight forward like a snowflake schema, but this is SSAS afterall. I don't work with it that much.

In most of my cases, I...

I can help give some insight into the whether or not moving into BI Dev is a good career or not.

I personally think the business intelligence and or...

Azure Data Warehouse one would be good too if not one already.

I use SQL Prompt for most everything. I have custom stuff in it to that I share with the team to keep us on the same page. It's really beneficial.

Sure. 

What you will want to do is build a service app that is basically a Python script that builds a service object (authenticates) with the Google API you...

Not sure what you need here. Both of these Google products have ways to call down the data via REST. You make a script using something like Python to make...

I totally bought a badass loud mechanical keyboard. Unboxing it at work, everyone got crazy jealous. 

I would do it again.

I take it that putting a layer between the user and the data warehouse is not an option? If it is an option, why not go the data mart road...

I don't mean to make it so black and white. I agree they are very complementary.