Data Querying and Wrangling: Power Query and ChatGPT Integration

About This Course

This module will focus on the use of the “Power Query” module within Microsoft Excel to engineer, or “wrangle”, data in its passage between the data source and the database. The objective is to tackle an increasingly important challenge in any analytics scenario, which is "how do I move and shape a diverse array of dynamic datasets from disparate sources". The approach taken in this module will be to stream a wide variety of data into Microsoft Excel table structures, using its “Get Data” and “Power Query” features. This learning will take the form of teamwork centred on a series of escalating data wrangling challenges taken from real-world scenarios. The application of third-party data via Application Programming Interface (API) will be featured.