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
  • 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
 

Need help picking the right course?
Call us +27 (0)10 005 5793

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 hours

TIBCO 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 hours

TIBCO 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 hours

TIBCO 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 hours

In 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 hours

This 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 hours

Google 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 hours

Grafana 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 hours

Grafana 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 hours

This 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 hours

Metabase 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 hours

QlikView 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 hours

QlikView 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 hours

Redash 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 hours

TIBCO 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 hours

TIBCO 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