MCSA BI Reporting Certification

Microsoft MCSA BI Reporting certification validates you have skills of data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. To earn this MCSA BI Reporting certification, you need to pass both 70-778 and 70-779 exams. Which information you need to know to pass 70-778 and 70-779 exams and earn MCSA BI Reporting certification? Let me show you below. 

70-778 and 70-779 Basic Information

Candidates for this Analyzing and Visualizing Data with Microsoft Power BI 70-778 exam should have a good understanding of how to use Power BI to perform data analysis. Candidates for Analyzing and Visualizing Data with Microsoft Excel 70-779 exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. The registration fee of each of the two exams is $165. 

70-778 and 70-779 Exams Topics

To prepare both 70-778 and 70-779 exams well, it is important for you to know Microsoft 70-778 and 70-779 exam topics. I just collected them from Microsoft official website. Share them with you in the following table. 

Master all the above Microsoft 70-778 and 70-779 exams topics, you can have a thorough knowledge of the two exams. And then, you can practice online Microsoft 70-778 and 70-779 exam dumps questions, which can help you test the skills. We provide the latest Microsoft MCSA 70-778 and 70-779 exam dumps, which can guarantee you success in the first attempt. 

70-778 Sample Dumps Questions

1.You plan to use Power BI Desktop to import 100 CSV files. The files contain data from different stores. The files have the same structure and are stored in a network share.You need to import the CSV files into one table. The solution must minimize administrative effort.What should you do?

A. Add a folder data source and use the Combine Files command.

B. Add a folder data source and use the Merge Queries command.

C. Add a Microsoft Excel data source and use the Merge Queries command.

D. Add text/CSV data sources and use the Append Queries command.

Answer: A

2.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?

A. Configure report level filters, and then create groups that use the List group type.

B. Configure drillthrough filters for each bar chart, and then select Selection Pane.

C. Filter the bar charts by using the slicer, and then create bookmarks.

D. Configure page level filters, and then create groups that use the Bin group type.

Answer: C

70-779 Sample Dumps Questions

1.You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model.You discover that new rows were added to the tables in Azure SQL Database.You need to ensure that the workbook has the new data.Why should you do?

A. Select a cell in the worksheet and pressF5.

B. From the data tab, click Refresh All.

C. Close and open the workbook.

D. From the Power Pivot tab, click Update All.

Answer: B

2.You have an Excel workbook query that loads data to a worksheet and the data model.You need to ensure that the data is refreshed whenever you open the workbook.What should you do?

A. From the File tab, click Option, and then modify the Data option.

B. From the File tab, click Options, and then modify the General options.

C. From the Data tab, click Queries & Connections, and then edit the properties of the query.

D. From the Power Pivot model, modify the Table Behavior setting.

Answer: C

After you complete all the above steps and pass both 70-778 and 70-779 exams, you can earn MCSA BI Reporting certification successfully.