Author(s)
Publisher:
AICPA
-
NASBA Field of Study
-
Format
On demand
-
Level
-
CPE Credit
0
-
Course acronym
-
Prerequisites
-
Course duration
2 Hours
Credit Info
Microsoft Power BI – Prepare Your Data Efficiently for Excel Analysis
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!
Topics discussed
Various forms of data sources
Accessing data sources
Working with multiple tables/sources
Importing data for analysis
Introduction to Get & Transform (formerly Power Query)
Learning objectives
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.
Who will it benefit?
Business analysts and data scientists
Anyone who needs to analyze data
