Power Query and Power Pivot in Microsoft Excel
This Free Online Course Includes:
- 3-4 Hours of Learning
- CPD Accreditation
- Final Assessment
Learn how to use Microsoft Excel’s Power Query and Power Pivot to model data in this free online data science course.
Excel’s Power Query and Power Pivot are business intelligence tools for data extraction, transformation and analysis. This data science course explains how to import multiple data files into an Excel sheet and reshape them with Power Query and Power Pivot. We show you how to consolidate files, create performance measures and display processed data in a pivot table. We also study key DAX functions used for data manipulation and analysis.
User Reviews
Be the first to review “Power Query and Power Pivot in Microsoft Excel”
Related Products
Data Scientist Nanodegree Program
Get hands-on experience running data pipelines, designing experiments, building recommendation systems, and more.
Introduction to Data Analytics
Take the first step toward a career in data analytics — no experience required. Learn analytics fundamentals. Get hands-on project experience. Work 1-on-1 with a dedicated industry mentor.
There are no reviews yet.