Instructor for this course
more

The course is presented in four parts. First, brief introduction to Power BI, how to install it, and compare Power BI dashboard with Excel charts, and other BI tools:

  • With Excel:
    • More visuals and charts in Power BI
    • Power BI allows users to type their questions and get instant answers, in the form of charts, which is not possible in Excel
    • Charts are slicers in Power BI
  • With other BI tools:
    • No. 1 leader on the Gartner Magic Quadrant (2020)
    • Connects to over 130 data sources and counting
    • Monthly updates on Power BI, not annually nor quarterly like others

Second part is to review what we learned in Power Query and Power Pivot, and how they function inside the Power BI environment.

  • Power Query: Advanced query editor, add a column from example, unpivot
  • Power Pivot: relationship, DAX formulas, Measures, fact/dimension tables
  • New DAX measure for commentaries in Part III below
    • FORMAT()

Third, we demonstrate how to build a dashboard based on data warehouse by using the following visuals:

  • Table
  • Card
  • Slicer & cross filter
  • Map
  • Play Axis
  • Commentaries
  • Q&A

Last, we conclude our webinar with:

  • Best practices in building a dashboard, and
  • Segue to next part of Power BI (Part II): Sharing “On-Demand” Dashboards

Course Key Concept: Power Query, Advanced query editor, Machine learning, unpivot, Power Pivot, Relationship, DAX formulas, Measures, Fact tables, dimension tables, Calculated Fields, Calculated columns, Data Analysis Expressions, Visuals, Card visual, Play Axis visual, Table visual, Slicer visual, Map visual.

Learning Objectives

  • Discover Power BI as leader in Business Intelligence platforms.
  • Explore how to add automated commentaries to Power BI dashboard.
  • Discover 6 essential visuals to make your dashboard interactive.
  • Recognize powerful function in Power BI to cross filter dashboard visuals.
  • Identify the best practices in Power BI dashboards.
Last updated/reviewed: July 23, 2020

2 Reviews (7 ratings)Reviews

5
Member's Profile
Mr. Wu is very clear and articulate. The information is well organized and I am eager to learn how to get started.
3
Anonymous Author
Decent information, but editing of commentary could be better.

Prerequisites

Course Complexity: Intermediate

Some background using Power Query and/or Power Pivot in Excel is preferred. Example: be able to connect to external files and load to Power Query and/or Power Pivot.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  0:37Introduction to Power BI: Building Interactive Dashboards
  2:07Why Power BI
  1:24Author Introduction
  1:30Compare with Other Courses
  1:26Purpose of This Course
  6:09Introduction to Power BI
QUICK REFRESHER - POWER QUERY
  3:32Merge Query
  1:46Unpivot Columns
  1:40Add Columns
QUICK REFRESHER - POWER PIVOT
  8:44Power Pivot Overview
  2:16DAX Formulas
  1:51DAX Formulas Cont'd
  3:44Advanced Query Editor
  5:24Automated Commentary
ADVANCED - 7 Essential Power BI Visuals
  0:56Dashboard
  3:47Visuals 1
  6:39Visuals 2
  1:59Visuals 3
Advanced - BEST PRACTICES IN POWER BI
  5:53Best Practices: Part 1
  2:14Best Practices: Part 2
CONCLUSION
  1:00Takeaways
  0:30Next Course
CONTINUOUS PLAY
  1:05:06Power BI: Building Interactive Dashboards
SUPPORTING MATERIAL
  PDFSlides: Power BI: Building Interactive Dashboards
  PDFPower BI: Building Interactive Dashboards Glossary/ Index
  ZIPPower BI: Practice
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM