POWER BI
Questions & Answers
Q1. What are the components of Power BI?
Ans. There are five different components of Power BI.
Power Pivot: Fetches and cleans data and loads on to Power Query
Power Query: Operates on the loaded data
Power Q&A: Makes it possible for users to interact with reports
using simple English language
Power View: This lets users create interactive charts, graphs, maps,
and other visuals
Power Map: Enables the processing of accurate geographic
locations in datasets
Q2. How Power BI is different from Tableau?
Ans. Below are some of the major differences between Power BI and
Tableau:
Pricing:
Power BI is generally less expensive than Tableau, especially for larger
teams.
Ease of use:
Power BI is generally easier to use, especially for those who are
already familiar with Microsoft products. Tableau has a more robust
feature set.
, Data sources:
Both Power BI and Tableau can connect to a wide range of data
sources, including databases, Excel files, and web-based data.
However, Tableau has more advanced features for connecting to and
preparing data.
Visualizations:
Both Power BI and Tableau offer a wide range of visualization options.
However, some users feel that Tableau offers more flexibility and
customization options, while others prefer the simplicity of Power BI's
visuals.
Q3. How is Power BI different from other BI tools?
Ans. Power BI provides better features and data manipulation tools as
compared to other BI tools like Tableau. A single user can connect
with multiple data sources without any experience in coding and data
analytics. As a product of Microsoft, Power BI is closely integrated
with other Microsoft tools such as Office 365, SharePoint, and Bing.
In the free version of Power BI Desktop, the user can analyze datasets
of up to 1GB in storage along with 10,000 rows of data steaming every
hour. Moreover, it provides features like Power Query which allows the
user to easily visualize the datasets by giving the command in the
natural English language.
Q4. What is Dax Function?
Ans. 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.
Data types of Dax are:
1) Numeric, 2) Boolean, 3) Date Time, 4) String, and 5) Decimal.
Q5. What are the types of filters available in Power BI Reports?
, Ans. Important filters of Power BI reports are:
Visual-level Filters
Page-level Filters
Report-level Filters
Q6.Differentiate between Power BI and Excel.
Ans. The key differences are:
Tabular reports-
Power BI is not very good at handling tabular reports.
Excel is better at handling tabular reports.
Duplicate table-
Power BI can’t display duplicate tables.
Excel allows users to display duplicate tables.
Reports-
Power BI allows interactive, personalized reports.
Excel users cannot perform advanced cross-filtering between charts.
Analytics-
Power BI offers simple analytics.
Excel offers advanced analytics.
Applications-
Power BI is ideal for KPIs, alerts, and dashboards.
Excel has new charts now but they can’t connect to data model.
Q7. What is the CALCULATE function in DAX?
Ans. The CALCULATE function helps calculate the sum of an entire
Questions & Answers
Q1. What are the components of Power BI?
Ans. There are five different components of Power BI.
Power Pivot: Fetches and cleans data and loads on to Power Query
Power Query: Operates on the loaded data
Power Q&A: Makes it possible for users to interact with reports
using simple English language
Power View: This lets users create interactive charts, graphs, maps,
and other visuals
Power Map: Enables the processing of accurate geographic
locations in datasets
Q2. How Power BI is different from Tableau?
Ans. Below are some of the major differences between Power BI and
Tableau:
Pricing:
Power BI is generally less expensive than Tableau, especially for larger
teams.
Ease of use:
Power BI is generally easier to use, especially for those who are
already familiar with Microsoft products. Tableau has a more robust
feature set.
, Data sources:
Both Power BI and Tableau can connect to a wide range of data
sources, including databases, Excel files, and web-based data.
However, Tableau has more advanced features for connecting to and
preparing data.
Visualizations:
Both Power BI and Tableau offer a wide range of visualization options.
However, some users feel that Tableau offers more flexibility and
customization options, while others prefer the simplicity of Power BI's
visuals.
Q3. How is Power BI different from other BI tools?
Ans. Power BI provides better features and data manipulation tools as
compared to other BI tools like Tableau. A single user can connect
with multiple data sources without any experience in coding and data
analytics. As a product of Microsoft, Power BI is closely integrated
with other Microsoft tools such as Office 365, SharePoint, and Bing.
In the free version of Power BI Desktop, the user can analyze datasets
of up to 1GB in storage along with 10,000 rows of data steaming every
hour. Moreover, it provides features like Power Query which allows the
user to easily visualize the datasets by giving the command in the
natural English language.
Q4. What is Dax Function?
Ans. 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.
Data types of Dax are:
1) Numeric, 2) Boolean, 3) Date Time, 4) String, and 5) Decimal.
Q5. What are the types of filters available in Power BI Reports?
, Ans. Important filters of Power BI reports are:
Visual-level Filters
Page-level Filters
Report-level Filters
Q6.Differentiate between Power BI and Excel.
Ans. The key differences are:
Tabular reports-
Power BI is not very good at handling tabular reports.
Excel is better at handling tabular reports.
Duplicate table-
Power BI can’t display duplicate tables.
Excel allows users to display duplicate tables.
Reports-
Power BI allows interactive, personalized reports.
Excel users cannot perform advanced cross-filtering between charts.
Analytics-
Power BI offers simple analytics.
Excel offers advanced analytics.
Applications-
Power BI is ideal for KPIs, alerts, and dashboards.
Excel has new charts now but they can’t connect to data model.
Q7. What is the CALCULATE function in DAX?
Ans. The CALCULATE function helps calculate the sum of an entire
