Power BI Interview Questions

 

1. What is Power BI?

Power BI is a developed by Microsoft that helps you turn multiple unrelated sources of data into valuable and interactive insights. These data may be in the form of an Excel spreadsheet or cloud-based/on-premises hybrid data warehouses. You can easily connect to all your data sources and share the insights with anyone. know more at Power bi online training

2. List out some benefits of using Power BI.

Here are some benefits of using Power BI:

  • It helps build interactable data visualization in data centres
  • It allows users to transform data into visuals and share them with anyone
  • It establishes a connection for Excel queries and dashboards for fast analysis
  • It provides quick and accurate solutions
  • It enables users to perform queries on reports using simple English words 

3. List out some drawbacks/limitations of using Power BI.

Here are some limitations of using Power BI:

  • It does not accept file sizes larger than 1 GB and also doesn’t mix imported data, which is accessed from real-time connections
  • There are very few data sources that allow real-time connections to Power BI reports and dashboard
  • Dashboards and reports are only shared with users logged in with the same email address
  • Dashboard doesn’t accept or pass user, account, or other entity parameters

4. What are some of the differences in data modeling between Power BI Desktop and Power Pivot for Excel? 

Power Pivot for Excel supports only single directional relationships (one to many), calculated columns, and one import mode. Power BI Desktop supports bi-directional cross filtering relationships, security, calculated tables, and multiple import options. know more at Power bi training

5. Name the different connectivity modes available in Power BI? 

There are three main connectivity modes used in Power BI are.

SQL Server Import

An SQL Server Import is the default and most common connectivity type used in Power BI. It allows you to use the full capabilities of the Power BI Desktop. 

Direct Query

The Direct Query connection type is only available when you connect to certain data sources. In this connectivity type, Power BI will only store the metadata of the underlying data and not the actual data.

Live Connection

In this connectivity type, data is not stored in the Power BI model. All interaction with a report using a Live Connection will directly query the existing Analysis Services model. There are only 3 data sources that support the live connection method -  SQL Server Analysis Services (Tabular models and Multidimensional Cubes), Azure Analysis Services (Tabular Models), and Power BI Datasets hosted in the Power BI Service

6. What are the different types of refresh options available in Power BI? 

There are four main types of refresh options available in Power BI -

  • Package refresh - This synchronizes your Power BI Desktop or Excel, file between the Power BI service and OneDrive, or SharePoint Online.
  • Model or data refresh - This refreshes the dataset within the Power BI service with data from the original data source.
  • Tile refresh - This updates the cache for tile visuals every 15 minutes on the dashboard once data changes.
  • Visual container refresh - This refreshes the visual container and updates the cached report visuals within a report once the data changes.

7. Name the data sources can Power BI connect to? 

There are a number of data sources that can be connected to Power BI, which are grouped into three main types:

Files

Data can be imported from Excel (.xlsx, .xlxm), Power BI Desktop files (.pbix) and Comma Separated Values (.csv). 

Content Packs

