Those trained in SSAS may cringe a bit, but a curious thought entered my mind. Many organizations start using data warehouse structure with fact and dimension tables, but never make it to the 'cube' state--actually using analysis services. Admittedly, I don't use SSAS and the occasional reprocessing of a cube or dimension is about my only experience. When Trey Johnson, our guest for this episode, wanted to chat about SSAS, I thought this would be interesting to get his perspective on using SSAS, the future of the service, and how PowerBI just might make it much more accessible.
The show notes for today's episode can be found at http://sqldatapartners.com/2018/11/1/episode-152-do-you-use-analysis-services. Have fun on the SQL Trail!