Microsoft Power BI Quick Start Guide电子书

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