Excel Business Intelligence: Power Query
With Chris Dutton
Liked by 5,589 users
Duration: 2h 1m
Skill level: Intermediate
Released: 5/14/2018
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.
LinkedIn Learning
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
-
Angel A.
Angel A.
Sr. Associate Advisory at KPMG
-
Andreas Hermle
Andreas Hermle
Marketing and Data Analysis
-
Eugenia Bernadsky
Eugenia Bernadsky
Data Analytics & Reporting | Ad-Hoc Reporting | Financial Services & Operations | Mortgage | Insurance | SAS | SQL | Data Quality | Data Validation |…
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