Correct Answer : 24 July 2015
Explanation : Power BI was first released to the general public on 24 July 2015. It has several versions for Desktop, Web, and Mobile App, etc.
Correct Answer : Microsoft
Explanation : This application was originally conceived by Thierry D'Hers and Amir Netz of the SQL Server Reporting Services Team at Microsoft. It was originally designed by Ron George in the summer of 2010 and named Project Crescent. Project Crescent was initially available for public download on 11 July 2011, bundled with SQL Server Codename Denali. Later renamed Power BI it was then unveiled by Microsoft in September 2013 as Power BI for Office 365. The first release of Power BI was based on the Microsoft Excel-based add-ins: Power Query, Power Pivot and Power View.With time, Microsoft also added many additional features like Question and Answers, enterprise-level data connectivity, and security options via Power BI Gateways. Power BI was first released to the general public on 24 July 2015. It has several versions for Desktop, Web, and Mobile App, etc.
Correct Answer : A business analytics tool
Explanation : Power BI is a Business Analytics Tool : Microsoft Power BI is a Business Intelligence (BI) platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel, and its deep integration with other Microsoft products makes it a versatile self-service tool that requires little upfront training.
Correct Answer : Charts
Explanation : Power BI provides a variety of charts and graphs, including bar charts, line charts, pie charts, and scatter plots, to help users visualize their data.
Correct Answer : R-language
Explanation : Visualize data your way, with our rich library of fully customizable, open-source data visualization tools. Use the Power BI visuals SDK to create stunning data visualizations based on well-known JavaScript libraries such as D3, jQuery, and even R-language scripts.
Correct Answer : Dimension table
Correct Answer : Microsoft Excel
Correct Answer : 1GB/client
Correct Answer : 10GB/Client
Explanation :
Correct Answer : Adobe Photoshop files
Explanation : Power BI can connect to various data sources, including Excel spreadsheets, JSON files, and Oracle databases, but it cannot connect to Adobe Photoshop files.
Correct Answer : Data cleansing
Explanation : Data cleansing is a data transformation feature in Power BI that allows users to clean, transform, and reshape data to prepare it for analysis.
Correct Answer : All of the above
Explanation : Natural language queries can be used in Power BI through the Q&A feature in the Power BI service, the Power BI mobile app, and the Power BI desktop application. This allows users to ask questions in everyday language and get answers in the form of interactive visuals.
Explanation : Data in a Power BI report can be refreshed manually in the Power BI desktop application, scheduled for automatic refreshes in the Power BI service, or triggered by a Power Automate flow.
Correct Answer : Publish them to the Power BI service
Correct Answer : MAX
Correct Answer : DAX
Explanation : Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models.
Correct Answer : None of the above
Explanation : Paginated reports in Power BI are created using the Power BI Report Builder application, which is a separate tool from the Power BI desktop application and the Power BI service.
Correct Answer : Using the Power BI desktop application
Explanation : Drillthroughs in Power BI can be created using the Power BI desktop application. This can be done by selecting the desired visual and configuring the drillthrough options in the Visualizations pane.
Explanation : Custom visuals can be added to a Power BI report using the Power BI desktop application. This can be done by importing the custom visual from the marketplace and then adding it to the report canvas.
Correct Answer : SUMX
Explanation : Power BI offers various visualization options, including pivot tables, histograms, and bubble charts, to help users analyze and interpret their data.
Correct Answer : A visual representation of data that provides an at-a-glance view of key metrics
Explanation : A dashboard in Power BI is a visual representation of data that provides an at-a-glance view of key metrics and performance indicators for a business or organization.
Correct Answer : A calculation based on data in a dataset
Explanation : A measure in Power BI is a calculation based on data in a dataset. Measures can be used to perform calculations such as sums, averages, and percentages.
Correct Answer : Slicer
Explanation : A slicer is a way to filter data in Power BI. Slicers allow users to interactively filter data by selecting one or more values from a list.
Correct Answer : To import, transform, and combine data from various sources
Explanation : Power Query is a data transformation and cleaning tool in Power BI that allows users to import, transform, and combine data from various sources.
Correct Answer : CONCATENATE
Correct Answer : Power BI Service
Correct Answer : Gateway
Correct Answer : Measures
Correct Answer : Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile
Correct Answer : Power BI desktop application
Explanation : Data models in Power BI can be created using the Power BI desktop application. This can be done by importing data from various sources and then using the Power Query Editor and DAX formulas to transform and model the data.
Explanation : Calculated tables in Power BI can be created using the Power BI desktop application. This can be done by using the DAX formula language to define the table based on the underlying data.
Explanation : Power BI reports can be shared with others using the Power BI desktop application, the Power BI service, and the Power BI mobile app. This allows users to collaborate and share insights with their colleagues.
Correct Answer : Using the Power BI service
Explanation : Data from a Power BI report can be exported using the Power BI service. This can be done by selecting the desired visualization, clicking the ellipsis button, and selecting “Export data”.
Correct Answer : Power BI service
Explanation : The Power BI service provides tools for monitoring the performance of a Power BI report. This includes metrics such as page load time, rendering time, and query duration.
Explanation : The Power BI service allows users to schedule the refresh of a Power BI dataset. This can be done by configuring a refresh schedule in the dataset settings.
Correct Answer : To create and manage data models
Explanation : Power Pivot is a data modeling tool in Power BI that allows users to create and manage data models. It allows users to define relationships between tables and create calculated columns and measures.
Correct Answer : DAX formula language
Explanation : DAX (Data Analysis Expressions) is a formula language used to create measures and calculated columns in Power BI.
Correct Answer : Publish to the Power BI service
Explanation : The recommended way to share a report or dashboard in Power BI is to publish it to the Power BI service. This allows other users to view and interact with the report or dashboard in a web browser.
Correct Answer : To share reports and dashboards with other users
Explanation : The Power BI service is a cloud-based platform that allows users to share reports and dashboards with other users. It also provides additional features such as collaboration, data exploration, and administration.
Correct Answer : When shaping or transforming data in Power BI Desktop, the source data remains unchanged
Correct Answer : Semua benar
Correct Answer : COUNT
Correct Answer : Power Query Editor in either Power BI Desktop or Power BI Service
Correct Answer : One to Many
Correct Answer : Using a web browser
Explanation : The most common way to connect to a data source in Power BI is to use a web browser. Power BI also provides other methods such as command-line interfaces and APIs for connecting to data sources.
Correct Answer : To import and transform data from various sources
Explanation : The Query Editor in Power BI is a data transformation and cleaning tool that allows users to import, transform, and combine data from various sources.
Correct Answer : Fields pane
Explanation : The Fields pane in Power BI allows users to create hierarchies by dragging and dropping fields onto each other. Hierarchies can be used to drill down into data and explore relationships between data points.
Correct Answer : To allow users to ask natural language questions and get answers from data
Explanation : The Q&A feature in Power BI allows users to ask natural language questions about data and get answers in the form of visualizations and reports. It uses natural language processing and machine learning algorithms to understand user queries and generate results.
Correct Answer : To view and interact with reports and dashboards on mobile devices
Explanation : The Power BI mobile app allows users to view and interact with reports and dashboards on mobile devices such as smartphones and tablets. It provides features such as touch-based navigation, drill-down, and offline access.
Explanation : Dashboards in Power BI can be created using the Power BI service. They allow users to view key metrics and performance indicators in a single, interactive view.
Correct Answer : To allow integration with other applications and services
Explanation : The Power BI API allows developers to programmatically interact with Power BI to perform tasks such as embedding Power BI reports and dashboards in other applications, automating report generation and distribution, and managing Power BI content and resources.
Explanation : Reports in Power BI can be shared in multiple ways, including publishing to the Power BI service, exporting to a PDF file, and sharing a link to the report.
Correct Answer : AVERAGE
Correct Answer : Calculated Colum
Correct Answer : Fact table
Correct Answer : Files, Content Packs, Connectors
Correct Answer : Developer tools
Explanation : Power BI provides developer tools for creating custom visuals using HTML, CSS, and JavaScript. Custom visuals can be used to create unique data visualizations and add additional functionality to Power BI reports and dashboards.
Correct Answer : Data view
Explanation : The Data view in Power BI allows users to perform data modeling tasks such as creating relationships between tables, creating calculated columns, and applying filters to data.
Correct Answer : Format pane
Explanation : The Format pane in Power BI allows users to format visuals in a report or dashboard. It provides options for changing colors, fonts, and other visual properties.
Explanation : Measures in Power BI are created using the Data view. They are used to perform calculations on data, such as sums, averages, and percentages.
Correct Answer : To create pixel-perfect, paginated reports for printing and PDF generation
Explanation : Power BI paginated reports are used to create pixel-perfect, paginated reports that are optimized for printing and PDF generation. They provide precise control over the layout and formatting of the report.
Explanation : Power BI reports can be customized using custom themes, custom visuals, and custom tooltips. This allows users to create reports that match the branding and style of their organization.
Correct Answer : Using the Power BI Embedded SDK
Explanation : The Power BI Embedded SDK is used to create a Power BI Embedded solution. It provides a set of APIs that can be used to embed Power BI content in other applications and web pages.
Correct Answer : To embed Power BI content in other applications
Explanation : Power BI Embedded allows developers to embed Power BI reports and dashboards in other applications and web pages. It provides a set of APIs that can be used to interact with Power BI content.
Correct Answer : To increase the performance and scalability of Power BI reports and dashboards
Explanation : The Power BI premium capacity is used to increase the performance and scalability of Power BI reports and dashboards. It provides additional processing power and memory, allowing users to work with larger datasets and more complex reports.
Correct Answer : Using the Power BI gateway installer
Explanation : The Power BI gateway installer is used to create a Power BI data gateway. It can be downloaded from the Power BI service and installed on a computer or server that is connected to the on-premises data source.
Correct Answer : IF
Correct Answer : FROM
Correct Answer : .pbix
Correct Answer : Datasets
Correct Answer : To create static and printable reports
Explanation : Power BI paginated reports are designed to create static, printable reports that are optimized for printing or generating PDF documents. They are ideal for creating forms, invoices, and other types of structured documents.
Correct Answer : Using SQL Server Reporting Services (SSRS)
Explanation : Power BI paginated reports are created using SQL Server Reporting Services (SSRS), a reporting platform that is integrated with Power BI. Paginated reports can be published to the Power BI service and shared with users.
Correct Answer : Using the Power BI JavaScript API
Explanation : The Power BI JavaScript API allows developers to embed Power BI reports and dashboards in other applications and web pages. It provides a set of JavaScript functions that can be used to interact with Power BI content.
Correct Answer : Using the Power BI mobile app
Explanation : The Power BI mobile app allows users to access Power BI content offline by downloading reports and dashboards to their mobile devices.
Correct Answer : SELECT
Correct Answer : To connect to on-premises data sources from the Power BI service
Explanation : The Power BI data gateway is used to connect to on-premises data sources from the Power BI service. It allows users to securely access data that is located behind a firewall or on a private network.
Correct Answer : Join queries
Correct Answer : Power Scale
Correct Answer : Data View
Correct Answer : Page-level filter
Correct Answer : Data Editing
Correct Answer : The tile you selected expands and takes the full space
Correct Answer : Power BI service dashboard
