Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning

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

About Marco Russo and Alberto FerrariMarco Russo and Alberto Ferrari specialize in developing complex business intelligence solutions using Microsoft technologies, and have been working with PowerPivot since its first beta. They run an international training and consulting firm, speak at a variety of technology conferences, and are coauthors of Expert Cube Development with Microsoft SQL Server 2008 Analysis Services.

Other Books By Marco Russo Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model Microsoft® Excel® 2013: Building Data Models with PowerPivot Programming Microsoft® LINQ Programming Microsoft® LINQ in .NET Framework 4 Other Books By Alberto Ferrari Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model Microsoft® Excel® 2013: Building Data Models with PowerPivot