Pro Power BI Desktop

1. Front Matter

   Pages i-xxxvi

   PDF

2. Introduction to Power BI Desktop

   • Adam Aspin

   Pages 1-38

3. Discovering and Loading File-Based Data with Power BI Desktop

   • Adam Aspin

   Pages 39-63

4. Loading Data from Databases and Data Warehouses

   • Adam Aspin

   Pages 65-109

5. DirectQuery and Connect Live

   • Adam Aspin

   Pages 111-123

6. Loading Data from the Web and the Cloud

   • Adam Aspin

   Pages 125-158

7. Dealing with Datasets

   • Adam Aspin

   Pages 159-196

8. Data Transformation

   • Adam Aspin

   Pages 197-232

9. Data Mashup

   • Adam Aspin

   Pages 233-262

10. Structuring, Managing, and Parameterizing Queries

    • Adam Aspin

    Pages 263-294

11. Creating a Data Model

    • Adam Aspin

    Pages 295-329

12. Extending the Data Model with Calculated Columns

    • Adam Aspin

    Pages 331-363

13. Adding Measures to the Data Model

    • Adam Aspin

    Pages 365-392

14. Analyzing Data over Time

    • Adam Aspin

    Pages 393-424

15. Table Visuals

    • Adam Aspin

    Pages 425-456

16. Matrix and Card Visuals

    • Adam Aspin

    Pages 457-489

17. Charts in Power BI Desktop

    • Adam Aspin

    Pages 491-526

18. Formatting Charts in Power BI Desktop

    • Adam Aspin

    Pages 527-552

19. Other Types of Visuals

    • Adam Aspin

    Pages 553-581

20. Maps in Power BI Desktop

    • Adam Aspin

    Pages 583-610

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

• Power BI
• Power View
• Power Query
• SQL Server
• Visualization
• Business Intelligence
• Dashboards
• Excel

• Stoke-on-Trent, United Kingdom

  Adam Aspin

Adam Aspin is an independent business intelligence consultant based in the United Kingdom. He has worked with SQL Server for more than 20 years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite.

A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from Access to Oracle and MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe using SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, SharePoint, and Power BI.

Business Intelligence has been Adam's principal focus for the last 15 years. He has applied his skills for a range of clients in industry sectors such as finance, utilities, telecommunications, insurance, manufacturing, and banking.

Adam is a frequent contributor to SQLServerCentral.com and Simple-Talk. He has written numerous articles for various French IT publications. A fluent French speaker, Adam has worked in France and Switzerland for many years. He speaks regularly at events such as SQLBits, SQL Saturdays, and local SQL Server user groups.

Adam is the author of SQL Server Data Integration Recipes (Apress), High Impact Data Visualization with Power View, Power Map, and Power BI (Apress), and Business Intelligence with SQL Server Reporting Services (Apress).

Policies and ethics