Microsoft Power BI Desktop and Microsoft Power Query

  • Live Vritual Classroom
  • Classroom Training
  • On-Site Training

Enquire Details & Pricing

Key Features MONEY BACK GUARANTEE

How this works :

At Learnfly, we greatly value the trust of our patrons. Our courses are designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Instructor Led Training :

Raise refund request within 7 days of commencement of the first batch you are eligible to attend. Money back guarantee is void if the participant has accessed more than 25% content of an e-learning course or has attended Online Classrooms for more than 1 day.

  • Learn with practical projects and hands on real tools.
  • Official Curriculum & Courseware Content.
  • Online Interactive Lab's Access.
  • Adaptive e-Learning with trainer's support.
  • Access Class via PC, Mobile App or on a large screen.
  • Attend Live HD Training Sessions via Go To MeetingTM. Interact with trainer and peers like in a real classroom via voice, video conference and live chat.

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.

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

Course Curriculum

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

See what our Alumni says

Our alumni’s are hired by top brands

Hundreds of employers — have maximized their talent with us.

Ready to enroll for this Course? Book your slot now: