MS POWER BI INTERVIEW QUESTIONS

1
MS POWER BI
Interview Questions
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 cant 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