ProPowerBIDesktop(2nd)无水印原版pdf

Pro Power BI Desktop(2nd) 英文无水印原版pdf 第2版 pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载自网络，如有侵权，请联系上传者或csdn删除查看此书详细信息请在美国亚马逊官网搜索此书Pro Power BI DesktopAdam AspinStoke-on-Trent, StaffordshireUnited KingdomISBN-13(pbk:978-1-484232095ISBN-13( ( electronic:978-1-4842-3210-1htps:/ doi. org/10.1007/978-1-4842-3210-1Library of Congress Control Number: 2017962307Copyright o 2018 by Adam AspinThis work is subject to copyright All rights are reserved by the Publisher, whether the whole or part of thematerial is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation,broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storageand retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known orhereafter developedTrademarked names, logos, and images may appear in this book. Rather than use a trademark symbol withevery occurrence of a trademarked name, logo, or image we use the names, logos, and images only in aneditorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.The use in this publication of trade names, trademarks, service marks, and similar terms, even if they arenotidentified as such, is not to be taken as an expression of opinion as to whether or not they are subject toproprietary rightsWhile the advice and information in this book are believed to be true and accurate at the date of publicationneither the authors nor the editors nor the publisher can accept any legal responsibility for any errors oromissions that may be made. The publisher makes no warranty, express or implied, with respect to the materialcontained hereinCover image designed by FreepikManaging director Welmoed SpahrEditorial Director: Todd greenAcquisitions Editor: Jonathan GennickDevelopment Editor: Laura berensonTechnical Reviewer: Chad SchuesslerCoordinating Editor: Jill BalzanoCopy Editor: Bill McManusCompositor: SPi GlobalIndexer: SPi GlobalArtist: SPi GlobalDistributed to the book trade worldwide by springer Science+ Business Media New York233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax(201)348-4505, e-mailorders-ny@springer-sbm.comorvisitwww.springeronline.comApressMedia,LlcisaCaliforniaLlcand the sole member (owner is Springer Science Business Media Finance Inc(SSBM Finance Inc)SSBM Finance Inc is a Delaware corporationForinformationontranslationspleasee-mailrights@apress.com,orvisithttp://www.apress.com/rights-permissionsApress titles may be purchased in bulk for academic, corporate, or promotional use eBook versionsand licenses are also available for most titles. For more information reference our print and ebook bulkSaleswebpageathttp://www.apRess.com/bulk-salesAny source code or other supplementary material referenced by the author in this book is available toreadersonGithubviathebooksproductpagelocatedatwww.apress.com/9781484232095.Formoredetailedinformationpleasevisithttp://www.apress.com/source-codePrinted on acid-free paperTo the memories of my mother and grandmother.ContentsAbout the author■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■About the technical reviewer xxxiAcknowledgmentsXXXIIIntroduction mmmm XXXVChapter 1: Introduction to Power Bl Desktop mmmammmmmammmmmann 1The Microsoft Self-Service Business Intelligence Solution2Importing Data from Diverse SourcesModeling Your DataCreating Reports and dashboards…............……3Power Bl Desktop Files.. ........................................................................................3The power bl universe4Installing Power Bl DesktopRemoving Power Bl Desktop……Running Power Bl DesktopA First Power Bl Desktop Dashboard.seeeenecneneenennenennnnnenann 10Loading the source dataThe data load process14The Navigator window14The Navigator data preview…,.,,….,…14Modifying data15The power b| Desktop Window….….….…,15CONTENTSYour first visualizations17Displaying Available Fields7Adding a Matrix of sales per Country by year.Adding a Column Chart of Delivery charge by ModelAdding a Map of Labor cost by country023Adding a Card Showing the Total Cost of Spare Parts.Adding a slicer by Make24Arranging the Dashboard..Interactivity in Dashboards.neeeeaeeeeeaeeenanatFormatting Reports5B89The format pane…Borders.Background color30Titles31Table gridlines……132Data colors…33Creating and modifying Reports35Adding Pages.36Renaming pages36Deleting pagesMoving pages37Duplicating Pages......,.,.,.,…,…,……37Scrolling Through Collections of Pages…………37Conclusion,…38Chapter 2: Discovering and Loading File-Based Data with Power Bl Desktop . um 39The Power Bl Desktop Query Editor40Data sourcesFile sources…41oading data42CSV Files42Text Files46Text and csv options.XML FillesExcel FillesImporting Excel and Power view ItemsMicrosoft Access databases….54JsoN Files .wwwwwwwww 55Loading Multiple Files from a Directory56Loading the contents of a Folder59The Navigator Dialog……59Searching for DatasetsDisplay Options61RefreshAdding Your Own Datammcmnmcmemcnmcone.... 62Conclusion…63Chapter 3: Loading Data from Databases and Data Warehouses mma. 65Relational databasesSQL Server.67Automatically Loading Related Tables.Database options...................................Searching for Tables日日74Oracle databases81other relational databasesMicrosoft SQL Server Analysis Services Data Sources ................................86Analysis Services Cube ToolsSSAS Tabular data warehousesImport or Connect Live..930 DBC Sources…93OLE DB Data sourcesBBBBDBBBBDBDBBBBDBDBBBBDBBBBBDBBBBDBDBBBBDBBBBBDBBBBDBDBBBBBDBBBBDBBBBBBDBBBBDBDBBBBBBBBBDBm100Modifying Connections104Changing Permissions.CONTENTSRefreshing data from Databases and data Warehouses108Refreshing the Entire Data in the Power Bl Desktop In-Memory ModelRefreshing an Individual table109Conc|uson…109Chapter 4: Directquery and connect LiveDirectQuery and Connect Live111Microsoft SQL Server Data.SQL Server Analysis Services Dimensional Data m.........amnon 116Microsoft SQL Server Analysis Services Tabular Data Sources.DirectQuery with Non-Microsoft Databases.me..eae.a.121DirectQuery and In-Memory Tables,122DirectQuery and refreshing the data123Conclusion,123Chapter 5: Loading Data from the Web and the cloud mann 125Web and cloud services, wmmmmmmo. 125Web Pages126Onlineservices.wwwwwwwwwww.126Microsoft azure126Web Pages127Advanced Web Options130Tablevieworwebviewwwwwwwwww.131Sa| enforce…132Loading Data from Salesforce objects.133Salesforce Reports..…138Microsoft Dynamics 365139Google analytics,142OData feeds1460Data0 ptions......………………147Azure SQL Database148CONtENTSAzure SQL Data Warehouse151Connecting to SQL Server on an Azure virtual Machine.Azure Blob Storage…156Azure Security158Conclusion,158Chapter 6: Dealing with Datasets■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■159Power Bl Desktop Queries.meeee etten 160Editing Data After a Data Load160Transforming Data Before Loading…,…………162Query or Load?163The Power Bl Desktop Query Editor164The App| ed Steps List.,…,…日面a165The Power Bl Desktop Query Editor Ribbons165Dataset Shaping171Renaming Columns.....……171Reordering columnsRemoving columns…...............…………173Choosing columns173Merging Columns自日自自日自a自日自自日自自自自日自日自a自目自自日自自日自a自日自日自日自自自a自日自自自a自目自自日自自a日自a自自日自日自自B面175Going to a Specific Column177Removing recordsKeeping RoWS179Removing Duplicate Records.18Sorting Data182Reversing the row order183Undoing a sort operation183Filtering data……184Selecting Specific Values... .........................................................................................184Finding elements in the Filter List185Filtering Text Ranges.……,…186coNTENtSFiltering Numeric Ranges..................186Filtering date and Time ranges187Filtering Data..................89Applying Advanced Filters190Grouping Records,191Simple Groups..........……191Complex Groups….....……193Saving Changes in the Query Editor195Exiting the Query editor195Conclusion196Chapter 7: Data Transformation ammmmmaamaa: 197Viewing a Full record198Power b| Desktop Query Editor Context Menus...,,…………,199Using the First Row As Headers..,….,…….,200Changing Data Type.Detecting Data Types…202Data Type Indicators……………203Switching Data Types . .................................................................................204Data Type Using Locale......204Replacing ValuesTransforming Column Contents207Text transformation207Adding a prefix or a suffix日日目日自日面日日日自目日自目日自B日面日自目日目日自日面目日目自目日目日日面日自目日自目日自日面208Removing Leading and Trailing Spaces ................209Removing Non-Printing CharactersNumber transformations∴…210Filling down Empty Cells...,,,,,,,,……217Extracting Part of a co| umn's Contents..………219Advanced Extract Options......220Duplicating Columns.