상세정보
Export to Refworks부가기능
Microsoft Power BI quick start guide [electronic resource] build dashboards and visualizations to make your data come to life
상세 프로파일
| 자료유형 | 단행본 |
|---|---|
| 서명/저자사항 | Microsoft Power BI quick start guide : build dashboards and visualizations to make your data come to life/ Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana. [electronic resource]. |
| 개인저자 | Knight, Devin,author. Knight, Brian,1976- author, Pearson, Mitchell,author, Quintana, Manuel,author, |
| 발행사항 | Birmingham, UK: Packt Publishing, 2018. |
| 형태사항 | 1 online resource: illustrations. |
| ISBN | 9781789130928 1789130921 |
| 내용주기 | Cover; Title Page; Copyright and Credits; Packt Upsell; Foreword; Contributors; Table of Contents; Preface; Chapter 1: 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; Chapter 2: 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 QueriesAppending Queries; Leveraging R; Installation and configuration; The R Script transform; M formula language; #shared; Summary; Chapter 3: 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 categorizationCreating hierarchies; Summary; Chapter 4: 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; Chapter 5: Visualizing Data; Data visualization basics Visuals for filteringInteractive 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 interactionsThe Analytics pane; The Top N filter; Show value as; Summary; Chapter 6: Digital Storytelling with Power BI; Configuring drillthrough filters; Storytelling with the Selection pane and bookmarks; Bookmarks pane; Selection pane; Summary; Chapter 7: 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 |
| 요약 | Microsoft Power BI is a cloud-based service that helps you easily visualize and share insights from your organization's data. This book will get you started with Business Intelligence using the Power BI tool, covering essential concepts like installation, building basic dashboards and visualizations to make your data come to life. |
| 주제명 (통일서명) | Microsoft Excel (Computer file) Microsoft PowerPivot (Computer file) Microsoft Excel (Computer file) --fast Microsoft PowerPivot (Computer file) --fast |
| 일반주제명 | Business intelligence --Computer programs. Information visualization --Computer programs. Business --Data processing. Visual analytics. Business --Data processing. Visual analytics. |
| 언어 | 영어 |
| 바로가기 |  |
