4 Jan 2018 · Thu 7:00 PM-9:00 PM
7F, 40 Bonham Strand, Sheung Wan, Hong Kong naked HUB Sheung Wan
Power Query has been around since 2010. It is a very powerful tool that lets you handle large set of data from different sources (SQL, Azure, Hadoop, CSV, Web etc...). You can easily write sequence to Extract, Transform and Load data into data model.
Come join your instructor Steven Correy. He will show you how you can easily combine Excel with Power Query to build a Portfolio monitoring tool. You will learn how you can data from financial website and refresh the data from Excel directly.