Courses

Power BI Course Details

About Power BI Training

Power BI Training in Hyderabad Curriculum

Introduction

• Introduction to Power BI – Need, Importance
• History – Power View, Power Query, Power Pivot
• Power BI Architecture and Data Access

Power BI Desktop

• Power BI Desktop – Installation, Usage
• Understanding Power BI Report Designer
• Report Visuals, Fields and UI Options
• Visualization Filters, Page Filters, Report Filters
• General Properties, Sizing, Dimensions, and Positions
• Sample Reports and Visualization Controls
• Experimenting Visual Interactions, Advantages
• Reports with Multiple Pages and Advantages
• Hierarchies and Drilldown Options
• Hierarchies: Grouping Multiple Report Fields
• Hierarchy Levels and Usages in Visualizations
• Drill-thru Options with Tree Map and Pie Chart
• Higher Levels and Next Level Navigation Option
• Data Fields and Filters with Visualizations
• Creating Customised Tables with Power BI Editor
• Column Headers, Column Formatting, Value Properties
• Conditional Formatting Options – Color Scale
• Background Properties, Borders and Lock Aspect
• CHART Report Types and Properties
• Map Reports: Working with Map Reports
• Creating high-density reports, ArcGIS Maps
• PUBLISH Options and Report Verification in Cloud

Power Query:

• Direct Query Options and Real-time (LIVE) Data Access
• Advanced Query Mode @ Connection Settings – Options
• Custom Columns with Power Query
• Power Query Expressions and Usage
• PIVOT Operation and Table.Pivot(). List Functions
• Using Parameters(Power Query Editor)
• Report Design using Databases & Queries

Power BI Service :

• Understanding PowerBI Cloud Architecture
• Publish Options and Data Import Options
• Page to Report – Mapping Options
• Import and Export Options with Power BI
• Gateways, Subscriptions, Mobile Reports
• Installing the Power BI Enterprise Gateway
• Dataset Actions and Refresh Settings with Gateway
• Dashboards and Pins – Real-time Usage
• Adding images to the dashboards
• Relation between Dashboards to Reports
• Dashboards, Workbooks, Reports, Datasets
• Dashboard Integration with Apps in Power BI
• Dashboard Actions: SETTINGS FOR Q & A, DELETE
• PIN Actions: SETTINGS FOR Q & A, DELETE
• EDIT DASHBOARD (CLOUD), On-The-Fly Reports
• SCHEDULED REFRESH & RELATED ITEMS
• with MY WORK SPACE group
• PowerBI Cloud Account and Workspace
• Quick Navigation Options with “My Workspace”
• Navigation Paths with “My Workspace” Screens
• Report Actions: USAGE METRICS, ANALYSE IN EXCEL
• Personal and Organizational Content Packs
• Dataset Navigations and Report Navigations
• Managing report in Power BI Services
• Dynamic Data Sources and Encryptions
• Data Refresh with Power BI Architecture
• Automatic Refresh – Possible Issues
• Publish PowerBI Report Templates
• Using natural Language Q&A to data – Cortana