Book 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. 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®
Publisher resources
Table of contents
- Introduction
- 1. Introduction to PowerPivot
- 2. Using the unique features of PowerPivot
- 3. Introducing DAX
- 4. Understanding data models
- 5. Publishing to SharePoint
-
6. Loading data
- Understanding data sources
- Loading from a database
- Opening existing connections
- Loading from Access
- Loading from SQL Server Analysis Services
- Loading from SharePoint
- Using linked tables
- Loading from Excel files
- Loading from text files
- Loading from the Clipboard
- Loading from a report
- Loading from a data feed
- Loading from Windows Azure Marketplace
- Refreshing connections
- 7. Understanding evaluation contexts
- 8. Understanding CALCULATE
- 9. Using hierarchies
- 10. Using Power View
- 11. Shaping the reports
- 12. Performing date calculations in DAX
- 13. Using advanced DAX
- 14. Using DAX as a query language
- 15. Automating operations using VBA
- 16. Comparing Excel and SQL Server Analysis Services
- A. About the Authors
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft Excel 2013: Building Data Models with PowerPivot
- Author(s):
- Release date: March 2013
- Publisher(s): Microsoft Press
- ISBN: 9780735676343
You might also like
book
Microsoft Excel 2013: Data Analysis and Business Modeling
Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. …
book
Practical PowerPivot & DAX Formulas for Excel 2010
250 + ready-to-use, powerful DAX formulas Develop effective business intelligence (BI) solutions and drive faster, better …
book
Microsoft® Excel® 2010: Data Analysis and Business Modeling
Master the business modeling and analysis techniques that help you transform data into bottom-line results. For …
book
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can …