These are a collection of related documents or files stored as a group. There are two types of content packs in Power BI:

  • Content packs from services providers like Google Analytics, Marketo or Salesforce and
  • Content packs created and shared by other users in your organization. 

  • 8. What is a dashboard in Power BI? 

    A dashboard is a single layer presentation sheet of multiple visualizations reports. The main features of the  are:

    • It allows you to drill through the page, bookmarks, and selection pane and also lets you create various tiles and integrate URLs
    • A dashboard can also help you set report layout to mobile view

    9. Explain how relationships are defined in Power BI Desktop? 

    Relationships between tables are defined in two ways: 

    • Manually - Relationships between tables are manually defined using primary and foreign keys
    • Automatic - When enabled, this automated feature of Power BI detects relationships between tables and creates them automatically

    10. Can you have more than one active relationship between two tables in a Power Pivot data model?

    No. There can be multiple inactive relationships, but only one active relationship between two tables in a Power Pivot data model. Dotted lines represent inactive relationships and continuous lines represent active relationships.

    11. Can you have a table in the model which does not have any relationship with other tables? 

    Yes. There are two main reasons why you can have disconnected tables:

    • The table is used to present the user with parameter values to be exposed and selected in slicers 
    • The table is used as a placeholder for metrics in the user interface

    12. What is the CALCULATE function in DAX?

    The CALCULATE function evaluates the sum of the Sales table Sales Amount column in a modified filter context. It is also the only function that allows users to modify filter context of measures or tables.

    13. Where is data stored in Power BI? 

    Data is stored in fact and dimension tables. 

    • Fact tables: It is the central table in a star schema of a data warehouse. It stores quantitative information for analysis.
    • Dimension tables: It is just another table in the star schema of a data warehouse. It stores attributes and dimensions that describe objects stored in a fact table.

    14. What are the different views available in Power BI Desktop? 

    There are three different views in Power BI, each of which serves a different purpose: 

    • Report View - In this view, users can add visualizations and additional report pages and publish the same on the portal.
    • Data View - In this view, data shaping can be performed using Query Editor tools
    • Relationship View - In this view, users can manage relationships between datasets

    15. What is the format available in Power BI?

    • Power BI Desktop—for desktop computers
    • Power BI service—an online SaaS (software as a service)
    • Mobile Power BI apps—for iOS and Android devices

    All of these can be used in conjunction. For example, you might create a report on your desktop, and then publish and share it online so that colleagues on mobile devices can read it.  know more at Power bi online course

    16. Describe the building blocks of Power BI.

    • Visualizations

      Visualization is a chart, graph, or similar visual representation of data.

    • Datasets

      A dataset is the group of data used to create a visualization, such as a column of sales figures. Datasets can be combined and filtered from different sources using built-in connectors.

    • Reports

      A report is a group of visualizations on one or more pages; for example, charts, graphs, and maps can be combined to create a report. 

    • Dashboards

      A dashboard lets you share a one-page visualization with others, who can then interact with your dashboard.

    • Tiles

      A tile is a visualization on your dashboard or in your report. As the creator, you can move tiles around.

    17. What are the main components of the Power BI toolkit, and what do they do?

    • Power Query: lets you discover, access, and consolidate info from different sources
    • Power Pivot: a modeling tool
    • Power View: a presentation tool for creating charts, tables, and more
    • Power Map: lets you create geospatial representations of your data
    • Power Q&A: lets you use natural language to get answers to questions; for example, “What were the total sales last week?”

    18. What is a content pack, and why would you use one?

    A content pack is a ready-made, predefined collection of visualizations and reports using your chosen service (for example, Salesforce). You’d use one when you want to get up and running quickly, instead of creating a report from scratch. know more at Power bi  training course

    19. Describe DAX.

    DAX stands for Data Analysis Expressions. It’s a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from the data you already have. 

    20. What are the three fundamental concepts of DAX?

    • Syntax

      This is how the formula is written—that is, the elements that comprise it. The Syntax includes functions such as SUM (used when you want to add figures). If the syntax isn’t correct, you’ll get an error message.

    • Functions

      These are formulas that use specific values (also known as arguments) in a certain order to perform a calculation, similar to the functions in Excel. The categories of functions are date/time, time intelligence, information, logical, mathematical, statistical, text, parent/child, and others.

    • Context

      There are two types: row context and filter context. Whenever a formula has a function that applies filters to identify a single row in a table, row context comes into play. When one or more filters are applied in a calculation that determines a result or value, the filter context comes into play.

Connectors

Comments

Post a Comment

Popular posts from this blog

What is Tableau?

Image
  What is Tableau? Tableau  is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data in a very easily understandable format. Tableau helps create the data that can be understood by professionals at any level in an organization. It also allows non-technical users to create customized dashboards. know more at Tableau online training Data analysis is very fast with Tableau tool and the visualizations created are in the form of dashboards and worksheets. The best features of Tableau software are Data Blending Real time analysis Collaboration of data The great thing about Tableau software is that it doesn’t require any technical or any kind of programming skills to operate. The tool has garnered interest among the people from all sectors such as business, researchers, different industries, etc. Tableau Product Suite The Tableau Product Suite consists of Tableau Desktop Tableau Public Tableau Online Tableau Server
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 and co-ordinate their efforts on on
Read more

Testing Interview Questions

  1. What do you understand by software testing? Software testing is a validation process which confirms that a system works as per the business requirements. It qualifies a system on various aspects such as usability, accuracy, completeness, efficiency, etc. ANSI/IEEE 1059 is the global standard that defines the basic principles of testing. 2. When should you stop the testing process? The testing activity ends when the testing team completes the following milestones. Test case execution The successful completion of a full test cycle after the final bug fix marks the end of the testing phase. know more at Testing tool online training Testing deadline The end date of the validation stage also declares the closure of the validation if no critical or high-priority defects remain in the system. Code Coverage(CC) ratio It is the amount of code  concealed  via automated tests. If the team achieves the intended level of code coverage (CC) ratio, then it can choose to end the validation. Mean
Read more