Course Code

pbidash
 

     Duration

14 Hours
 
 

     Requirements

There are no specific requirements needed to attend this course.

 

     Overview

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

 

 

     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

 

 

     Feedback (2)

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.


The course could be tailored to suit your needs and objectives. It can also be delivered on your premises if preferred.


  
  
  


  

Online Price per participant 6000 AED

  

Classroom Price per participant 6000 AED

Starts

 

Ends

 

  Workday courses take place between 9:30 and 16:30

Location


  Show venue details


Number of Participants






Related Courses

Total Courses 8


Algorithmic Trading with Python and R

  14 hours

Statistical Analysis with Stata and R

  35 hours

Stata: Beginner to Advanced

  14 hours

Cluster Analysis with R and SAS

  14 hours

SAS Programming

  14 hours

QlikView for Developers

  14 hours

QlikView for Business Users

  7 hours

Alteryx for Developers

  14 hours

Data Preparation with Alteryx

  7 hours

Alteryx for Data Analysis

  7 hours

Alteryx Advanced

  14 hours

 

IBM Cognos Analytics

  14 hours

 

Google Sheets for Excel Users

  14 hours

Business Intelligence and Data Analysis with Metabase

  14 hours

Data Analysis with Redash

  14 hours



Public Course Discounts

Total Courses 5