4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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
Presented by Lee Hawthorn at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    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.
  • Video
    The video is not available to view online.