Microsoft Power BI Advanced Training
Microsoft Power BI Advanced online course e is a one-of-a-kind Advanced Power BI course, which is designed to fulfill the needs of modern company workers who demand experience in business intelligence technologies as well as deep data analytics abilities. Participants will learn all of the key analytical reports and dashboards creation functions and features using Power BI tools from a beginner to a master level of expertise. After completing the course, participants will be able to perform their day-to-day tasks in a more productive and professional manner, thereby improving organizational performance.
Course Key Learning
This course is for people who want to learn how to create and publish stunning visual reports and dashboards, as well as do data analysis using Power BI.
- Learn to use Power BI (Business Intelligence) Desktop to create highly visual reports and dashboards that can easily be shared with others.
- Get an understanding of how the reports and dashboards can interact with each other and the great level of interactivity the audience can use to drill, filter, and sort the reports.
- Data Visualization
- Industry Use Cases
Course Key Topic
Power Bi Desktop Basics
- Power BI Use Case
- Installation and Setup
What is Power Bi Desktop
- Introducing the Power BI Ecosystem
- Getting started with Power BI Desktop
Digital Storytelling
- Purpose of creating dashboard/reports
- Planning Reports & Dashboards
- Structure Reports & Dashboards
- Simple Data connections
- Connect to Excel data (single table)
- Connect to a data model created in Power Bi Desktop
Calculations
- Sum, Average
- Divide, Multiply
Power Bi standard visuals
- Chart, Table, Matrix
- Treemap, Funnel, Map
- KPI, Gauge
- Card, Multi Row Card, Slicer
Custom Visuals
- Import and use custom visuals
- Visuals interactions
- How to use Images, Shapes, and Textboxes on pages
Buttons and Bookmarks
- Add navigation to report
- Add interactivity to reports using buttons
Drill/Filter & Sort
- Page level filters
- Report level filter
- Drill through levels in visuals
- Sort data in visuals
- Sort by column
Tooltip Page
- Control Tooltips
- Create Tooltip pages
- Set interaction between visuals and tooltip pages
Layout and Formatting
- Format visuals, Format pages
- Work with themes, Snap Object to Grid
- Use gridlines, Lock Objects
- Selection Pane, Conditional Colour formatting
- Publishing Reports and Dashboard
Power BI Service and Excel PowerPivot
Creating a PowerPivot Data Model
Import data from PowerPivot to Power BI Service
Using PowerPivot data to create visualisations in Power BI Service
Power BI Desktop for Visualisation Workshop
- Adding visualisations to Report Canvas
- Managing visualisation relationships
- Drill Down and Drill through techniques
- Use of Hierarchies
- Importing and using custom visualisations
Sharing Data with Power BI
- Share interactive Power BI dashboards
- Share through Power BI, PowerPoint, the web and other mediums
- Content Packs
Refreshing Data
- Refreshing data manually
- Scheduled Refresh
Power BI on Mobile Devices
- Meeting different mobile clients’ requirements
- Windows 10, Ipad, Android
Course Useful Downloads
Microsoft Power BI Desktop
Microsoft Power BI Report Builder
International Student Fee : 300$ | 1,125 AED | 1,125 SAR
Flexible Class Options
- Corporate Group Training | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training
