Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Arrow up icon
GO TO TOP
Mastering Microsoft Power BI

You're reading from   Mastering Microsoft Power BI Expert techniques for effective data analytics and business intelligence

Arrow left icon
Product type Paperback
Published in Mar 2018
Publisher Packt
ISBN-13 9781788297233
Length 638 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
 Powell Powell
Author Profile Icon Powell
Powell
Arrow right icon
View More author details
Toc

Table of Contents (20) Chapters Close

Title Page
Dedication
Packt Upsell
Contributors
Preface
1. Planning Power BI Projects FREE CHAPTER 2. Connecting to Sources and Transforming Data with M 3. Designing Import and DirectQuery Data Models 4. Developing DAX Measures and Security Roles 5. Creating and Formatting Power BI Reports 6. Applying Custom Visuals, Animation, and Analytics 7. Designing Power BI Dashboards and Architectures 8. Managing Application Workspaces and Content 9. Managing the On-Premises Data Gateway 10. Deploying the Power BI Report Server 11. Creating Power BI Apps and Content Distribution 12. Administering Power BI for an Organization 13. Scaling with Premium and Analysis Services 1. Other Books You May Enjoy Index

Index

A

  • Active Directory (AD) / Report server administration, Implementing data governance
  • Analysis Services
    • about / Analysis Services
    • versus Power BI Desktop / Analysis Services Models versus Power BI Desktop
    • scale / Scale
    • usability / Usability
    • development and management tools / Development and management tools
    • versus SSAS / Azure Analysis Services versus SSAS
    • SSAS, migrating / SSAS to Azure AS Migration
    • Provision Azure Analysis Services / Provision Azure Analysis Services 
    • Power BI Desktop, migration / Migration of Power BI Desktop to Analysis Services
  • Analysis Services models
    • Live connection / Live connections to Analysis Services models
    • Azure Analysis Services / Azure Analysis Services refresh
  • Analytics pane
    • about / Analytics pane
    • Trend Line / Trend Line
    • forecast line / Forecast line
  • Analyze in Excel / Analyze in Excel
  • animation / Animation and data storytelling
  • application lifecycle management (ALM) / Version control
  • application workspaces
    • about / Application workspaces
    • rights / Workspace roles and rights
    • roles / Workspace roles and rights
    • admins / Workspace admins
    • members / Workspace members
    • My Workspace / My Workspace
  • ArcGIS Map visual
    • about / ArcGIS Map visual for Power BI
    • ArcGIS Maps Plus subscriptions / ArcGIS Maps Plus subscriptions
  • audit logs
    • about / Audit logs
    • monitoring solutions / Audit log monitoring solutions
    • solution template / Audit logs solution template
  • Azure Active Directory (AAD)
    • about / App deployment process, Implementing data governance, Azure Active Directory
    • B2B collaboration / Azure AD B2B collaboration
    • conditional access policies / Conditional access policies
  • Azure Active Directory Privileged Identity Management (PIM) / Power BI licenses
  • Azure Analysis Services (AAS) / Dataset-to-workspace relationship, Premium capacity estimations, Analysis Services
  • Azure Data Lake Store (ADLS) / Azure Analysis Services versus SSAS

B

  • base measures
    • about / Base measures
    • measure support expressions / Measure support expressions
  • bidirectional relationships
    • about / Bidirectional relationships
    • shared dimensions / Shared dimensions
    • date dimensions / Date dimensions 
  • bookmarks
    • about / Bookmarks
    • selection pane / Selection pane and the Spotlight property
    • spotlight property / Selection pane and the Spotlight property
    • custom report navigation / Custom report navigation
    • view mode / View mode
  • Bridge Table Queries / Bridge Tables Queries
  • bubble map / Bubble map
  • business-to-business (B2B) collaboration
    • about / Azure AD B2B collaboration
    • external users, licensing / Licensing external users

