Preview

Microsoft Power BI Desktop and Microsoft Power Query

 

Microsoft Power BI Desktop and Microsoft Power Query

Key Features

  • Learn from anywhere in the world. Connect with an Instructor in real time.
  • Attend Live Class from a PC or Mobile.
  • Ask questions from an Instructor in real time over voice & chat.
  • Includes Certificate of Completion.
  • Official Exam & Certification Assitance.
  • Get 30 Days free after class support.

Join a next available Live Class:

This course training is available on request only. Send us your request with preferred date & Time & our training advisor will get back to you within 24 business hours.


Request for a Live Class

as per your availability

Enquire for more information

Course Description

About the Course

This course familiarizes the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel. The course uses Excel 2016, however Power Query works with Excel 2010 and above.

Course Curriculum

Course # : MPBI-142
Exam : Microsoft Power BI Desktop and Microsoft Power Query

Microsoft Power BI Desktop and Microsoft Power Query

Objectives

  • Understand the revolutionary changes in Power Query and the ease it provides for Excel pros
  • Successfully navigate the Power Query interface
  • Understand and properly configure data types
  • Understand and perform importing data
  • Understand and perform transforming data
  • Understand and perform loading data
  • Understand and utilize ranges in Excel
  • Understand and handle special situations
  • Understand and perform appending operations
  • Understand and utilize working with folders and files
  • Understand and perform combining worksheets
  • Understand and utilize PivotTables
  • Understand working with relational data
  • Understand and perform importing from SQL Server Analysis Services Multidimensional
  • Understand and perform importing from SQL Server Analysis Services Tabular
  • Understand the issues encountered when performing merges
  • Understand and utilize merges
  • Understand and utilize loading into Excel
  • Understand and utilize loading into Power Pivot
  • Understand and utilize loading to Power BI Desktop
  • Understand and utilize the data sources available
  • Understand and utilize grouping
  • Understand and utilize summarizing
  • Understand the M interface
  • Understand Power Query formulas

Target Audience

  • Business Intelligence Professionals

Prerequisites

  • Required: Should be familiar with Excel and the concepts of datasets and basic reporting, including the use of PivotTables
  • Recommended: Excel 2016: Level 1
  • Recommended: Excel 2016: Level 2
Be Amazed with Online Learning Experience
Future is fast forwarding towards online learning & now it’s becoming easy for everyone to take a world class training from anywhere in the world. Listen from Learnfly Live recent alumni’s studying around the globe.

Get an e-Certificate of Completion

Get a e-Certificate of Course Completion after successfully completing your live class with Learnfly. Share & showcase your proud achievement with your friends & colleagues. Join a live class today & start learning online from anywhere: