Power BI Terminology
Understand the important Power BI words and concepts used throughout this course, with simple definitions, practical examples, and visual explanations for beginners.
1. Why Is Power BI Terminology Important?
Before learning Power Query, data modeling, DAX, and visualizations, you should understand the basic terms used in Power BI. These terms help you follow lessons, understand instructions, and work confidently with reports.
At CIIT TRANING INSTITUTE, learners can use the examples in this lesson to understand how common Power BI concepts work together in a practical business reporting scenario.
Example: A Sales Report
Samadhan receives an Excel file containing product sales. Pradnya helps check the data, Samiksha prepares a report layout, Neha checks the totals, Omkar reviews the results, and Nesha explores the report using filters.
This example introduces several terms you will learn: data source, Power Query, data model, measure, visual, report, filter, and dashboard.
2. Data Source, Dataset, and Semantic Model
Data Source
A data source is the original location from which Power BI obtains information. Examples include Excel workbooks, CSV files, databases, and supported online sources.
Dataset and Semantic Model
In Power BI, the term semantic model refers to the organized data, relationships, measures, and metadata used for reporting. Older Power BI learning materials often use the term dataset for this concept.
A source file and a semantic model are not the same thing. A source file contains the original data, while the semantic model organizes data for analysis.
Example
Samadhan stores sales records in SalesData.xlsx. The Excel workbook is the data source. After loading and preparing the relevant tables in Power BI, those tables can form part of a semantic model.
3. How Data Becomes a Report
The following illustration shows how source data moves through preparation and modeling before being displayed in a report.
Visual 1: The relationship between the source, transformation, model, and report.
4. Power Query and Data Transformation
Power Query is the data connection and transformation technology used in Power BI Desktop. It helps you prepare source data before loading it into the model.
| Term | Meaning | Example |
|---|---|---|
| Query | A set of instructions used to retrieve and transform data. | Load and prepare a sales table. |
| Data Type | Defines the kind of value stored in a column. | Date, text, whole number, or decimal number. |
| Applied Steps | The recorded transformation operations in a query. | Remove columns, change types, filter rows. |
| Merge Queries | Combines columns from related tables using matching values. | Bring product names into a sales query. |
| Append Queries | Combines rows from tables with compatible column structures. | Combine January and February sales. |
5. Rows, Columns, Tables, and Relationships
Row
A row is one record in a table. In a sales table, a row might represent a single order or transaction.
Column
A column represents a field or attribute, such as Product, Region, OrderDate, Quantity, or SalesAmount.
Table
A table organizes information into rows and columns. Power BI models commonly contain fact tables and dimension tables.
Relationship
A relationship connects tables through related columns. For example, a Sales table and a Product table may both contain ProductID.
6. Understanding a Table and Its Relationship
Visual 2: An example of a relationship between two tables.
7. Measures, Calculated Columns, and DAX
DAX
DAX stands for Data Analysis Expressions. It is a formula language used for calculations in Power BI models.
Measure
A measure calculates a result based on the current filter context. Measures are commonly used for totals, averages, percentages, and business performance indicators.
Calculated Column
A calculated column creates a value for each row using a DAX expression. It can be useful when you need a calculated field for grouping, filtering, or relationships where appropriate.
Example DAX Measure
Suppose the sales table contains a column named
SalesAmount. You can create a measure
to calculate the total sales.
Total Sales =
SUM ( Sales[SalesAmount] )
This measure adds the values in the SalesAmount column. Its displayed result can change when report filters or slicers change the current filter context.
8. How Measures Work with Filters
A measure does not always show one fixed result. Its result can change according to the filters applied to a report or visual.
Visual 3: The same measure can display different results for different regions.
9. Visualizations, Reports, and Dashboards
Visualization
A visualization, often called a visual, displays data graphically or in a structured format. Examples include bar charts, line charts, cards, tables, matrices, and maps.
Report
A report is an interactive collection of report pages containing visuals, filters, and other supported elements. It is commonly developed in Power BI Desktop.
Dashboard
In Power BI Service, a dashboard is a single-page canvas that can combine tiles from reports and other supported sources. It is different from a multi-page report.
Tile
A tile is an individual item displayed on a Power BI dashboard, often created by pinning supported report content or other supported information.
10. Understanding a Report and Dashboard
Visual 4: A report can contain multiple pages, while a Power BI dashboard is a single-page canvas in the Service.
11. Filters, Slicers, and Interactions
| Term | Meaning | Example |
|---|---|---|
| Filter | Restricts the data included in a visual, page, or report. | Show sales for 2026 only. |
| Slicer | A visual control that lets report users select values to filter data. | Select a particular region. |
| Drill Down | Moves through levels of a hierarchy in a visual. | Year to quarter to month. |
| Drill Through | Navigates to a detail page filtered for a selected item. | Open a detailed page for one product. |
| Bookmark | Captures a configured report state, depending on its settings. | Return to a saved report view. |
12. Refresh, Workspace, and Publishing
- Refresh: Updates data from the configured source when refresh is supported and successfully completed.
- Workspace: A place in Power BI Service where teams organize and manage Power BI content.
- Publish: Sends supported report content from Desktop to a destination in Power BI Service.
- Permissions: Determine who can view, edit, share, or manage content.
- Gateway: A supported connection mechanism that can allow the Service to reach certain data sources located on private networks.
13. Quick Revision Table
| Term | Remember it as |
|---|---|
| Data Source | Where the original data comes from. |
| Power Query | Connect and transform data. |
| Semantic Model | Organized data and model information for analysis. |
| Relationship | A connection between related tables. |
| DAX | Formula language for model calculations. |
| Measure | A calculation evaluated in the current context. |
| Visualization | A graphical or structured display of data. |
| Report | An interactive collection of report pages. |
| Dashboard | A single-page canvas in Power BI Service. |
| Slicer | A visual control for filtering report data. |
14. Beginner Practice Questions
Q1. What is a data source?
Answer: The original location from which data is obtained, such as an Excel workbook or database.
Q2. What is Power Query used for?
Answer: Connecting to, cleaning, and transforming data.
Q3. What does DAX stand for?
Answer: Data Analysis Expressions.
Q4. What is the difference between a report and a dashboard?
Answer: A report can have multiple pages and interactive visuals. A dashboard in Power BI Service is a single-page canvas.
Q5. What does a slicer do?
Answer: It allows a user to select values and filter report data.
Q6. What is a measure?
Answer: A calculation that returns a result based on its evaluation context, commonly used for totals and business metrics.
Summary
In this lesson, you learned the important vocabulary used in Power BI, including data sources, semantic models, Power Query, tables, relationships, DAX, measures, visualizations, reports, dashboards, filters, and slicers.
Understanding these terms will make the upcoming lessons at CIIT TRANING INSTITUTE easier to follow. You will use these concepts when connecting data, preparing tables, building models, creating calculations, and designing reports.