C

  • CALCULATE() function
    • about / The CALCULATE() function
    • related tables / Related tables
    • FILTER() function / The FILTER() function
  • chart
    • versus tables / Tables versus charts
    • selection / Chart selection
  • Chiclet Slicer / Chiclet Slicer
  • column metadata
    • about / Column metadata
    • Default Summarization / Default Summarization
    • data format / Data format
    • data category / Data category
  • comma-separated value (CSV) / Audit logs
  • conditional access policies, AAD / Conditional access policies
  • content distribution methods / Content distribution methods
  • Coordinated Universal Time (UTC) / Parameter Tables, Audit logs
  • Corporate BI Capacity / Corporate and Self-Service BI capacity 
  • Corporate Power BI datasets
    • about / Corporate Power BI datasets
    • limitations / Limitation of Corporate BI datasets – Reusability
  • CROSSFILTER function / The CROSSFILTER function
  • custom application embedding / Custom application embedding
  • custom report navigation / Custom report navigation
  • custom visuals
    • about / Custom visuals
    • adding / Adding a custom visual
    • Power KPI visual / Power KPI visual
    • Chiclet Slicer / Chiclet Slicer
    • Impact Bubble Chart / Impact Bubble Chart
    • pulse chart / Pulse Chart

D

  • dashboard data classifications / Dashboard data classifications, Gateway security
  • dashboards
    • versus reports / Dashboards versus reports
    • design / Dashboard design
    • visual selection / Visual selection
    • layout / Layout
    • navigation pane / Navigation pane
    • full screen mode / Full screen mode
    • supporting tiles / Supporting tiles
    • custom date filters / Custom date filters
    • sharing / Sharing dashboards and reports
  • dashboard tiles
    • about / Dashboard tiles
    • details links / Tile details and custom links
    • custom links / Tile details and custom links
    • text boxes / Images and text boxes
    • images / Images and text boxes
    • SQL Server Reporting Services / SQL Server Reporting Services
    • DMVs, querying from Power BI / SQL Server Reporting Services
    • excel workbooks / Excel workbooks
    • Excel workbooks / Excel workbooks
    • cache, refreshing / Dashboard cache refresh
  • data alerts
    • about / Data alerts
    • Microsoft Flow integration / Microsoft Flow integration
  • Data Analysis Expressions (DAX) / Dataset layers
  • data governance
    • about / Data governance for Power BI
    • implementing / Implementing data governance
  • Data Model
    • about / The Data Model 
    • Relationships View / The Relationships View
    • Data View / The Data View
    • Report View / The Report View
    • fact tables / Fact tables
    • dimension tables / Dimension tables
    • bridge tables / Bridge tables
  • data profiling / Data profiling
  • dataset design process
    • about / Dataset design process
    • business process, selecting / Selecting the business process
    • grain, declaring / Declaring the grain
    • dimensions, identifying / Identifying the dimensions
    • facts, defining / Defining the facts
  • dataset layers
    • about / Dataset layers
    • dataset objectives / Dataset objectives
    • objectives, competing / Competing objectives
    • external factors / External factors
  • dataset planning
    • about / Dataset planning
    • data transformations / Data transformations
    • Import mode, versus DirectQuery mode / Import versus DirectQuery
  • data sources
    • about / Data sources
    • authentication / Authentication
    • settings / Data source settings
    • privacy levels / Privacy levels
    • Power BI, using / Power BI as a data source
    • Power BI Desktop options / Power BI Desktop options
    • global options / Global options
    • CURRENT FILE options / CURRENT FILE options
  • data storytelling
    • about / Animation and data storytelling
    • play axis, for scatter charts / Play axis for scatter charts
  • data warehouse bus matrix / Data warehouse bus matrix
  • date intelligence metrics
    • about / Date intelligence metrics
    • current year measure / Current versus prior and growth rates
    • prior year measure / Current versus prior and growth rates
    • growth percentage measures / Current versus prior and growth rates
    • rolling periods / Rolling periods
  • DAX, using as query language
    • URL / Tracing a Power BI dataset via DAX Studio
  • DAX measures
    • about / DAX measures
    • filter context / Filter context
    • SQL equivalent / SQL equivalent
    • measure evaluation process / Measure evaluation process
    • row context / Row context
    • scalar function / Scalar and table functions
    • table function / Scalar and table functions
    • CALCULATE() function / The CALCULATE() function
    • DAX variables / DAX variables
  • DAX Studio
    • about / DAX Studio
    • Power BI dataset, tracing / Tracing a Power BI dataset via DAX Studio
  • dimension metrics
    • about / Dimension metrics
    • missing dimensions / Missing dimensions
  • dimension tables
    • about / Dimension tables
    • hierarchies / Hierarchies
    • custom sort / Custom sort
  • DirectQuery datasets
    • about / DirectQuery , DirectQuery datasets
    • optimized DAX functions / Optimized DAX functions
    • columnstore / Columnstore and HTAP
    • HTAP / Columnstore and HTAP
    • single sign-on, via Kerberos / Single sign-on to DirectQuery sources via Kerberos
  • DirectQuery mode
    • versus Import mode / Import versus DirectQuery
    • about / DirectQuery mode
  • Dot Plot by Maq Software / Dot Plot by Maq Software
  • drillthrough report pages
    • about / Drillthrough report pages
    • custom labels / Custom labels and the back button
    • back button / Custom labels and the back button
    • multi-column drillthrough / Multi-column drillthrough
  • Dynamic Management Views (DMVs) / The Report View, Field descriptions, Metadata management
  • dynamic row-level security (DRLS) / Dynamic row-level security

