Hi all
greetings from TS TECHNOLOGIES
We are offering POWER BI online course
course duration: 35 days
mode : online
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
anusha tstech 
