Course Outline
Power BI Desktop & Key Terminology
- Procurement and installation of the Power BI Desktop application
- Establishing connectivity to an Oracle Database Server
- Navigation of the Power BI interface: Report view, Data view, and Relationship view
- Management of report pages: adding, renaming, duplicating, hiding, and deleting
- Data ingestion from Excel workbooks
- Data ingestion from text files
- Integration with multiple data sources
- Elimination of redundant columns within datasets
Power BI Visualization Components
- Column charts
- Bar charts
- KPI cards
- Clustered column charts
- Utilization of natural language query features
- Incorporation of custom visual elements
Power BI Filtering Mechanisms
- Slicers for interactive filtering
- Standard filters
- Complex conditional filters
- Top N ranking filters
- Filters applied to calculated measures
- Page-level filtering controls
- Report-level filtering controls
- Drill-through filter configurations
Dashboard Configuration & Operational Best Practices for government
- Standards for effective dashboard design and governance
- Management of data relationships
- Execution of dashboard actions
- Integration of reports into dashboards
- Implementation of descriptive titles
- Incorporation of graphical images
- Embedding video content
- Insertion of web-based content components
- Configuration of dashboard settings
- Removal of dashboards
- Pinning reports to dashboards for persistent access
Distribution and Collaboration Protocols
- User invitation processes for dashboard access (Share Dashboard)
- Internal distribution within the agency
- External distribution to authorized partners outside the organization
- Report sharing procedures
- Workspace collaboration management
- Data refresh management
- Automation of scheduled data refresh cycles
Power BI Administrative Functions and Oversight
- Navigating the Power BI admin portal
- Key administrative modules:
- Usage metrics and analytics
- User management
- Audit log review
- Tenant configuration settings
- Premium capacity settings
- Key administrative modules:
- Assignment of administrative roles within Office 365 via the Admin Center
- Identification of administrative roles and responsibilities
Access Control and Security Framework
- Permission management for Applications and Content Packs
- Implementation of Row-Level Security (RLS) protocols
- User Lifecycle and License Management
- Activation and deactivation of user accounts
- Monitoring and auditing of Power BI activity logs
Requirements
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.
