Power BI Interview Questions

 1. What is BI?

Business intelligence is a technology-driven method. It helps you to analyze data and to provide actionable information which helps corporate executives, business managers, and other users to take decisive business decisions. know more at Power bi online training

2. What is a Power BI?

Power BI is a Business Intelligence and Data Visualization tool which helps you to convert data from the various data source into interactive dashboards and BI reports. It provides multiple software connectors and services.

3. Why use Power BI?

Here are four primary reasons for using Power BI tool:

  • Pre-built dashboards and reports for SaaS Solutions.
  • Power BI allows real-time dashboard updates.
  • Offers Secure and reliable connection to your data sources in the cloud or on-premises
  • Power BI offers fast deployment, hybrid configuration, and secure environment.
  • Helps you in data exploration using natural language query

4. What are the important components of Power BI?

Important components of Power BI are: 1) Data Integration, 2) Data Processing, and 3) Data Presentation

5. What is Dax Function?

It is a formula expression language called (DAX) that can be used with various visualization tools like Power BI. It is also known as a functional language, where the full code is kept inside a function know more at power bi training.

6. What are the data types of Dax?

Data types of Dax are: 1) Numeric, 2) Boolean, 3) DateTime, 4) String, and 5) Decimal.

7. What are the essential applications of the Power BI?

Power BI is mainly used by:

  • PMO - Project Management Office
  • Business & Data Analyst
  • Developer & Database Administrator
  • IT Team, IT Professional
  • Consumer for End User Report
  • Data Scientist

8. What are the drawbacks of using Power BI?

Here, are the main drawbacks of Power BI:

  • Dashboards and reports only shared with users having identical email domains.
  • Power Bl does not mix imported data, which is accessed from real-time connections.
  • Power BI can't accept file size larger than 1 GB.
  • Dashboard does not accept or pass user, account, or other entity parameters.

9. Name out three important Power BI tools

Three important power BI tool are:

  • Power BI Desktop—It is used for desktop computers
  • Power BI service—It is an online software as a service tool
  • Mobile Power BI apps—They are used for iOS and Android devices.

10. What are the important components of the Power BI toolkit, and what do they do?

  • Power Query: It allows you to discover, access, and consolidate information from different sources.
  • Power Pivot: A modeling tool.
  • Power View: It is a presentation tool for creating charts, tables, and more.
  • Power Map: Helps you to create geospatial representations of your data.
  • Power Q&A: Allows you to use natural language to get answers to questions.

11. What types of data types are available in Power BI?

Important Data sources used in Power BI Desktop are:

  • All
  • File
  • Database
  • Power BI
  • Azure
  • Online Services
  • Other

12. What is grouping? How can you use it?

Power BI Desktop allows you to group the data into small chunks. For grouping, you should use Ctrl + click to select multiple elements in the visual. Right-click one of those elements which appear in groups window.

13. Explain the term responsive slicers.

On a report page, you can easily resize a responsive slicer to various sizes and shapes, and the data contained in it should be rearranged according to it. In case if the visual becomes too small to be useful, an icon representing the visual ability to take its place, thus saving the space on the report page. know more at power bi online course

14. Define the term 'M language."

It is a programming language used in Power Query. It's a functional, case-sensitive language which is similar to other programming languages and easy to use.

15. What information is required to create a map in Power Map?

Power Map can display visualizations which are geographical in nature. That's why some kind of location data is needed, for example, city, state, country or latitude and longitude.

16. What are the important features of Power BI dashboard?

  • It allows you to drill through the page, bookmarks, and selection pane.
  • It allows you to create various tiles like web content, images, textbox, and integrate URLs.
  • Allows you to set report layout to mobile view.

17 What are the steps to go to Data Stories Gallery in Power Bi communities?

