Microsoft Power BI quick start guide : bring your data to life through data modeling, visualization, digital story telling, and more / Devin Knight [and three others].

Format:

Book

Author/Creator:

Knight, Devin, author.

Language:

English

Subjects (All):

Operations research.

Information technology: general issues.

Enterprise software.

Physical Description:

1 online resource (295 pages) : illustrations

Edition:

Second edition.

Place of Publication:

Birmingham, England ; Mumbai, India : Packt Publishing, Limited, [2020]

Summary:

Microsoft Power BI Quick Start Guide, Second Edition gets you up to speed with Power BI quickly, enabling you to derive actionable insights from your data using the data visualization capabilities of Microsoft Power BI within a short span of time.

Contents:

Cover

Copyright

Packt Page

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

Composite models

Live connection

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

Column From Examples

Advanced data transformation options

Conditional Columns

Fill Down

Unpivot

Merge Query

Append Query

Leveraging R

Installation and configuration

The R script transform

AI Insights

Sentiment Analysis with Text Analytics

The M formula language

#shared

Chapter 3: Building the Data Model

Building relationships

Editing relationships

Creating a new relationship

Creating a relationship on the Datekey

Disabling automatically created date tables

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

Data model performance

Query performance

Data model design methodologies

Aggregations

Processing performance

Query folding

Incremental refresh

Best practices

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 measures - basic aggregations

Total Sales

Total Cost

Profit

Profit Margin

Assignment of calculated measures

Display folders

Filter context

Calculate

The percentage of total calculation

Time intelligence

YTD Sales

YTD Sales (fiscal calendar)

Prior Year Sales

Role-playing tables with DAX

Chapter 5: Visualizing Data

Report view basics

Creating new visuals

Filtering visualizations and data

Cross-filtering and cross-highlighting

Edit interactions

Slicer

String/text

Numeric

Date

Visualizing tabular data

Table

Matrix

Visualizing categorical data

Bar and column charts

Pie and donut charts

Treemap

Scatter chart

Visualizing trend data

Line and Area charts

Combo charts

Ribbon chart

Waterfall chart

Funnel chart

Visualizing KPI data

Gauge

KPI

Visualizing data using cards

Card

Multi-row card

Visualizing geographical data

Map

Filled map

Shape map

ArcGIS Map

Azure maps

Natural language

Visuals from analytics

Power BI custom visuals

Data visualization tips and tricks

Changing visuals

Formatting visuals

The Analytics section

The Top N filter

Show value as

Chapter 6: Digital Storytelling with Power BI

Configuring drill through

Capturing report views with bookmarks

Combining object visibility with bookmarks

Bookmarking alternate views of the same data

Using buttons to select bookmarks

Report pages as tooltips

Chapter 7: Using a Cloud Deployment with the Power BI Service

Deploying reports 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

Chapter 8: Data Cleansing in the Cloud with Dataflows

Getting started with dataflows

Creating a dataflow

Using dataflows as a data source in Power BI Desktop

Chapter 9: On-Premises Solutions with Power BI Report Server

Deploying to Power BI Report Server

Securing reports

Other Books You May Enjoy

Index.

Notes:

Includes index.

Description based on print version record.

Description based on publisher supplied metadata and other sources.

ISBN:

9781800569942

1800569947

OCLC:

1204142816