Note: some courses require a minimum of 2 delegates. Please contact us.
Last updated
Course Code
pbidash
Duration
14 hours (usually 2 days including breaks)
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
- 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
Testimonials
We also do Consultancy!
We work with leading clients across a wide range of technologies!
Reach out for Project | Staff Enhancement | System Audit Consulting
