Packt Admin

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. 
 
The reffiles for this course are available at: <a href="https://github.com/PacktPublishing/Building-Interactive-Dashboards-with-Microsoft-Power-BI">https://github.com/PacktPublishing/Building-Interactive-Dashboards-with-Microsoft-Power-BI</a>

In this section, we start by building a simple, functional interactive dashboard presenting linked charts, KPIs, tooltips, and a legend.

<ul>
	<li>The Course Overview</li>
	<li>The Visualization Palette, Reports, and Dashboards</li>
	<li>Link Them Up – Enabling Visual Interactions</li>
	<li>Key to Performance – Calculating Your KPIs</li>
	<li>Helpful Hints – Adding Tooltips and Legends</li>
</ul>

This video will give you an overview about the course.

<ul>
	<li>Introduce the author</li>
	<li>Describe the course workflow</li>
	<li>Explain prerequisites</li>
</ul>

The Course Overview

This video forms part of the course Building Interactive Dashboards with Microsoft Power BI   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.  Target AudienceThis 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.

The Visualization Palette, Reports, and Dashboards

Link Them Up – Enabling Visual Interactions

Key to Performance – Calculating Your KPIs

Helpful Hints – Adding Tooltips and Legends

Section 1: Power BI Kick Start

In this section, we present an example analytical dashboard, for detailed data exploration. We introduce time series and heat map charts, for detailed investigation of history and trends. We enable the analyst to slice, dice, ask what-if questions, and export the raw data for external analysis.

<ul>
	<li>Introducing the Analytical Dashboard Example</li>
	<li>Time Matters – Time Series Chart</li>
	<li>Some Like It Hot – Heat Map Charts</li>
	<li>What-if – Using Parameters and Slicers to Filter and Explore</li>
	<li>Detail Oriented – Exporting Data from Visuals</li>
</ul>

Introducing the Analytical Dashboard Example

Time Matters – Time Series Chart

Some Like It Hot – Heat Map Charts

What-if – Using Parameters and Slicers to Filter and Explore

Detail Oriented – Exporting Data from Visuals

Section 2: Analytical Dashboards

In this section, we build a dashboard to enable a manager to identity key customers, see how products are performing, and locate where the action is at. With these goals in mind, we introduce several custom visuals and sample Power BI's geographic visuals.

<ul>
	<li>Introducing the Tactical Dashboard Example</li>
	<li>Point of Reference – Creating a Dot Plot</li>
	<li>Statistics Never Lie – Box and Whisker Plots</li>
	<li>Big Spenders – Building a Funnel Chart</li>
	<li>Where It Is – Geographical Map Charts</li>
</ul>

Introducing the Tactical Dashboard Example

Point of Reference – Creating a Dot Plot

Statistics Never Lie – Box and Whisker Plots

Big Spenders – Building a Funnel Chart

Where It Is – Geographical Map Charts

Section 3: Tactical Dashboards

In this section, we build a high-level dashboard targeted at the C-Level executive. After preparing and displaying a year-over-year comparison, we use bullet charts to summarize performance against goals. We then publish our dashboard to the web, where we introduce dashboards, a powerful, tile-based, data fusion and mash-up feature, tailor-made for the effective executive. Finally, we cover adding ad-hoc content to our dashboard.

<ul>
	<li>Introducing the Strategic Dashboard Example</li>
	<li>Are We There Yet? – Calculating Period-over-Period Changes</li>
	<li>On Target – Visualizing Comparisons with Bullet Charts</li>
	<li>Mash It Up – Pinning Visuals to Dashboards</li>
	<li>Make It Pop – Adding Media Tiles to a Dashboard</li>
</ul>

Introducing the Strategic Dashboard Example

Are We There Yet? – Calculating Period-over-Period Changes

On Target – Visualizing Comparisons with Bullet Charts

Mash It Up – Pinning Visuals to Dashboards

Make It Pop – Adding Media Tiles to a Dashboard

Section 4: Strategic Dashboards

In this section, we introduce a narrative-oriented custom visual, Power BI's dashboard navigation capabilities, and bookmarks, a powerful storytelling feature. Finally, we enable our end-users to do the research with external links. Previous sections focused on making the data visible to your target audience, effectively. Sometimes, however, you need to walk them through the key insights. With Power BI, you don't need to prepare a slide presentation; you can tell the story directly with the data.

<ul>
	<li>Introducing the Data Stories Dashboard Example</li>
	<li>Meet the Players – Presenting Data with the Card Browser Custom Visual</li>
	<li>Space Travel – Linking Together Dashboards with Actions</li>
	<li>Time Travel – Telling a Story with Bookmarks</li>
	<li>Click for More – Embedded Links and Hyperlink Dashboard Tiles</li>
</ul>

Introducing the Data Stories Dashboard Example

Meet the Players – Presenting Data with the Card Browser Custom Visual

Space Travel – Linking Together Dashboards with Actions

Time Travel – Telling a Story with Bookmarks

Click for More – Embedded Links and Hyperlink Dashboard Tiles

Section 5: Data Stories with Dashboards

In this section, we conclude the course with a walkthrough of Power BI's flexible formatting features. While Power BI's default style and formatting is perfect for prototyping and many production scenarios, you'll often want to tailor your dashboard's look and feel for your specific client or project.

<ul>
	<li>Formatting Concepts and Best Practices</li>
	<li>Formatting Visuals and Reports</li>
	<li>Creating Relevant Labels and Effective Number Formats</li>
	<li>Formatting Dashboards</li>
	<li>Course Conclusion</li>
</ul>

Formatting Concepts and Best Practices

Formatting Visuals and Reports

Creating Relevant Labels and Effective Number Formats

Formatting Dashboards

This video wraps up the course.

<ul>
	<li>Review the Power BI workflow and offer a writing analogy</li>
	<li>Review design best practices</li>
	<li>Suggest checking out more videos</li>
</ul>

Building Interactive Dashboards with Microsoft Power BI

What you'll learn

Explore more technology skills