Interview Questions

Demo Video Course Content Interview Questions

                       

1.What is Microsoft Power BI?

Power BI  is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life.

2.What’s the difference between Power BI and Power BI Pro?

Power BI provides all sorts of features to help you get started exploring data in a whole new way. Power BI Pro provides all of the same great features in Power BI, plus additional features like more storage capacity, scheduling data refresh more frequent than daily, live data sources with full interactivity, groups, and more. Learn more about the differences between Power BI Pro and the free Power BI.

3.How much does Power BI cost?

Power BI and Power BI Desktop are free. There is a 60-day free trial available for Power BI Pro. After that, Power BI Pro is $9.99/User/Month. Learn more about our pricing Power BI pricing.

4.What is Power BI Desktop?

Power BI Desktop is a free desktop application you can install right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and report creation with highly interactive visualizations. You can save your work to a file, and publish your data and reports right to your Power BI site to share with others.

5.What do I need to use Power BI?

Just a Web browser and work email address.

Note: Work email addresses ending in .gov and .mil aren’t currently supported.

6.What is DAX ?

To do basic calculation and data analysis on data in power pivot we use Data Analysis Expression (DAX).It is formula language to compute calculated column and calculated field.

  • Dax works on column values
  • Dax can not modify or insert data
  • We can calculate calculated column and measures but we can not calculate rows using daxSample DAX formula syntax:

For the measure named Total Sales, calculate (=) the SUM of values in the [SalesAmount ] column in the Sales table.

  • Measure Name

B- equal sign – indicate beginning of formula

C- DAX Function

D- Parenthesis for Sum Function

E- Referenced Table

F- Referenced column name

7.Why do I have to sign up with my work email?

Power BI does not support email addresses provided by consumer email services or telecommunications providers. Learn more about the Power BI self-service sign-up process.

8.Which work email addresses are supported?

Work email addresses ending in .edu and .org are supported.

Those ending in .gov and .mil aren’t currently supported.

9.Is government, academic and non-profit pricing available for Power BI?

Yes, non-profit pricing is available when purchasing directly from Microsoft. You can learn more and sign up through the Microsoft Product Donation site. Government and academic pricing is offered through

the MOSP/Direct, EA, and Open licensing programs. Government pricing is also available in syndication. Power BI is not yet available for the US Government Community Cloud (GCC).

10.What is xVelocity in-memory analytics engine used in power pivot?

The main engine behind power pivot is the xVelocity in-memory analytics engine. It can handle large amount of data because it stores data in columnar databases and in memory analytics which results in faster processing of data as it loads all data to RAM memory. For best result use 64 bit operating system as 64 bit can load more data to RAM.

11.Is Power BI available on-premises?

No, Power BI is not available as a private, internal cloud service. However, with Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services server, and other data sources. You can also scheduled refresh with a centralized gateway. If a gateway is not available, you can refresh data from on-premises data sources using the Power BI Gateway – Personal.

You can also view on-premises SQL Server mobile reports with the Power BI iOS apps:

  • SQL Server mobile reports on the iPhone.
  • SQL Server mobile reports on the iPad

12.Does Power BI support mobile devices?

Yes. Power BI has native apps for Android phones, iOS devices, and Windows 10 devices. Download one of the Power BI mobile apps from its respective store:

  • Apple App Store
  • Google Play
  • Windows Store

13.What data sources can I connect to?

The list of data sources for Power BI is extensive, but it can be grouped into the following:

  • Data from Excel and Power BI Desktop files.
  • Content packs for services, with ready-made dashboards, reports, and datasets for services such as Salesforce. In addition to establishing a data connection, Power BI provides pre-built dashboards and reports for each of these services.
  • Connectors to databases and other datasets such as Azure SQL Databaseand SQL Server Analysis Services tabular data

14.What are content packs?

Content packs for services are pre-built solutions for popular services as part of the Power BI experience. A subscriber to a supported service can quickly connect to their account from Power BI and see their data through live dashboards and interactive reports that have been pre-built for them.  We’ve released content packs for popular services such as Salesforce.com, Marketo, Adobe Analytics, Azure Mobile Engagement, CircuitID, comScore Digital Analytix, Quickbooks Online, SQL Sentry, and tyGraph. Over the coming months, we’ll extend this to include content packs and integrations for Sage, SpaceCurve, Sumo Logic, Zuora, Planview, Insightly, Troux, Inkling, and others.

Organizational content packs provide users, BI professionals, and system integrators the tools to build their own content packs to share purpose-built dashboards, reports, and datasets within their organization.

15.What are the different Excel BI add ins?

  • Power Query—find, edit and load external data
  • PowerPivot—for data modeling for analysis
  • Power View—design visually and interactively reports
  • Power Map—display insights on 3D Map

16.What do I need to install in order to use Power BI?

