Until now, building Business Intelligence solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, filter, and format data before it can even be used. And updates have been tedious and error prone.
Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities.
Power Query is a tool that can be used for data discovery, reshaping the data and combining data ( Merge / Blend / Consolidate, etc.) coming from different sources. Power Query can connect directly to Excel, Access, Text, CSV, Hadoop, Sales Force, Azure and many other different sources of data.
Learning to use Power Query means less time spent manipulating data and more time analyzing it to gain powerful insights and make better decisions.
Power Query will save you hours of time gathering and preparing your data before loading it into your data model.
The British Academy for Training and Development offers this course to the following categories:
After completing the program, participants will be able to master the following topics:
Note / Price varies according to the selected city
Oracle Database Administration
2024-12-09
2025-03-10
2025-06-09
2025-09-08