Pro Power BI Desktop, Second Edition

  • 10h 36m
  • Adam Aspin
  • Apress
  • 2018

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

About the Author

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

In this Book

  • Introduction to Power BI Desktop
  • Discovering and Loading File-Based Data with Power BI Desktop
  • Loading Data from Databases and Data Warehouses
  • DirectQuery and Connect Live
  • Loading Data from the Web and the Cloud
  • Dealing with Datasets
  • Data Transformation
  • Data Mashup
  • Structuring, Managing, and Parameterizing Queries
  • Creating a Data Model
  • Extending the Data Model with Calculated Columns
  • Adding Measures to the Data Model
  • Analyzing Data over Time
  • Table Visuals
  • Matrix and Card Visuals
  • Charts in Power BI Desktop
  • Formatting Charts in Power BI Desktop
  • Other Types of Visuals
  • Maps in Power BI Desktop
  • Filtering Data
  • Using Slicers
  • Enhancing Dashboards