Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills) - Softcover

Ferrari, Alberto; Russo, Marco

Softcover

ISBN 10: 0735676348 ISBN 13: 9780735676343

Publisher: Microsoft Press, 2013

Synopsis

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. You'll 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 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

Authors’ note on using Microsoft Excel 2016: This book’s 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.

About this title

From the Author

This book has a very wide target of different kind of people. You might be an Excel userwho uses Power Pivot for Excel, or you may be a data scientist using Power BI. Or youcould be starting your career as a business-intelligence professional and you want toread an introduction to the topics of data modeling. In all these scenarios, this is thebook for you.

Note that we did not include in this list people who want to read a book about datamodeling. In fact, we wrote the book thinking that our readers probably do not evenknow they need data modeling at all. Our goal is to make you understand that you needto learn data modeling and then give you some insights into the basics of this beautifulscience. Thus, in a sentence if you are curious about what data modeling is and why it is auseful skill, then this is the book for you.

About the Author

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.

Edition details

• Publisher: Microsoft Press
• Publication date: 2013
• ISBN 10: 0735676348
• ISBN 13: 9780735676343
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 512