Power BI Dashboards Training Course
Learn how to Get & Transform Data to Prepare Interactive Dashboards
Power BI is one of the most popular Data Visualization tool, and a Business Intelligence Tool. Power BI is a collection of data connectors, apps, and software services, which are used to get data from different source, transforms data, and produce beautiful reports.
Power BI also allows you to publish them for your organization so that you can access them using mobiles, tablets etc. In this Power BI Tutorial, we will show you the step by step approach to connect with multiple data sources, data transformations, and creating reports like charts, tables, matrix, maps, etc
Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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.
14 Hours
Open Training Courses require 5+ participants.
Power BI Dashboards Training Course - Booking
Power BI Dashboards Training Course - Enquiry
Power BI Dashboards - Consultancy Enquiry
Consultancy Enquiry
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.
Shelly - Valuation Office Agency
Course - Power BI Dashboards
Upcoming Courses
Related Courses
Advanced Alerting and Automation with Grafana and Prometheus
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at advanced-level DevOps and SRE professionals who wish to enhance their alerting and automation skills with Grafana and Prometheus.
By the end of this training, participants will be able to:
- Create and manage advanced alerting rules in Prometheus.
- Integrate Prometheus Alertmanager with external tools using webhooks.
- Automate responses to alerts for faster issue resolution.
- Use Grafana to visualize and manage alerts effectively.
Read more...
Advanced Data Analysis with TIBCO Spotfire
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at business analysts who wish to learn advanced Spotfire Analyst techniques for analyzing data.
By the end of this training, participants will be able to:
- Share visualizations among different team members.
- Secure access to software based on roles and access controls.
- Create visualizations such as map charts.
- Integrate statistical computing languages such as R with Spotfire.
Read more...
Building Effective Dashboards with Grafana and Prometheus
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at intermediate-level DevOps and SRE professionals who wish to create impactful dashboards and optimize their monitoring practices using Grafana and Prometheus.
By the end of this training, participants will be able to:
- Understand best practices for designing effective dashboards.
- Create and configure advanced Grafana dashboard elements.
- Leverage Grafana templating for dynamic and reusable dashboards.
- Implement alerting mechanisms to enhance operational awareness.
Read more...
Custom Metrics and Instrumentation with Prometheus and Grafana
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at intermediate-level developers and DevOps engineers who wish to instrument their applications to export and monitor custom metrics effectively using Prometheus and Grafana.
By the end of this training, participants will be able to:
- Understand the importance of custom metrics for application monitoring.
- Instrument applications to export custom metrics for Prometheus.
- Create and configure dashboards in Grafana to visualize custom metrics.
- Apply best practices for integrating monitoring into the development lifecycle.
Read more...
Monitoring with Grafana
14 HoursThis instructor-led, live training in Panama (onsite or remote) is aimed at data analysts who wish to use Grafana for monitoring and visualizing data.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start creating visualizations in Grafana.
- Set up Grafana for high availability.
- Customize panels and dashboards with data.
- Configure a reverse proxy for fast loading speeds.
Read more...
Advanced Grafana
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at intermediate-level data analysts who wish to learn and utilize the advanced features and components of Grafana for data visualization and analysis.
By the end of this training, participants will be able to:
- Gain an in-depth understanding of advanced Grafana concepts and components.
- Leverage template variables and dynamic dashboards for enhanced data visualization.
- Use Grafana Query Language for complex queries.
- Learn best practices for scaling Grafana, optimizing performance, and ensuring high availability.
Read more...
Grafana Comprehensive
21 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at intermediate-level system administrators and monitoring professionals who wish to effectively use Grafana for setting up monitoring solutions, managing dashboards, and creating alerts.
By the end of this training, participants will be able to:
- Understand the difference between observability and monitoring.
- Install and set up the Grafana server.
- Configure and connect various data sources such as Prometheus, InfluxDB, and ElasticSearch.
- Create, manage, and customize dashboards and charts.
- Use variables and queries to create dynamic dashboards.
- Set up notifications and alerts through Grafana.
- Install and manage plugins to extend Grafana’s functionality.
Read more...
Grafana and GLPI Administration
21 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at beginner to intermediate-level IT professionals who wish to gain the knowledge and practical skills necessary to excel in the administration of Grafana and GLPI.
By the end of this training, participants will be able to:
- Create and customize Grafana dashboards with different visualizations.
- Implement alerting and notifications for monitoring.
- Administer user accounts, teams, and permissions.
- Manage IT assets effectively, including hardware and software inventory.
- Implement a helpdesk system for user support and ticket management.
Read more...
Grafana and Graphite
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at web developers and DevOps engineers who wish to visualize and monitor data with Grafana and Graphite.
By the end of this training, participants will be able to:
- Aggregate and visualize metrics about systems and applications.
- Create a StatsD client for gathering application metrics.
- Build informative and dynamic dashboards with Grafana.
- Gather insights from back-end performance.
Read more...
Introduction to Spotfire
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at business analysts and data analysts who wish to learn basic Spotfire Analyst techniques for analyzing data.
By the end of this training, participants will be able to:
- Install and configure TIBCO Spotfire.
- Combine data from different databases.
- Visualize large datasets.
- Create and share complex dashboards.
Read more...
AI-Driven Data Analysis with TIBCO Spotfire X
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at business analysts and data analysts who wish to use TIBCO Spotfire X with its artificial intelligence capabilities to visualize, transform, and analyze data.
By the end of this training, participants will be able to:
- Install and configure TIBCO Spotfire X.
- Understand the features and architecture of TIBCO Spotfire X.
- Understand the concepts behind augmented and predictive analytics.
- Learn how to load, process, and visualize data using Spotfire X.
- Create interactive and enhanced data visualizations.
Read more...
Data Analysis with SQL, Python and Spotfire
14 HoursIn this instructor-led, live training in Panama, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Read more...
TIBCO for Developers
21 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at developers who wish to use BusinessEvents and ActiveMatrix Service Bus to develop, deploy, and manage event driven applications.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start developing.
- Build distributed, stateful, rule-based event-processing systems.
- Manage business events data and execute proper business rules.
- Reduce the event response time in large-scale, data driven applications.
- Build applications for fraud detection, track-and-trace, real-time customer offer generation, etc.
Read more...
TIBCO Statistica
14 HoursThis instructor-led, live training in Panama (online or onsite) is aimed at engineers, researchers, and data analysts who wish to use TIBCO Statistica features to create analytic workflows and models.
By the end of this training, participants will be able to:
- Install and navigate the TIBCO Statistica program to build and manage data analysis projects.
- Understand statistics basics to analyze data and generate useful insights for the business.
- Explore advanced topics to work with big data and machine learning using TIBCO Statistica.
Read more...
