- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Ships in 1 to 3 days
Other titles in the Business Skills series:
Microsoft(r) Excel(r) 2013: Building Data Models with Powerpivotby Alberto Ferrari
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!
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.
Table of Contents
IntroductionChapter 1: Introduction to PowerPivotChapter 2: Using the unique features of PowerPivotChapter 3: Introducing DAXChapter 4: Understanding data modelsChapter 5: Publishing to SharePointChapter 6: Loading dataChapter 7: Understanding evaluation contextsChapter 8: Understanding CALCULATEChapter 9: Using hierarchiesChapter 10: Using Power ViewChapter 11: Shaping the reportsChapter 12: Performing date calculations in DAXChapter 13: Using advanced DAXChapter 14: Using DAX as a query languageChapter 15: Automating operations using VBAChapter 16: Comparing Excel and SQL Server Analysis ServicesAbout the Authors
What Our Readers Are Saying
Business » Computers