Microsoft Excel 2013 Building Data Models with PowerPivot: Microsoft (R) Excel (

Description: Microsoft Excel 2013 Building Data Models with PowerPivot by Marco Russo, Alberto Ferrari Transform your skills, data, and business - and 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. FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description Your guide to quickly turn data into results. Transform your skills, data, and business—and 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. Youll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BIExtend your existing data-analysis skills to create your own BI solutionsQuickly manipulate large data sets, often in millions of rowsPerform simple-to-sophisticated calculations and what-if analysisCreate complex reporting systems with data modeling and Data Analysis ExpressionsShare your results effortlessly across your organization using Microsoft SharePoint Authors note on using Microsoft Excel 2016: This books 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. Notes Written by two experts on BI development and training, this comprehensive new guide is a must for Excel power users and data analysts. Author Biography Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI 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. Table of Contents Introduction Chapter 1: Introduction to PowerPivot Chapter 2: Using the unique features of PowerPivot Chapter 3: Introducing DAX Chapter 4: Understanding data models Chapter 5: Publishing to SharePoint Chapter 6: Loading data Chapter 7: Understanding evaluation contexts Chapter 8: Understanding CALCULATE Chapter 9: Using hierarchies Chapter 10: Using Power View Chapter 11: Shaping the reports Chapter 12: Performing date calculations in DAX Chapter 13: Using advanced DAX Chapter 14: Using DAX as a query language Chapter 15: Automating operations using VBA Chapter 16: Comparing Excel and SQL Server Analysis Services About the Authors Long Description Your guide to quickly turn data into results. Transform your skills, data, and business--and 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 Details ISBN0735676348 Language English ISBN-10 0735676348 ISBN-13 9780735676343 Media Book Format Paperback Author Alberto Ferrari Birth 1967 Year 2013 Imprint Microsoft Press,U.S. Place of Publication Redmond Country of Publication United States DEWEY 005.54 Illustrations Yes Edition 1 Short Title MS EXCEL 2013 BUILDING DATA MO Subtitle Microsoft (R) Excel (R) 2013 Series Business Skills UK Release Date 2013-03-15 Replaces 9780735640580 AU Release Date 2013-03-15 NZ Release Date 2013-03-15 US Release Date 2013-03-15 Pages 512 Publisher Microsoft Press,U.S. Publication Date 2013-03-15 Audience Professional & Vocational We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:51606814;

Price: 94.93 AUD

Location: Melbourne

End Time: 2025-01-01T06:12:53.000Z

Shipping Cost: 0 AUD