Microsoft Power BI Desktop and Microsoft Power Query|

Preview

Microsoft Power BI Desktop and Microsoft Power Query

Download Curriculum

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.

Enquire for more information

By submiting, you agree to our terms and policy

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

Microsoft Power BI Desktop and Microsoft Power Query

Exam : Microsoft Power BI Desktop and Microsoft Power Query

Download Syllabus

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

Why Microsoft Power BI Desktop and Microsoft Power Query from SkillCertified™

Live Interactive Learning
- World-Class Instructors
- Expert-Led Mentoring Sessions
- Instant doubt clearing
Lifetime Access
- Course Access Never Expires
- Free Access to Future Updates
- Unlimited Access to Course Content
24x7 Support
- One-On-One Learning Assistance
- Help Desk Support
- Resolve Doubts in Real-time
Hands-On Project Based Learning
- Industry-Relevant Projects
- Course Demo Dataset & Files
- Quizzes & Assignments
Industry Recognised Certification
- SkillCertified Training Certificate
- Graded Performance Certificate
- Certificate of Completion
Like what you hear from our learners?

Take the first step!
Drop us query

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.

Paul Spranger

Very comprehensive materials with a clear presentation. I have been teaching digital forensics for over 10 years and I found this training to be very interesting and on-point

Rami Khalife

I have completed the course 20778 Analyzing data with Power BI. The instructor Mr. Abhishek Kumar delivered interactive sessions which were impressively informative. He went through the content in detail which showcased that he has a thorough knowledge of the subject matter. He set up a collaborative medium between instructor and students. You can ask questions and he will give you a presenter view where you can share what you have learnt.
Instructor Abhishek Kumar is a terrific subject expert. I will be happy to take more courses with Learnfly Live from this experience and recommend it to everyone as well. A job well done! I am now going to practice the content taught by Mr. Abhishek so that I can deliver it in my career pursuits.

Miaozi Guo

Cisco training has given me ample exposure to the field. The trainers were good and provided conceptual understanding for core concepts and technology. They supported me throughout the training and even guided me for job opportunities. I would surely recommend SkillCertified™ Live to everyone.

Uno Lapimaa

I've attended SkillCertified™ Live Microsoft SQL Server Self-Paced. It was very useful and enlightening. The training session was great – interactive as well as informative. Trainers were very helpful and offered personal assistance during the training and career guidance after it.