Understand querying with natural language.In this module, we will explore the Power BI interface and walk-through the options available. In this module we will explore Power Map and its capabilities. We will examine the options available within the ribbon, as well as explore and demonstrate importing, filtering, and merging data using Power Query. In this module, we will delve into the benefits and features provided using Power Query. Configure calculated columns are calculated fields.Configuring Calculated Columns and Calculated Fields.In this module, we will explore PowerPivot and its capabilities, then briefly walk-through the options available and how to configure them. It is available as an add-in in Excel 2010, 2013 in separate downloads, and as an add-in included with the Excel 2016 program. In this module, we will explore Power View and its capabilities, then briefly walk-through the types of reports available and how to format them. Have a full understanding of what the course intends to cover.Successfully log into their virtual machine.This module explains how the class will be structured and introduces course materials and additional administrative information.Īfter completing this module, students will be able to:

Power pivot for excel 2016