Power BI Interview Questions

 

1. What is Power BI?

Power BI is a Self-Service Business Intelligence tool powered by Microsoft. It was launched in 2013. Today, it has gone way ahead of its competitors like Tableau, QlikView & traditional Bi tools, and other competitors. know more at Power bi online training

You can connect to various data sources from different databases like SQL, Oracle, etc. using Power BI, build relationships using Data Modelling & transform the data in Power Query Editor before actually loading it to Power BI for visuals. DAX Formula and calculations help in data analysis, and they can create interactive reports & dashboards to share with the people.

2. What is visualization in Power BI?

Visualizations are used to represent our data in more than a tabular form. In Power BI, we have the design space where all the elements of a report, different visuals, slicers/filters, etc. These elements, when put into the design space, are called tiles. All the visuals that are available in Power BI are put under the Visualization Pane. It includes basic visuals such as bar, pie, line, column, and map with their varieties. Along with them, we do not have very common visuals like waterfalls, funnels, gauges, etc. We have a lot of custom visuals available as well. They can be imported into the report from App Marketplace. And then we can bring them into our design view.

If one knows R or Python, then we also have the option to create visuals using code. 

3. What is the calculated column in Power BI?

Calculated columns are built to extend the data attributes. They are those columns that are created when the available columns in the data do not serve our purpose or we are not able to generate any useful insight from the same. That is when calculated columns come into the picture. And these are created using different DAX functions as per need. We can have a simple example of a date where we do not want to work with the complete date but individual day, month, or year. For this, in the data part of the Power BI desktop, we have the option of a ‘New Column.’ When we click that, we get a formula bar on top (like excel), where it asks us to type the new column name with its calculation. So, if we consider the data example, it will be something like this: yearcol = YEAR([Date column]) where YEAR is a DAX function. And ‘yearcol’ is your calculated column.

4. What is legend in Power BI?

Legends are part of Power BI visuals. They represent categories in a visual and are usually color-coded. In some visuals, we can add a category dimension as legend explicitly. One example can be in stacked bar/column charts, and the stacks represent different categories, and these categories are color-coded. These categories are represented in the legend. And every visual where the legend is applicable has a separate formatting section where we can specify its font and font size, or whether we need it to be visible or not, or even its position(top, bottom, left, right) know more at Power bi training

5. What is drill down in Power BI?

Drill down, as the name suggests, is going downwards. And in Power BI, it is going down a hierarchical category or dimension. Basically, when we have data attributes like a date where we have a default hierarchy of year->quarter->month->day, then when using the same field in a visual, in Power  BI, it by default takes the hierarchy form of the field. This gives the option of a drill-down feature denoted by up and down arrows. Also, we can right-click on the element in visual and get the option of drill-down.

6. How to calculate average in Power BI?

Average can be calculated in two ways- 

one is when we add a measure to a visual; by default, it summarizes any measure. When we click on the drop-down for the measure- we can change from Sum to Average. This gives us an average.

The second one is creating a calculated measure for average using the AVERAGE() DAX function.

7. How to update Power BI desktop?

Power BI is a very active community. And in terms of features Power BI team is open to feedback for its new features and new features to be added, if any. And Power BI keeps improving by adding new features in terms of visualizations, data connectors, etc., monthly. And when the updates are available in the new version, there are multiple ways to update the desktop to get the new features.

8. What is Power BI Cloud?

Power BI Cloud is a Cloud-Based Data Visualization set-up which gives access to its users for editing, viewing, creating and sharing the dashboards’ reports & datasets across organizations and a group of people by protecting the Admin Rights & Credentials. Access is required to view & edit these reports & dashboards.

9. How to change Power Bi Password?

It is a very easy & quick process to change your Power BI Service Password. Follow the given link & the process explained know more at Power bi online course

10. How to Connect to Oracle Databases in Power BI?

To connect to Oracle Databases from a server, you need to open the Power BI desktop in your Machine & click on the get data, under the Home Tab in Ribbon. Once you do so, you will get a list of Files/ Databases & other Sources. To connect to the Oracle databases, click on database & then select Oracle database & click on connect.

11. What is Power BI in Office-365?

Power BI is a cloud-based business analytics tool & Intelligence tool that allows its users to connect to, analyze & visualize data with a faster speed. It Basically connects its users to a broad range of live data through its dashboards & interactive reports and delivers insights & visualizations that help organizations make better decisions.

12. What are the components of Power BI?

There are 6 main components of Power BI:

Power Query, Power Pivot, Power View, Power Map, Power Bi Desktop, Power Q & A.

Let’s discuss one by one in detail: 

13. Explain DAX

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

14. SUM() vs SUMX(): What is the difference between the two DAX functions?

The sum function (Sum()) takes the data columns and aggregates them totally but the SumX function (SumX()) lets you filter the data which you are adding.
SUMX(Table, Expression), where the table contains the rows for calculation. Expression is a calculation that will be evaluated on each row of the table. know more at Power bi online training in Hyderabad

15. List the benefits of using variables in DAX.

  • Improve performance
  • Improve readability
  • Reduce complexity
  • Simplify debugging

16. What is the Power Map?

Power BI is a business intelligence and Analytics tool for non-technical and technical users to manage, analyze, visualize and share data with others. One of its key features is visualization - that is, present data and insights using appealing visuals. Among the visuals available in power BI  are maps. 

17. How to create and use Maps in Power BI?

There are 4 types of core or built-in map visuals:

  • Map (Basic)
  • Filled Map
  • Shape Map
  • ArcGIS Maps

18. Explain the filled map in Power BI?

Power BI utilizes two built-in map charts map and a filled map. A filled map shows data points with geospatial areas rather than points on a map. Areas can be continent, country, state, city. Working with a filled map, however, is not as easy and convenient as the map chart is 

19. What data sources can you connect to Power BI?

The Power BI data sources are extensive, which are divided as follows:

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

Content Packs: It refers to the collection of related files or documents that are stored as a group. There are two types of content packs in Power BI: those from service providers including Google Analytics, Salesforce, or Marketo, and those created and shared by other users in the organization.

Connectors: To connect databases and other datasets, including Database, Azure SQL, and SQL Server Analysis Services tabular data, etc. know more at Power bi training course

20. Explain about Power BI Desktop

Power BI Desktop is a free desktop application that can be installed on your computer. It cohesively works with the Power BI service by providing advanced data modeling, shaping, exploration, and creating reports with highly interactive visualizations. It enables users to save the work to a file or publish their reports and data right to your Power BI site to share with others. 

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