Course Outline
Power BI Desktop & Introducing Key terms
- Download and Install BI Desktop
- Connect to Oracle Database Server
- Understanding Power BI Screen → Report | Data | Relationship
- Add, Rename, Duplicate, Hide and Delete Pages
- Get Data from Excel Files
- Get Data from Text Files
- Load Data from Multiple Data Sources
- Remove Unwanted Columns from Tables
Power BI Charts
- Column Chart
- Bar Chart
- Card
- Clustered Column Chart
- Introducing natural-language queries
- Importing custom visuals
Power BI Filters
- Slicer
- Basic Filters
- Advanced Filters
- Top N Filters
- Filters on Measures
- Page Level Filters
- Report Level Filters
- Drill through Filters
Working with Power BI Dashboards & Best Practices
- Dashboard best practices
- Understanding Relationship
- Dashboard Actions
- Add Reports to a Dashboard
- Add Title to Dashboard
- How to Add Image to Dashboard
- Add Video to Dashboard
- Add Web Content to Dashboard
- Dashboard Settings
- Delete a Dashboard
- Pin Report to a Dashboard
Sharing Power BI Work
- Inviting a user to see a dashboard (Share Dashboard)
- Internal
- External (Inviting users outside your organization)
- Share a Report
- Sharing Workspace
- Understanding data refresh
- Configuring automatic refresh
Power BI Administration (behind the scenes)
- Understanding the Power BI admin portal
- The admin portal presents five features:
- Usage metrics
- Users
- Audit logs
- Tenant settings
- Premium settings
- The admin portal presents five features:
- Assign users to the admin role in office 365 (Office 365 admin center)
- Three actors in play for administration
Power BI Security Access Control
- Giving access to Apps and Contents Packs
- Row Level Security
- Managing Users and Licenses
- Enabling / disabling users
- Audit Power BI Activity
Requirements
There are no specific requirements needed to attend this course.
Testimonials (7)
The training was nicely personalised to my needs due to it being 1 on 1 and Tony made sure to answer all my questions/queries before moving forward with a new subject.
Shelly - Valuation Office Agency
Course - Power BI Dashboards
the teachers pacience.
Camelia-Gabriela - Ursus Breweries S.A.
Course - Power BI Dashboards
Trainers are very knowledgeable, and patient in ensuring students could follow the lecture.
Trudy Staples Girardin - Indigenous Services Canada
Course - Power BI Dashboards
I felt like we saw the whole spectrum of what Power BI can do. The trainers were super knowledgeable and so patient with our group.
Angela Murphy - Indigenous Services Canada
Course - Power BI Dashboards
I learned a lot about Power BI and how to integrate the excel into it. I also enjoyed learning all different filters, visualizations and information that can be created.
Krystina Merkley - Indigenous Services Canada
Course - Power BI Dashboards
I found the two instructors extremely knowledgeable, personable and respectful, great guys.
Bruce Pickett - Indigenous Services Canada
Course - Power BI Dashboards
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.