Microsoft has PowerBI which is already almost magic for many business users with it's ease of connectability with different databases and SaaS services. Transformations, parsing, mixing data from different sources and reporting capabilities are also easy to start with and quite powerful in the right hands. It's not integrated into Excel directly but sits quite well imho in the MS ecosystem.