Pro Power BI Desktop

✍ Scribed by Adam Aspin (auth.)

• Publisher: Apress
• Year: 2018
• Tongue: English
• Leaves: 783
• Edition: 2
• Category: Library

✦ Synopsis

Deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features, including combo charts, Cartesian charts, trend lines, use of gauges, and more. Also covered are Top-N features, the ability to bin data into groupings and chart the groupings, and new techniques for detecting and handling outlier data points.

You can take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease and then add metrics and KPIs to project the insights that create your competitive advantage. Make raw data into clear, accurate, and interactive information with Microsoft’s free self-service business intelligence tool.

Pro Power BI Desktop shows you how to choose from a wide range of built-in and third-party visualization types so that your message is always enhanced. You’ll be able to deliver those results on the PC, tablets, and smartphones, as well as share results via the cloud. This book helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you.

What You'll Learn

• Deliver attention-grabbing information, turning data into insight
  
• Mash up data from multiple sources into a cleansed and coherent data model
• Create dashboards that help in monitoring key performance indicators of your business
• Build interdependent charts, maps, and tables to deliver visually stunning information
• Share business intelligence in the cloud without involving IT
• Deliver visually stunning and interactive charts, maps, and tables
• Find new insights as you chop and tweak your data as never before
  
• Adapt delivery to mobile devices such as phones and tablets
  

Who This Book Is For
Everyone from CEOs and Business Intelligence developers to power users and IT managers

✦ Table of Contents

Front Matter ....Pages i-xxxvi
Introduction to Power BI Desktop (Adam Aspin)....Pages 1-38
Discovering and Loading File-Based Data with Power BI Desktop (Adam Aspin)....Pages 39-63
Loading Data from Databases and Data Warehouses (Adam Aspin)....Pages 65-109
DirectQuery and Connect Live (Adam Aspin)....Pages 111-123
Loading Data from the Web and the Cloud (Adam Aspin)....Pages 125-158
Dealing with Datasets (Adam Aspin)....Pages 159-196
Data Transformation (Adam Aspin)....Pages 197-232
Data Mashup (Adam Aspin)....Pages 233-262
Structuring, Managing, and Parameterizing Queries (Adam Aspin)....Pages 263-294
Creating a Data Model (Adam Aspin)....Pages 295-329
Extending the Data Model with Calculated Columns (Adam Aspin)....Pages 331-363
Adding Measures to the Data Model (Adam Aspin)....Pages 365-392
Analyzing Data over Time (Adam Aspin)....Pages 393-424
Table Visuals (Adam Aspin)....Pages 425-456
Matrix and Card Visuals (Adam Aspin)....Pages 457-489
Charts in Power BI Desktop (Adam Aspin)....Pages 491-526
Formatting Charts in Power BI Desktop (Adam Aspin)....Pages 527-552
Other Types of Visuals (Adam Aspin)....Pages 553-581
Maps in Power BI Desktop (Adam Aspin)....Pages 583-610
Filtering Data (Adam Aspin)....Pages 611-641
Using Slicers (Adam Aspin)....Pages 643-672
Enhancing Dashboards (Adam Aspin)....Pages 673-704
PowerBI.com (Adam Aspin)....Pages 705-747
Sample Data (Adam Aspin)....Pages 749-751
Back Matter ....Pages 753-761

✦ Subjects

Database Management