| About The BookTransform your skills, data, and business—with the power user’s guide to PowerPivot for Excel. |
Extend your data-analysis skills—and increase your impact—by creating your own business intelligence solutions, right from Excel. No programming required! Guided by two business intelligence experts, you’ll learn how to use the PowerPivot add-in to manipulate millions of rows of data—for critical new business insights and on-the-job results.
Build your own business intelligence solutions with PowerPivot!
Apply what you know about Excel formulas to DAX, the PowerPivot language
Quickly import, sort, and filter massive data sets
Master the fundamentals of data modeling and working with patterns
Simplify year-to-date, closing balance, and other date-driven computations
Calculate ratios, ranking, standard deviation, and Pareto analyses
Express PowerPivot data in sophisticated PivotTables, reports, and charts
Easily share—and update—your solutions through Microsoft SharePoint