Building Interactive Dashboards with Microsoft Power BI

Building Interactive Dashboards with Microsoft Power BI

by Peter MacMurchy
Released October 2018
Publisher(s): Packt Publishing
ISBN: 9781789612066

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Do you get confused when you analyze data from various sources? If yes, then this course will be your perfect guide and companion to analyze any data with ease.

This course provides an introduction to Power BI's powerful dashboard design features and how you can use it to the advantage of your organization. You'll begin the course by building a simple, functional interactive dashboard. You'll present linked charts and KPIs. You'll develop dashboard examples suitable for publishing to analysts through managers and executives. At times, you need to walk users through the data so we introduce some storytelling features of Power BI. Finally, we'll wrap up with some tips to style your dashboards for publishing.

At the end of this course, you’ll explore real-world examples, get started with Microsoft Power BI, and become comfortable with it so you can delve deeper.

What You Will Learn

  • Make interesting and creative visualizations based on your data with Power BI
  • Build powerful, structured reports and KPIs with Power BI
  • Explore detailed investigation history, trends, time series, and heat map charts with the analytical dashboard
  • Build several custom and geographic visuals to study the market with a strategic dashboard
  • Publish your dashboard to the web to have powerful, tile-based, data fusion, and tailor-made data for the effective executive
  • Get introduced to a narrative-oriented custom visual, Power BI s navigation capabilities, and a powerful storytelling feature
  • Get a detailed walkthrough of Power BI s flexible formatting features

Audience

This course is for developers, engineers, analytics, and BI professionals who have some knowledge of Power BI and want to learn to create dashboards and more. It’s also ideal for professionals who want to create customized visuals with the Power BI Developer tools.

About The Author

Peter MacMurchy: Peter MacMurchy has been a professional software developer for over 15 years, focusing on UX, UI, and interactive data visualization tools. He acquired a keen interest in information visualization from coursework while studying Computer Graphics for his M.Sc. in Computer Science at the University of Calgary. Since then, he's continued to develop visualization and interactive software for finance, film, energy, and other industries. At Uncharted, Peter helps clients improve their data visualization capabilities on a consulting basis.

Table of contents

  1. Chapter 1 : Power BI Kick Start
    1. The Course Overview
    2. The Visualization Palette, Reports, and Dashboards
    3. Link Them Up – Enabling Visual Interactions
    4. Key to Performance – Calculating Your KPIs
    5. Helpful Hints – Adding Tooltips and Legends
  2. Chapter 2 : Analytical Dashboards
    1. Introducing the Analytical Dashboard Example
    2. Time Matters – Time Series Chart
    3. Some Like It Hot – Heat Map Charts
    4. What-if – Using Parameters and Slicers to Filter and Explore
    5. Detail Oriented – Exporting Data from Visuals
  3. Chapter 3 : Tactical Dashboards
    1. Introducing the Tactical Dashboard Example
    2. Point of Reference – Creating a Dot Plot
    3. Statistics Never Lie – Box and Whisker Plots
    4. Big Spenders – Building a Funnel Chart
    5. Where It Is – Geographical Map Charts
  4. Chapter 4 : Strategic Dashboards
    1. Introducing the Strategic Dashboard Example
    2. Are We There Yet? – Calculating Period-over-Period Changes
    3. On Target – Visualizing Comparisons with Bullet Charts
    4. Mash It Up – Pinning Visuals to Dashboards
    5. Make It Pop – Adding Media Tiles to a Dashboard
  5. Chapter 5 : Data Stories with Dashboards
    1. Introducing the Data Stories Dashboard Example
    2. Meet the Players – Presenting Data with the Card Browser Custom Visual
    3. Space Travel – Linking Together Dashboards with Actions
    4. Time Travel – Telling a Story with Bookmarks
    5. Click for More – Embedded Links and Hyperlink Dashboard Tiles
  6. Chapter 6 : Formatting Dashboards and Data
    1. Formatting Concepts and Best Practices
    2. Formatting Visuals and Reports
    3. Creating Relevant Labels and Effective Number Formats
    4. Formatting Dashboards
    5. Course Conclusion

Product information

  • Title: Building Interactive Dashboards with Microsoft Power BI
  • Author(s): Peter MacMurchy
  • Release date: October 2018
  • Publisher(s): Packt Publishing
  • ISBN: 9781789612066