Learn Power BI : A Beginner’s Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI.

Cover
 Title Page
 Copyright and Credits
 About Packt
 Contributors
 Table of Contents
 Preface
 Section 1: The Basics
 Chapter 1: Introduction to Business Intelligence and Power BI
 Key concepts of business intelligence
 Domain
 Data
 Internal and external data
 Structured, unstructured, and semi-structured data
 Model
 Organizing
 Transforming and cleansing
 Defining and categorizing
 Analysis
 Visualization
 The Power BI ecosystem
 Core, Power BI-specific
 Core, non-Power BI-specific
 Non-core, Power BI-specific
 Natively integrated Microsoft technologies
 The extended Power BI ecosystem Power BI licensingPower BI Free
 Power BI Pro
 Power BI Premium
 Power BI Embedded
 Power BI Report Server
 Power BI Desktop and Service
 Power BI Desktop
 Getting data
 Creating a data model
 Analyzing data
 Creating and publishing reports
 Power BI Service
 Viewing and editing reports
 Creating dashboards
 Sharing and collaborating with others
 Accessing and creating apps
 Refreshing data
 Summary
 Questions
 Further reading
 Section 2: The Desktop
 Chapter 2: Up and Running with Power BI Desktop
 Technical requirements
 Downloading and installing Power BI Desktop Power BI Desktop (the trusted Microsoft Store app)Power BI Desktop (MSI)
 Power BI Desktop (Report Server edition)
 Running Power BI Desktop
 Touring the Desktop
 Title Bar and Quick Access Toolbar
 The Ribbon
 The Formula Bar
 Understanding DAX
 Views Bar
 Panes
 Canvas
 Page tabs
 Footer
 Generating data
 Creating a calculated table
 Creating calculated columns
 Formatting columns
 Creating visualizations
 Creating your first visualization
 Formatting your visualization
 Adding analytics to your visualization
 Creating and using a slicer
 Creating more visualizations Editing visual interactionsSummary
 Questions
 Further reading
 Chapter 3: Connecting and Shaping Data
 Technical requirements
 Getting data
 Creating your first query
 Getting additional data
 Transforming data
 Touring the Power Query Editor
 The Title Bar and Quick Access Toolbar
 The Ribbon
 Formula Bar
 The Queries Pane
 The Query Settings Pane
 Data Canvas
 Footer
 Transforming budget and forecast data
 Cleaning up extraneous bottom rows
 Filtering rows
 Unpivoting data
 Using Fill
 Changing data types
 Transforming people, tasks, and January data
 Transforming the People query Transforming the Tasks queryTransforming the January query
 Merging, copying, and appending queries
 Merging queries
 Expanding tables
 Disabling the loading of queries
 Copying queries
 Changing sources
 Appending queries
 Verifying and loading data
 Organizing queries
 Checking column quality, distribution, and profiles
 Loading the data
 Summary
 Questions
 Further reading
 Chapter 4: Creating Data Models and Calculations
 Technical requirements
 Creating a data model
 Touring the Model view
 Title Bar and Quick Access Toolbar
 Ribbon
 Views Bar
 Panes
 Canvas
 Layout Tabs
 Footer