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
La distribución de temas del curso