Course Outline
Power BI Desktop & Key Concepts
- Download and Install Power BI Desktop
- Connect to Oracle Database Server
- Navigate the Power BI Interface: Report, Data, and Relationship Views
- Manage Pages: Add, Rename, Duplicate, Hide, and Delete
- Ingest Data from Excel Files
- Ingest Data from Text Files
- Load Data from Multiple Sources
- Eliminate Unwanted Columns from Tables
Visualizing Data with Power BI
- Column Chart
- Bar Chart
- Card Visuals
- Clustered Column Chart
- Introduction to Natural-Language Queries
- Importing Custom Visuals
Applying Filters in Power BI
- Slicers
- Basic Filters
- Advanced Filters
- Top N Filters
- Filters on Measures
- Page-Level Filters
- Report-Level Filters
- Drill-through Filters
Building Power BI Dashboards & Best Practices
- Dashboard Best Practices
- Understanding Data Relationships
- Executing Dashboard Actions
- Adding Reports to a Dashboard
- Adding Titles to Dashboards
- Incorporating Images into Dashboards
- Incorporating Videos into Dashboards
- Incorporating Web Content into Dashboards
- Configuring Dashboard Settings
- Deleting a Dashboard
- Pinning Reports to a Dashboard
Sharing Power BI Content
- Inviting Users to View Dashboards (Share Dashboard)
- Internal Sharing
- External Sharing (Inviting users outside your organization)
- Sharing Reports
- Sharing Workspaces
- Understanding Data Refresh
- Configuring Automatic Data Refresh
Power BI Administration (Behind the Scenes)
- Navigating the Power BI Admin Portal
- Key Features of the Admin Portal:
- Usage Metrics
- Users
- Audit Logs
- Tenant Settings
- Premium Settings
- Key Features of the Admin Portal:
- Assigning Administrative Roles in Office 365 (Office 365 Admin Center)
- The Three Key Actors in Administration
Power BI Security & Access Control
- Granting Access to Apps and Content Packs
- Row-Level Security
- Managing Users and Licenses
- Enabling and Disabling Users
- Auditing Power BI Activity
Requirements
No specific prerequisites are required to enroll in this course.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (7)
- Building dashboards - Learning the counts and SUMs and SWITCH -
Thereso - South African National AIDS Council Trust
Course - Power BI Dashboards
I like the exercises on creating the different dashboards
Xabiso - South African National AIDS Council Trust
Course - Power BI Dashboards
The creation of dashboards.
Kulani Mabasa - South African National AIDS Council Trust
Course - Power BI Dashboards
The facilitator was exceptionally engaging throughout the training, effectively creating a positive and dynamic learning environment. His ability to break down the foundational concepts of Power BI was particularly impressive, as he communicated the information in a clear and accessible manner, ensuring that all participants, regardless of their prior knowledge, could follow along and grasp the key concepts. Moreover, the facilitator fostered an atmosphere that encouraged active participation, which significantly enhanced the overall learning experience. Rather than simply delivering a lecture, he actively involved participants by allowing them to work with the example data set independently. This hands-on approach gave participants the opportunity to apply what they had learned in real time, deepening their understanding and boosting their confidence in using Power BI. Whenever challenges arose, the facilitator was readily available to offer support, ensuring that no one felt left behind. His responsiveness to individual questions and issues helped maintain the momentum of the training, making it a more interactive and personalized experience for all attendees. In addition to his technical knowledge, the facilitator demonstrated excellent facilitation skills, adjusting his delivery style to suit the needs of the audience. He was keenly aware of the varying levels of expertise within the group and was able to tailor his explanations accordingly, ensuring that both beginners and more advanced participants felt comfortable and engaged. His ability to gauge the audience’s understanding and adjust the pace of the training accordingly contributed to a positive and effective learning environment. Overall, the facilitator's expertise, adaptability, and engaging teaching style were key factors in the success of the training, and his approach ensured that participants not only gained practical skills but also felt empowered to use Power BI confidently in their work.
Mlungisi - South African National AIDS Council Trust
Course - Power BI Dashboards
Very informative, very relevant, facilitator knows his stuff, brilliant delivery
Anthony - South African National AIDS Council Trust
Course - Power BI Dashboards
Enhancement of my knowledge of creating visuals using Power BI.
Billia - South African National AIDS Council Trust
Course - Power BI Dashboards
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.
