Microsoft Power BI Training From SQL School Training Institute

[sequelschool]

Microsoft Power BI Training From SQL School Training Institute

Complete Real-time and Practical Power BI Training with Real-time Project. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports and compelling visualizations for your day to day corporate business data needs! PowerBI Training Course.

 

Module I: PowerBI Config Settings, Basic Usage

Module II: Data Visualizations, Deployments

 

Introduction

• Introduction to Power BI
• Introduction to Excel
• Relationship between Excel &Power BI
• Understanding  Excel BI add
• Why power BI
• Downloading and installing Power BI.
• Power BI Desktop &Power BI Services.
• Building blocks of Power BI

Query Editor

• Different external data source
• Fetching data from different files
• Working with import and direct query
• Creating custom table in the Power BI
• Merge Queries and Append Queries
• Remove columns and split columns
• Choosing required columns in the data
• Working with different transformations
• Applied steps in query editor
• Working with hierarchies and measures
• Working with Pivot &Unpivot columns
• Creating index and custom columns
• Group By functionality in Query Editor

Groups, Pivots, Filters

• Creating and Working with groups
• Managing the null values and errors
• Managing data types in Query editor
• Working with dynamic parameters.
• Dynamic parameters to filter

DAX functions with Power BI

• Working with DAX Functions
• Calculated Measures by using DAX
• Parameters with DAX
• Dynamic Report Filters, Expressions

Power BI Desktop

• Connecting to Data sources
• Working with different visualizations
• Importing custom visualizations
• Working with table and matrix visuals
• Working with different level of filters
• Data Visualizations with Power BI
• Single row & multi row cards
• Defining relationships between tables
• Creating a custom table with range
• Publishing a report to Power BI Services

Power BI Views & KPIs

• Working with Power BI Views
• Working with Data Hierarchies
• In-built slicers and custom slicers
• Working with reference lines
• Working with Power pivot data model
• Working with data modeling
• Developing KPIs and Measures

Power BI Services

• Data from multiple Data Sources
• Reports from various data sets
• Dashboards from multiple reports
• Working with MY WORK SPACE group
• Creating Groups & Working
• Managing Gateways & Content Packs
• Adding tiles to the Dash Boards
• Adding YouTube videos to dashboards
• Adding images to the dashboards
• Working with all visualizations
• Using natural language Q&A to data
• Reading & Editing Power BI Views
• Managing report in Power BI Services
• Scheduling refresh to the Datasets
• Share dashboards to Client

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Contact us:

[email protected]

India: 0091 (0)9666440801 USA: 001 (510) 400-4845

 

Please register for Power BI Demo Session on Thursday, March 9, 2017 6:00 AM - 7:00 AM IST at: 

https://attendee.gototraining.com/r/6990108171318926338

After registering you will receive a confirmation email containing information about joining the training.