实例介绍
【实例简介】
This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience's attention. Slice and dice the data with remarkable ease
Pro Power BI Desktop Adam aspin Stoke-on-Trent Staffordshire, United Kingdom ISBN-13(pbk:978-1-4842-1804-4 ISBN-13( electronic:978-1-4842-1805-1 DOI10.1007/978-1-4842-1805-1 Library of Congress Control Number: 2016938680 Copyright o 2016 by Adam Aspin This work is subject to copyright All rights are reserved by the Publisher, whether the whole or part of the material 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 storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed Exempted from this legal reservation are brief excerpts in connection with reviews or scholarly analysis or material supplied specifically for the purpose of being entered and executed on a computer system, for exclusive use by the purchaser of the work. Duplication of this publication or parts thereof is permitted only under the provisions of the Copyright Law of the Publisher's location, in its current version, and permission for use must always be obtained from Springer Permissions for use may be obtained through RightsLink at the Copyright Clearance Center Violations are liable to prosecution under the respective Copyright Law. Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rigllo entified The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not ide While the advice and information in this book are believed to be true and accurate at the date of publication, neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or omissions that may be made. The publisher makes no warranty, express or implied, with respect to the material contained herein Managing Director: Welmoed Spahr Lead Editor: Jonathan gennick Development Editor Douglas Pundick Technical reviewer: lan rice Editorial Board: Steve Anglin, Pramila Balen, Louise Corrigan, Jim De Wolf, Jonathan Gennick Robert hutchinson, Celestin Suresh John, Michelle Lowman, James Markham, Susan McDermott Matthew Moodie, Jeffrey Pepper, Douglas Pundick, Ben Renow-Clarke, Gwenan Spearing Coordinating editor: Jill Balzano Copy Editor: Kim Burton-Weisman Compositor: SPi Global Indexer: SPi global Artist: SPi Global Distributed to the book trade worldwide by Springer Science+Business Media New York, 233 Spring Street 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax(201)348-4505, e-mail orders-nyaspringer-sbm. com, orvisitwww.springercomApressMedia,LlcisaCaliforniaLlcandthesolemember(owner)isSpringer Science Business Media Finance Inc(SSBM Finance Inc). SSBM Finance Inc is a Delaware corporation Forinformationontranslationspleasee-mailrights@apress.comorvisitwww.apress.com Apress and friends of ed books may be purchased in bulk for academic, corporate, or promotional use e Book versions and licenses are also available for most titles For more information, reference our Special bulk Sales-ebookLicensingwebpageatwww.apress.com/bulk-sales Any source code or other supplementary material referenced by the author in this text is available to readers at www.apress.com.Fordetailedinformationabouthowtolocateyourbookssourcecodegoto www.apress.com/source-code/ Printed on acid-free paper To the memories of my mother and grandmother Contents at a glance About the author…xi About the technical reviewer xXV Acknowledgments XXVI Introduction Chapter 1: Introduction to Power Chapter 2: Discovering and Loading Data with Power Bl Desktop g35 Chapter 3: Transforming Datasets amammmnamammannmmmammaammnammmmmmammam 79 ■ Chapter4: Data Cleansing,,,,,…,,,,,…,,m,m,m,,m,109 Chapter5: Data Mashup…,,,,,,,,,m…131 Chapter 6: creating a data Model 175 Chapter 7: Extending the Data Model with calculated columns aaman 205 Chapter 8: Adding measures to the data Model ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ 239 Chapter 9: Analyzing data over Time 267 Chapter 10: Text-Based visualizations 國■■■■■■■■■■■國■■■■■■■■■■■■■■■■■■■■■■■■■■■■口■■■■■國■■■■■口■■■■■國■ 301 Chapter 11: Charts in Power Bl Desktop a mamamamaamamanmammma 333 Chapter 12: Other Types of visuals.mmaa 371 Chapter 13: Filtering Data 401 CONTENTS AT A GLANCE Chapter 14: Using Slicers 429 Chapter 15: Enhancing Dashboards m aaamamnanmnammnamana 451 Chapter16:Powerbl.comammmammmmAmmmmammammammammm471 Appendix A: Sample Data manaa 501 Index 503 Contents About the author ■口■■■■■■■■口■■■■■■■■■■■■■■■■■■■口■■■■■■■■■■■口■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■口■■■■■■■■■■■口■ XXII About the technical reviewer xXV Acknowledgments XXVI Introduction Chapter 1: Introduction to Power Bl Desktop mammalian 1 The Microsoft Self-Service Business Intelligence Solution…………, 2 Import data from Diverse Sources ......................................................................................2 Model your dati 3 Creating dashboards and reports ........................................................................................3 Power Bl Desktop Files Installing Power Bl Desktop Removing Power Bl Desktop…..,,,…9 Running Power Bl Desktop…….. 10 A First Power Bl Desktop Dashboard Loading the Source Data...e.e...e. The data load process 14 The Navigator Window.. The Navigator data Preview…...,.….….….,….,…..……15 Modifying Data... 16 The Power Bl Desktop Window 16 Your first visualizations Display Available Fields 18 Add a Matrix of Sales per Country by year................................19 CONtENTS Add a column Chart of Delivery charge by model.…… 21 Add a Map of Labor Cost by country Add a Card showing the Total Cost of Spare Parts. Add a Slicer by Make Arranging the Dashboard Interactivity in Dashboards 28 Creating and Modifying reports Adding Pages Renaming Pages........... 日日日日面日日自B日面日日自B日日自日自日B自日日日自日自日a日面日自自日 30 Deleting Pages.… Moving pages….....11 Duplicating Pages..... 31 Scrolling through Collections of Pages….....,.,.,.,…,…,,…… n日面日日B日日日自B自日自日日 mporting Excel and Power View Items….………,31 Conclusion 34 Chapter 2: Discovering and Loading data with Power Bl Desktop mmammmmmnam 35 Data sources 36 File sources Databases Azure∴ ther sources,… Loading data Web Pages 39044 CSV Files Textfiles,wwww. XML Files 49 EXce….51 Microsoft Access databases 52 Relational Databases: sQL Server 53 Automatically Loading related Tables .55 Database Options……....,,…,.56 CONTENTS Microsoft SQL Server Analysis Services Data Sources................. 63 Analysis Services Cube Tools…… 66 Microsoft SQL Server Analysis Services Tabular Data Sources 68 Other Data sources Reusing Recent Data Sources Reusing a Data Source….… Pinning a data Source 73 Refreshing Data 74 Refreshing a Query......………74 Refreshing all the Queries in a Power bl Desktop File.... 74 Old data 74 Connection Security 75 Conclusion Chapter 3: Transforming Datasets.a ■■■■■■■■■■■■■■■■■■ Power Bl Desktop Queries 80 Editing Data After a Data Load 80 Transforming Data Before Loading Query or Load? 82 The Power Bl Desktop Query Editor 83 The applied steps list 84 The power bl Desktop Query Editor Ribbons..……85 Dataset shaping.aa.. Renaming Columns...,,………,91 Reordering Co|umns…........………….92 Removing columns… 93 Merging Columns 93 Removing records 96 Removing Duplicate Records 99 Sorting data 100 Reversing the row Order. 101 【实例截图】
【核心代码】
This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience's attention. Slice and dice the data with remarkable ease
Pro Power BI Desktop Adam aspin Stoke-on-Trent Staffordshire, United Kingdom ISBN-13(pbk:978-1-4842-1804-4 ISBN-13( electronic:978-1-4842-1805-1 DOI10.1007/978-1-4842-1805-1 Library of Congress Control Number: 2016938680 Copyright o 2016 by Adam Aspin This work is subject to copyright All rights are reserved by the Publisher, whether the whole or part of the material 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 storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed Exempted from this legal reservation are brief excerpts in connection with reviews or scholarly analysis or material supplied specifically for the purpose of being entered and executed on a computer system, for exclusive use by the purchaser of the work. Duplication of this publication or parts thereof is permitted only under the provisions of the Copyright Law of the Publisher's location, in its current version, and permission for use must always be obtained from Springer Permissions for use may be obtained through RightsLink at the Copyright Clearance Center Violations are liable to prosecution under the respective Copyright Law. Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rigllo entified The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not ide While the advice and information in this book are believed to be true and accurate at the date of publication, neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or omissions that may be made. The publisher makes no warranty, express or implied, with respect to the material contained herein Managing Director: Welmoed Spahr Lead Editor: Jonathan gennick Development Editor Douglas Pundick Technical reviewer: lan rice Editorial Board: Steve Anglin, Pramila Balen, Louise Corrigan, Jim De Wolf, Jonathan Gennick Robert hutchinson, Celestin Suresh John, Michelle Lowman, James Markham, Susan McDermott Matthew Moodie, Jeffrey Pepper, Douglas Pundick, Ben Renow-Clarke, Gwenan Spearing Coordinating editor: Jill Balzano Copy Editor: Kim Burton-Weisman Compositor: SPi Global Indexer: SPi global Artist: SPi Global Distributed to the book trade worldwide by Springer Science+Business Media New York, 233 Spring Street 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax(201)348-4505, e-mail orders-nyaspringer-sbm. com, orvisitwww.springercomApressMedia,LlcisaCaliforniaLlcandthesolemember(owner)isSpringer Science Business Media Finance Inc(SSBM Finance Inc). SSBM Finance Inc is a Delaware corporation Forinformationontranslationspleasee-mailrights@apress.comorvisitwww.apress.com Apress and friends of ed books may be purchased in bulk for academic, corporate, or promotional use e Book versions and licenses are also available for most titles For more information, reference our Special bulk Sales-ebookLicensingwebpageatwww.apress.com/bulk-sales Any source code or other supplementary material referenced by the author in this text is available to readers at www.apress.com.Fordetailedinformationabouthowtolocateyourbookssourcecodegoto www.apress.com/source-code/ Printed on acid-free paper To the memories of my mother and grandmother Contents at a glance About the author…xi About the technical reviewer xXV Acknowledgments XXVI Introduction Chapter 1: Introduction to Power Chapter 2: Discovering and Loading Data with Power Bl Desktop g35 Chapter 3: Transforming Datasets amammmnamammannmmmammaammnammmmmmammam 79 ■ Chapter4: Data Cleansing,,,,,…,,,,,…,,m,m,m,,m,109 Chapter5: Data Mashup…,,,,,,,,,m…131 Chapter 6: creating a data Model 175 Chapter 7: Extending the Data Model with calculated columns aaman 205 Chapter 8: Adding measures to the data Model ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ 239 Chapter 9: Analyzing data over Time 267 Chapter 10: Text-Based visualizations 國■■■■■■■■■■■國■■■■■■■■■■■■■■■■■■■■■■■■■■■■口■■■■■國■■■■■口■■■■■國■ 301 Chapter 11: Charts in Power Bl Desktop a mamamamaamamanmammma 333 Chapter 12: Other Types of visuals.mmaa 371 Chapter 13: Filtering Data 401 CONTENTS AT A GLANCE Chapter 14: Using Slicers 429 Chapter 15: Enhancing Dashboards m aaamamnanmnammnamana 451 Chapter16:Powerbl.comammmammmmAmmmmammammammammm471 Appendix A: Sample Data manaa 501 Index 503 Contents About the author ■口■■■■■■■■口■■■■■■■■■■■■■■■■■■■口■■■■■■■■■■■口■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■口■■■■■■■■■■■口■ XXII About the technical reviewer xXV Acknowledgments XXVI Introduction Chapter 1: Introduction to Power Bl Desktop mammalian 1 The Microsoft Self-Service Business Intelligence Solution…………, 2 Import data from Diverse Sources ......................................................................................2 Model your dati 3 Creating dashboards and reports ........................................................................................3 Power Bl Desktop Files Installing Power Bl Desktop Removing Power Bl Desktop…..,,,…9 Running Power Bl Desktop…….. 10 A First Power Bl Desktop Dashboard Loading the Source Data...e.e...e. The data load process 14 The Navigator Window.. The Navigator data Preview…...,.….….….,….,…..……15 Modifying Data... 16 The Power Bl Desktop Window 16 Your first visualizations Display Available Fields 18 Add a Matrix of Sales per Country by year................................19 CONtENTS Add a column Chart of Delivery charge by model.…… 21 Add a Map of Labor Cost by country Add a Card showing the Total Cost of Spare Parts. Add a Slicer by Make Arranging the Dashboard Interactivity in Dashboards 28 Creating and Modifying reports Adding Pages Renaming Pages........... 日日日日面日日自B日面日日自B日日自日自日B自日日日自日自日a日面日自自日 30 Deleting Pages.… Moving pages….....11 Duplicating Pages..... 31 Scrolling through Collections of Pages….....,.,.,.,…,…,,…… n日面日日B日日日自B自日自日日 mporting Excel and Power View Items….………,31 Conclusion 34 Chapter 2: Discovering and Loading data with Power Bl Desktop mmammmmmnam 35 Data sources 36 File sources Databases Azure∴ ther sources,… Loading data Web Pages 39044 CSV Files Textfiles,wwww. XML Files 49 EXce….51 Microsoft Access databases 52 Relational Databases: sQL Server 53 Automatically Loading related Tables .55 Database Options……....,,…,.56 CONTENTS Microsoft SQL Server Analysis Services Data Sources................. 63 Analysis Services Cube Tools…… 66 Microsoft SQL Server Analysis Services Tabular Data Sources 68 Other Data sources Reusing Recent Data Sources Reusing a Data Source….… Pinning a data Source 73 Refreshing Data 74 Refreshing a Query......………74 Refreshing all the Queries in a Power bl Desktop File.... 74 Old data 74 Connection Security 75 Conclusion Chapter 3: Transforming Datasets.a ■■■■■■■■■■■■■■■■■■ Power Bl Desktop Queries 80 Editing Data After a Data Load 80 Transforming Data Before Loading Query or Load? 82 The Power Bl Desktop Query Editor 83 The applied steps list 84 The power bl Desktop Query Editor Ribbons..……85 Dataset shaping.aa.. Renaming Columns...,,………,91 Reordering Co|umns…........………….92 Removing columns… 93 Merging Columns 93 Removing records 96 Removing Duplicate Records 99 Sorting data 100 Reversing the row Order. 101 【实例截图】
【核心代码】
标签：
好例子网口号：伸出你的我的手 — 分享！
相关软件
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
网友评论
我要评论