Question

1. Explain the three different version of Power BI Desktop.

2. Explain the nine different areas of Power BI desktop user Interface.

3. What is DAX and what is DAX used for?

Answer 1

Q. 1. Explain the three different version of Power BI Desktop.

Ans.

• Power BI Desktop
  • Power BI Desktop is that the free version of Power BI that you can install on your local computer as a program and acts as a companion desktop application to the full version of Power BI. If you wish to consolidate your knowledge sources, produce your reports and conduct your analysis or check its capabilities, it’s the proper version to start outwith for all talent levels - whether or not you’re non-IT and need to form your reports a lot of interactive, or analysts seeking richer detail, it's one among the simplest business analytics tools to use.
• Power BI Pro
  • Power BI Pro is that the full version of Power BI, complete with the ability to use Power BI for each building dashboards and reports and unlimited viewing, sharing and consumption of your created reports (and reports shared by others) - the latter unacceptable with Power BI Desktop.
• Power BI Premium
  • Power BI Premium differs from the free version and Power BI Pro in its licensing model, that solely suits a particular size and sort of organisation and business state of affairs. You'll purchase Premium during a vary of capability size that supply completely different numbers of memory and virtual cores which will scale as your knowledge analysis needs amendment.

Q. 2. Explain the nine different areas of Power BI desktop user Interface.

Ans.

• Ribbon
  • On the top page is the ribbon which consists of various tabs. This is similar to what you would find in any Microsoft product.
• View Tab
  • It allows the users to adjust the view settings.
• Modelling Tab
  • It allows the users to manipulate the data before importing it to Power BI.
• Help Tab
  • It provides users with various training resources & helo related to Power BI.
• Data View
  • This presents the data in a tabular format.
• Fields Pane
  • The Fields Pane on the right side enables users to see each table that they have loaded.
• Format
  • Below data type, users can also see a setting called format which determines how the values are displayed in the charts created by them.
• Visualization Panes
  • These are used for data visualization.
• Page Controls
  • At the lowest of the report are the page controls. Here, the users will add new pages, delete existing ones, or rename pages by double-clicking on the title just as they'd for sheets in Microsoft Excel Sheets.

Q. 3. What is DAX and what is DAX used for?

Ans.

DAX is the abbreviation for Data Analysis Expressions which is a formula language. It is the native formula and command language for Power BI Desktop. We can use DAX to outline custom calculations for Calculated Columns and for Measures that are called calculated fields.  DAX includes a number of the functions used in Excel formulas, and extra functions designed to figure with relative information and perform dynamic aggregation.

"I sincerely request you to please give me an Up-Vote! Thank you so much in advance."