Data Querying and Wrangling: Power Query and ChatGPT Integration
Training Provider: SINGAPORE MANAGEMENT UNIVERSITY
Course Reference: TGS-2022012183
S$480
Original: S$1,600
Save S$1,120
About This Course
At the end of the 2-day module, participants will be able to:
• Employ the use of data connectors to access online and offline data using Excel Data Connectors.
• Learn the functions and features of “Power Query” using “transform” and “enrich” toolkits
• Understand data source and sourcing good practice by learning about Data Source Management.
What You'll Learn
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 API will be featured.
Entry Requirements
Participants with at least a diploma qualification
Course Details
Back to All Courses
Note: To apply for this course, visit the SkillsFuture website or contact the training provider directly.
More Courses from SINGAPORE MANAGEMENT UNIVERSITY
In today’s rapidly evolving technological landscape, the emphasis on digital transformation is mor...
This certificate programme is designed for non-technical professionals who want to develop data visu...
This programme covers the operational aspects of data protection and information security. It seeks ...