E

  • Email Subscriptions / Email Subscriptions
  • Enterprise Mobility and Security (EMS) / Conditional access policies
  • environment, installation
    • about / Installation
    • hardware, requisites / Hardware and software requirements
    • software, requisites / Hardware and software requirements
    • Analysis Services Integrated / Analysis Services Integrated
    • Report Server product key, retrieving / Retrieve the Report Server product key
    • SQL Server Reporting Services, migrating from / Migrating from SQL Server Reporting Services
  • Excel workbooks / Excel workbooks
  • extract-load-transform (ELT) / Data transformations, PowerShell sample scripts, Audit log monitoring solutions
  • extract-transform-load (ETL) / SQL views versus M queries, Uniqueness , PowerShell sample scripts, Data governance for Power BI, Audit log monitoring solutions, Azure Analysis Services versus SSAS

F

  • fact tables
    • about / Fact tables
    • columns / Fact table columns
    • column data types / Fact column data types
    • fact-to-dimension relationships / Fact-to-dimension relationships
  • filled map / Filled map
  • Forecast line / Forecast line

G

  • gateway architectures / Gateway architectures
  • gateway clusters
    • about / Gateway clusters
    • managing / Managing gateway clusters
    • gateway administrators / Gateway administrators
    • data sources / Gateway data sources and users
    • users / Gateway data sources and users
    • PowerShell support / PowerShell support for gateway clusters
  • gateway security / Gateway security
  • generally available (GA) / On-premises data gateway planning, Parity with SQL Server Reporting Services
  • Geographic Information Systems (GIS) / ArcGIS Map visual for Power BI

H

  • hindcasting / Forecast line
  • hybrid transactional and analytical processing (HTAP) / Columnstore and HTAP

I

  • Impact Bubble Chart / Impact Bubble Chart
  • Import mode
    • versus DirectQuery mode / Import versus DirectQuery
  • independent software vendors (ISVs) / Custom application embedding
  • Infrastructure-as-a-Service (IaaS) / Import mode dataset queries, On-premises data gateway planning
  • integrated development environment (IDE) / Development and management tools
  • Integrated Scripting Environment (ISE) / PowerShell sample scripts

K

  • Kerberos
    • DirectQuery sources, single sign-on / Single sign-on to DirectQuery sources via Kerberos
  • Kerberos Constrained Delegation (KCD) / Data source authentication
  • Key Performance Indicator (KPI) / KPI Targets, Power KPI visual, Dashboards versus reports

L

  • Live connection
    • to Power BI datasets / Live connections to Power BI datasets
    • reports, customizing / Customizing Live connection reports
  • live report pages / Live report pages
  • Load Balancer / Scale Power BI Report Server

