Presentation: Self-Service Data Integration with Power Query
Discover, Load, Transform and Mashup. Microsoft Power Query for Excel includes a powerful query engine and a formula language that enables self-service data integration and shaping over a diverse set of data sources. Power Query makes it possible for analysts to do basic ETL by themselves without much help from the IT department. Most common tasks can be accomplished within an intuitive user interface, but a powerful language called “M” can also be used to do some pretty sophisticated data preparation work. Come learn how to succeed and tackle your data and data-shaping needs.
SQL Server MVP, Stéphane Fréchette is a Database & Business Intelligence Professional who is very passionate about architecting, designing and building solutions that matter. Specialized in SQL Server, the Microsoft BI Stack, Data Visualization and the Cloud, he also works and his fluent with several other database platforms (NoSQL, MySQL, Oracle, PostgreSQL) as well as several application development platforms. A self proclaimed Open Data Hacker/Advocate Stéphane founded Gatineau Ouverte a citizen led initiative which aims to promote open access to civic data of the city of Gatineau and his the licensee and organizer of TEDxGatineau.
Twitter: @sfrechette (https://twitter.com/sfrechette)
Blog: http://stephanefrechette.com (http://stephanefrechette.com/)