Menu

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

Overview

Power Query and Power BI offer great opportunities for accessing your data and making it more useful in reporting scenarios. Learn how to benefit from these tools in this session.

Prerequisites

Fundamental knowledge of Excel

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

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

Register Now

Materials are generally available 3 days in advance of an event. Once you have downloaded the manual, we are unable to cancel your registration.

Event Code:

6006791

2 CPE Credits
Computer Software & Applications: 2 Credits

Registration

Member Price:
$79
Non-member Price:
$109

Registration is open through 11/23.

Saturday, November 23rd

10:00am to 12:00pm

Add to Calendar

Instructor

Thomas Stephens