M

  • map visuals
    • about / Map visuals
    • bubble map / Bubble map
    • filled map / Filled map
  • Master Data Management (MDM) / Identifying the dimensions
  • measure evaluation process
    • Initial Filter Context / Measure evaluation process
    • about / Measure evaluation process
    • Filter Context Modified via DAX / Measure evaluation process
    • Relationship Cross-Filtering / Measure evaluation process
    • Measure Logic Computation / Measure evaluation process
  • measure support expressions
    • about / Measure support expressions
    • KPI targets / KPI Targets
    • prior period / Current and prior periods
    • current period / Current and prior periods
  • M editing tools
    • about / M editing tools
    • advanced editor / Advanced Editor
    • Visual Studio Code / Visual Studio Code
    • Visual Studio / Visual Studio
  • metadata management
    • about / Metadata management
    • field descriptions / Field descriptions
    • descriptions, creating / Creating descriptions
    • view field descriptions / View field descriptions
    • metadata, reporting / Metadata reporting
    • query field descriptions / Query field descriptions
    • standard metadata reports / Standard metadata reports
    • server parameters / Server and database parameters
    • DMVs, querying from Power BI / Querying the DMVs from Power BI
    • DMV data, integrating / Integrating and enhancing DMV data
    • DMV data, enhancing / Integrating and enhancing DMV data
    • report pages / Metadata report pages
  • Microsoft Flow integration / Microsoft Flow integration
  • Microsoft Office Data Connection (ODC) / Analyze in Excel
  • mobile-optimized dashboards / Mobile-optimized dashboards
  • mobile-optimized reports
    • about / Mobile-optimized reports
    • responsive visuals / Responsive visuals
  • model metadata
    • about / Model metadata
    • visibility / Visibility
    • column metadata / Column metadata
    • field descriptions / Field descriptions
  • month-to-date (MTD) / Date intelligence metrics
  • M queries
    • versus SQL views / SQL views versus M queries
    • about / M queries
    • Data Source Parameters / Data Source Parameters
    • staging queries / Staging Queries
    • DirectQuery staging / DirectQuery staging
    • fact queries / Fact and dimension queries
    • dimension queries / Fact and dimension queries
    • Source Reference Only / Source Reference Only
    • summary / M query summary
    • excel workbook / Excel workbook – Annual Sales Plan
    • data types / Data types
    • item, accessing / Item access in M
    • DirectQuery report execution / DirectQuery report execution
    • Bridge Table Queries / Bridge Tables Queries
    • parameter tables / Parameter Tables
    • security tables / Security Tables
    • examples / M Query examples
    • three years filter, trailing / Trailing three years filter
    • customer history column / Customer history column
    • derived column data types / Derived column data types
    • product dimension integration / Product dimension integration
    • transformation / R script transformation
  • multi-dashboard architectures
    • about / Multi-dashboard architectures
    • single-dashboard architecture / Single-dashboard architecture
    • multiple-dashboard architecture / Multiple-dashboard architecture
    • organizational dashboard architecture / Organizational dashboard architecture
    • multiple datasets / Multiple datasets
  • multi-factor authentication (MFA) / Azure Active Directory, Conditional access policies
  • Multidimensional Expressions (MDX) / Analysis Services

O

  • OAuth authentication, configuring
    • URL / Power BI mobile applications
  • Object Linking and Embedding, Database (OLE DB) / Data sources
  • Office Online Server (OOS) / Office Online Server for Excel Workbooks
  • On-premises data gateway
    • planning / On-premises data gateway planning
    • planning tasks / Top gateway planning tasks
    • usage, determining / Determining whether a gateway is needed
    • installation, identifying / Identifying where the gateway should be installed
    • infrastructure, defining / Defining the gateway infrastructure and hardware requirements
    • hardware requisites, defining / Defining the gateway infrastructure and hardware requirements
    • versus personal mode / On-premises data gateway versus personal mode
    • configuration / Gateway configuration
    • service account / The gateway service account
    • TCP, versus HTTPS mode / TCP versus HTTPS mode 
    • troubleshooting / Troubleshooting and monitoring gateways
    • monitoring / Troubleshooting and monitoring gateways
    • restore, selecting / Restoring, migrating, and taking over a gateway
    • migrate, selecting / Restoring, migrating, and taking over a gateway
    • take over / Restoring, migrating, and taking over a gateway
    • log files / Gateway log files
    • performance-monitor counters / Performance Monitor counters
  • Online Analytical Processing (OLAP) / Analysis Services
  • online transaction processing (OLTP) / Import versus DirectQuery
  • Open Database Connectivity (ODBC) / Data sources, On-premises data gateway planning

