33. Glossary
Ha glossary tumchya sathi shabdakosh aahe. Pratyek term sobat tyacha English meaning aani Marathi arth (Devanagari madhe) dila aahe. Je shabd standard English aahet (Filter, Slicer, Measure vagaire), tithe "— (English madhech vapra)" asa lihila aahe – te English madhech vapra. Kontahi shabd visarla tar ithe patkan bagha.
| Term | Meaning | मराठी अर्थ |
|---|---|---|
| Aggregation | Summarising many values into one (sum, average, count). Also a Power BI feature that stores pre-summarised tables to speed up large models. | एकत्रीकरण (अनेक मूल्यांचा एक सारांश) |
| Alt text | Description of a visual read by screen readers. | दृश्याचे शब्दांत वर्णन |
| Anti join | A merge that returns rows with no match in the other table (Left Anti / Right Anti) – used to find unmatched codes. | न जुळणाऱ्या ओळी शोधणारी जोडणी |
| AOV | Average Order Value – sales divided by number of (delivered) orders. | — (English madhech vapra) |
| App | A packaged, read-only collection of reports and dashboards distributed from a workspace to audiences. | — (English madhech vapra) |
| Append | Stacking rows of two or more tables with similar columns. | ओळी एकाखाली एक जोडणे |
| Applied Steps | The recorded list of transformations for a query in Power Query. | — (English madhech vapra) |
| Bin | An equal-width range created by a bin group, e.g. 5-minute delivery time bins or ₹100 order value bins. | संख्यांचा ठरावीक टप्पा |
| Bookmark | Saved state of a report page (filters, visibility, sort) that can be recalled. | — (English madhech vapra) |
| Button slicer | A newer slicer style that shows values as formatted buttons/tiles with states and images. | — (English madhech vapra) |
| Calculated column | A DAX column computed row by row at refresh and stored in a table. | गणना केलेला स्तंभ |
| Calculated table | A table created by a DAX expression at refresh. | गणना केलेला तक्ता |
| Canvas | The report page area; size set in Format page › Canvas settings (16:9, 4:3, Letter, Tooltip, Custom). | — (English madhech vapra) |
| Capacity | Dedicated compute resources bought by an organisation (e.g. Fabric F SKUs). | क्षमता (संस्थेने घेतलेली संगणकीय क्षमता) |
| Cardinality | (1) Type of relationship: one-to-many, one-to-one, many-to-many. (2) Number of distinct values in a column. | कार्डिनॅलिटी (संबंधाचा प्रकार / वेगळ्या मूल्यांची संख्या) |
| Column profile | Power Query view showing statistics and value distribution of a column (View tab). | — (English madhech vapra) |
| Composite model | A model that mixes storage modes, e.g. Import and DirectQuery. | संमिश्र मॉडेल |
| Conditional formatting | Changing colours, data bars, icons or URLs based on values, using Gradient, Rules or Field value. | अटीनुसार स्वरूपण |
| Context transition | CALCULATE converting a row context into a filter context. | संदर्भ रूपांतर (ओळ संदर्भाचा गाळणी संदर्भ होणे) |
| Cross-filter direction | Direction in which a relationship propagates filters: Single or Both. | गाळणीची दिशा |
| Dark store | A small warehouse, closed to walk-in customers, used by quick-commerce services to pick and pack online orders quickly (e.g. the sample Kothrud Hub in Pune). | फक्त डिलिव्हरीसाठीचे दुकान-गोदाम |
| Dashboard | A single-page canvas in the Service composed of tiles pinned from reports. | — (English madhech vapra) |
| Data category | Column property telling Power BI what the data represents (City, URL, etc.). | — (English madhech vapra) |
| Data profiling | Checking column quality, distribution and statistics before cleaning data. | डेटाची तपासणी |
| Dataflow | Power Query transformations created and stored in the Power BI Service for reuse. | — (English madhech vapra) |
| Date table | A dimension table with one row per date, marked as date table, used for time intelligence. | दिनांक तक्ता |
| DAX | Data Analysis Expressions – the formula language for measures, columns, tables and RLS. | — (English madhech vapra) |
| Dimension table | A table of descriptive attributes (Product, Customer, Date) used to filter and group facts. | परिमाण तक्ता (वर्णनात्मक माहिती) |
| Direct Lake | Fabric storage mode reading Delta tables from OneLake directly. | — (English madhech vapra) |
| DirectQuery | Storage mode where data stays in the source and is queried on demand. | थेट क्वेरी (डेटा स्रोतातच राहतो) |
| Disconnected table | A table with no relationships, used to drive slicer choices in measures (e.g. metric switching with SWITCH). | संबंध नसलेला स्वतंत्र तक्ता |
| Drill down / up | Moving between levels of a hierarchy in a visual. | खोलात जाणे / वर येणे |
| Drill through | Navigating to a detail page filtered by a selected item. | तपशील पानावर जाणे |
| Dual | Storage mode where a table can act as Import or DirectQuery as needed. | दुहेरी साठवण पद्धत |
| Dynamic format string | A DAX expression that returns the format string of a measure while the measure stays numeric. | बदलणारे स्वरूप सूत्र |
| ETL | Extract, Transform, Load – the data preparation process. | काढणे, रूपांतर करणे, लोड करणे |
| Fact table | A table of events/transactions with numeric values and foreign keys. | तथ्य तक्ता (व्यवहारांची नोंद) |
| Festival day | A date flagged in the Date table (e.g. Diwali, Ganeshotsav) to analyse festival demand separately. | सणाचा दिवस |
| Field parameter | A feature letting users switch measures or dimensions in a visual. | स्तंभ/मापक बदलण्याची सोय |
| Filter context | The set of filters active when a DAX measure is evaluated. | गाळणी संदर्भ |
| Gateway | On-premises data gateway – software that connects the cloud Service to on-premises data. | गेटवे (कंपनीचा डेटा आणि क्लाउड यांतील सुरक्षित पूल) |
| Geocoding | Converting location text (city, address) into map coordinates. | भू-स्थान निश्चिती (नावावरून नकाशावरील जागा) |
| Grain | The level of detail of a table – what one row represents (e.g. one order line). | सूक्ष्मता (एका ओळीचा अर्थ) |
| Group (data group) | A new category created by combining values of a column, e.g. Region = West for Pune and Solapur. | गट |
| Helper queries | Queries created by Combine Files: Parameter1, Sample File, Transform Sample File and the Transform File function. | सहाय्यक क्वेरी |
| Hierarchy | Ordered set of columns for drilling (Year › Quarter › Month). | श्रेणीरचना |
| Import | Storage mode where data is loaded into the in-memory model. | — (English madhech vapra) |
| Incremental refresh | Refreshing only recent partitions of a large table. | वाढीव रिफ्रेश (फक्त नवीन डेटा अद्ययावत) |
| Invoke Custom Function | Add Column command that calls a Power Query function for every row. | — (English madhech vapra) |
| IST | Indian Standard Time (UTC+5:30); all times in the sample data use IST. | भारतीय प्रमाण वेळ |
| Iterator | A DAX function that evaluates an expression row by row (SUMX, FILTER, RANKX). | ओळ-दर-ओळ फिरणारे फंक्शन |
| Live connection | Connecting a report to an existing published semantic model or Analysis Services model. | थेट जोडणी (तयार मॉडेलशी) |
| M language | Power Query's formula language (case-sensitive). | — (English madhech vapra) |
| Mapping table | A small lookup table (e.g. Raw City → Clean City) merged in to standardise values. | जुळवणी तक्ता |
| Measure | A DAX calculation evaluated at query time in the current filter context. | फिल्टरनुसार बदलणारा हिशोब (शब्द English मध्येच वापरा) |
| Merge | Joining two queries side by side on matching key columns. | विलीन करणे |
| Microsoft Fabric | Microsoft's unified analytics platform that includes Power BI. | — (English madhech vapra) |
| Native query | A SQL statement written by hand and sent directly to a database. | मूळ SQL क्वेरी |
| OLS | Object-Level Security – hides tables or columns from certain roles. | वस्तू-स्तरीय सुरक्षा (स्तंभ/तक्ते लपवणे) |
| Page navigator | A button group that creates one navigation button per report page automatically. | — (English madhech vapra) |
| Paginated report | Pixel-perfect, printable report built with Power BI Report Builder. | छपाईसाठी पानबद्ध अहवाल |
| Parameter (Power Query) | A named, typed value used in queries instead of hard-coded text, e.g. FolderPath, ServerName, RangeStart. | मापदंड (बदलता येणारे मूल्य) |
| Performance Analyzer | Built-in tool that measures how long each visual takes. | — (English madhech vapra) |
| Pin | Adding a report visual to a dashboard as a tile. | — (English madhech vapra) |
| Power Query | The data connection and transformation engine in Power BI. | — (English madhech vapra) |
| Privacy level | Setting (Private, Organizational, Public) that controls whether data from one source may be sent to another when combining queries. | गोपनीयता स्तर |
| Query folding | Translating Power Query steps into a native source query. | क्वेरी फोल्डिंग (काम स्रोत डेटाबेसकडे सोपवणे) |
| Quick commerce | Online ordering of groceries and daily essentials with very fast delivery (often in minutes) from nearby dark stores. | १०-१५ मिनिटांत घरपोच डिलिव्हरी |
| Relationship | A link between columns of two tables that allows filters to flow. | संबंध |
| Report | A multi-page interactive set of visuals built on one semantic model. | — (English madhech vapra) |
| Report page tooltip | A small report page shown as a tooltip when hovering over a data point. | — (English madhech vapra) |
| RLS | Row-Level Security – restricting rows by user role. | ओळ-स्तरीय सुरक्षा |
| Row context | The current row during a calculated column or iterator evaluation. | ओळ संदर्भ |
| Selection pane | Pane listing all objects on a page to show/hide, reorder layers, set tab order and group them. | — (English madhech vapra) |
| Semantic model | The published model (data, relationships, measures, security) – formerly called dataset. | सिमॅन्टिक मॉडेल (अहवालांसाठी सामायिक डेटा मॉडेल) |
| Slicer | An on-canvas visual used to filter other visuals. | — (English madhech vapra) |
| Snowflake schema | A model where dimensions are normalised into multiple related tables. | हिमकण रचना |
| Source.Name | Column added by Combine Files that holds the file name each row came from. | — (English madhech vapra) |
| Star schema | A model with one fact table directly connected to dimension tables. | तारा रचना |
| Sync slicers | Feature that applies one slicer's selection across several pages. | — (English madhech vapra) |
| Template (.pbit) | A Power BI file with report, model, queries and parameters but no data; prompts for parameters when opened. | — (English madhech vapra) |
| Theme | JSON-based set of colours, fonts and formatting applied to a report. | — (English madhech vapra) |
| Tile | A single item on a dashboard (visual, text, image, etc.). | — (English madhech vapra) |
| Time intelligence | DAX functions for period comparisons (YTD, last year, rolling periods). | कालावधी विश्लेषण |
| Tooltip | Information shown when hovering over a data point; can be a whole report page. | — (English madhech vapra) |
| UPN | User Principal Name – a user's sign-in name, usually e-mail format. | वापरकर्त्याचे साइन-इन नाव |
| VertiPaq | The columnar, compressed in-memory engine behind Import mode. | — (English madhech vapra) |
| Web.Contents | M function that downloads content from a URL or API; used with Json.Document for JSON APIs. | — (English madhech vapra) |
| What-if parameter | A numeric slider parameter for scenario analysis. | 'जर-तर' गणनेसाठी मूल्य |
| Workspace | A container in the Service for related content and collaborators. | — (English madhech vapra) |
Keep practising!
The fastest way to become job-ready is to build. Recreate the Blinkit quick-commerce project for Pune, Nashik, Nagpur, Kolhapur, Solapur and Sambhaji Nagar, then pick a public dataset in an area you care about and build your own report from raw data to a published app. Explain every decision you make – that is exactly what interviewers look for.
— Ravindra Bagale