Course Outline
Power BI Desktop Environment & Fundamental Terminology
- Acquire and deploy the Power BI Desktop application
- Establish connections to Oracle Database Server infrastructure
- Analyze the Power BI interface components: Report View, Data View, and Relationship View
- Manage report pages: create, rename, duplicate, hide, and delete
- Ingest data from Excel-based workbooks
- Ingest data from plain text file formats
- Integrate data from multiple heterogeneous sources
- Prune unnecessary columns from tabular data structures
Visualization Components in Power BI
- Column chart implementation
- Bar chart implementation
- Card visual elements
- Clustered column chart configuration
- Introduction to natural-language query capabilities
- Integration of custom visual extensions
Filtering Mechanisms in Power BI
- Slicer controls
- Basic filtering logic
- Advanced filtering criteria
- Top N filter applications
- Filters applied to calculated measures
- Page-level filter scope
- Report-level filter scope
- Drill-through filter functionality
Dashboard Management & Operational Standards
- Best practices for dashboard design and utility
- Analyzing data relationship structures
- Executing dashboard actions
- Attaching reports to a dashboard instance
- Assigning titles to dashboard elements
- Incorporating image assets into dashboards
- Embedding video content within dashboards
- Integrating web-based content into dashboards
- Configuring dashboard system settings
- Removing a dashboard instance
- Pinning specific report elements to a dashboard
Distribution and Collaboration of Power BI Assets
- Authorizing user access to dashboards (Dashboard Sharing)
- Internal personnel
- External entities (users outside the organizational boundary)
- Sharing report artifacts
- Distribution of workspace access
- Data refresh protocols
- Configuring automated refresh schedules
Power BI Administrative Oversight
- Reviewing the Power BI administrative portal
- The administrative portal facilitates five core functions:
- Usage metrics analysis
- User management
- Audit log review
- Tenant configuration
- Premium licensing settings
- The administrative portal facilitates five core functions:
- Assigning administrative roles via the Office 365 Admin Center
- Defining the three key administrative actors
Power BI Security and Access Control
- Provisioning access to Apps and Content Packs
- Implementing Row Level Security
- User and license administration
- Enabling or disabling user accounts
- Auditing Power BI activity logs
Requirements
No specific technical or procedural prerequisites are required for participation in this course.
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.