Steps to go to Data Stories Gallery:

  • First, open PowerBI.com in a favorite browser.
  • By hovering on Learn
  • Click on Community
  • Scroll down little, and you will find Data Stories Gallery.
  • Anyone can submit her or his Data Story as well.
  • 18. Where incremental licensing refresh feature is accessible?

  • Incremental refresh feature mainly used for high-end scalability of data by publishing only on that workspace in Power BI Service where Premium capacity is needed.

    19. How can you analyze Power BI reports data in excel?

    You need to follow the below-given steps:

    • Open Power BI Admin portal, go to tenant settings and select -> Analyze.
    • Check that Power BI Administrator has enabled Excel option or not.
    • Then at the upper right corner, click settings to download and install Excel updates.
    • Next, go to the left-hand side navigation pane, go to the workspace, click on the dataset, click on Eclipses (three dots) and select Analyze in Excel.
    • Download ODC file, save, and double click on it.
    • After that needs to provide power BI user id and password.

    20. What is Power Pivot, and what are the filter writes in Power BI?

    Power Pivot is an in-memory component which offers highly compressed data storage. It helps you to build a data model, creating formulas, relationship, calculated columns from various resources.

    Filters are applicable in:

    • Visualization level
    • Page Level
    • Report Level

    21. How can you perform Dynamic filtering in Power BI?

    Dynamic Filtering in Power BI is done using the following steps:

    • Once all the data are set up, publish a detail report to Power BI.
    • Publish it to group workspace.
    • Create a filter link
    • Create a DAX calculated column.
    • Public overview report

    22. What is Power Pivot Data Model?

    It is a model that contains data writes, tables, sections, and table relations. These data tables help you to develop for holding data for a business substance. know more at Power bi online training from Inida

    23. What is Power Query?

    Power query is an ETL tool which helps you to clean, shape, and modify data utilizing instinctive interfaces without doing anything.

    24. Which programming language is used in Power Query?

    M-code is a new programming language that is used in power query. It is similar to other programming languages and easy to use.

    25. List out benefits of using Variables in DAX.

    Here, are benefits of using DAX function:

    • By declaring and evaluating a variable, the variable can be reused multiple times in a DAX expression, which helps you to avoid additional queries of the source database.
    • Variables can make DAX expressions more useful and logical.
    • Variables is only scoped, which should be measure or query which can't be among measures. power bi online training hyderabad

    25. What are Tiles in Power BI?

    Tile is an important feature of power BI services and can be said as a picture of the data which can be pinned to the dashboard.

Comments

Post a Comment

Popular posts from this blog

What is Azure?

  What is Azure? Microsoft Azure, formerly known as Windows Azure is a  Microsoft public cloud computing environment.  This platform provides a wide range of services including compute, storage, networking, and networking. Here the users can pick and scale these services to develop and scale applications (or) run the existing applications in the public cloud. This Azure platform aims to help business challenges and meet their organizational goals.  It offers tools that support all industries including e-commerce, finance, and a variety of fortune 500 companies.  This platform is compactable with various open-source technologies. This platform is capable of four cloud computing platforms like: a)Infrastructure as a Service(Iaas) b)Platform as a Service(Paas) c)Software as a Service (Saas) and d)Server less Besides, this cloud computing platform is an online portal that allows you to access and manage cloud services provided by Microsoft. These services and resour...
Read more

SharePoint Interview Questions

  1) What is MS Share-Point is used for? MS Share Point is used for multiple purposes, and it acts as a back-end system that combines all your employees PC’s and mobile device together allowing them to communicate symmetrically. know more at Share point online training Share documents:  It allows to store and share documents by anyone in the company also it allows to work on a single document by several employees at same time Intranet:  Dashboards can be customized by department and access to all employees are given to check the regular updates into the company Extranet:  With the help of SharePoint, you can provide an outside company a space or a site to upload all the information your company may require from them Websites:  You can use SharePoint to manage and build a publicly facing site as well.  display relationship between different inputs through charts and graphs Collaboration:  Through SharePoint employees can be interlinked with each other a...
Read more

Selenium Interview Questions

  1) What is Automation Testing? Automation testing or Test Automation is a process of automating the manual process to test the application/system under test. Automation testing involves the use of a separate testing tool which lets you create test scripts which can be executed repeatedly and doesn’t require any manual intervention. know more at Selenium online training Q #2) What are the benefits of Automation Testing? Benefits of Automation testing are: Supports execution of repeated test cases Aids in testing a large test matrix Enables parallel execution Encourages unattended execution Improves accuracy thereby reducing human-generated errors Saves time and money Q #3) Why should Selenium be selected as a test tool? Selenium is a free and open source have a large user base and helping communities have cross Browser compatibility (Firefox, Chrome, Internet Explorer, Safari etc.) have great platform compatibility (Windows, Mac OS, Linux etc.) supports multiple programming langu...
Read more