I'm a long-time Excel pro (mostly Pivots/Tables) and lately I've been using Power BI Desktop as a complement to Excel 2016's integrated Power Query/Power Pivot. However I was confused at first about the various "Power" components and where all the parts fit, so I took some time to research the current product line and integration points. I've put together a short presentation to try and map this and I'd love to get feedback on it in case there are some missing parts or mistakes:
http://www.slideshare.net/oliviertravers/microsoft-power-stack-2017
More than anything I wanted to clarify my own thinking in terms of what products I should spend time learning and pitching to clients. I mostly work in the online marketing/sales/publishing world where it's all about SaaS (Google Analytics, Salesforce, Hubspot, Marketo, Mailchimp, Drip, etc.), which is why I've left the whole on-remises SQL world out of my slides. In this world I see demand for online dashboard tools such as Klipfolio, Geckoboard, Google Data Studio, (and countless others like them) but I really like pivots and working at desktop speed, hence my continued interest in the Microsoft stack. And Microsoft has been moving much faster than usual in this space lately, so it's hard to keep up.
I'd love to hear from other people with a similar background and focus,
