![Practical Powerpivot & DAX Formulas for Excel 2010](http://addons.books.com.tw/G/F01/2/0/7/F012080997.jpg) |
售價:1400
![](http://addons.books.com.tw/G/books2006/images/cart01.gif)
|
作者:TENNICK, ART 出版社:MCGRAW-HILL OSBORNE MEDIA 出版日期:2010年08月16日 語言:英文 ISBN:9780071746854 裝訂:平裝 內容簡介TOPEXTRACT ACTIONABLE BI USING EXCEL 2010 POWERPIVOT AND DAX LANGUAGE FEATURING 200 READY-TO-USE DAX QUERIES, PRACTICAL POWERPIVOT & DAX QUERIES FOR EXCEL 2010 SHOWS OFFICE AND EXCEL POWER USERS HOW TO TAKE ADVANTAGE OF DAX (DATA ANALYSIS EXPRESSIONS)—THE NEW STANDARD LANGUAGE FOR EXTRACTING BI WITHIN EXCEL. AN ENTIRE SECTION SHOWS HOW TO CREATE TABLES, PIVOT TABLES, AND POWERPIVOT TABLES IN EXCEL. YOU CAN THEN PROGRESS TO WRITING DAX QUERIES AND FORMULAS TO HARNESS THE POWER OF BI.THIS SOLUTIONS-BASED GUIDE CONTAINS MORE THAN 200 DAX QUERIES THAT CAN BE IMMEDIATELY APPLIED ACROSS A WIDE VARIETY OF BI-RELATED PROBLEMS. IT BEGINS WITH FUNDAMENTAL PRINCIPLES AND SIMPLE QUERIES AND RAPIDLY PROGRESSES TO COMPLEX AND SOPHISTICATED QUERIES. THE BOOK IS STRUCTURED AS FOLLOWS:QUERY: INTRODUCTION AND DESCRIPTION OF QUERY AND ITS USESYNTAX: COMPLETE DAX SYNTAXRESULT: SCREEN SHOT SHOWING THE DATA RETURNED IN AN EXCEL 2010 PIVOT TABLEANALYSIS: ANALYSIS OF THE RESULTS AND TIPS FOR CUSTOMIZATIONPRACTICAL POWERPIVOT & DAX QUERIES FOR EXCEL 2010INCLUDES 200+ READY-TO-USE, EASILY CUSTOMIZABLE DAX QUERIES, ALL AVAILABLE FOR DOWNLOADFEATURES A PRACTICAL AND HANDS-ON APPROACH WITH A MINIMUM OF DIFFICULT CONCEPTS AND THEORYEXPLAINS HOW TO VISUALIZE ACTIONABLE BIHELPS TO DRAMATICALLY IMPROVE ANALYSIS AND DECISION-MAKING SKILLSCOMPLETE COVERAGE OF EXCEL 2010 POWERPIVOT AND DAX POWERPIVOT FUNDAMENTALS; INSTANT BUSINESS INTELLIGENCE; POWERPIVOT: OVERVIEW; POWERPIVOT: DETAILS; DAX: OVERVIEW - CALCULATED COLUMNS AND MEASURES; VISUALIZATION - MANIPULATING PIVOT TABLES AND CHARTS; DAX FORMULAS - EXTENDING POWERPIVOT; FUNDAMENTAL FUNCTIONS; AGGREGATE FUNCTIONS; DATE AND TIME FUNCTIONS; DATE AND TIME INTELLIGENCE FUNCTIONS; TEXT FUNCTIONS; MATH FUNCTIONS; AFTER YOU FINISH; HOW TO WRITE SQL QUERIES FOR POWERPIVOT; HOW TO WRITE MDX QUERIES FOR POWERPIVOT; HOW TO WRITE DMX QUERIES FOR POWERPIVOT - USING SSAS DATA MINING DATA |
詳細商品說明 |
happybuy8 發表在 痞客邦 留言(0) 人氣()