I'd like to revisit an old article which is still very relevant today. Thanks to Jen Underwood in SQL Server BI Blog for this amazing article.
Love it or hate it, export to Excel is still the most specified requirement in contemporary analytic tool selections, despite all the advances in business intelligence (BI) technologies. Excel is comfortable, flexible and with the new Microsoft Office 365 Excel Power BI add-ins (Power Query, Power Pivot, and Power Map), it's growing to become exponentially more powerful—pun intended. With the latest Microsoft strategy shift of embedding self-service BI applications right within Excel, could Microsoft's Excel Power BI release become a BI "killer app?"
Ian Littlejohn worked as a Management Consultant for 15 years and is passionate about teaching business people to analyze data and understand business data.