K2's 2024 Accessing Your Company's Data With Power Query And Power BI
Thursday, January 02, 2025
Webcast or Webinar, Online
10:00AM - 12:00PM (opens at 9:30 AM) EST
2Credits
Technical Business
Registration is Open
Members
$79.00 Regular Price
Non-Members
$109.00 Regular Price
CPE PowerPass Users
Click the "Apply PowerPass" button to use your PowerPass for the applicable course below.
$40.00 Members / $56.00 Non-Members
Don't have a CPE PowerPass? Click
here to find out more about the CPE PowerPass program.
Course Type: Webcast
Course Code: 24/AC005979
Level: Intermediate
Vendor: ACPEN
Field of Study: Computer Software and Applications
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.
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
Major Topics:
- 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
Major Topics:
- 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