To use the Power BI service for free, you just need a Web browser and email.

To explore data and create reports in Power BI Desktop, download Power BI Desktop for free.

You can download the Power BI mobile apps from their respective stores:

  • App Store
  • Google Play
  • Windows Store

17.Power BI Desktop’s Software License Terms say “You may install and use one copy of the software on your premises.” Does this mean I am limited to one copy of Power BI Desktop for the entire company?

Power BI Desktop’s use rights do not limit you to one copy of Power BI Desktop for the entire company. Each individual user at the company may install and use one copy on their premises.

18.Where do I get started with Power BI?

The following resources are available to help get your started:

  • Power BI Blog
  • Webinars
  • Getting started videos on our YouTube Channel
  • Get started with Power BI article
  • Join our community and ask questions

19.How can I buy Power BI Pro in my country?

You can purchase Power BI Pro licenses directly or chat with a representative at www.powerbi.com.

You can also find a Microsoft Partner to help you with your Power BI implementation.

20.Does Power BI meet national, regional, and industry-specific compliance requirements?

Learn more about Power BI compliance, at the Microsoft Trust Center.

Bonus Question

21.What has happened to the Power BI for Office 365 experience?

The Power BI for Office 365 experience has been deprecated.

Our design of course tutorials and interview questions is practical and informative. At TekSlate, we offer resources to help you learn various IT courses. We avail both written material and demo video tutorials. For in-depth knowledge and practical experience explore Online Power BI Training.

22.Explain various parts of Microsoft self-service BI solution.

There are two main parts of Microsoft self-service Business Intelligence solution. They are:

  1. Excel BI Toolkit
  2. Power BI
  3. Define Microsoft Power BI

23.Define Excel BI Toolkit

Allowing users to create interactive report by means of importing data from a wide range of sources and model data acc to requirement.

  1. Define Power BI.

A cloud-based data sharing environment, Power BI allows anyone to analyze and visualize data with greater efficiency, speed and understanding. Besides, it helps in connecting users to a wide range of data with the help of easy-to-operate dashboards, compelling visualizations, and interactive reports bringing data to life.

  1. Differentiate between Power BI and Power BI Pro.

Power BI offers various kinds of features to help you get started searching data in a complete new way.  On the other hand, Power BI Pro caters with some additional features like scheduling data refresh more often than on daily basis, more storage capacity, live data sources along with complete interactivity, and much more.

  1. What is the cost for Power BI?

Both Power BI Desktop and Power BI are free of cost. While for Power BI Pro, a user is required to pay $9.99 per month after completing 60-day free trial.

  1. What the term Power BI Desktop means?

Can be installed on your computer, Power BI Desktop is a free app that works in cohesion with the Power BI service by offering advanced data exploration, modelling, shaping, and report creation with the use of highly interactive visualizations. Moreover, it allows you to save your all work to a file for publishing your reports and data to Power BI site for sharing with others.

  1. What are the basics needed for using Power BI?

To use Power BI, all you need is a web browser and a work email address.

Please be informed that work email addresses finishing in .mil and .gov are currently not supported.

  1. What is the need of signing up with work email?

Power BI is not supporting email addresses given by telecommunications providers and consumer email services, thus there is a need of signing up with work email.

  1. Name the work email addresses that are currently supported.

Work email addresses that are finishing with .org and .edu are currently supported.

  1. Which pricing is available for Power BI from academic, government and non-profit?

Non-profit pricing is currently available for Power BI only when availing it directly from Microsoft. While Academic and Government pricing for Power BI is provided via the EA, MSOP/Direct and Open licensing programs. Besides, government pricing can also be availed in syndication.

  1. Is there are support available for mobile devices by Power BI?

Yes, Power BI supports mobile devices. It has some native apps for iOS devices, Android smartphones, and Windows 10 devices. You can download and install Power BI mobile apps from the following app stores:

  1. Google Play
  2. Apple App Store
  3. Windows Store

33.What data sources can be connected to for Power BI?

There is a wide list of data sources you can connect to for Power BI. They are groups as mentioned below:

  1. Connectors to databases and some other datasets like Azure SQL
  2. Data from Power BI Desktop files and Excel
  3. Content packs for reports, services, and datasets. Moreover, along with establishing a data connection, Power BI offers pre-built reports and dashboards for each of these services.

34. Define content packs.

These are pre-built solutions used for popular services as a major part of the Power BI experience.

various Excel BI add Ins.

Power Query to find, edit and load external data

Power View for designing interactive and visual reports

PowerPivot to analyse data modeling

Power Map for displaying insights in 3D Map

35.What must be installed to use Power BI?

For using the service of Power BI for free, one just need a web browser and work email. With this, you can explore data as well as create reports in Power Bi Desktop. To get Power BI mobile apps, you can head to their respective stores:

