# data[].attributes.body
What is an aggregation?

An aggregation is the act of summarizing data with a mathematical function, such as averaging the values in a column, or counting the number of rows in a table. The resulting number is often called a metric

# data[].attributes.body
What is an attribute?

An attribute is a property that describes or identifies some entity.

# data[].attributes.body
What is an analytical database?

An analytical database is a database optimized for a few large analysis operations rather than many small transactions. OLAP usually relies on analytical databases.

# data[].attributes.body
What is a BI tool?

A BI tool is an app designed for people to look at data without relying on code. These apps allow people to visualize and share data as tables, charts, and dashboards.

# data[].attributes.body
What is a card?

A card is a component of a dashboard that displays data or text.

# data[].attributes.body
What is a custom column?

Sometimes called a “calculated” column. You can use a custom expression to add columns to the results of your query. For example, adding a column that calculates the difference between the total and subtotal.

# data[].attributes.body
A drill-through action allows a user to navigate from a dashboard or report to another report to see greater detail. The typical drill-through experience allows the user to see more details within the context of the item they selected.

A well-designed drill-through dashboard solution keeps the initial dashboard simple and high-performing, allowing users to navigate to different reports in different subject areas and levels of detail.

# data[].attributes.body
Also referred to as Desktop. The free Windows application of Power BI you can install on your local computer that lets you connect to, transform, and visualize your data. Used by report designers and admins. For more information, see What is Power BI.

# data[].attributes.body
A product used by developers to embed Power BI dashboards and reports into their own apps, sites, and tools.

# data[].attributes.body
An add-on to the Power BI Pro license that enables organizations to predictably scale BI solutions through the purchasing of reserved hardware in the Microsoft cloud. See account and license.

# data[].attributes.body
A monthly per-user license that provides the ability to build reports and dashboards, collaborate on shared data, keep data up-to date automatically, audit and govern how data is accessed and used, and the ability to package content to distribute (Power BI apps). See account and license.

# data[].attributes.body
It is a free, standalone Windows Desktop application used for authoring paginated reports. Used by report designers. For more information see Power BI Report Builder. Power BI Report Builder can be downloaded from the Power BI site.

# data[].attributes.body
An on-premises report server with a web portal in which you display and manage reports and KPIs. It allows organizations to build distributed, hybrid BI systems (a mix of cloud and on-premises deployments).

# data[].attributes.body
An online SaaS (software as a service). For more information, see What is Power BI.

# data[].attributes.body
A workspace running in a capacity, signified to customers by a diamond icon.

# data[].attributes.body
Power BI service report designers bundle the contents of a Power BI workspace to make it available to others as a Power BI app. Power BI Desktop report designers use publish to refer to sending a Power BI Desktop report in pbix format to the Power BI service so that they can build dashboards from it and easily share it with others.

# data[].attributes.body
A drill-down action allows the user to view more details without leaving the dashboard. This is often done by expanding the levels of a hierarchy or double-clicking on a level to show members of the next level in the hierarchy. The key to enabling drill-down reporting is to understand hierarchal structures in the data and design them into a data model which is used to serve data to the dashboard.

# data[].attributes.body
A data mart is a relational database created specifically to store analytic data that will be processed into a semantic model for reporting. There are different philosophies and approaches in the industry for preparing data for analysis but the essential concepts are the same. A data mart may either be a component of, or an alternative to, a larger data warehouse. Commonly referred to (in general terms) as “star schema” or “dimensional model”, a data mart holds a copy of data intended for reporting. In many modern Business Intelligence solutions, data moves through three (or more) different storage layers: operational database systems, data mart and the semantic model.

* Prior to the proliferation of semantic modeling technologies like SQL Server Analysis Services, dashboard-like reports often queries the relational data mart or data warehouse directly. However, modern tools like Power View and Excel are optimized to query cubes and tabular models. Therefor the term “model” now refers to a semantic model or cube and the term data mart refers to a relational database.