Exciting Christmas Offer: Get upto 30% discounts on IT training or a chance to win iPhone XS or XR. Offer valid till Ends In:
Exciting Christmas Offer: Get upto 30% discounts on IT training or a chance to win iPhone XS or XR. Offer valid till


Microsoft Power BI Desktop and Microsoft Power Query

Talk With Us

Enquire more information

}

Key Features

  • Worldwide Training Locations & Centers
  • Live Online, Classroom or On-Site Training
  • Learn from Industry Experts
  • Official Courseware & Exam
  • Money Back Guarantee
  • Choose your own Schedule
  • Discounted Pricing & Offers
  • Free bundled Self-Paced Courses access for 1 year

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

Schedule & Fees

For individuals Recommended

Live Virtual Classroom
Duration : 1 Days

  • 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.
  • 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.
  • Official Exam & Certification.
For Individual or Group

On-Demand Classroom

  • Learn at our training locations*
  • Personalised Training
  • Official Curriculum & Courseware
  • Physical Lab Access
  • Official Exam & Certification
  • Travel Visa Assistance (Optional)
  • Tea & Snacks Facility
  • Accommodation Assitance (Optional)
  • Including other perks

*Locations are subject to availability.

For business

Corporate Training Solutions

  • All Standard features +
  • Customized Pricing for 3+ participants.
  • Tailored Course Bundling Options.
  • Blended Training Options including Live Virtual Classroom, On-Site or Classroom.
  • Staff training & monitoring via LMS(learning management system) access.
  • 24/7 dedicated account manager for support

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: