Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Adam Aspin
High Impact Data Visualization with Power View, Power Map, and Power BI
Cover
Title
Copyright
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1: Self-Service Business Intelligence
The Microsoft Self-Service Business Intelligence Solution
The Excel BI Toolkit
Power BI
The Excel BI Toolkit and Power BI
Power Query
PowerPivot
Power View
Power Map
Power BI
Preparing the Self-Service BI Environment
PowerPivot
Power View
Power Query
Power Map
Power BI
Adding a Power BI Site
The Windows Power BI App
Corporate BI or Self-Service BI?
The Excel Data Model
How This Book Is Designed to Be Read
Discovering Data
Creating a Data Model
Taking Data and Preparing It for Output
Taking Existing Excel BI and Sharing It
Delivering Geodata
Delivering Excel BI to Mobile Devices
To Learn the Product Suite Following a Real-World Path
The Self-Service Business Intelligence Universe
Conclusion
Chapter 2: Power View and Tables
The Power View Experience
Adding a Power View Sheet to an Excel Workbook
The Power View Interface
The Power View Ribbon
The Field List
Using the Field List
Renaming or Deleting a Power View Report
Tables in Power View
Adding a Table
Deleting a Table
Changing the Table Size and Position
Changing Column Order
Removing Columns from a Table
Types of Data
Data and Aggregations
Enhancing Tables
The Design Ribbon
Row Totals
Formatting Columns of Numbers
Default Formatting
Changing Column Widths
Font Sizes in Tables
Copying a Table
Sorting by Column
Table Granularity
Matrix Tables
Row Matrix
Column Matrix
Sorting Data in Matrix Tables
Drilling Through with Matrix Tables
Drilling Down
Drilling Up
Reapplying Matrix Visualization
Drilling Through with Column Hierarchies
Card Visualizations
Card Visualization Styles
Sorting Data in Card-View Tables
Switching Between Table Types
Key Performance Indicators (KPIs)
Conclusion
Chapter 3: Filtering Data in Power View
Filters
Hiding and Displaying the Filters Area
View Filters
Adding Filters
The (All) Filter
Clearing Filters
Deleting Filters
Expanding and Collapsing Filters
Subsetting Large Filter Lists
Filtering Different Data Types
Numeric Data
Date and Time Data
Other Data Types
Multiple Filters
Advanced Filters
Applying an Advanced Filter
Clearing an Advanced Filter
Advanced Wildcard Filters
Numeric Filters
Date and Time Filters
Complex Filters
Advanced Text Filter Options
Advanced Numeric Filter Options
Advanced Date Filter Options
Visualization-Level Filters
Filter Hierarchy
Filtering Tips
Don’t Filter Too Soon
Drill-Down and Filters
Annotate, Annotate, Annotate
Conclusion
Chapter 4: Charts in Power View
A First Chart
Creating a First Chart
Deleting a Chart
Basic Chart Modification
Basic Chart Types
Essential Chart Adjustments
Resizing Charts
Repositioning Charts
Sorting Chart Elements
Font Size
Applying Color to Bar and Column Charts
Multiple Data Values in Charts
Data Details
The Layout Ribbon
Enhancing Charts
Chart Legends
Chart Title
Chart Data Labels
Drilling Down
Popping Charts Out and In
Chart Filters
Conclusion
Chapter 5: Advanced Charting with Power View
Multiple Charts
Multiple Bar or Column Charts
Specifying Vertical and Horizontal Selections
Specifying the Layout of Multiple Chart Visualizations
Creating Horizontal Multiples
Defining the Multiples Grid
Multiple Line Charts
Multiple Pie Charts
Drilling Down with Multiple Charts
Scatter Charts
Drilling Down with Scatter Charts
Scatter Charts to Display Flattened Hierarchies
Scatter Chart Multiples
Bubble Charts
Bubble Chart Data Labels and Legend
Multiple Bubble Elements
Bubble Chart Multiples
Play Axis
Tiles with Charts
Conclusion
Chapter 6: Interactive Data Selection
Tiles
Creating a Tiled Visualization from Scratch
Adjusting Tile Display
Some Variations on Ways of Creating Tiled Visualizations
Creating a Tiled Visualization from Scratch—Another Variant
Adding Tiles to an Existing Visualization
Adding Tiles to an Existing Visualization—Another Variant
Modifying an Existing Visualization Inside a Tile Container
Re-creating a Visualization Using Existing Tiles
Re-creating a Visualization Using Existing Tiles—A Simple Variant
Removing Tiles from a Visualization
Deleting a Tile Visualization
Tile Types
Using Tiles
Filtering Tiles
Tiles with No Data
Changing the Inner Visualization
Tiles and Multiple Charts
Slicers
Adding a Slicer
Applying a Slicer
Clearing a Slicer
Deleting a Slicer
Modifying a Slicer
Using Charts as Slicers
Charts as Slicers
Highlighting Chart Data
Cross-Chart Highlighting
Highlighting Data in Bubble Charts
Charts as Filters
Scatter Chart Filtering
Column and Bar Charts as Filters
Choosing the Correct Approach to Interactive Data Selection
Filter Granularity
Conclusion
Chapter 7: Images and Presentation
Titles
Adding a Title
Moving and Resizing Titles
Formatting a Title
The Text Ribbon
Adding Text Boxes to Annotate a Report
Deleting Text Boxes
The Context Menu
Altering the Font Used in a Report
Font Family
Text Size
Altering the Theme of a Report
Deciphering Themes
Applying a Report Background
Images
Image Sources
Background Images
Images in Tables
Images in Slicers
Images in Tiles
Independent Images
Layering Visualizations
Some Uses for Independent Images
Image File Format
Preparing Images
Conclusion
Chapter 8: Mapping Data in Power View
Bing Maps
Maps in Power View
Adjusting Map Display in Power View
Positioning the Map Elements
Zooming In or Out
Removing or Adding a Map Title
Modifying the Map Background
Filtering Map Data
Multi-Value Series
Highlighting Map Data
Adjusting a Legend
Adding Tiles to Maps
Multiple Maps
Drilling Down in Maps
Conclusion
Chapter 9: PowerPivot Basics
The PowerPivot Environment
Using PowerPivot
The PowerPivot Ribbons
Loading Data into PowerPivot
Loading Data from SQL Server
Preview and Filter Tables
Importing Other Tables from an Existing Source
Modifying Existing Imports
Loading Data from Excel
PowerPivot Data Sources
Refreshing Data
Refreshing Data from External Data Sources
Refreshing Data from Linked Excel Worksheets
Deleting a Connection
PowerPivot Data Types
Managing PowerPivot Data
Manipulating Tables
Moving Around a Table
Manipulating Columns
Formatting PowerPivot Tables
Manipulating Data in PowerPivot
Sorting Data in PowerPivot Tables
Filtering Data in PowerPivot Tables
Conclusion
Chapter 10: Extending the Excel Data Model Using PowerPivot
Designing a PowerPivot Data Repository
Data View and Diagram View
Creating Relationships
Creating Relationships Manually
Creating Relationships Automatically
Deleting Relationships
Managing Relationships
Preparing a Date Table
Marking a Table as a Date Table
Calculations
Calculated Columns
Simple Calculations
Looking Up Related Data
Making Good Use of the Formula Bar
Multiline Formulas
Calculated Fields
A First Calculated Field: Number of Cars Sold
Basic Aggregations in Calculated Fields
More Advanced Aggregations
Time-Dependent Calculations
Other Possibilities
Putting It All Together
A Few Comments and Notes on Using Calculated Fields
Calculation Options
Creating Pivot Tables from PowerPivot
Creating a Pivot Table
The PowerPivot Ribbon
Copying Data from PowerPivot
Conclusion
Chapter 11: PowerPivot for Self-Service BI
Default Field Set
Table Behavior
Sort Column
Row Identifier
Keep Unique Rows
Default Label
Set a Default Aggregation (Summarize By)
Preparing Images for Power View
Binary Images
Image URLs
Default Image
Preparing Hyperlinks for Power View
Creating Hierarchies
Modifying Hierarchies
Deleting a Hierarchy
Hiding the Original Field
Hiding Hierarchies from the Diagram View
Key Performance Indicators (KPIs)
Creating a KPI
KPI Options
KPI Descriptions
Calculated KPI Targets
Modifying a KPI
Deleting a KPI
Perspectives
Creating a Perspective
Applying a Perspective
Data Categories
Hiding Columns from Client Tools
Preparing Data for Natural Language Querying
Optimizing File Size
Conclusion
Chapter 12: Discovering and Loading Data with Power Query
The Power Query Interface
The Power Query Ribbon
Data Sources
Loading Data
Web Pages
CSV Files
Text Files
XML Files
Excel
Microsoft Access Databases
Relational Databases
Database Metadata
Data Discovery or Data Load?
Peeking at Data
Searching for Data
Conclusion
Chapter 13: Transforming Data with Power Query
Modifying Data
The Power Query Window
The Power Query Ribbons
Dataset Shaping
Using First Row as Headers
Filtering Data
Extending Data
Duplicating Column
Splitting Columns
Data Cleansing and Modification
Changing Datatype
Replacing Values
Transforming Column Contents
Filling Down
Sorting Data
Managing the Transformation Process
Modifying a Step
Renaming a Step
Deleting a Step or a Series of Steps
Adding a Step
Altering Process Step Sequencing
An Approach to Sequencing
Changing the Data Structure
Unpivoting Tables
Grouping Records
Merging Data
Appending Data
Adding the Contents of One Query to Another
Adding Multiple Files from a Source Folder
Data Destinations
The Power Query View Ribbon
Effective Use of the Formula Bar
Replacing Values
Transforming
Grouping
Extending a Filter
Conclusion
Chapter 14: Power Map
Bing Maps
Running Power Map
The Power Map Window
The Power Map Ribbon
Region Maps
Power Map Source Data
Refreshing Data
Geographical Data Types
Using the Task Panel
Showing and Hiding the Task Panel
Task Panel Panes
The Task Panel Data Views
Removing a Field
Moving Around in Power Map
Moving Around a Map
Zooming In or Out
Changing the Pitch of a Map
Flat Map and 3-D Globe
Going to a Specific Location
Power Map Aggregations
Map Types
The Various Map Types, by Example
Bubble Maps
Column Maps
Heat Maps
Region Maps
Presentation Options
The Settings View
Power Map Themes
Text Boxes
Timelines
Adding a Timeline
Using a Timeline
Using Layers
2-D Charts
2-D Chart Types
Hiding the Map Data
Power Map Tours
Creating Power Map Tours
Deleting a Power Map Tour
Power Map Movies
Transitions
Exporting a Movie
Conclusion
Chapter 15: Self-Service Business Intelligence with Power BI
Using Excel Workbooks in Power BI
Adding a Workbook
Enabling Team Site Excel Files
Adding a Workbook to Featured Reports
Marking a Workbook as a Favorite
Interacting with a Workbook
Downloading a Copy of an Excel Workbook
Removing a Workbook from Power BI
The Power BI App on Tablet Devices
Running the Power BI App
Adding Reports to the Power BI App from the Power BI Site
Removing Reports from the Power BI App
Using Reports in the Power BI App
Synchronizing the Power BI App with the Power BI Site
Power BI on Other Mobile Devices
Keeping Power BI Data Up to Date
Data Management Gateway
Download a Data Management Gateway to a Workstation or Server on the Corporate Network
Installing and Configuring a Data Management Gateway from the Power BI Admin Page
The Data Management Gateway Application
Deleting a Gateway
Data Sources
Using a Connection String to Determine Connection Settings
Deleting a Data Source
Data Refresh
Scheduled Data Refresh
Ad-Hoc Data Refresh
Using Data Sources
Shared Queries
OData Feeds
My Power BI
Power BI Admin
Role Management
The Data Steward Group
Checking System Health
Exporting System Health Logs
Natural Language Querying
Conclusion
Appendix A: Sample Data
Downloading the Sample Data
The Sample Data
Sample Files
Sample Database
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset