Power BI

Description

Design and create a data model which drives an interactive dashboard to analyze and display company data

This course provides an introduction on how to refine, analyze and visualize data with Power BI Desktop. A rich corporate data set is used to build a professional quality interactive dashboard. The relationships between various data sources are defined to create a relational data model. This model forms the foundation for an interactive dashboard with a variety of exhibits. Participants will be able to explore the company’s data by cross-filtering and drilling down through various levels in the exhibits. This course is designed as an introduction to Microsoft Power BI Desktop which is free to download and install.

Note: This software is currently only available for PC / Windows

Details
Prerequisites

None

Time

1 day

Learning Topics

Connecting & Refining Data

  • Overview of Power BI interface and workflow
  • Review some common types of data connections
  • Discuss best practices for editing queries
  • Settings for defining data categories
  • Demonstration of basic table transformations
  • Tools used to manipulate text, numbers and dates
  • Creating index and conditional columns

Building a Relational Data Model

  • Review of best practices for data modeling
  • Common guidelines for database normalization
  • Discussion of lookup tables and data tables
  • Understanding primary keys and foreign keys
  • Creating, defining and editing table relationships
  • Review of star schemas and snowflake schemas
  • Discussion of relationship cardinality

Data Visualization with Reports

  • Best practices and guidelines for report design
  • Introduction and layout of the Report View
  • Adding various visualizations to reports
  • Visualization options for fields and formatting
  • Using slicers to filter report visualizations
  • Filtering at various levels in the data model
  • Editing interactions to control cross-filtering
Download a one-page course summary
Download Now

Upcoming Power BI Events

All Events