Master Microsoft-Certifications PL300 Power BI Data Analyst Associate with our interactive study cards designed for effective learning. These flashcards use proven spaced repetition techniques to help you memorize key concepts, definitions, and facts. Perfect for students, professionals, and lifelong learners seeking to improve knowledge retention and ace exams through active recall practice.
Click any card to reveal the answer
A Windows application for creating reports and data models
The cloud-based platform for sharing and collaborating on reports
Mobile apps for viewing reports on iOS and Android devices
A collection of data used to create reports and visualizations
A reusable collection of tables stored in the Power BI service
The data transformation and preparation tool in Power BI
Data Analysis Expressions language for calculations and formulas
Extract Transform and Load
A data model with fact tables connected to dimension tables
A normalized star schema with dimension tables split into multiple tables
A table containing measurable quantitative data and foreign keys
A table containing descriptive attributes for analysis
The level of detail or summarization in your data
The relationship between tables based on matching values
When one row in a table relates to multiple rows in another table
When multiple rows relate to multiple rows between tables
How filter selections flow between related tables
Filter flow that works in both directions between tables
Restricting data access based on user roles
A column created using DAX that is stored in the model
A DAX calculation evaluated at query time not stored
An automatic aggregation created by dragging a field to a visual
A user defined measure created with DAX
The set of filters applied to a calculation
Iteration through rows in a table during calculation
Converting row context to filter context in measures
A DAX function that modifies filter context
A DAX function that returns a filtered table
A DAX function that removes filters from columns or tables
A DAX function that retrieves values from related tables
A DAX function that returns related rows as a table
A DAX function that adds all numbers in a column
A DAX function that calculates the mean of values
A DAX function that counts non blank values
A DAX function that counts unique values
An iterator function that evaluates an expression for each row
A DAX function that refers to previous row context
DAX functions for date based calculations like YTD and MTD
A function calculating year to date totals
A function returning dates from the same period last year
A dedicated table containing continuous dates for time analysis
The interface for connecting to various data sources
A connection mode that queries the source in real time
A connection mode that loads data into Power BI memory
A connection mode that uses an existing model without importing
A model combining Import and DirectQuery connections
Loading only new or changed data to improve performance
Pushing transformations back to the data source
The formula language used in Power Query
Analyzing data quality and distribution in Power Query
Combining tables based on matching columns
Stacking tables vertically to combine rows
A value that can be changed to update queries dynamically
A column created based on if then logic
A column created using M formulas
Converting columns into rows for better analysis
Converting rows into columns
Dividing a column into multiple columns by delimiter
The format of data like text number or date
A table with row and column groupings and values
A simple grid displaying data in rows and columns
A single large value display
An interactive filter control on a report page
A saved state of a report page including filters and visuals
A page that shows filtered details when drilling from another page
Navigating from summary to detailed data in a hierarchy
Organized levels of data like Year Quarter Month Day
A custom page shown when hovering over data points
Formatting that changes based on data values
A visual showing progress toward a goal
A visual displaying a value within a minimum and maximum range
A visual showing stages in a linear process
A visual showing cumulative effect of sequential values
A visual showing relationship between two numeric values
A geographic visualization showing data by location
A visual showing hierarchical data as nested rectangles
A visual showing ranking changes over time
Making slicers affect multiple pages
A collaborative environment for sharing content in Power BI Service
A packaged collection of dashboards and reports
A single page with pinned visualizations from multiple reports
A pinned visualization on a dashboard
Automatic data updates at specified times
Software that connects on premises data to Power BI Service
A gateway for individual use installed on a personal computer
An enterprise gateway for organizational data sources
Permission levels like Admin Member Contributor or Viewer
A classification marking for data protection
Marking content as Certified or Promoted for quality
A service for embedding Power BI content in applications
A pixel perfect report designed for printing
Natural language querying feature in Power BI
Automatic discovery of patterns in your data
Connecting Excel PivotTables to Power BI datasets
Extracting underlying data from a visual
An on premises server for hosting Power BI reports
The new term for dataset in Power BI
A dynamic way to change measures or dimensions in visuals
A self service data warehouse in Power BI
A tool for moving content through development test and production
Remember: Use all available resources to study. Flearn alone cannot guarantee success in any exams—make sure to supplement your learning!