×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You are creating a Power BI Desktop report that has several bar charts and a date slicer. You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts filtered for a different year. What should you do before you publish the report?
2.
You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables:
Product (Product_id, Producct_Name)
Sales (Order_id, Order_Date, Product_id, Selasperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
The model has the following relationships:
Sales to Product
Sales to Salesperson
You create a new Power BI file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson. What should you do before you create the report?
Product (Product_id, Producct_Name)
Sales (Order_id, Order_Date, Product_id, Selasperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
The model has the following relationships:
Sales to Product
Sales to Salesperson
You create a new Power BI file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson. What should you do before you create the report?
3.
You have the following two queries in Power BI Desktop:
A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle database Both tables have the same columns.
You need to combine the data from SMB_Customers and Enterprise_Customers. Which command should you use?
A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database
A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle database Both tables have the same columns.
You need to combine the data from SMB_Customers and Enterprise_Customers. Which command should you use?
4.
You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a slicer to filter the data by year. You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year. What should you do?
5.
You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should you do?
6.
You create a dashboard that displays the results of a customer satisfaction survey. You need to embed a tweet from your company's Twitter feed into the dashboard. What should you do?
7.
You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data. Which data source you should use?
8.
9.
You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category. You need to ensure that when you select a year on the bar chart, the donut remains unchanged. What should you do?
10.
You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the dashboard. You need to provide users with sample questions that they can ask when using Q&A. Which settings should you modify from the Power BI Settings?