Google Pay, App Store and Windows Store

36). What is Power BI Q&A?

Power BI Q&A is a natural language tool which helps in querying your data and get the results you need from it. You do this by typing into a dialog box on your Dashboard, which the engine instantaneously generates an answer similar to Power View. Q&A interprets your questions and shows you a restated query of what it is looking from your data. Q&A was developed by Server and Tools, Microsoft Research and the Bing teams to give you a complete feeling of truly exploring your data.

37). What are some ways that Excel experience can be leveraged with Power BI?

Below are some of the ways through which we can leverage Power BI:

  • The Power BI Publisher for Excel:
  • Can be used to pin Excel items (charts, ranges, pivot tables) to Power BI Service.
  • Can be used to connect to datasets and reports stored in Power BI Service.
  • Excel workbooks can be uploaded to Power BI and viewed in the browser like Excel Services.
  • Excel reports in the Power BI service can be shared via Content Packs like other reports.
  • Excel workbooks (model and tables) can be exported to service for PBI report creation.
  • Excel workbook Power Pivot models can be imported to Power BI Desktop models.

38). What is a calculated column in Power BI and why would you use them?

Calculated Columns are DAX expressions that are computed during the model’s processing/refresh process for each row of the given column and can be used like any other column in the model.

Calculated columns are not compressed and thus consume more memory and result in reduced query performance. They can also reduce processing/refresh performance if applied on large fact tables and can make a model more difficult to maintain/support given that the calculated column is not present in the source system.

39). How is data security implemented in Power BI ?

Power BI can apply Row Level Security roles to models.

  • A DAX expression is applied on a table filtering its rows at query time.
  • Dynamic security involves the use of USERNAME functions in security role definitions.
  • Typically a table is created in the model that relates users to specific dimensions and a role.

40). What are many-to-many relationships and how can they be addressed in Power BI ?

Many to Many relationships involve a bridge or junction table reflecting the combinations of two dimensions (e.g. doctors and patients). Either all possible combinations or those combinations that have occurred.

  • Bi-Directional Crossfiltering relationships can be used in PBIX.
  • CROSSFILTER function can be used in Power Pivot for Excel.
  • DAX can be used per metric to check and optionally modify the filter context.

41). Why might you have a table in the model without any relationships to other tables?

There are mainly 2 reasons why we would have tables without relations in our model:

  • A disconnected table might be used to present the user with parameter values to be exposed and selected in slicers (e.g. growth assumption.)
  • DAX metrics could retrieve this selection and use it with other calculations/metrics.
  • A disconnected table may also be used as a placeholder for metrics in the user interface.
  • It may not contain any rows of data and its columns could be hidden but all metrics are visible.

42). What is the Power BI Publisher for Excel?

You can use Power BI publisher for Excel to pin ranges, pivot tables and charts to Power BI.

  • The user can manage the tiles – refresh them, remove them, in Excel.
  • Pinned items must be removed from the dashboard in the service (removing in Excel only deletes the connection).
  • The Power BI Publisher for Excel can also be used to connect from Excel to datasets that are hosted in the Power BI Service.
  • An Excel pivot table is generated with a connection (ODC file) to the data in Azure.

The Publisher installs all necessary drivers on local machine to establish connectivity .

43). What are the differences between a Power BI Dataset, a Report, and a Dashboard?

Dataset: The source used to create reports and visuals/tiles.

  • A data model (local to PBIX or XLSX) or model in an Analysis Services Server
  • Data could be inside of model (imported) or a Direct Query connection to a source.

Report: An individual Power BI Desktop file (PBIX) containing one or more report pages.

  • Built for deep, interactive analysis experience for a given dataset (filters, formatting).
  • Each Report is connected to atleast one dataset
  • Each page containing one or more visuals or tiles.

Dashboard: a collection of visuals or tiles from different reports and, optionally, a pinned.

  • Built to aggregate primary visuals and metrics from multiple datasets.

44) What are the three Edit Interactions options of a visual tile in Power BI Desktop?

 The 3 edit interaction options are Filter, Highlight, and None.

Filter: It completely filter a visual/tile based on the filter selection of another visual/tile.

Highlight: It highlight only the related elements on the visual/tile, gray out the non-related items.

None: It ignore the filter selection from another tile/visual.

45). What are some of the differences in report authoring capabilities between using a live or direct query connection such as to an Analysis Services model, relative to working with a data model local to the Power BI Desktop file?

With a data model local to the PBIX file (or Power Pivot workbook), the author has full control over the queries, the modeling/relationships, the metadata and the metrics.

With a live connection to an Analysis Services database (cube) the user cannot create new metrics, import new data, change the formatting of the metrics, etc – the user can only use the visualization, analytics, and formatting available on the report canvas.

