Overview
This course aims to teach learners how to utilize SQL Server PowerPivot for Excel to load and prepare data from various sources, create multidimensional models, and generate reports using PivotTable and PivotChart. The course covers the process of enriching models with calculations and managing them in SharePoint for data source sharing. The teaching method includes a combination of theory, demonstrations, and discussions. The intended audience for this course includes analysts and individuals interested in self-service business intelligence using SQL Server PowerPivot.
Syllabus
End-to-End SQL Server PowerPivot - Peter Myers
Taught by
PASS Data Community Summit