Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    New Favorites | November 25, 2014

    Powell's Staff: IMG Our Favorite New Favorites of 2014



    Every week, we gather together a small pile of newly released titles that we agree should be on everyone's radar. We deem these titles our New... Continue »

    spacer
Qualifying orders ship free.
$34.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
2 Beaverton COMP- WIN APPS A- Z
1 Burnside Microsoft Windows- Applications
25 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Microsoft(r) Excel(r) 2013: Building Data Models with Powerpivot

by

Microsoft(r) Excel(r) 2013: Building Data Models with Powerpivot Cover

 

Synopses & Reviews

Publisher Comments:

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 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

Product Details

ISBN:
9780735676343
Author:
Ferrari, Alberto
Publisher:
Microsoft Press
Author:
Russo, Marco
Subject:
Spreadsheets - General
Subject:
Personal Computers-Desktop Applications-General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Microsoft;Windows;Office;Excel;PowerPivot;For Dummies;business;intelligence;BI;analysis;analyst;data;SQL;report;solution;skill;problem;solving;real;world
Copyright:
Edition Description:
Trade Paper
Series:
Business Skills
Publication Date:
20130331
Binding:
TRADE PAPER
Language:
English
Pages:
500
Dimensions:
7.38 x 9 in

Related Subjects

Business » Computers
Computers and Internet » Computers Reference » General
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Computers and Internet » Software Engineering » Programming and Languages

Microsoft(r) Excel(r) 2013: Building Data Models with Powerpivot New Trade Paper
0 stars - 0 reviews
$34.99 In Stock
Product details 500 pages Microsoft Press - English 9780735676343 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.