Building Interactive Dashboards with Microsoft Power BI

This video provides an overview of the section.

   •  Introduce analytical dashboards as a concept

   •  Describe the visuals we’ll be exploring

   •  Show the completed example report running in Power BI

This video will teach us how we can analyze time series data in Power BI.

   •  Use a waterfall chart to explore drill-down

   •  Use an Area chart to try out analytics

   •  Use a ribbon chart to visualize rank changes over time

This video will help us understand what tools analysts can use to compare hot spots, over time and geography.

   •  Introduce the heat streams and heat map visuals

   •  Introduce the marketplace and create a heat streams visual

   •  Create a heat map visual to find geographic hot spots

How can analysts slice and dice their data? How do what-if questions work in BI? In this video, you will learn about slicers and parameters to filter.

   •  Build three slicers

   •  Create a parameter and associated parameterized metric

   •  Create a what-if tax scenario using the parameter

Through this video, you will learn how analysts can get at the raw data.

   •  Introduce show data and export data in desktop

   •  Introduce export to excel in dashboards

   •  Demonstrate the enhanced features of export data in Power BI service

This video provides an overview of the section.

   •  Introduce tactical dashboards as a concept

   •  Describe the visuals we’ll be exploring

   •  Show the completed example report running in Power BI

In this video, we will learn how we can simply visualize distributions Power BI.

   •  Introduce dot plot charts

   •  Use a dot plot chart to get an overview of our cart stages

   •  Use dot plot by MAQ software to explore two dimensions of the data

In this video, we will learn how we can get more insight into our distributions.

   •  Introduce box and whisker plots

   •  Create a box plot visual grouped by stage and sort it

   •  Create a box plot video grouped by source and compare to bar charts

How can we identify where on the internet our customers are coming from?

   •  Introduce funnel charts

   •  Create a regular funnel chart to show progress through the stages

   •  Create a funnel with source by MAQ software to break down leads

In this video we will learn how to find out where in the world our customers are.

   •  Use a map visual to break down by location and gender

   •  Use a filled map visual to break down and filter by country

   •  Use ArcGIS maps for Power BI to create a geographical drill-down

This video provides an overview of the section.

   •  Introduce strategic dashboards as a concept

   •  Describe the visuals we’ll be exploring

   •  Show the completed example dashboard running in Power BI service

How can we calculate and visualize period-over-period changes in Power BI?

   •  Introduce period-over-period concepts

   •  Use merge queries, a calculated column, and quick measures to calculate period-over-period changes

   •  Visualize period-over-period changes in KPI and clustered column chart visuals

What’s the best way to evaluate a metric against a target?

   •  Introduce bullet graphs and the bullet chart

   •  Create a bullet chart using a custom visual

   •  Color the bullet chart to match the design specification

How do we mash up visuals into strategic-level dashboards?

   •  Upload three dashboards to the Power BI service

   •  Pin several visuals to a new dashboard

   •  Arrange the dashboard to fit on a single screen

How can we add titles, images, and external links to a dashboard?

   •  Add two image tiles to our strategic dashboard

   •  Apply drill-down links to the image tiles

   •  Add a text box tile to the dashboard, containing external links

This video provides an overview of the section.

   •  Introduce data stories as a concept

   •  Describe the visuals we’ll be exploring

   •  Show the completed example report and dashboard running in Power BI

How can we build a customer browser?

   •  Introduce the card browser custom visual

   •  Demonstrate a couple of ways to use the card browser custom visual

   •  Introduce the facet key custom visual

How can we drilldown from one dashboard to another, and back?

   •  Introduce drillthrough

   •  Set up drillthrough

   •  Set up a custom back button

How do we create a presentation out of our data?

   •  Introduce bookmarks

   •  Use bookmarks to present a customer profile process

   •  Create a button to expose a bookmark on a report page

How can we add external links to a report and dashboard?

   •  Add URL links to our customer data

   •  Bind URLs to the card browsers

   •  Expose the card browser links on a dashboard and add a web content tile with an embedded link

This video provides an overview of the section.

   •  Define formatting

   •  Discuss best practices for labels and high level design.

   •  Give tips for using color and fonts

How can we change a report’s color scheme?

   •  Explore Power BI themes

   •  Demonstrate how to manually set colors for a report and its visuals

   •  Use the format painter to share formatting among visuals

How can we tidy up labels and numeric values?

   •  Explore how renaming fields affects the visual’s title

   •  Suggest when to turn off titles altogether

   •  Demonstrate how to set up currency formatting in the data pane

How can we improve the formatting of a dashboard on web and mobile?

   •  Explore dashboard themes

   •  Introduce phone view

   •  Optimize our strategic dashboard’s phone view to keep essential visuals above the fold

This video wraps up the course.

   •  Review the Power BI workflow and offer a writing analogy

   •  Review design best practices

   •  Suggest checking out more videos