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.

Correct Answer :   All of the above

---

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.

Correct Answer :   Using the Power BI desktop application

---

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

Correct Answer :   All of the above

---

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.

Correct Answer :   Power BI desktop application

---

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.

Correct Answer :   All of the above

---

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.

Correct Answer :   Power BI service

---

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.

Correct Answer :   Power BI service

---

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.

Correct Answer :   All of the above

---

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.

Correct Answer :   Data view

---

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.

Correct Answer :   All of the above

---

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 :   Gateway

Correct Answer :   The tile you selected expands and takes the full space

Correct Answer :   Power BI service dashboard