Microsoft Power BI Flashcards
25 cards from real Microsoft Power BI practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 20 Microsoft Power BI flashcards as text
Microsoft released Power BI Embedded in which year?
Answer: 2016
Microsoft Power BI Embedded was officially released in June 2016. This service allows developers to integrate Power BI reports and dashboards directly into their own applications, providing interactive data visualization capabilities without requiring end-users to have a Power BI account.
Power BI was released to the general public for the first time on
Answer: 2015
Power BI was first released to the general public in July 2015. This marked the official launch of the comprehensive suite of business intelligence tools, offering self-service analytics and data visualization capabilities to a broad audience.
The initial release of Power BI was dependent on the
Answer: Microsoft Excel
The initial development and release of Power BI were heavily dependent on Microsoft Excel. It originated as a set of powerful add-ins for Excel, including Power Query, Power Pivot, Power View, and Power Map, which extended Excel's capabilities for data analysis and visualization.
The data limit point of confinement in the free Power BI adaption is...
Answer: 1GB/client
The free version of Power BI, known as Power BI Desktop, has a data limit of 1 GB per user for models published to the Power BI service. This limit applies to the size of the dataset that can be stored and refreshed in the cloud.
BI is still in use for...
Answer: Business Intelligence
BI is an acronym that stands for Business Intelligence. This term encompasses the technologies, applications, and practices used for the collection, integration, analysis, and presentation of business information. Its primary goal is to support better business decision-making.
Power BI Plus is available for a month-to-month membership fee of less than how much US$ per license?
Answer: $10.00
Power BI Pro is available for a monthly subscription fee of $10.00 per user per month. This paid tier offers enhanced features compared to the free version, including increased data capacity, collaboration tools, and the ability to share content with other Power BI Pro users.
Power Bl portable application is accessible for all these with the exception of—
Answer: BlackBerry
The Power BI mobile application is widely available for major mobile operating systems, including iOS (Apple), Android, and Windows Phone. However, it is not available for BlackBerry devices, reflecting BlackBerry's significantly smaller market share and app ecosystem compared to the other platforms.
What is the number of GB/client in Power BI Pro?
Answer: 10GB/client
Power BI Pro offers a significantly higher data limit compared to the free version, allowing for larger and more complex datasets. Specifically, Power BI Pro provides a data limit of 10 GB per user for models published to the Power BI service.
Ron George composed it in the middle of the year...
Answer: 2010
Ron George is widely recognized for his foundational work on what would become Power Pivot, a crucial component of Power BI, around the year 2010. His contributions laid the groundwork for the self-service business intelligence capabilities that Power BI later offered.
Project Crescent was formerly available for open download on before it was renamed Power BI.
Answer: July 11, 2011
Project Crescent, an early codename for what later evolved into Power View (a key visualization component of Power BI), was made available for public download on July 11, 2011. It was initially released as part of SQL Server 2012 CTP3, demonstrating Microsoft's early commitment to interactive data reporting.
In Power BI, where do you go to edit and reshape data?
Answer: Data Editing
In Power BI, the primary tool for editing and reshaping data is the Power Query Editor. This environment allows users to perform various data transformations, clean data, merge queries, and define data types before loading the data into the Power BI data model for analysis and visualization.
In Power BI, what isn't a data compose?
Answer: Date
In Power BI, 'Date' is a specific data type used to store temporal values representing a date without a time component. While 'General' (Any), 'Double' (a numeric type), and 'Decimal Number' (another numeric type) are also valid data types, 'Date' specifically categorizes temporal information, distinguishing it from numerical or flexible data representations.
When characterizing a parameter, what isn't an option for suggested esteems?
Answer: Any Value
In Power Query Editor, when defining a parameter, you can specify "Suggested Values" to guide users on what input to provide. These suggested values can come from a "List of Values" (a predefined static list) or be loaded dynamically from a "Table". "Any Value" is not a *suggested value* option; instead, it's a "Type" setting for the parameter itself, indicating that the user can enter any value without predefined suggestions.
What do you use in Power BI to group your queries?
Answer: Join Queries
In Power BI, when you need to combine data from multiple tables or queries based on common columns, you use "Join Queries" (specifically, merge queries in Power Query Editor). This operation links rows from two tables, effectively grouping their data together into a single, more comprehensive query result. This is distinct from appending queries, which stacks rows from tables with identical column structures.
What is the relationship between the Countries table and the Fact table in the accompanying illustration?
Answer: Numerous to one
In a typical data model, a 'Countries' table serves as a dimension table, containing unique country entries. A 'Fact' table, which records transactions or events, will often have many rows corresponding to a single country. Therefore, the relationship from the Fact table to the Countries table is 'Many to One' (Numerous to one), meaning many records in the Fact table relate to one unique record in the Countries table.
What kind of computation should Total Cost be according to best practice in the recipe Total Cost = Sum('Fact'[Cost])?
Answer: Variable
While `Total Cost = Sum('Fact'[Cost])` directly defines a measure in Power BI, best practices for complex DAX calculations often involve using `VAR` (variable) statements. Defining intermediate calculations like `Total Cost` as a variable within a larger measure improves readability, simplifies debugging, and can optimize performance by ensuring the calculation is executed only once. This approach makes the overall DAX expression more modular and maintainable.
In inquiry supervisor, what is the M dialect's capacity to sort a segment?
Answer: Sort.Table
In Power Query Editor, the M language function used to sort a table by one or more columns is `Table.Sort`. This function takes a table and a list of columns to sort by, along with their respective sort orders (e.g., `Order.Ascending`). Although the option is presented as `Sort.Table`, it refers to the core functionality of sorting data within a table structure in M, which is precisely achieved using the `Table.Sort` function.
In the question proofreader, what is the option to unpivot data?
Answer: Unpivot lines
The 'Unpivot' feature in Power Query Editor is used to transform data from a wide format into a tall format, which is often necessary for proper data modeling in Power BI. This process effectively takes multiple columns and converts them into two new columns: one for the attribute name and one for its corresponding value. The option 'Unpivot lines' refers to this operation, where data previously spread across columns is consolidated into fewer, longer 'lines' or rows.
Which of the following is not a self-service business intelligence tool?
Answer: SAP 80
Self-service Business Intelligence (BI) tools empower business users to analyze data and create reports without extensive IT involvement. Tableau, MS Power BI, and QlikSense are all prominent examples of such tools, designed for user-friendly data exploration and visualization. SAP 80, likely referring to older, more traditional SAP BI platforms like SAP BW or earlier versions of BusinessObjects, typically requires significant IT expertise for setup, data modeling, and report development, thus not fitting the self-service paradigm.
What image would you choose to convey a sense of self-esteem in a solitary situation?
Answer: Disseminate Plot
This question appears to be poorly translated, but assuming 'convey a sense of self-esteem in a solitary situation' refers to visualizing individual data points and their distribution, a 'Disseminate Plot' (likely a mistranslation of Scatter Plot) would be the most appropriate. A Scatter Plot displays individual data points as markers, showing the relationship between two numerical variables and revealing patterns, clusters, or outliers among distinct observations. This allows for the examination of each 'solitary' data point's position relative to others.