K2's 2024 Accessing Your Company's Data With Power Query And Power BI

Prerequisites

Fundamental knowledge of Excel

Highlights

• Utilizing Power Query to access data from the web, spreadsheets, folders, and databases
• Using Power Query to perform various transformations to clean up data before importing it to Power BI or Excel
• Producing various reporting documents from data delivered from Power Query

Objectives

• Outline Power Query's noteworthy features and functions and how you can use them for reporting projects
• Demonstrate how to connect Power Query to web resources, spreadsheets, and databases to extract, transform, and load data into your reports
• List the various methods to transform your data using Power Query before importing it into a report
• Demonstrate connecting Power Query and Power BI to a sample data server

Preparation

None