FOR FREE DEMO contact :

Email : info@ibasetraining.com

Phone/WhatsApp : +91-8106721223

USA Number : +1-650-993-1007

Gtalk : ibasetraining@gmail.com

WebSite: http://www.ibasetraining.com



————PowerBI Desktop—————

Introduction to PowerBI Desktop

Different data sources (excel,csv,Sql server,ssas,web)

Data types and Categories

Direct Query And Import and Live connection

Parameters in power BI

Caliculate Column Vs Calculated Measures

All Transformation Options in EDIT Query Window

How to create Customer Function

How to Invoke Custome Function

Templates in powerBI

Synanoyms in PowerBI

Hierarchies in PowerBI

import Excel workbook content

Modeling and Filters in PowerBI

MERGING AND APPENDING QURIES

cross filter direction in modeling

Bins and list in Grouping

Theams in powerbi

Customevisualls

Filters(Visual Level,Report Level ,Page Level,Drill through) in PowerBI Desktop

Scatter chart by using play axis option

word cloud

slicer

Archimaps enablement in powerBI Desktop and service

Power BI publisher for Excel

Quick measures

Publish reports to PowerBI Online



——————PowerBIService(Online)———————

Introduction to Power BI Service

How to create Dashboards

Delivery Methods Of Dashboard

How to create powerBI Apps

Data Gateways and schedule refresh

Row Level Security

Row Level Security in PowerBI Desktop

Row level security in Power BI Service

Row level security in powerBI dynamic

Power BI Reporting Services

Q&A Natural Language Processing option in PowerBI

Quick Insights

Dashboards and Pins – Real-time Usage

Dynamic Data Sources and Encryptions

Personal and Organizational Content Packs

Gateways, Subscriptions, Mobile Reports

Data Refresh with Power BI Architecture

PBIX and PBIT Files with Power BI – Usage

Visual Data Imprts and Visual Schemas

Cloud and On-Premise Data Sources

Relation between Dashbaords to Reports

Relation between Datasets to Reports

Relation between Datasets to Dashboards

Page to Report – Mapping Options

Publish Options and Data Import Options

Need for PINS @ Visuals and PINS @ Reports



—————–PowerBI DAX expressions——————

Purpose of Data Analysis Expresssions (DAX)

Scope of Usage with DAX.Usabilty Options

DAX Context : Row Context and Filter Context

DAX Entities : Calculated Columns and Measures

DAX Data Types : Numeric, Boolean, Variant, Currency

Date time Data Tye with DAX. Comparison with Excel

DAX Operators & Symbols. Usage. Operator Priority

Parenthesis, Comparison, Arthmetic, Text, Logic

DAX Functions and Types: Table Valued Functions

Filter, Aggregation and Time Intelligence Functions

Information Functions, Logical, Parent-Child Functions

Statistical and Text Functions. Formulas and Queries

Syntax Requirements with DAX. Differences with Excel

Naming Conventions and DAX Format Representation

Working with Special Characters in Table Names

Attribute / Column Scope with DAX – Examples

Measure / Column Scope with DAX – Examples

YTD, QTD, MTD Calculations with DAX

DAX Calculations and Measures

Using TOPN, RANKX, RANK.EQ

Computations using STDEV & VAR

SAMPLE Function, COUNTALL, ISERROR

ISTEXT, DATEFORMAT, TIMEFORMAT

Time Intelligence Functions with DAX

Data Analysis Expressions and Functions

DATESYTD, DATESQTD, DATESMTD

ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH

FIRSTDATE, LASTDATE, DATESBETWEEN

CLOSINGBALANCEYEAR, CLOSINGBALANCEQTR

SAMEPERIOD and PREVIOUSMONTH, QUARTER

KPIs with DAX. Vertipaq Queries in DAX

IF..ELSEIF.. Conditions with DAX

Slicing and Dicing Options with Columns, Measures

DAX for Query Extraction, Data Mashup Operations

Calculated Columns and Calculated Measures with DAX



————————————————————–

PowerBI Reporting Services with SSRS

R language integration with PowerBI


M language in Power BI Desktop



For course content please follow the link : http://ibasetraining.com/power-bi-realtime-online-training-from-india/