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.
There are no reviews yet.