Course Name: Microsoft PowerPivot for Excel 2010 - Data Analysis and Business Modeling
Area of Study: Project Management Software
Classroom Hours: 7
Tuition per Student: $325
Description:
Do you want to transform your skills, data, and business?
This course introduces PowerPivot in Excel 2010 to power users and data analysts who want to give their data meaning by creating their own Business Intelligence models.
It presents the PowerPivot functionality, then takes a pragmatic approach to understanding and working with data models, data loading, data manipulation with Data Analysis Expressions (DAX), simple-to-sophisticated calculations, what-if analysis, and PowerPivot patterns.
Master the business modeling and analysis techniques that help you transform data into bottom-line results through the best real-world experience in this practical, scenario-focused course.
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
• First Steps with PowerPivot
• PowerPivot at Work
• Introduction to DAX
• Data Models
• Loading Data and Models
• Evaluation Context and CALCULATE
• Date Calculations in DAX
• Mastering PivotTables
• PowerPivot DAX Patterns
• PowerPivot Data Model Patterns
• Publishing to SharePoint
Students enrolled for this course should have the following:
This course is perfect for anyone who has a desire to transform data into bottom-line results. Its proven practices and hands-on examples are designed to help individuals work smarter, make better decisions, and gain the competitive edge.
Upon successful completion of this course, students will be able to:
Know and understand the best ways to use Office Excel 2010 for data analysis and business modeling including:
• How to create and share their own BI solutions using software they already know and love: Microsoft Excel
• How to extend their existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required
• How to share their results from “self-service” BI solutions effortlessly across their organization using Microsoft SharePoint