Use this quick start guide to collect all the information about Microsoft Analyzing and Visualizing Data with Microsoft Excel (70-779) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the 70-779 Analyzing and Visualizing Data with Microsoft Excel exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual Microsoft MCSA BI Reporting certification exam.
The Microsoft Analyzing and Visualizing Data with Microsoft Excel certification is mainly targeted to those candidates who want to build their career in Microsoft Excel domain. The Microsoft Certified Solutions Associate (MCSA) - BI Reporting exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of Microsoft MCSA BI Reporting.
Microsoft Analyzing and Visualizing Data with Microsoft Excel Exam Summary:
|Exam Name||Microsoft Certified Solutions Associate (MCSA) - BI Reporting|
|Exam Price||$165 (USD)|
|Number of Questions||40-60|
|Passing Score||700 / 1000|
|Books / Training||20779A: Analyzing Data with Excel|
|Schedule Exam||Pearson VUE|
|Sample Questions||Microsoft Analyzing and Visualizing Data with Microsoft Excel Sample Questions|
|Practice Exam||Microsoft 70-779 Certification Practice Exam|
Microsoft 70-779 Exam Syllabus Topics:
|Consume and Transform Data by Using Microsoft Excel||
Import from data sources
Perform data transformations
Create and optimize data models
Create calculated columns, measures, and tables
Create performance KPIs
Create and manage PivotTables
Create and manage PivotCharts
Interact with Power BI
To ensure success in Microsoft MCSA BI Reporting certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for Analyzing and Visualizing Data with Microsoft Excel (70-779) exam.