P

  • parameter tables
    • about / Parameter Tables, Parameter tables
    • measure groups / Measure groups
    • last refreshed date / Last refreshed date
    • measure support logic / Measure support logic
  • partial query folding / Partial query folding
  • performance optimization
    • about / Optimizing performance
    • import / Import
    • columnar compression / Columnar compression
    • memory analysis via DMVs / Memory analysis via DMVs
    • DirectQuery / DirectQuery 
  • performance testing
    • about / Performance testing
    • DAX Studio / DAX Studio
  • personal mode
    • versus on-premises data gateway / On-premises data gateway versus personal mode
  • Platform-as-a-Service (PaaS) / On-premises data gateway planning, Feature differences with the Power BI service
  • Power BI admin portal
    • about / Power BI Admin Portal
    • usage metrics / Usage metrics
    • Users and Audit logs / Users and Audit logs
    • Tenant settings / Tenant settings
    • Embed Codes / Embed Codes
    • Organizational Custom visuals / Organizational Custom visuals
  • Power BI apps
    • about / Power BI apps
    • licensing apps / Licensing apps
    • app deployment process / App deployment process
    • user permissions / User permissions
    • publishing / Publishing apps
    • installing / Installing apps
    • mobile apps / Apps on Power BI mobile
    • updates / App updates
    • dataset-to-workspace relationship / Dataset-to-workspace relationship
    • versus sharing dashboards and reports / Sharing versus Power BI apps
  • Power BI datasets
    • Live connections / Live connections to Power BI datasets
    • source datasets, switching / Switching source datasets
  • Power BI deployment, modes
    • about / Power BI deployment modes
    • Corporate BI / Corporate BI
    • Self-Service Visualization / Self-Service Visualization
    • Self-Service BI / Self-Service BI
    • selecting / Choosing a deployment mode
  • Power BI Desktop
    • versus Analysis Services / Analysis Services Models versus Power BI Desktop
    • migrating, to Analysis Services / Migration of Power BI Desktop to Analysis Services
  • Power BI licenses
    • about / Power BI licenses
    • scenarios / Power BI license scenarios
    • Power BI Premium features / Power BI Premium features
  • Power BI mobile applications / Power BI mobile applications
  • Power BI Premium
    • about / Power BI Premium
    • capabilities / Power BI Premium capabilities
    • Corporate Power BI datasets / Corporate Power BI datasets
    • capacity nodes / Premium capacity nodes
    • frontend resource, versus backend resource / Frontend versus backend resources
  • Power BI Premium administrators
    • responsibilities / Power BI Premium capacities
  • Power BI Premium calculator
    • URL / Power BI license scenarios, Premium capacity estimations
  • Power BI Premium capacities
    • about / Power BI Premium capacities
    • allocation / Capacity allocation
    • monitoring / Create, size, and monitor capacities, Monitor premium capacities
    • creating / Create, size, and monitor capacities
    • sizing / Create, size, and monitor capacities
    • size, modifying / Change capacity size
    • app workspace assignment / App workspace assignment
    • capacity admins / Capacity admins
  • Power BI Premium capacity allocation
    • about / Power BI Premium capacity allocation
    • Corporate BI Capacity / Corporate and Self-Service BI capacity 
    • Self-Service BI capacity / Corporate and Self-Service BI capacity 
    • resource utilization / Power BI Premium resource utilization
    • data model optimizations / Data model optimizations
    • report optimization / Report and visualization optimizations
    • visual optimization / Report and visualization optimizations
  • Power BI Premium P2 / Hardware and user licensing
  • Power BI project roles
    • about / Power BI project roles
    • dataset designer / Dataset designer
    • report authors / Report authors
    • Power BI admin / Power BI admin
    • project role collaboration / Project role collaboration
  • Power BI project template
    • about / Sample Power BI project template 
    • Adventure Works BI / Sample template – Adventure Works BI
  • Power BI publisher for Excel
    • about / Power BI Publisher for Excel
    • URL / Power BI Publisher for Excel
  • Power BI Report Server (PBIRS)
    • about / SQL Server Reporting Services
    • planning / Planning for the Power BI Report Server
    • feature differences / Feature differences with the Power BI service
    • SQL Server Reporting Services / Parity with SQL Server Reporting Services
    • data sources / Data sources and connectivity options
    • connectivity options / Data sources and connectivity options
    • hardware, requisites / Hardware and user licensing
    • user licensing / Hardware and user licensing
    • pro licenses, for report authors / Pro licenses for report authors
    • alternative deployment models / Alternative and hybrid deployment models
    • hybrid deployment models / Alternative and hybrid deployment models
    • reference topology / Report Server reference topology
    • URL / Installation
  • Power BI service administrator role / Power BI admin
  • Power BI Template (.PBIT) / Data Source Parameters
  • premium capacity estimations / Premium capacity estimations
  • prior year-to-date (PYTD) / Top N visual-level filters
  • privacy levels
    • about / Privacy levels
    • public / Privacy levels
    • organizational / Privacy levels
    • private / Privacy levels
    • none / Privacy levels
  • project analysis / Sample project analysis
  • proof-of-concept (POC) / Choosing a deployment mode
  • Provision Azure Analysis Services / Provision Azure Analysis Services 
  • Publish to web / Publish to web
  • Pulse chart / Pulse Chart

