Pro Power BI Dashboard Creation: Building Elegant and Interactive Dashboards with Visually Arresting Analytics

  • 4h 44m
  • Adam Aspin
  • Apress
  • 2022

Produce high-quality, visually attractive analysis quickly and effectively with Microsoft’s key BI tool. This book teaches analysts, managers, power users, and developers how to harness the power of Microsoft’s self-service business intelligence flagship product to deliver compelling and interactive insight with remarkable ease. It then shows you the essential techniques needed to go from source data to dashboards that seize your audience’s attention and provide them with clear and accurate information.

As well as producing elegant and visually arresting output, you learn how to enhance the user experience through adding polished interactivity. This book shows you how to make interactive dashboards that allow you to guide users through the meaning of the data that they are exploring. Drill down features are also covered that allow you and your audience to dig deeper and uncover new insights by exploring anomalous and interesting data points.

Reading this book builds your skills around creating meaningful and elegant dashboards using a range of compelling visuals. It shows you how to apply simple techniques to convert data into business insight. The book covers tablet and smartphone layouts for delivering business value in today’s highly mobile world. You’ll learn about formatting for effect to make your data tell its story, and you’ll be a master at creating visually arresting output on multiple devices that grabs attention, builds influence, and drives change.

What You Will Learn

  • Produce designer output that will astound your bosses and peers
  • Make new insights as you chop and tweak your data as never before
  • Create high-quality analyses in record time
  • Create interdependent charts, maps, and tables
  • Deliver visually stunning information
  • Drill down through data to provide unique understandings
  • Outshine competing products and enhance existing skills
  • Adapt your dashboard delivery to mobile devices

About the Author

Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for over 25 years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft data platform.

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 dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe when using the Microsoft data and analytics stack—both in Azure and on-premises.

Business Intelligence has been Adam’s principal focus for the last 20 years. He has applied his skills for a range of clients in finance, banking, utilities, leisure, luxury goods, and pharmaceuticals. Adam is a frequent contributor to and Simple-Talk. He is a regular speaker at events such as SQL Saturdays and SQLBits. A fluent French speaker, Adam has worked in France and Switzerland for many years.

Adam is the author of SQL Server Data Integration Recipes, Business Intelligence with SQL Server Reporting Services, High Impact Data Visualization in Excel with Power View, 3D Maps and Get and Transform, Data Mashup using Microsoft Excel using Power Query and M, and Pro Power BI Theme Creation—all with Apress.

In this Book

  • Introduction
  • Dashboard Basics
  • Table Visuals
  • Advanced Table Visual Techniques
  • Matrix Visuals
  • Card Visual Types
  • Charts in Power BI Desktop
  • Advanced Chart Types
  • Formatting Charts
  • Other Types of Visuals
  • Third-Party Visuals
  • Drill Down and Drill Up
  • Maps in Power BI Desktop
  • Filtering Data
  • Slicers and Cross-Filtering
  • Enhancing Dashboards
  • Multipage Dashboards
  • Bookmarks and Buttons