Accessing and Analyzing Open Data Using Power Query

Power Query is perhaps the most useful but also most unknown of Microsoft programs. Ryan Yeung, Director of Performance Evaluation and Analytics, and Lori Lam, Data Analyst, from the Department of Citywide Administrative Services (DCAS) will demonstrate how to connect Power Query to the NYC Open Data and how to automate tedious Extract, Transform, Load (ETL) processes for use in Microsoft Excel or Microsoft PowerBI.