Q

  • query design per dataset mode
    • about / Query design per dataset mode
    • import mode dataset queries / Import mode dataset queries
    • DirectQuery dataset queries / DirectQuery dataset queries
  • query folding
    • about / Query folding
    • partial query folding / Partial query folding
  • Query Processing Units (QPUs) / Provision Azure Analysis Services 
  • Quick Insights
    • about / Quick Insights 
    • features / Explain the increase/decrease

R

  • ranking metrics
    • about / Ranking metrics
    • dynamic ranking measures / Dynamic ranking measures
  • relationships
    • about / Relationships
    • uniqueness / Uniqueness 
    • ambiguity / Ambiguity
    • single-direction relationships / Single-direction relationships
    • direct flights only / Direct flights only
    • bidirectional relationships / Bidirectional relationships
    • CROSSFILTER function / The CROSSFILTER function
  • report design summary / Report design summary
  • report filter scopes
    • about / Report filter scopes
    • conditions / Report filter conditions
    • report filters / Report and page filters
    • page filter / Report and page filters, Page filter or slicer?
    • slicer / Page filter or slicer?
    • relative date filtering / Relative date filtering
    • visual-level filtering / Visual-level filtering
    • top N visual-level filters / Top N visual-level filters
  • report planning
    • about / Report planning
    • Power BI report architecture / Power BI report architecture
  • reports
    • versus dashboards / Dashboards versus reports
    • sharing / Sharing dashboards and reports
  • Report server administration
    • about / Report server administration
    • Power BI report content, securing / Securing Power BI report content
    • execution logs / Execution logs
  • Report Server Configuration Manager
    • about / Configuration
    • Service Account / Service Account
    • Remote Report Server Database / Remote Report Server Database
    • Office Online Server, for Excel Workbooks / Office Online Server for Excel Workbooks
  • Report Server Desktop Application
    • about / Report Server Desktop Application
    • desktop versions, executing side-by-side / Running desktop versions side by side
  • Report Server product key
    • retrieving / Retrieve the Report Server product key
  • Report Server Web Portal
    • about / Report Server Web Portal
    • scheduled data refresh / Scheduled data refresh
    • data source authentication / Data source authentication
  • responsive visuals / Responsive visuals
  • return on investment (ROI) / Sample Power BI project template 
  • row-level security (RLS) / Self-Service BI, Privacy levels, Security Tables, User permissions, Azure Active Directory

