Excel Business Intelligence: Power Query
- Offered byLinkedin Learning
Excel Business Intelligence: Power Query at Linkedin Learning Overview
Duration | 2 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Excel Business Intelligence: Power Query at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
Excel Business Intelligence: Power Query at Linkedin Learning Course details
- 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
Excel Business Intelligence: Power Query at Linkedin Learning Curriculum
Introduction
Welcome
Getting Started
Important: Versions and compatibility
Download the course exercise files
Set expectations
Intro to the Power Excel Series
The power Excel workflow
The best thing to happen to Excel in 20 years
When to use Power Query and Power Pivot in Excel
Power Query
Power Query introduction
Meet Power Query aka Get & Transform
The Query Editor
Options for loading data in Excel
Basic Power Query table transformations
Text-specific query editing tools
Number-specific query editing tools
Date-specific query editing tools
Create a rolling calendar with Power Query
Add index and conditional columns with Power Query
Group and aggregate data with Power Query
Modify Excel workbook queries
Merge queries
Append queries
Connect Excel to a folder of files
Excel Power Query best practices
Pivot and unpivot data with Power Query
Conclusion
Next steps
Excel Business Intelligence: Power Query at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?