Synopses & Reviews
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
About the Author
Alberto Ferrari is a Business Intelligence consultant whose two main interests are in a methodological approach to the BI development lifecycle, and performance tuning of ETL and SQL code. His activities are related to designing and implementing solutions based on Integration Services and Analysis Services for the financial, manufacturing and statistical areas. He is also a book author and a speaker in international conferences such as PASS Summit, SQLRally and SQLBits. Alberto holds an SSAS Maestro certification.
Marco Russo is a Business Intelligence consultant and mentor. His main activities are related to data warehouse relational and multidimensional design, but he is also involved in the complete development lifecycle of a BI solution. He has particular competence and experience in sectors like financial services (including complex olap designs in banking area), manufacturing, gambling and commercial distribution.Marco is also a book author and, apart from his BI-related publications, he also wrote some books about .NET programming. He speaks at international conferences such as PASS Summit, SQLRally and SQLBits. Marco has achieved the unique SSAS Maestro certification and is also a Microsoft Certified Trainer with several Microsoft Certified Professional certifications.
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