Microsoft Power BI Quick Start Guide : build dashboards and visualizations to make your data come to life/ Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana

Format:

Book

Author/Creator:

Knight, Devin, author.

Knight, Brian, author.

Pearson, Mitchell, author.

Quintana, Manuel, author.

Language:

English

Subjects (All):

MBA 511.

Business intelligence--Computer programs.

Business intelligence.

Information visualization--Computer programs.

Information visualization.

Business Data processing.

Visual analytics.

Microsoft Excel (Computer file).

Microsoft PowerPivot (Computer file).

Physical Description:

1 online resource (181 pages)

Edition:

1st edition

Other Title:

Microsoft Power Business Intelligence quick start guide

Place of Publication:

United Kingdom : Packt Publishing, 2018.

System Details:

text file

Summary:

Bring your data to life with Power BI Key Features Get to grips with the fundamentals of Microsoft Power BI and its Business Intelligence capabilities Build accurate analytical models, reports and dashboards Get faster and more intuitive insights from your data using Microsoft Power BI Book Description Microsoft Power BI is a cloud-based service that helps you easily visualize and share insights using your organization's data.This book will get you started with business intelligence using the Power BI toolset, covering essential concepts such as installation,designing effective data models, as well as building basic dashboards and visualizations to make your data come to life You will learn how to get your data the way you want ? connecting to data sources sources and how to clean your data with the Power BI Query Editor. You will next learn how to properly design your data model to make your data easier to work with.. You will next learn how to properly design your data model to navigate table relationships and build DAX formulas to make your data easier to work with. Visualizing your data is another key element of this book, and you will learn how to follow proper data visualization styles and enhanced digital storytelling techniques. By the end of this book, you will understand how to administer your organization's Power BI environment so deployment can be made seamless, data refreshes can run properly, and security can be fully implemented What you will learn Connect to data sources using both import and DirectQuery options Use the Query Editor to apply data transformations and data cleansing processes, including learning how to write M and R scripts Design optimized data models by designing relationships and DAX calculations Leverage built-in and custom visuals to design effective reports Use the Power BI Desktop and Power BI Service to implement Row Level Security on your model Administer a Power BI cloud tenant for your organization Deploy your Power BI Desktop files into the Power BI Report Server Who this book is for This book is for aspiring Business Intelligence professionals who want to get up and running with Microsoft Power BI. If you have a basic understanding of BI concepts and want to learn how to apply them using Microsoft Power BI, this book is for you.

Contents:

Cover

Title Page

Copyright and Credits

Packt Upsell

Foreword

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

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

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

Chapter 3: 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

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

Chapter 5: 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

Chapter 6: Digital Storytelling with Power BI

Configuring drillthrough filters

Storytelling with the Selection pane and bookmarks

Bookmarks pane

Selection pane

Chapter 7: 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

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

Deploying to Power BI Report Server

Securing reports

Other Books You May Enjoy

Index.

Notes:

Online resource; Title from title page (viewed July 30, 2018)

ISBN:

9781789130928

9781789138221