Power Pivot Workshop Beginner
Requirements
- Power Pivot for Excel 2010 or Excel 2013
The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics.
The course includes almost 3 hours of video in 30 lectures. You do not need any previous experience in Power Pivot to take this course.
Sections included in this course:
- Introduction to Self-Service Business Intelligence
- Introduction to Power Pivot
- Loading Data
- Data Modeling
After this course, we suggest you to take the Power Pivot Workshop Intermediate one.
- Advanced Excel Users
- Business Analysts
- Business Intelligence Developers
- Data Scientists
- PivotTables in Excel
- PivotTables in Excel 2013
- Using Power Pivot
- Calculated Columns
- Linked Tables
- Calculated Fields
- Publishing to Power BI
- Loading Data in Power Pivot
- Loading from SQL Tables
- Loading from SQL Queries
- Loading from Access
- Loading from Analysis Services
- Using Linked Tables
- Loading from Excel
- Loading from Text Files
- Loading from the Clipboard
- Loading from Reports
- Loading from Data Feeds
- Loading from Azure Marketplace
- Loading from SharePoint
- Data Connection Properties
- Introduction to Data Models
- Normalization and Denormalization
- Star Schemas
- Over Denormalization
- Beginner Course Conclusion
- Download Sample Files
![Marco Russo](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 2,344 Reviews
- 41,077 Students
- 4 Courses
Marco is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 1999 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe.
Marco is also a book author and wrote two books for Microsoft Press about Power Pivot with Alberto Ferrari: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits.
- 4.3 Instructor Rating
- 2,344 Reviews
- 41,077 Students
- 4 Courses
Alberto is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 2005 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe.
Alberto is also a book author and wrote two books for Microsoft Press about Power Pivot with Marco Russo: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits.