When and how should I use Power Query? Microsoft has incorporated it in many of its flagship products and services. It can provide assistance in the data preparation, cleaning, and transformation process. This powerful tool has over 80 data connectors and similar features found in enterprise class tools, like database services. Report creators will be faced with tough decisions regarding which tool will prepare and transform data. Knowing when and how to use these powerful features is essential to creating and maintaining high performance reports. In this session, we will explore features and usage guidelines that will ease the decision-making process.