Microsoft Power BI - Prepare Your Data Efficiently for Excel Analysis
Available Anytime
Location:
Online
2Credits
Technical Business
Registration is Open
FICPA Members
Nonmembers
$69.00 Regular Price
Product Code: AI23-PWRBI2
Level: Overview
Vendor: AICPA CPE Division
Field of Study: Computer Software and Applications
Overview:
Get started on data gathering!
This is the second course in the Microsoft Power BI series of courses. This course focuses on getting data from different sources into Excel.
Tools like Power Query (now known as "Get & Transform") can make transforming data from those sources quick and easy. Whether you are importing data or cleaning it, learn how to make it happen!
This self-study online course is part of the Microsoft Power BI: Power BI Series.
Objectives:
Learning Outcomes
- Differentiate between proper and improper data structure.
- Select the best way to import data into Excel.
- Identify ways to use Get & Transform/Power Query to clean your data.
Major Topics:
Key Topics
- Various forms of data sources
- Accessing data sources
- Working with multiple tables/sources
- Importing data for analysis
- Introduction to Get & Transform (formerly Power Query)