Ad hoc data integration with Power Query
In this demo heavy session you'll learn how Power Query can fill in the day to day requirements for data integration that we're increasingly seeing as data moves to the cloud.
We'll take a typical business scenario and apply Power Query to source and transform data held on premise and in 3rd party web applications.
1. Use cases for ad-hoc data integration
2. Introduction to Power Query
3. Alphabet Soup and M
4. Acquiring XML using Restful services
5. So what about SSIS
Sorry, there are no downloads available for this session.
Lee started his career as a software engineer, it was during this time he caught the database bug.
Sometime later Lee flipped over to Finance and joined the Chartered Institute of Management Accountants where he caught the Excel bug
He actively encourages and promotes the use of databases to his fellow Finance professionals and has participated in numerous BI projects with the Microsoft stack.
The video is not available to view online.