Excel Business Intelligence: Power Query Preview

Excel Business Intelligence: Power Query

With Chris Dutton Liked by 5,552 users
Duration: 2h 1m Skill level: Intermediate Released: 5/14/2018

Start my 1-month free trial

Course details

Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities. In this course—the first installment in the Excel Business Intelligence series—follow along with experienced Excel trainer Chris Dutton as he shows you the robust capabilities of Power Query. Chris kicks off the course by outlining the power Excel landscape and spelling out when to use business intelligence tools like Power Query, Power Pivot, and DAX. He then dives into Power Query, explaining how to leverage key query editing tools to connect and transform data. Learn about basic Power Query table transformations, text-specific query editing tools, how to merge and append queries, and more. Chris also shares best practices for working efficiently with Power Query.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.8 out of 5

2,043 ratings
  • 5 star
    Current value: 1,725 84%
  • 4 star
    Current value: 273 13%
  • 3 star
    Current value: 35 1%
  • 2 star
    Current value: 6 <1%
  • 1 star
    Current value: 4 <1%

Contents

What’s included

  • Practice while you learn 2 exercise files
  • Test your knowledge 2 quizzes
  • Learn on the go Access on tablet and phone
  • Stay up to date Continuing Education Units

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.