POWER BI online training in hyderabad

Services   Hyderabad   80 views Reference: 74593

Location: Hyderabad

Price: Free


Hi all 

TS TECHNOLOGIES providing POWER BI ONLINE COURSE 

training will be provided by excellent and experienced faculty

please go through the course content 

SLNO CONCEPTS TOPICS

1 POWER BI BASICS

POWER BI TERMINOLOGY, FEATURES AND

RELEASE HISTORY

POWER BI COMPONENTS

POWER BI ACCOUNT TYPES AND

INSTALLATION

POWER BI INSTALLATION

DATA MODELLING

DATA TYPES IN IT AND DATA

APPLICATIONS/MODELS/SYSTEMS (OLTP

VS OLAP)

ER MODEL RELATIONSHIPS AND

DIMENSIONAL MODEL RELATIONSHIPS

Data Ware housing concepts

POWER BI END TO END GET DATA FILE CATEGORIES

POWER BI AGGREGATIONS

POWER QUERY MENU: HOME, TRANSFORM,

ADD COLUMN,VIEW, HELP

Ribbon Options

POWER BI PARAMETERS

Power BI Reusability

POWER BI MASHUP LANGUAGE

DYNAMIC QUERY IN POWER BI

POWER BI DATASET AND FIELD PROPERTIES

POWER DESKTOP MENU: HOME, VIEW,

MODELING, HELP

COURSE CONTENT

3 DAX

POWER BI SERVICE

4 Power BI Service Power Bi Service Intro, Workspace, Apps

Dashboard creations, subscription, alert,

content packs, Gateways

Add users and provide roles

Dataflows

Publish workspace

Sharing reports to app workspace

Row Level Security

Power Bi gateways

Configure Data Gateway(Personal and

Standared)

SUB-TOPICS

Desktop(Power Desktop, Power Query, Power Pivot),Service, Mobile App, Gateway,

Power BI Desktop for On-premises and On-premises Report Server

Three accounts: Free, 1GB RAM, 1.5GHZ, 1.5P GroB, DPirsekmspiuamce ,[ pW1i,np 27,/p83/]10 or above, display 1440x900 or

1600x900 (16:9)

End to End report process in Power BI

Getting Data from Flat file & Excel files

Working with JSON and XM files

Getting Data from Web pages

Getting data from Databases using Query, View and Procedures

Working with Import/Load and Direct query, Connect live modes

Using Blank query and M-scripting knowledge

Introduction to POWER BI REPORT BULDER

Data types in Desktop and Query Editor

Queries Properties, Query Properties and Column properties

Joins Concepts in Power BI

Refresh, Enable Load, Functions, Grouping, Duplicate and Reference

Three Types a)Any b)List c) Query

Many ways a)PBIX file sharing b)PBIT file create and share c)Power BI Datasets usage

from Power BI Service d)Data flow usage

How to use and develop reports based on others code and very basic

knowledge

Go to Home menu-->Enter Data, specify values and table name

Filters in Power BI (Visual, Report, Page, Drill through)

Filters and Highlighting

Buttons,Bookmarking, Slicer and Sync Slicers

Row-Level Security and Dynamic Row-Level Security

Drill down and drill through Implementation

CONTENT

OLAP vs. OLTP vs. Insights and Analytics

Data warehouse, Data Mart and differences

Data Lake and Blob Storages

Data Granularity

Dimension, Dimension Table & types

Fact, Fact Table & measures types

Fact less fact table

Star Schema, Snow Flake Schema, Galaxy Schema

1:1, 1: Many, Many: Many relationships

Active, Inactive relationships

Single and Bidirectional relationships

Cross filtering relationship

Role Playing dimension

Tabular & Multi-dimensional model

Report creation on top of Python Script

Report creation on top of R Script

Major dax functions based on real-time covered

 

INTERESTED CANDIDATES 

CONTACT TS TECHNOLOGIES 

MOBILE &WHATS app 9951180008

VISIT www.tstechnologies.co.in