MS POWER BI INTERVIEW QUESTIONS

1. Interview Questions MS POWER BI

2. Define Power BI • A cloud-based information sharing tool, Power BI enables anybody to examine and visualize information with more noteworthy productivity, speed and comprehension. Additionally, it helps in associating clients to an extensive variety of information with the assistance of simple to-operate dashboards and interactive reports which brings data to life. Name some of the filters used in Power BI reports. • Page Level Filters • Visual Level Filters • Drill Through Filters • 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. 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.

4. What are the types of Data Refresh in Power BI? • Mainly there are four different types of refresh that can happen in Power BI. They are: • Package refresh • Model or data refresh • Tile refresh • Visual container refresh What are benefits of using variables in DAX? • Variables can make more unconstrained DAX expressions which are more consistent to interpret. Then 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.

5. What are the different components of Power BI? • Power BI Service • Power Query • Power Pivot • Power View • Power Map • Data Management Gateway • Power BI Q & A • Data Catalog What are the connectivity modes available in Power BI • Mainly there are two types of connectivity modes • Import • Direct Query

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. What is DAX ? • In order to do data analysis on data and for calculation in power pivot, Data Analysis Expression (DAX) is used. • DAX works on column values • We can modify or insert data using DAX • The calculated columns can  be calculated but the same cannot be done for rows using DAX

7. What is the Difference between Microsoft Business Intelligence tool - Power BI Desktop and Power BI? Power BI Desktop • It is a Windows application (Client) running on the PC. It is a client machine which can be connected with various data sources from your PC to the data in the local PC or the information in the server. Power BI • Power BI is a cloud solution. We can utilize internet browser to connect with Power BI. We can implement similar advancement work utilizing either Power BI OR Power BI Desktop.

8. VISUALPATH TRAINING INSTITUTE For More Information About MS Power BI Online Training Contact: 9704455959, 9989971070 Address: Flat no: 205, 2nd Floor, Nilgiri Block, Aditya Enclave, Ameerpet, Hyderabad-16 Website: www.visualpath.in