book

Microsoft Power BI Dashboards Step by Step, First Edition

by Errin O’Connor

November 2018

Beginner to intermediate

305 pages

5h 59m

English

Microsoft Press

Read now

Unlock full access

Who this book is forThe Step by Step approachFeatures and conventionsDownload the practice filesEbook editionGet support and give feedback
An introduction to Power BIPower BI featuresPower BI platformsPower BI licensing modelsSet up Power BIPrepare a dashboard in Power BI serviceGeneral note for Power BI securitySkills reviewPractice tasks
Power BI architectureThe Power BI Admin PortalPower BI data models and report developmentSkills reviewPractice tasks

Overview of visuals in Power BIPower BI visuals out of the boxThird-party visuals in Power BIDrill through Power BI visualsApply filters in Power BI reportsSkills reviewPractice tasks
Data sources supported by Power BIBuild a Power BI report in Power BI DesktopPublish your report to Power BI serviceSkills reviewPractice tasks
Calculated columns and measuresDAX expressions syntax and contextDAX functionsSkills reviewPractice tasks
Import data from an Excel workbook into Power BIAdd a measure and a calculated columnAdd Power BI visuals to the reportArrange the visualsPrepare the report for mobile viewPublish and view the reportPrepare a dashboard from the reportSkills reviewPractice tasks
Build a Power BI report based on data from a SharePoint Online listBuild a Power BI report based on data from a SharePoint Online folderRefresh report data in a Power BI reportEmbed Power BI reports in SharePoint OnlineSkills reviewPractice tasks
Import data from a SharePoint On-Premises list into Power BICreate a Power BI reportSet up a data gatewayConfigure Power BI to use the data gateway and set up refresh functionalitySkills reviewPractice tasks
Import data from a SQL Server database into Power BICreate a Power BI reportSet up a data gatewayConfigure Row-Level Security (RLS) in Power BISkills reviewPractice tasks
Basic terminologyImport data from an SSAS cube into Power BICreate a Power BI reportSet up and configure a data gatewaySkills reviewPractice tasks
Overview of the Azure SQL portalImport data from an Azure SQL database into Power BICreate a Power BI reportSet up a live data connection and data refresh functionalitySkills reviewPractice tasks
Import data from an Oracle database into Power BICreate a Power BI reportSet up and configure a data gatewaySkills reviewPractice tasks
Import data from Dynamics 365 into Power BI DesktopCreate a Power BI reportImport data from Dynamics 365 into Power BI serviceEmbed a Power BI dashboard into a Dynamics 365 dashboardSet up data refresh functionalitySkills reviewPractice tasks

Overview

Your hands-on guide to building effective Power BI dashboards

Expand your expertise–and teach yourself how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making. If you're an experienced business intelligence professional or manager, you'll get all the guidance, examples, and code you need to succeed–even if you've never used Power BI before.

Successfully design, architect, and implement Power BI in your organization
Take full advantage of any Microsoft Power BI platform, including Power BI Premium
Make upfront decisions that position your Power BI project for success
Build rich, live dashboards to monitor crucial data from across your organization
Aggregate data and data elements from numerous internal and external data sources
Develop dynamic visualizations, including charts, maps, and graphs
Bring data to life with stunning interactive reports
Ensure dashboard security and compliance
Drive user adoption through effective training