This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.


Microsoft PowerBI - Get Started with the Right Data Logo aicpa

  Free |   CPE: 2.0 |   AICPA |   25 Jun 2019 |   Computer Science |   AICPA Store
Learning Objectives
  • Place data into the correct structure.
  • Identify the different data sources that you can access.
  • Work with multiple tables and data sources.
  • Identify the steps to import data for analysis.
  • Understand the functions of Power Query and Get and Transform.

This webcast is part of the Microsoft PowerBI Series. Please see below for the suggested viewing order.

Before you can analyze data, you must first discover and shape your data. This webcast focuses on getting your data into a data model and then shaping that data. You will learn the importance of having data in a model versus in a spreadsheet. We will introduce some of the basic features of the Microsoft PowerBI Power Query, as well as Get and Transform in Excel 2016, and discuss how it removes many of the roadblocks to getting data.

By the end of this webcast, you will know how to eliminate the use of the resource sucking VLOOKUP function by using the efficient Relationship feature. You will finally be able to retrieve the data you need to perform data analysis!

Explore the other webcasts in the Microsoft PowerBI Series:

Important Information on Your CPE Credit

Topics covered:
  • Management accounting: Technical: Accounting information systems: Information systems environment, Foundational
  • Management accounting: Digital skills: Data analytics, Foundational