Monday, December 24, 2018

Top Power BI Interview Questions And Answers

1.difference between power bi and tableau

Tableau is the best tool when it comes to Data Visualization whereas Power BI focuses more on predictive modeling and reporting. Tableau has more flexible deployment options compared to Power BI. Power BI is available only as SaaS model whereas Tableau has got both on-premises and cloud options.

2. Name some of the filters used in Power BI reports.

1.Page Level Filters
2.Visual Level Filters
3.Drill Through Filters
4.Report Level Filters.

3. What is Power BI Desktop?

Power BI Desktop works well with Power BI service by giving the most advanced data visualization, modeling,and report creation with profoundly interactive visualizations. You can spare your work to a document, and distribute your information and reports ideal to your Power BI site to impart to others.

4. What is your understanding on content packs?

Content packs for administrations are pre-developed solutions for popular administrations as a feature of the Power BI experience. An endorser of a supported service can rapidly interface with their account from Power BI and see their data through live dashboards and reports that have been pre-developed for them.For more questions Power bi online training 

5. What are benefits of using variables in DAX?

Variables can make more unconstrained DAX expressions which are more consistent to interpret.They can’t be shared among queries or be characterized at the model level. When it is declared,the variables can be reused for various circumstances in a DAX expression, in this way staying away from extra queries of the reference or source database.

6. What is Power Pivot?

Power Pivot helps in analyzing our data so as to settle on convenient business choices without needing IT support. It empowers us to import large scale of data from numerous data sources into a single Excel sheet. It gives us a chance to make connections between complex data. It helps us to create Pivot Tables and Pivot Charts.learn at power BI certification

7. What is the default visual interaction in Power BI ?

The default visual interaction should be “Drill Mode On”, we can set this to on off, in the event that we keep off, we need to change the setting without fail. Rather set the Default to ‘Drill Mode On’.

Drilling Mode on, if the aggregates are at yearly level, the drill mode on can empower client to drill down to month to month, week by week, etc.

No comments:

Python for data analysis

I lean toward Python to R for scientific processing in light of the fact that numerical figuring doesn't exist in a vacuum; there's...