With a direct query model in Power BI to SQL Server, for example, the author has access to the same features (and limitations) available to SSAS Direct Query mode.

  • Only one data source (one database on one server) may be used, certain DAX functions are not optimized, and the user cannot use Query Editor functions that cannot be translated into SQL stat

46). How does SSRS integrate with Power BI?

 Below are some of the way through which SSRS can be integrated with Power BI:

  • Certain SSRS Report items such as charts can be pinned to Power BI dashboards.
  • Clicking the tile in Power BI dashboards will bring the user to the SSRS report.
  • A subscription is created to keep the dashboard tile refreshed.
  • Power BI reports will soon be able to be published to SSRS portal

47).What is Power View?

Power View is a data visualization technology that lets you create interactive charts, graphs, maps, and other visuals which bring your data to life. Power View is available in Excel, SharePoint, SQL Server, and Power BI.

The following pages provide details about different visualizations available in Power View:

  • Charts
  • Line charts
  • Pie charts
  • Maps
  • Tiles
  • Cards
  • Images
  • Tables
  • Power View
  • Multiples Visualizations
  • Bubble and scatter charts
  • Key performance indicators (KPIs)

48). What is data management gateway and Power BI personal gateway?

Gateway acts a bridge between on-premises data sources and Azure cloud services.

Personal Gateway:

  • Import Only, Power BI Service Only, No central monitoring/managing.
  • Can only be used by one person (personal); can’t allow others to use this gateway.

On-Premises Gateway:

  • Import and Direct Query supported.
  • Multiple users of the gateway for developing content.
  • Central monitoring and control.

49). What is Power BI Q&A?

Power BI Q&A is a natural language tool which helps in querying your data and get the results you need from it. You do this by typing into a dialog box on your Dashboard, which the engine instantaneously generates an answer similar to Power View. Q&A interprets your questions and shows you a restated query of what it is looking from your data. Q&A was developed by Server and Tools, Microsoft Research and the Bing teams to give you  a complete feeling of truly exploring your data.

50). What are some ways that Excel  experience can be leveraged with Power BI?

Below are some of the ways through which we can leverage Power BI:

 

  • The Power BI Publisher for Excel:

Can be used to pin Excel items (charts, ranges, pivot tables) to Power BI Service.

               Can be used to connect to datasets and reports stored in Power BI Service.

  • Excel workbooks can be uploaded to Power BI and viewed in the browser like Excel Services.
  • Excel reports in the Power BI service can be shared via Content Packs like other reports.
  • Excel workbooks (model and tables) can be exported to service for PBI report creation.
  • Excel workbook Power Pivot models can be imported to Power BI Desktop models.

51). What is a calculated column in Power BI and why would you use them?

Calculated Columns are DAX expressions that are computed during the model’s processing/refresh process for each row of the given column and can be used like any other column in the model.

Calculated columns are not compressed and thus consume more memory and result in reduced query performance. They can also reduce processing/refresh performance if applied on large fact tables and can make a model more difficult to maintain/support given

that the calculated column is not present in the source system.

52). How is data security implemented in Power BI ?

Power BI can apply Row Level Security roles to models.

  • A DAX expression is applied on a table filtering its rows at query time.
  • Dynamic security involves the use of USERNAME functions in security role definitions.
  • Typically a table is created in the model that relates users to specific dimensions and a role.

53). What are many-to-many relationships and how can they be addressed in Power BI ?

Many to Many relationships involve a bridge or junction table reflecting the combinations of two dimensions (e.g. doctors and patients). Either all possible combinations or those combinations that have occurred.

  • Bi-Directional Crossfiltering relationships can be used in PBIX.
  • CROSSFILTER function can be used in Power Pivot for Excel.
  • DAX can be used per metric to check and optionally modify the filter context.

54). Why might you have a table in the model without any relationships to other tables?

There are mainly 2 reasons why we would have tables without relations in our model:

  • A disconnected table might be used to present the user with parameter values to be exposed and selected in slicers (e.g. growth assumption.)

DAX metrics could retrieve this selection and use it with other calculations/metrics.

  • A disconnected table may also be used as a placeholder for metrics in the user interface.

It may not contain any rows of data and its columns could be hidden but all metrics are visible.

55). What is the Power BI Publisher for Excel?

 You can use Power BI publisher for Excel to pin ranges, pivot tables and charts to Power BI.

  • The user can manage the tiles – refresh them, remove them, in Excel.
  • Pinned items must be removed from the dashboard in the service (removing in Excel only deletes the connection).
  • The Power BI Publisher for Excel can also be used to connect from Excel to datasets that are hosted in the Power BI Service.
  • An Excel pivot table is generated with a connection (ODC file) to the data in Azure.

The Publisher installs all necessary drivers on local machine to establish connectivity.