YoVDO

Excel: Power Pivot for Beginners

Offered By: LinkedIn Learning

Tags

Power Pivot Courses Business Intelligence Courses Data Analysis Courses DAX (Data Analysis Expressions) Courses KPIs (Key Performance Indicators) Courses Data Modeling Courses PivotTables Courses PivotCharts Courses

Course Description

Overview

Get a short, beginner-friendly introduction to the robust Power Pivot feature in Microsoft Excel for Windows.

Syllabus

Introduction
  • Doing more in Excel with Power Pivot
1. Understanding Power Pivot
  • Become familiar with the Power Pivot interface
2. Building a Basic Data Model
  • Get started by connecting with source data
  • Create and manage data relationships
  • Enhance your data by adding calculations
  • Generate insights on the fly by creating measures
3. Presenting Your Data
  • Analyze results using PivotTables
  • Wow stakeholders with KPIs
  • Illustrate results using PivotCharts
Conclusion
  • Where to learn more about Power Pivot

Taught by

Joshua Rischin

Related Courses

Social Network Analysis
University of Michigan via Coursera
Intro to Algorithms
Udacity
Data Analysis
Johns Hopkins University via Coursera
Computing for Data Analysis
Johns Hopkins University via Coursera
Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX