Your guide to quickly turn data into results. Transform your skills, data, and businessaand create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job resultsano programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint Authorsa note on using Microsoft Excel 2016: This bookas content was written against Excel 2013, but it is useful and valid for users of Excel 2016 too. Excel 2016 introduces several new DAX functions and an improved editor for DAX without changing any existing behavior. In other words, all of the concepts and examples explained in this book continue to work with Excel 2016.It might seem strange to have the option to load data from SQL Server Analysis Services (whose main purpose is the construction of PivotTables) into PowerPivot (whose purpose is to build PivotTables)! You might wonder why you ever wouldanbsp;...
|Title||:||Microsoft Excel 2013 Building Data Models with PowerPivot|
|Author||:||Alberto Ferrari, Marco Russo|
|Publisher||:||Pearson Education - 2013-03-15|