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®
DVD includes :
• Workbook examples to study and customize
• A Microsoft Access® version of the book’s sample database
• Fully searchable eBookAbout the Author
Marco Russo, MCT, focuses on Windows development and business intelligence solutions. He has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and has coauthored many books, including Microsoft PowerPivot for Excel 2010 and Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model.
|Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and specializes in developing Microsoft business intelligence solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.