舉報

會員
Microsoft Power BI Quick Start Guide
MicrosoftPowerBIisacloud-basedservicethathelpsyoueasilyvisualizeandshareinsightsusingyourorganization'sdata.ThisbookwillgetyoustartedwithbusinessintelligenceusingthePowerBItoolset,coveringessentialconceptssuchasinstallation,designingeffectivedatamodels,aswellasbuildingbasicdashboardsandvisualizationstomakeyourdatacometolifeYouwilllearnhowtogetyourdatathewayyouwant–connectingtodatasourcessourcesandhowtocleanyourdatawiththePowerBIQueryEditor.Youwillnextlearnhowtoproperlydesignyourdatamodeltomakeyourdataeasiertoworkwith..YouwillnextlearnhowtoproperlydesignyourdatamodeltonavigatetablerelationshipsandbuildDAXformulastomakeyourdataeasiertoworkwith.Visualizingyourdataisanotherkeyelementofthisbook,andyouwilllearnhowtofollowproperdatavisualizationstylesandenhanceddigitalstorytellingtechniques.Bytheendofthisbook,youwillunderstandhowtoadministeryourorganization'sPowerBIenvironmentsodeploymentcanbemadeseamless,datarefreshescanrunproperly,andsecuritycanbefullyimplemented.
目錄(152章)
倒序
- 封面
- Title Page
- Copyright and Credits
- Microsoft Power BI Quick Start Guide
- Packt Upsell
- Why subscribe?
- PacktPub.com
- Foreword
- Contributors
- About the authors
- About the reviewer
- Packt is searching for authors like you
- Preface
- Who this book is for
- What this book covers
- To get the most out of this book
- Download the example code files
- Download the color images
- Conventions used
- Get in touch
- Reviews
- Getting Started with Importing Data Options
- Getting started
- Importing data
- Excel as a source
- SQL Server as a source
- Web as a source
- DirectQuery
- Limitations
- Live Connection
- Limitations
- Which should I choose?
- Summary
- Data Transformation Strategies
- The Power Query Editor
- Transform basics
- Use First Row as Headers
- Remove Columns
- Change type
- Add Column From Examples
- Advanced data transformation options
- Conditional Columns
- Fill Down
- Unpivot
- Merging Queries
- Appending Queries
- Leveraging R
- Installation and configuration
- The R Script transform
- M formula language
- #shared
- Summary
- Building the Data Model
- Building relationships
- Editing relationships
- Creating a new relationship
- Working with complex relationships
- Many-to-many relationships
- Cross-filtering direction
- Enabling filtering from the many side of a relationship
- Role-playing tables
- Importing the date table
- Usability enhancements
- Hiding tables and columns
- Renaming tables and columns
- Default summarization
- How to display one column but sort by another
- Data categorization
- Creating hierarchies
- Summary
- Leveraging DAX
- Building calculated columns
- String functions – Month Year
- Format function – Month Year
- Age calculation
- SWITCH() – age breakdown
- Navigation functions – RELATED
- Calculated measures – the basics
- Calculated measure – basic aggregations
- Total Sales
- Total Cost
- Profit
- Profit Margin
- Optional parameters
- Filter context
- Calculate
- Percentage of total calculation
- Time intelligence
- Year to Date Sales
- YTD Sales (Fiscal Calendar)
- Prior Year Sales
- Summary
- Visualizing Data
- Data visualization basics
- Visuals for filtering
- Interactive filtering
- The Slicer visual
- Visualizing tabular data
- The table visual
- The Matrix visual
- Visualizing categorical data
- Bar and Column charts
- Pie and Donut charts
- The Treemap visual
- The Scatter chart
- Visualizing trend data
- Line and Area charts
- Combo charts
- The Ribbon Chart
- The Waterfall Chart
- The Funnel Chart
- Visualizing KPI data
- The Gauge visual
- The KPI visual
- Visualizing geographical data
- The Map visual
- The Filled Map visual
- The Shape Map visual
- The ArcGIS Map visual
- Leveraging Power BI custom visuals
- Data visualization tips and tricks
- Edit interactions
- The Analytics pane
- The Top N filter
- Show value as
- Summary
- Digital Storytelling with Power BI
- Configuring drillthrough filters
- Storytelling with the Selection pane and bookmarks
- Bookmarks pane
- Selection pane
- Summary
- Using a Cloud Deployment with the Power BI Service
- Deploying to the Power BI service
- DATASETS
- WORKBOOKS
- Creating and interacting with dashboards
- Creating your first dashboard
- Asking your dashboard a question
- Subscribing to reports and dashboards
- Sharing your dashboards
- Workspaces
- Setting up row-level security
- Scheduling data refreshes
- Summary
- On-Premises Solutions with Power BI Report Server
- Deploying to Power BI Report Server
- Securing reports
- Scheduling data refreshes
- Summary
- Other Books You May Enjoy
- Leave a review - let other readers know what you think 更新時間:2021-08-13 16:03:20
推薦閱讀
- 數據展現的藝術
- AutoCAD快速入門與工程制圖
- Design for the Future
- PowerShell 3.0 Advanced Administration Handbook
- 最后一個人類
- 小型電動機實用設計手冊
- DevOps:Continuous Delivery,Integration,and Deployment with DevOps
- Kubernetes for Developers
- Google SketchUp for Game Design:Beginner's Guide
- 激光選區熔化3D打印技術
- Excel 2007常見技法與行業應用實例精講
- Visual C++項目開發案例精粹
- Photoshop CS5圖像處理入門、進階與提高
- SQL Server數據庫應用基礎(第2版)
- 嵌入式Linux系統實用開發
- 智能控制技術及其應用
- 網絡互聯組網配置技術
- 光電檢測技術與系統
- Hyper-V Security
- Scala Machine Learning Projects
- 單片機應用技能操作和學習指導
- 名家傳道:數碼攝影后期處理秘笈
- Hands-On Data Science with Anaconda
- 零基礎學三菱PLC編程:入門、提高、應用、實例
- 機器學習從入門到入職:用sklearn與keras搭建人工智能模型
- Amazon Fargate Quick Start Guide
- 可重入生產系統的多尺度建模與控制策略研究
- Moodle Gradebook(Second Edition)
- Hands-On Recommendation Systems with Python
- Microsoft System Center Configuration Manager Advanced Deployment