POWER BI INTERVIEW QUESTIONS
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.
Whats 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.
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.
What is Power BI Q&A?
It is a natural language data quering where we can directly plot charge by simpl typing Questions on data set like: Total sales by year and area It is available only when reports are published to cloud(power bi.com or sharepoint). .
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 dax
Sample DAX formula syntax:
For the measure named Total Sales, calculate (=) the SUM of values in the [SalesAmount ] column in the Sales table.
A- Measure Name
B- equal sign indicate beginning of formula
C- DAX Function
D- Parenthesis for Sum Function
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.
What is power query?
Power query is a ETL Tool use to shape,clean and transform data using intuitive interfaces without having to use code.
. Import data from wide range of source from files to databases,big data to social media.
. Join and append data from multiple data sources
. shape data as per requirement by removing and adding data.
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:
i) Data from Excel and Power BI Desktop files.
ii) 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.
iii) Connectors to databases and other datasets such as Azure SQL Databaseand SQL Server Analysis Services tabular data.
What are the different Excel BI add ins?
An effective PPC keyword should be
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
What is Power BI Designer?
It is a stand alone application where we can make Power BI reports and than upload it to power bi.com, it does not requires excel.
How many types of filters are there in Power BI Reports?
Visual level filters i) These filters work on only an individual visualization, reducing the amount of data that the visualization can see. Moreover, visual-level filters can filter both data and calculations.
Page level filters
i) These filters work at the report-page level. Different pages in the same report can have different page-level filters.
Report level filters
i) There filters work on the entire report, filtering all pages and visualizations included in the report.
Can we have more than one active relationship between two tables in the data model?
- No we cannot have more than one active relationship between two tables in the data model
What is Power pivot data model?
Data model in Power pivot is made up of tables,columns,datatypes,and table relations. Tippically data tables are constructed to hold data for a Business entity.
Does Power BI support mobile devices?
- Yes. Power BI has native apps for Android phones and tablets, 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
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.
How mHow do I find out who in my organization is eligible for the Extended Pro Trial?
While there is not a direct way to discover this, you can view the Azure Active Directory Integrated Applications report for Power BI to see who are active users within your organization. Those active users in the eligibility period, and who are on free licenses, will receive the pop-up notification. For more information, see Find Power BI users that have signed in.
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.
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).
What is the relationship between MapReduce and Hive? or How Mapreduce jobs submits on the cluster?
Hive provides no additional capabilities to MapReduce. The programs are executed as MapReduce jobs via the interpreter. The Interpreter runs on a client machine which rurns HiveQL queries into MapReduce jobs. Framework submits those jobs onto the cluster.
Is Power BI available on-premises?
No, the Power BI service 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 iPad and iPhone.
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 have released content packs for popular services such as Salesforce.com, Marketo, and Adobe Analytics. Read more about connecting to services with content packs.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.
Where do I get started with Power BI?
The following resources are available to help get your started:
. Power BI Blog
. Getting started videos on our YouTube Channel
. Get started with Power BI article
. Join our community and ask questions
What browsers does Power BI support?
Internet Explorer 11
Chrome desktop latest version
Safari Mac latest version
Firefox desktop latest version
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.
What has happened to the Power BI for Office 365 experience?
The Power BI for Office 365 experience has been deprecated.
How do I undo in Power BI?
Like many other Microsoft services and software, Power BI provides an easy way to undo your last command.
To undo your last action, or last few actions, press CTRL+Z.
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 arent currently supported.
Are users who signed up after May 3, 2017 eligible for the Extended Pro Trial?
- Users who signed up to Power BI (free) on or after May 3, 2017 are not eligible for the Extended Pro Trial. However, they are eligible for the standard 60-day Pro Trial.
Power BI Desktops 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 Desktops 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.
Can we refresh our Power BI reports once uploaded to cloud(share point or power bi.com) ?
Yes we can refresh our reports through a data management gateway(or sharepoint)and Power Bi personal gateway (for power bi.com)
For which platform Power BI is available ?
1. Android Mobile
2. iphone and ipad
3. Windows desktop and Windows tablates
4. Windows phones comingsoon
What isthe differance between microsoft business intelligence tool-power BI desktop and Power BI?
- Power BI Desktop is a Windows application (Clinet) running on the local computer. It is more a of client machine which can connect with variety of data sources from your computer to the data in the local computer or the data in the server. Power BI Power BI is a cloud solution. We can use web browser to connect with Power BI. We can perform the same development work using either Power BI OR Power BI Desktop.
What are the components of Power BI?