what's power bi?

Question 1

WHATS IS OLTP?

Answer 1

ON-LINE TRANSACTIONAL PROCESSING
IT REFERS IT BUSINESS DATA

Question 2

how many are there steps of
in the process making report?

Answer 2

there are 5
OLTP,
ETL,
OLAP,
CREATE REPORT,
SHARING TO CLIENTS,

Question 3

WHAT DATA IS PRESENT IN OLTP?

Answer 3

RAW AND UN-STRUCTURED DATA MEANS DATA IS MESSED-UP IN BULK NOT ORGANIZED

Question 4

WHAT IS DATA BASE CALLED?

Answer 4

OLAP ,
MEANS CREATING DATABASE FOR A SPECIFIC DATA TO ORGANIZE

Question 5

OLAP FULL FORM?

Answer 5

ON-LINE,ANALYTICAL,PROCESS

Question 6

ETL FULL FORM?

Answer 6

EXTRACTING,TRANSFORM & LOAD

Question 7

WHY OLTP IS NOT USEFUL TO MAKE REPORT?

Answer 7

OLTP IS A UN ORAGANIZED BUSINESS DATA IT WILL BE FULL RAW AND MESSED UP DATA SO WE CANNOT USE WHOLE RAW DATA TO MAKE REPORT

Question 8

WHY WE CALL ACTIONABLE INFO TO REPORT?

Answer 8

CLIENT SHARES REPORT AND ACTION UPON THE REPORT IN HIS DECISION MAKING.

Question 9

3 MAJOR STEPS OF DATA ANALYISIS

Answer 9

OLTP»ETL»OLAP
OLTP contains raw data which is transformed in ETL AND ORGANIZED AND SENDS TO OLAP TO PREPARE REPORTS

Question 10

POWER BI CALLED?

Answer 10

B-USINESS I-NTELLIGENCE SOFTWARE

DATA ANALYSIS SOFTWARE

REPORTING ANALYSIS SOFTWARE

DATA VISUALIZATION SOFTWARE

Question 11

OLTP GET DATA FROM WHERE?

Answer 11

SQL,ORACLE,EXCEL DATA IS ARE SOURCES OF DATA WHICH IS PRESENT IN OLTP

Question 12

POWER BI ACCESS?

Answer 12

POWER BI REPORT SERVER&raquo_space; SEND ON PREMISE DATA TO 1% OF CLIENTS

POWER BI SERVICE&raquo_space; AZURE CLOUD BASED SERVER TO SEND REPORTS TO 99% OF CLIENTS

POWER BI MOBILE&raquo_space; IT IS USEFUL TO CLIENTS TO VIEW REPORTS VIA MOBILE IN ANDROID AND IOS

Question 13

POWER BI DESKTOP’S BRANCHES

Answer 13

POWER QUERY -IT IS A ETL SOFTWARE WHERE DATA IS TRANSFORMED INTO ORGANIZED DATA

POWER PIVOT - IT IS A DATABASE WHERE OLAP COMMENCES

POWER VIEW - REPORT IS DONE HERE

Question 14

SQL FULL FORM

Answer 14

STRUCTURED QUERY LANGUAGE