1.5 CPE 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: March 17, 2024
42 Reviews (202 ratings)
Reviews
Anonymous
(Senior Internal Auditor)
This was an interesting introductory course into powerBI and its uses
Anonymous
()
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.
Beverly Allgood
(Revenue Agent at Department of the Treasury)
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!
Anonymous
(Accountant)
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.
Anonymous
()
This was a great course but I do want to go back & take his Power Pivot & Power Query classes. Some of the discussion items were too advanced for me at this point. He is a really upbeat presenter. "How great is that?:" :)
Anonymous
(Account Payable Specialist)
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.
Anonymous
(Senior Accountant)
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.
Anonymous
(Senior Cost Accountant)
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.
Juan Antonio Romero
( at Mondelez International)
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.
Thomas Simkiss
(Director of Cloud Solutions at Creoal Consulting)
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.
Anonymous
(Accountant)
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.
Anonymous
(Plant Controller)
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
Anonymous
(Internal Audit Manager)
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.
Anonymous
(System Procedure Analyst)
I like the way the instructor went step by step and pointed out
the tools in the tool bar and side bars to use when using power BI.
Anonymous
(Senior Accountant)
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.
Justin Farr
(Controller at Ncontracts)
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.
Doug Poor
(Controller at Blueprint CFO)
Extremely helpful and clear guidance. Recommend this to anyone else who is interested in learning more about Power BI.
Bonnie Tomei
(CFO at Salience Labs)
Mr. Wu is very clear and articulate. The information is well organized and I am eager to learn how to get started.
Ningjie Tang
( at Dentsu China Investment Limited)
overall, a good class for beginners. If you are free for a couple of hours, you may follow the practices as well.
TOMOAKI TOGO
( at Canadian Solar Japan)
I spent 4 hours to complete this course
It is very informative and will be useful for my job,
Thank you.
Anonymous
(Chief Financial Officer)
Great introduction to Power BI. Unlocks a number of concepts that can be built on for many uses.
Brad Sweetser
(Finance and Accounting Consultant at DLC Group)
What a course. Extremely insightful and practical. Cannot wait to implement this with my clients!
Anonymous
(Accountant)
There must be a prerequisite for this course. It was little more advanced than I was ready for.
Katherine Hart
(None at Not Applicable)
Very helpful introduction to Power BI and I will be taking this instructor's other courses.
Anonymous
(Accounting Manager)
It is good course for Power BI beginner. I would like to take query editor courses as well.
Robert Read
( at Thompson Law LLP)
This course moves fast but it is really good. Great to follow along in the Power BI app.
Anonymous
(Accountant)
This course is very informative as to how Power BI can help you create visual reports.
Anonymous
(Internal Audit Manager)
Excellent course! Recommended for everyone who wants expand his knowledge of Power BI.
Anonymous
(Senior Lean Development Officer)
More self-aggrandizing than informative but does contain some useful information
Anonymous
()
Extremely useful - I want more of this content & to try it myself really soon!
Dan Marlow
(Owner at Valor Business Services, LLC)
I have no comments about this course.
I have no comments about this course.
Anonymous
(Accountant)
Excellent course. Content clearly presented and well organized.
Thank you!
Scott Anderton
(CFO at HCA)
Informative for someone who uses PowerBI but has never built a dashboard
Juliana Veiga
(Controllership Coordinator at Novelis)
I enjoyed the chart possibilities and Q & A, thats is really helpful.
Anonymous
()
Create a Measure Table: to hold all measures separate from other tables
Michelle Hodgson-Smith
(Senior Accounting Analyst at Solutionreach)
I loved how well Lenny explained things in a very understandable way.
Anonymous
()
Class was well taught and managed. Was an interesting hour to spend
Anonymous
(CFO)
Decent information, but editing of commentary could be better.
Anonymous
(Director - Data Analytics, Sales and Pri..)
Great overview at a quick pace to learn basic PowerBI skills
Anonymous
()
This course is a great beginning to understanding power BI.
Kathleen Busk Varas
(Principal Financial Consultant at V Ventures Consulting)
Logical, methodical presentation makes 'how to' clear.
Anonymous
(Area Controller)
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)
Lenny WuManagement Reporting Analyst, Seaspan Ship Management
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 1608 W Campbell
- Av #221, Campbell, CA 95008
© 2024 Illumeo, Inc.
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,
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
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