Video is locked.

Unlock the full course today

Join today to access over 16,000 courses taught by industry experts or purchase this course individually.

Excel Business Intelligence: Power Query

The best thing to happen to Excel in 20 years

From the course: Excel Business Intelligence: Power Query

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.

    Instructor

    • Click here to view Chris Dutton’s instructor page

      Chris Dutton

      Founder & COO, Maven Analytics

      Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling instructor.

      Chris has spent 10+ years specializing in data visualization and business intelligence. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur.com, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics seeks to empower everyday people to change the world with data. Chris graduated summa cum laude and received the Charles G. Bluhdorn Prize in Economics at Tufts University.

    Skills covered in this course

  • Welcome

    - [Instructor] All right, so there's a quote by this guy named Bill Jelen. He's known as Mr. Excel. He's an Excel MVP and one of the leaders in the field. And what he said was that Power Query and Power Pivot were the best thing to happen to Excel in 20 years. And I couldn't agree more. So let's talk through why that's the case and review some of the key benefits to these business intelligence tools. So, first and foremost, we can now import and analyze millions, tens of millions, even hundreds of millions of rows of data directly in Excel from virtually anywhere. So that alone is a pretty huge game-changer. Second, we can quickly build models to blend and analyze data across sources. So no longer do we need to actually mash them together with cell formulas like V Lookup or Index and Match. We can easily create relationships to analyze holistic performance across an entire data model. Third, we can now create fully automated data shaping and loading procedures with no VBA and no…

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

    Download the exercise files for this course. Get started with a free trial today.

  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Watch this course anytime, anywhere. Get started with a free trial today.

Contents