PowerPivot for Microsoft Excel 2010
Offered By: Pluralsight
Course Description
Overview
This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You'll soon be assembling data from diverse sources into models that deliver business intelligence upon demand.
Learn how to use Microsoft PowerPivot to do self service Business Intelligence. This course will guide you through importing data, working with it, then creating pivot tables and charts all in Excel 2010.
Learn how to use Microsoft PowerPivot to do self service Business Intelligence. This course will guide you through importing data, working with it, then creating pivot tables and charts all in Excel 2010.
Syllabus
- Introduction and Foreword 6mins
- PowerPivot Installation and Overview 53mins
- Building the Basic PowerPivot Data Model 24mins
- Working with the PowerPivot Model, and an Introduction to DAX 49mins
- Build a Practical PowerPivot Application - Part 1 30mins
- Build a Practical PowerPivot Application - Part 2 42mins
- Practical PowerPivot Analysis and Reporting with PivotTables 44mins
Taught by
Bill Pearson
Related Courses
Social Network AnalysisUniversity 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