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
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.
Marco Iuliano
some of the best practices on charts
AIG SHARED SERVICES-BUSINESS PROCESSING, INC.
Related Courses
Advanced Data Analysis with TIBCO Spotfire
14 hoursTIBCO Spotfire Analyst is a web and Windows based client application for analyzing data and creating analytic dashboards. This instructor-led, live training (online or onsite) is aimed at business analysts who wish to learn advanced Spotfire
Introduction to Spotfire
14 hoursTIBCO Spotfire Analyst is a web and Windows based client application for analyzing data and creating analytic dashboards. This instructor-led, live training (online or onsite) is aimed at business analysts and data analysts who wish to learn
AI-Driven Data Analysis with TIBCO Spotfire X
14 hoursTIBCO Spotfire X is a business intelligence and augmented analytics tool that combines natural language, artificial intelligence (AI), and streaming data technologies. This instructor-led, live training (online or onsite) is aimed at business
Data Analysis with SQL, Python and Spotfire
14 hoursIn this instructor-led, live training, 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
ELK: Elasticsearch, Logstash and Kibana for Administrators
14 hoursThis instructor-led, live training is aimed at system administrators who wish to set up an ELK stack (Elasticsearch, Logstash, Kibana). Note that a minimum of 3 delegates is needed for this course to run. The training starts with a discussion of
Google Sheets for Excel Users
14 hoursGoogle Sheets is a cloud-based spreadsheet application for formatting and analyzing data. Google Sheets is a great alternative to Excel that provides cloud capabilities and more. This instructor-led, live training (online or onsite) is aimed at
Monitoring with Grafana
14 hoursGrafana is a visualization and metric analytic suite. Grafana presents a visual representation of real-time data for application analytics. Grafana is most commonly used for home automation, process control, and more. The aim of the course is to
Grafana and Graphite
14 hoursGrafana is an open source visualization and metric analytic suite for visualizing real-time data of application analytics. Graphite is an open source software for monitoring and graphing computer system data. Together with Grafana and Gaphite, users
Kibana: Essentials
14 hoursThis training introduces Kibana to the users of Elasticsearch. Kibana is an open source analytics and visualization platform designed to work with Elasticsearch. You use Kibana to search, view, and interact with data stored in Elasticsearch
Business Intelligence and Data Analysis with Metabase
14 hoursMetabase is an open source business intelligence (BI) tool. It provides a simple and user-friendly interface for creating and configuring data visualizations and dashboards. This instructor-led, live training (online or onsite) is aimed at data
QlikView for Business Users
7 hoursQlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this
QlikView for Developers
14 hoursQlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making. In this
Data Analysis with Redash
14 hoursRedash is an open source business intelligence tool for creating data visualizations and interactive dashboards. It uses SQL to query and extract data from different database sources, such as Postgres, MySQL, MongoDB, Presto, Snowflake, etc. This
TIBCO for Developers
21 hoursTIBCO is a software suite for integrating, managing, and monitoring enterprise applications and information delivery. Two of its products, BusinessEvents (business rules engine) and ActiveMatrix Service Bus (lightweight enterprise service bus), are
TIBCO Statistica
14 hoursTIBCO Statistica is an advanced analytics system that provides data analysis, data management, data visualization, data mining, statistics, and machine learning solutions for businesses. This instructor-led, live training (online or onsite) is