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: November 15, 2020

6 Reviews (33 ratings)Reviews

5
Anonymous Author
I am excited to try out Power BI in my current role. This course showed some of what was possible with the software and I am sure that I will come back to refer to some of the content in the future. I plan to take some of the other courses offered by this instructor.
5
Member's Profile
Extremely helpful and clear guidance. Recommend this to anyone else who is interested in learning more about Power BI.
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.
5
Member's Profile
Very helpful introduction to Power BI and I will be taking this instructor's other courses.
5
Member's Profile
I enjoyed the chart possibilities and Q & A, thats is really helpful.
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 .

3 QuestionsCourse Questions and Answers

User picture

Do you need to have Power BI installed on your PC in order to get the most out of this course? I am working on an iMac and MacBook Pro and it would take some manipulation to use it,

Member's Profile

You need either a PC or a virtual machine to install Power BI Desktop. A workaround though is that you can publish data to Power BI Service at https://app.powerbi.com/ and then create your Power BI reports online the same way you do in PBI Desktop.
Hope this helps.
Lenny

Member's Profile

You need either a PC or a virtual machine to install Power BI Desktop. A workaround though is that you can publish data to Power BI Service at https://app.powerbi.com/ and then create your Power BI reports online the same way you do in PBI Desktop.
Hope this helps.
Lenny

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
  4:32Visuals 2
  1:59Visuals 3
Advanced - BEST PRACTICES IN POWER BI
  4:43Best Practices: Part 1
  2:14Best Practices: Part 2
CONCLUSION
  1:00Takeaways
  0:30Next Course
CONTINUOUS PLAY
  1:01:48Power 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