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 Concepts: 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: August 23, 2023
36 Reviews (182 ratings)

Reviews

5
Member's Profile
This course moves fast but it is really good. Great to follow along in the Power BI app.

5
Anonymous Author
Class was well taught and managed. Was an interesting hour to spend

5
Anonymous Author
This is a highly practical and easy-to-follow course providing an example-based overview of Power BI mechanics I'd highly recommend to someone looking to understand why they should use this tool to build dashboards. My only note is that there were a handful of editing misses in the compilation of the video that caused some confusion.

5
Member's Profile
This was a great overview of some of the functions of Power BI. As a new user, I feel much more confident that I will be able to create an informative dashboard with my audit data. Thanks for teaching an old lady some new tricks. I will definitely be taking more of Mr. Wu's data analytics classes!

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.

4
Anonymous Author
I enjoyed how Lenny broke down the topics into simple and easy to understand pieces. I didn't have PowerBI installed to follow him with, but that didn't hinder my understanding of the subject matter at all.

5
Anonymous Author
Amazing course. Wish there will be more to come for actual case practices that apply to multiple useful circumstances in life, especially for corporate analyses for internal decision-making purposes.

5
Anonymous Author
I enjoyed learning more about the available visuals for PowerBI. I think the play axis will be especially useful. And it was also good to know that more visuals could be downloaded from Microsoft.

4
Member's Profile
Good introduction to Power BI and easy to follow. Make sure to download the materials prior to starting the course. See the "Supporting Materials" section at the bottom of the course syllabus.

4
Member's Profile
If there was a pre-req noted for the Power Query Class I missed it. The refresher section was helpful, but I wound up having to take the prereq class to understand all the functions.

4
Anonymous Author
It seems that there should be some prerequisite courses listed prior to taking the Power BI course. It would have been helpful for me to have done Power Query and Power Pivot first.

4
Anonymous Author
Interesting class, but I felt like it was just assumed certain items were known. I have taken previous classes from the instructor and still struggled to complete the course

5
Anonymous Author
Really enjoyed the instructor's enthusiasm and I think the course and content is well presented. I especially enjoyed the section devoted to best practices for dashboards.

5
Anonymous Author
Great tool and presentation. I do feel like it would be helpful to have a bit more PDF documentation to go along with the videos.

5
Member's Profile
This is a perfect intro to Power BI, and gives you a great understanding as to why Power BI can be useful and very powerful.

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.

4
Member's Profile
overall, a good class for beginners. If you are free for a couple of hours, you may follow the practices as well.

5
Member's Profile
I spent 4 hours to complete this course It is very informative and will be useful for my job, Thank you.

5
Anonymous Author
Great introduction to Power BI. Unlocks a number of concepts that can be built on for many uses.

5
Member's Profile
What a course. Extremely insightful and practical. Cannot wait to implement this with my clients!

3
Anonymous Author
There must be a prerequisite for this course. It was little more advanced than I was ready for.

5
Member's Profile
Very helpful introduction to Power BI and I will be taking this instructor's other courses.

5
Anonymous Author
It is good course for Power BI beginner. I would like to take query editor courses as well.

5
Anonymous Author
This course is very informative as to how Power BI can help you create visual reports.

5
Anonymous Author
Excellent course! Recommended for everyone who wants expand his knowledge of Power BI.

4
Anonymous Author
More self-aggrandizing than informative but does contain some useful information

5
Anonymous Author
Extremely useful - I want more of this content & to try it myself really soon!

5
Member's Profile
I have no comments about this course. I have no comments about this course.

5
Anonymous Author
Excellent course. Content clearly presented and well organized. Thank you!

5
Member's Profile
I enjoyed the chart possibilities and Q & A, thats is really helpful.

4
Member's Profile
I loved how well Lenny explained things in a very understandable way.

3
Anonymous Author
Decent information, but editing of commentary could be better.

5
Anonymous Author
Great overview at a quick pace to learn basic PowerBI skills

5
Anonymous Author
This course is a great beginning to understanding power BI.

5
Anonymous Author
Great presentation. Easy to understand and apply.

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 Questions and Answers(3 Questions)
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

Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Power BI: Building Interactive Dashboards0:37
  Why Power BI2:07
  Author Introduction1:24
  Compare with Other Courses1:30
  Purpose of This Course1:26
  Introduction to Power BI6:09
QUICK REFRESHER - POWER QUERY
  Merge Query3:32
  Unpivot Columns1:46
  Add Columns1:40
QUICK REFRESHER - POWER PIVOT
  Power Pivot Overview8:44
  DAX Formulas2:16
  DAX Formulas Cont'd1:51
  Advanced Query Editor3:44
  Automated Commentary5:24
ADVANCED - 7 Essential Power BI Visuals
  Dashboard0:56
  Visuals 13:47
  Visuals 24:32
  Visuals 31:59
Advanced - BEST PRACTICES IN POWER BI
  Best Practices: Part 1 4:43
  Best Practices: Part 2 2:14
CONCLUSION
  Takeaways 1:00
  Next Course 0:30
CONTINUOUS PLAY
  Power BI: Building Interactive Dashboards1:01:48
SUPPORTING MATERIAL
  Slides: Power BI: Building Interactive DashboardsPDF
  Power BI: Building Interactive Dashboards Glossary/ IndexPDF
  Power BI: PracticeZIP
  Power BI: DataXLSX
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam