Menu Close

We Help You Invent The Future

POWER BI

Course Description

Adiversetech Hyderabad offers an inclusive Power BI training in Hyderabad. This Power BI Visual, Usage and Properties as per the latest versions. This Power BI course includes On-premise and Cloud Data Access, REST API, Azure Stream and R Integration including Data Modelling and ETL Techniques with Basic to Advanced Power Query (M Language), DAX Language Functions, Power BI Dashboards, Streaming Datasets, App Workspace, Content Packs, Data Gateways, Alerts, Power BI Report Server Components, Power BI Mobile Repots, Excel Integration, Excel Analysis, KPIs for Big Data Analytics, Microsoft OneDrive, Google Big Query, DataFlow and ETL in Cloud are also a part of this.
Duration:5 days Course Outline
Day 1

Session 1: Quick Start Power BI Service

1.01 Get Power BI Tools 0:03:45
1.02 Introduction to Tools and Terminology 0:04:37
1.03 Dashboard in Minutes 0:12:46
1.04 Refreshing Power BI Service Data 0:03:15
1.05 Interacting with your Dashboards 0:07:34
1.06 Sharing Dashboards and Reports 0:04:53
1.07 Recap and What’s Next 0:01:46
 Session 2: Getting and Transforming Data with Power BI Desktop
2.01 Introduction to Power BI Desktop 0:09:05
2.02 Getting Data: Excel vs Power BI Desktop & Service 0:08:01
2.03 Data Structure for Q&A 0:03:59
2.04 DirectQuery vs Import Data 0:04:15
2.05 Recap and What’s Next 0:02:37
Day 2

Session 3: Modeling with Power BI

3.01 Introduction to Modeling 0:01:25
3.02 Setup and Manage Relationships 0:08:36
3.04 Default Summarization & Sort by 0:07:07
3.05 Creating Calculated Columns 0:02:43
3.06 Creating Measures & Quick Measures 0:14:32
3.07 Recap and What’s Next 0:02:22
Day 3  Session 4: Power BI Desktop Visualisations
4.01 Creating Visualisations 0:06:36
4.02 Color Formatting 0:08:44
4.03 Setting Sort Order 0:04:46
4.04 Scatter & Bubble Charts & Play Axis 0:05:14
4.05 Tooltips 0:02:48
4.06 Slicers, Timeline Slicers & Sync Slicers 0:12:27
4.07 Cross Filtering and Highlighting 0:04:27
4.08 Visual, Page and Report Level Filters 0:07:16
4.09 Drill Down/Up 0:09:33
4.10 Hierarchies 0:05:09
4.11 Reference/Constant Lines 0:05:40
4.12 Tables, Matrices & Conditional Formatting 0:15:17
4.13 KPI’s, Cards & Gauges 0:11:50
4.14 Map Visualizations 0:07:445
4.15 Custom Visuals 0:04:56
4.16 Managing and Arranging 0:04:53
4.17 Drillthrough 0:06:50
4.18 Custom Report Themes 0:13:22
4.19 Grouping and Binning 0:04:59
4.20 Selection Pane, Bookmarks & Buttons 0:14:47
4.z Recap and What’s Next 0:03:14
Day 4  Session 5: Power BI Service Visualisation Tools
5.01 Introduction 0:01:01
5.02 Standalone Tiles 0:07:59
5.03 Data Driven Alerts 0:07:51
5.04 Quick and Related Insights 0:05:16
5.05 Custom Q&A questions 0:04:59

Session 6: Publishing and Sharing

6.01 Introduction 0:01:01
6.01 Sharing Options Overview 0:05:31
6.02 Publish from Power BI Desktop 0:05:25
6.03 Publish to Web 0:07:34
6.04 Share Dashboard with Power BI Service 0:10:38
6.05 Workspaces and Apps (Power BI Pro) 0:13:53
6.06 Content Packs (Power BI Pro) 0:08:19
6.07 Print or Save as PDF 0:03:03
6.08 Row Level Security (Power BI Pro) 0:11:49
6.09 Export Data from a Visualization 0:05:19
6.10 Publishing for Mobile Apps 0:03:17
6.11 Export to PowerPoint 0:03:34
6.z Sharing Options Summary 0:02:31
Day 5  Session 7: Refreshing Datasets
7.01 Understanding Data Refresh 0:04:55
7.02 Personal Gateway (Power BI Pro and 64-bit Windows) 0:10:23
7.03 Replacing a Dataset 0:04:18
7.04 Troubleshooting Refreshing 0:02:54
 Session 8: Power BI and Excel Together
8.01 Options for Publishing from Excel 0:04:19
8.02 Pin Excel Elements to Power BI 0:04:57
8.03 Connect to Data using Power BI Publisher/Analyze in Excel 0:07:54
8.04 Excel 2016 Publish: Upload and Export to Power BI 0:08:17
8.05 Sharing Published Excel Dashboards 0:08:59
 
Code Calibre