Azure Data Engineering

  1.Types of source used in Power BI Desktop?

Ans:   There multiple data source which we used to extract our source data ,But based on our business requirements will decide and use those data source connection.

Most frequently will use below data sources in my current dashboard.

2.Types of Filters available in Power BI?

Ans:Most commonly real time will use below filters

1.Visual Level Filter

2.Report Level Filter

3.Bi-directional cross filter

3.What are the visuals mostly used in Power BI dashboard?

Ans: There are many visuals available in power bi desktop some are predefined and some are customized,

In my real time i have used below visual  to re present data accurately.

1.Line chart:-Its very use fully to represent the sum of sales based on Location/Product wise.

2.Pie chart:-Its Very use full to represent the sales present(%) of each store wise or Location wise.

3.Filter:-Used to filter the location wise sales like (US,Canada,UK)

4.Card:-Used to represent total sales of all Geo graphic locations

5.Slicer:-Slicer are useful to sort the report data.

6.ArcGis Map-Previously we have Bing maps now in the latest version used ArcGis which is very help full to connect google maps. 

7.Clustered Column Chart:- It will be use full to represent and show the total sales vs Discounts . 

4.What is live connection mode in Power BI?

Ans: Live connection mode is the one of the best option to connection azure SSAS cube and the power BI dashboard.

But there are some cons in this method

1.4If the data volume is high then the power BI dashboard will give bad performance./

5.Difference between Live connection mode and Direct connection in power BI? 

Ans:Below are the differences which observed on Live connection and direct connection.

1.Live connection:

a.This mode we dint have option to write any customized query

b.Limited data its give best performance

2.Direct Connection:

a.This mode will connect SSAS model which deployed on server and there will retry the table data using sql query like below way.

B.Its very faster relative of back end data .

C.We can set query time out value to check if query is not running usual manner and its help full to optimize query.

6.What is the bi-directional filer  ?

Ans:Bi-directional cross filter are used to filter the multiple dimensional data in the model level.Again it based on our scenario we can apply this filter like below.

Thank you,I will share the next set of answers in my next post.

Thank you

Karthik.