S

  • scalar function / Scalar and table functions
  • Scale Power BI Report Server / Scale Power BI Report Server
  • scatter charts / Scatter charts
  • scheduled data refresh / Scheduled data refresh
  • scopes
    • sharing / Sharing scopes
  • security roles
    • about / Security roles
    • dynamic row-level security / Dynamic row-level security
  • security tables / Security Tables
  • Selection Pane / Selection pane and the Spotlight property
  • self-service BI (SSBI) / Data governance for Power BI
  • Self-Service BI Capacity / Corporate and Self-Service BI capacity 
  • Self-Service BI workspace
    • about / Self-Service BI workspace
    • content distribution / Self-Service content distribution
    • risks / Risks to Self-Service BI
  • SharePoint Online embedding / SharePoint Online embedding
  • Single Dataset Across Workspaces / Power BI Premium capabilities
  • single sign-on (SSO) / On-premises data gateway planning
  • slicers
    • about / Slicers
    • synchronization / Slicer synchronization
    • custom slicer parameters / Custom slicer parameters
  • Software-as-a-Service (SaaS) / Feature differences with the Power BI service, Custom application embedding
  • Spotlight property / Selection pane and the Spotlight property
  • SQL Server Analysis Services (SSAS)
    • about / Corporate BI, SQL views versus M queries, Live connections to Power BI datasets, On-premises data gateway planning, Office Online Server for Excel Workbooks, Data source authentication, Dataset-to-workspace relationship, Data governance for Power BI, Premium capacity estimations
    • versus Analysis Services / Azure Analysis Services versus SSAS
    • migrating, to Analysis Services / SSAS to Azure AS Migration
  • SQL Server Data Tools (SSDT) / SQL Server Reporting Services, Feature differences with the Power BI service, Report Server Web Portal, Scale
  • SQL Server Integration Service (SSIS) / Data profiling, Data governance for Power BI, Audit log monitoring solutions, Azure Analysis Services versus SSAS
  • SQL Server Management Studio (SSMS) / DAX Studio, Tracing a Power BI dataset via DAX Studio, Live connections to Analysis Services models, Scheduled data refresh, Securing Power BI report content, Development and management tools
  • SQL Server Reporting Services (SSRS)
    • about / Scalar and table functions, Tables versus charts, Drillthrough report pages, SQL Server Reporting Services, Parity with SQL Server Reporting Services
    • migrating from / Migrating from SQL Server Reporting Services
  • SQL view
    • about / SQL views
    • versus M queries / SQL views versus M queries
    • examples / SQL view examples
    • date dimension view / Date dimension view
    • Mark As Date Table / Mark As Date Table
    • Product Dimension view / Product Dimension view
    • dimensions, modifying / Slowly-changing dimensions
  • staged deployment
    • about / Staged deployments
    • workspace datasets / Workspace datasets
    • workspace dataset / Workspace datasets
    • Power BI REST API / Power BI REST API
    • client application ID / Client application ID
    • workspace / Workspace and content IDs
    • content IDs / Workspace and content IDs
    • PowerShell sample scripts / PowerShell sample scripts
  • subject matter experts (SMEs) / Project discovery and ingestion

T

  • table functions / Scalar and table functions
  • tables
    • versus charts / Tables versus charts
  • Tabular Model Scripting Language (TMSL) / Development and management tools
  • Team Foundation Server (TFS) / Visual Studio
  • Trend Line / Trend Line

U

  • upgrade cycles / Upgrade cycles 
  • usage metrics reports / Usage metrics reports
  • user acceptance testing (UAT) / Staged deployments
  • User Principal Name (UPN) / Dynamic row-level security, Email Subscriptions

V

  • version control
    • about / Version control
    • OneDrive, for Business version history / OneDrive for Business version history
    • source control, for M code / Source control for M and DAX code
    • source control, for DAX code / Source control for M and DAX code
    • source code, for DAX code / Source control for M and DAX code
  • view mode / View mode
  • virtual machines (VMs) / On-premises data gateway planning, Azure Analysis Services versus SSAS
  • visual
    • selecting / Choosing the visual
    • tables, versus charts / Tables versus charts
    • chart selection / Chart selection
  • visual interactions
    • about / Visual interactions
    • edit interactions / Edit interactions
    • what-if parameters / What-if parameters
  • visualization
    • best practices / Visualization best practices
    • anti-patterns / Visualization anti-patterns
  • visualization, formatting
    • about / Visualization formatting
    • visual-level formatting / Visual-level formatting
    • line and column / Line and column charts
    • tooltips / Tooltips
    • report page tooltips / Report page tooltips
    • column-chart conditional formatting / Column chart conditional formatting
    • line chart conditional formatting / Line chart conditional formatting
    • table / Table and matrix
    • matrix / Table and matrix
    • table conditional formatting / Table and matrix conditional formatting
    • matrix conditional formatting / Table and matrix conditional formatting
    • values as rows / Values as rows
    • scatter charts / Scatter charts
  • Visual Studio Team Services (VSTS) / Visual Studio, Version control, Analysis Services Models versus Power BI Desktop
  • Volume Licensing Service Center (VLSC) / Retrieve the Report Server product key

W

  • waterfall chart breakdown / Waterfall chart breakdown
  • Web Data Connector (WDC) / Determining whether a gateway is needed
  • week-to-date (WTD) / Date intelligence metrics

Y

  • year-over-year (YOY) / Current versus prior and growth rates, Report planning
  • year-over-year year-to-date (YOY YTD) / Current versus prior and growth rates
  • year-to-date (YTD) / Dataset designer, Pulse Chart
lock icon The rest of the chapter is locked
arrow left Previous Section
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at £13.99/month. Cancel anytime
Visually different images