VTEC Training
Course Code: 19312
Microsoft Power BI Dashboards
VTEC Training
Portland,
ME
Class Dates:
1/1/0001
Length:
2 Days
Cost:
$995.00
Class Time:
Technology:
Business
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training
Overview
- Course Overview
- Expand your expertise–and learn how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making. If you’re an experienced business intelligence professional or manager, you’ll get all the guidance, examples, and code you need to succeed–even if you’ve never used Power BI before.
Successfully design, architect, and implement Power BI in your organization
Take full advantage of any Microsoft Power BI platform, including Power BI Premium
Make upfront decisions that position your Power BI project for success
Build rich, live dashboards to monitor crucial data from across your organization
Aggregate data and data elements from numerous internal and external data sources
Develop dynamic visualizations, including charts, maps, and graphs
Bring data to life with stunning interactive reports
Ensure dashboard security and compliance
Drive user adoption through effective training
Prerequisites
Course Details
- 1. Introduction of Power BI and Its Capabilities
- Introduction to Power BI
- Power BI features
- Power BI platforms
- Power BI licensing models
- Set up Power BI
- Prepare a dashboard in Power BI Service
- 2. Power BI architecture and administration
- Power BI architecture
- The Power BI Admin Portal
- Power BI data models and report development
- Relationship view
- 3. Visuals in Power BI
- Overview of visuals in Power BI
- Power Bi visuals out of the box
- Third-party visuals in Power BI
- Other ways to import third-part visuals into Power BI
- More Options
- Drill through Power BI visuals
- Apply filters in Power BI Reports
- Slicers
- 4. Power BI report development
- Data sources supported by Power BI
- Build a Power BI report in Power BI Desktop
- Relationship view
- Publish your report to Power BI service
- 5. Use DAX in Power BI
- Calculated columns and measures
- DAX capabilities
- DAX expressions syntax and context
- DAX functions
- 6. Develop Power BI reports from Excel
- Import data from an Excel workbook into Power BI
- Add a measure and a calculated column
- Add Power BI visuals to the report
- Arrange the visuals
- Prepare the report for mobile view
- Publish and view the report
- Prepare a dashboard from the report
- 7. Develop Power BI reports from SharePoint
- Build a Power BI report based on data from a SharePoint Online list
- Build a Power BI report based on data from a SharePoint Online folder
- Refresh report data in a Power BI report
- Embed Power BI reports in SharePoint Online
- 8. Developing Power BI reports from SharePoint On-Premises
- Import data from a SharePoint On-Premises list into Power BI
- Create a Power BI Report
- Set up a data gateway
- Configure Power BI to sue the data gateway and set up refresh functionality
- 9. Developing Power BI reports from SQL
- Import data from a SQL Server database into Power BI
- Create a Power BI report
- Set up a data gateway
- Configure Row-Level Security (RLS) in Power BI
- Limitations of RLS in Power BI
- 10. Developing Power BI from SSAS cube
- Import data from a SSAS cub into Power BI
- Create a Power BI report
- Set up and configure a data gateway
- 11. Developing Power BI reports from Azure SQL
- Overview of the Azure SQL portal
- Import data from an Azure SQL database into Power BI
- Create a Power BI report
- Set up and configure a data gateway
- 12. Develop Power BI reports from Oracle
- Import data from an Oracle database into Power BI
- Create a Power BI report
- Set up and configure a data gateway
- 13. Develop Power BI reports from Dynamics 365
- Import data from Dynamics 365 into Power BI Desktop
- URL syntax
- Create a Power BI report
- Import data from Dynamics 365 into Power BI service
- Embed a Power BI dashboard into a Dynamics 365 dashboard
- Understanding DAX and Power BI Dashboard Development